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