1、jdk配置:
JAVA_HOME D:\Program Files\Java\jdk1.6.0_10
CLASSPATH .;%JAVA_HOME%/lib/dt.jar;%JAVA_HOME%/lib/tools.jar
Path ;%JAVA_HOME%/bin
2、orcle配置:
导出表:exp aa/aa@orcl file="d:/aa.dmp";
//导出用户:exp system/sa@orcl owner=aa file="d:/aa.dmp";
导入表:imp bb/bb@orcl file="d:/aa.dmp" full=y ignore=y;
//导入用户:imp system/sa@orcl file="d:/aa.dmp" fromuser=aa touser=bb;
aa/aa 用户名/密码 bb/bb 用户名/密码
连接到数据库:sqlplus system/sa as sysdba;
sqlplus aa/aa
connect aa/aa
锁定用户:alter user scott account lock;
解锁用户:alter user scott account unlock;
建立表空间:create tablespace oa
datafile 'D:\oracle\oradata\orcl\oa.dbf'
size 10M
autoextend on;
创建用户:create user aa identified by bb [default tablespace oa] [temporary tablespace oa];
授权(必须两个):grant connect to aa;
grant resource to aa;
可要:grant create sequence to aa;授予创建序列(sequence)的权限
删除用户:drop user aa cascade;
3、tomcat配置:
JAVA_HOME D:\Program Files\Java\jdk1.6.0_10
CLASSPATH .;%JAVA_HOME%/lib/dt.jar;%JAVA_HOME%/lib/tools.jar
Path ;%JAVA_HOME%/bin
2、orcle配置:
导出表:exp aa/aa@orcl file="d:/aa.dmp";
//导出用户:exp system/sa@orcl owner=aa file="d:/aa.dmp";
导入表:imp bb/bb@orcl file="d:/aa.dmp" full=y ignore=y;
//导入用户:imp system/sa@orcl file="d:/aa.dmp" fromuser=aa touser=bb;
aa/aa 用户名/密码 bb/bb 用户名/密码
连接到数据库:sqlplus system/sa as sysdba;
sqlplus aa/aa
connect aa/aa
锁定用户:alter user scott account lock;
解锁用户:alter user scott account unlock;
建立表空间:create tablespace oa
datafile 'D:\oracle\oradata\orcl\oa.dbf'
size 10M
autoextend on;
创建用户:create user aa identified by bb [default tablespace oa] [temporary tablespace oa];
授权(必须两个):grant connect to aa;
grant resource to aa;
可要:grant create sequence to aa;授予创建序列(sequence)的权限
删除用户:drop user aa cascade;
3、tomcat配置:
首先在myeclipse上生成war文件(add tomcat选择packaged archive(production mode)),
安装tomcat,把war文件放到tomcat安装路径的webapps下,启动服务器。