【文件属性】:
文件名称:jsp+oracle
文件大小:303KB
文件格式:RAR
更新时间:2012-06-05 08:48:38
jsp,oracle,系统
讲解了关于jsp+oracel的实例
cmd下指令:
exp jsp/jsp@orcl file=c:\jsp.dmp log=c:\jsp.log
exp jsp/jsp@orcl file=c:\jsp_crm.dmp log=c:\jsp_crm.log tables=(crmuser,customer,orders)
imp test/test@orcl file=c:\jsp.dmp log=c:\jsp_imp.log ignore=y
mysql命令行下指令:
drop table customer;
create table customer(
customerId int(6) unsigned not null auto_increment,
name varchar(50) not null,
address varchar(300),
zipCode varchar(25),
phone varchar(50),
fax varchar(50),
comments varchar(4000),
addTime datetime,
primary key (customerId)
)engine=InnoDB default charset=gbk;
cmd下指令:
load data local infile 'E:/JSP book/Mybook/customer_data.csv'
into table customer
fields terminated by ','
lines terminated by '\r\n';
SQL server命令行下指令:
create table customer(
customerId int not null identity(1,1) PRIMARY KEY,
name nvarchar(50) not null,
address nvarchar(300),
zipCode nvarchar(25),
phone nvarchar(50),
fax nvarchar(50),
comments nvarchar(4000),
addTime datetime
)
Go
SQL Plus下指令
alter session set NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'
cmd下指令:
sqlldr userid=jsp/jsp control=C:\input.ctl