%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%本机部分%%%%%%%%%%%%%%%%%%%%%%%%%%%
1. 源代码有最新版吗
2. 数据库
3. 运行打开服务的命令services.msc
4. 数据库部分
1.启动所有数据库服务
2.删除用户:drop user fjcstest cascade;
3.删除表空间:DROP TABLESPACE HNUFJCS INCLUDING CONTENTS AND DATAFILES;
4.创建表空间:cmd-->sqlplus sys/ABCabc123 as sysdba;-->
-->CREATE TABLESPACE HNUFJCS DATAFILE 'D:/app/chris/product/11.2.0/dbhome_1/oradata/sample/HNUFJCS.dbf' SIZE 500M UNIFORM SIZE 128k;
5.创建用户:create user fjcstest identified by fjcstest default tablespace HNUFJCS temporary tablespace TEMP;
6.赋予权限:grant connect,dba,resource to fjcstest;
7.导表,imp命令:使用quit退出SQL-->imp fjcstest/fjcstest@ORCL file=D:20180629shujuku+xuesheng+peiti.dmp full=y ignore=y
8.导入.sql文件:用txt打开-->PLSQLDeveloper中以fjcstest/fjcstest登录-->在命令窗口中执行.sql文件中的
9.使用MyEclipse将项目部署到tomcat
10.将webapps下的hnuPtest项目拷贝到,到时候部署使用
11.启动Tomcat:方式一:在cmd中,进入tomcat主目录下的bin目录,执行service.bat install -----安装完成会出现服务名-->
-->启动服务net start Tomcat7(服务名),写成.bat文件,以管理员身份运行
12.删除STUDENTS表:truncate table STUDENTS;
13.删除PLANS表:truncate table PLANS;-->设置PLAN_SEQ 开始于1
14.删除RESULTS表:truncate table RESULTS;-->设置RESULTS_SEQ 开始于1
15.删除PART_RESULTS表:truncate table PART_RESULTS;
16.删除PAPERDETAILS表:truncate table PAPERDETAILS;-->PAPERDETAILS_SEQ
17.删除SCRIPTS表:truncate table SCRIPTS;-->SCRIPTS_SEQ
18.删除ASSESS_TEACHER表:truncate table ASSESS_TEACHER;
19.删除SCORE_HISTORY表:truncate table SCORE_HISTORY;
19-1.删除PAPERS的操作见word文档,把PAPERS_SQ设置为开始于1
%%%%%%%%%%%%%%%%%%%%%%%%知识补充%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
删除PAPERS表的未成功,因为ORA-02266: 表中的唯一/主键被启用的外键引用
解决办法:见word文档
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
20.导入学生:在考试人数多的情况下,几个批次备份一次数据库
21.备份数据库:数据库+学生
22.添加批次
23.导入考生
24.组卷
25.备份数据库:数据库+学生+配题
26.关闭数据库服务,关闭Tomcat服务,备份hnuPtest
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%部署部分%%%%%%%%%%%%%%%%%%%%%%%%%%%
1.
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%