InitDatabaseOperation.jsp
2.34 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="com.alibaba.fastjson.JSONObject" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="weaver.upgradetool.dbupgrade.upgrade.DBUpgradeProcess" %>
<%@ page import="weaver.upgradetool.dbupgrade.upgrade.DBUpgradeOperation" %>
<%@ page import="weaver.upgradetool.dbupgrade.upgrade.ToolUtil" %>
<%@ page import="weaver.conn.RecordSet" %>
<%@ page import="weaver.upgradetool.dbupgrade.logger.DBUpgradeLogger" %>
<%@ include file="/system/upgradetoe9/MigrationOperation.jsp"%>
<%
String method = Util.null2String(request.getParameter("method"));
String myname = Util.null2String(request.getParameter("myname"));
JSONObject jsonObj = new JSONObject();
if(!"weaver@ecology2E9".equals(myname)){
jsonObj.put("error","error5");
}
if (method.equals("InitDatabase")) {
DBUpgradeProcess.initProcess();
jsonObj.put("error","success");
} else if(method.equals("shieldtool")){
DBUpgradeOperation operation = new DBUpgradeOperation();
operation.shieldTool();
jsonObj.put("error","success");
}else if(method.equalsIgnoreCase("continueAction")){//执行跳过action的操作
DBUpgradeOperation operation = new DBUpgradeOperation();
String mainsequence=Util.null2String(request.getParameter("mainsequence"));
RecordSet rs = new RecordSet();
rs.executeQuery("select * from DBUpgradeDetail where mainsequence= ? and status = ? and used = ? order by sequence", mainsequence, ToolUtil.EXECUTE_STATUS_ERR, ToolUtil.USED_ON);
if (rs.next()) {
String detailsequence = rs.getString("sequence");
//任务全部执行完成
new DBUpgradeLogger().write2File("明细表的序列："+detailsequence+" 主序列 ："+mainsequence);
rs.executeUpdate("update DBUpgradeDetail set status = ? where mainsequence = ? and sequence = ? and used = ?", ToolUtil.EXECUTE_STATUS_FIN, mainsequence, detailsequence, ToolUtil.USED_ON);
rs.executeUpdate("update DBUpgradeAction set status=? where mainsequence = ? and detailsequence= ? and used = ?",ToolUtil.EXECUTE_STATUS_FIN,mainsequence,detailsequence,ToolUtil.USED_ON);
}
jsonObj.put("status","0");
// jsonObj = operation.executeTask(mainsequence);
}
out.print(jsonObj.toJSONString());
%>