MigrationResourceFileOperation.jsp
2.54 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
<%@ page language="java" contentType="text/html; charset=UTF-8" %><%@ page import="weaver.general.Util,weaver.general.GCONST" %><%@ page import="java.util.*" %><%@ page import="java.io.*" %>
<%@ page import="com.alibaba.fastjson.JSONObject" %>
<%@ page import="weaver.conn.RecordSet" %>
<%@ page import="weaver.upgradetool.dbupgrade.logger.DBUpgradeLogger" %>
<%@ page import="weaver.upgradetool.dbupgrade.upgrade.*" %>
<%@ include file="/system/upgradetoe9/MigrationOperation.jsp"%>
<%
DBUpgrade dbupgrade = new DBUpgrade();
JSONObject object = dbupgrade.getResourceFile();
out.print(object.toJSONString());
String method = Util.null2String(request.getParameter("method"));
if("ScanXMlFile".equalsIgnoreCase(method)){
String sqlconfigpath = GCONST.getRootPath() + "system" + File.separatorChar + "upgradetoe9" + File.separatorChar + "resource" + File.separatorChar + "migration.properties";
PropUtil propUtil = PropUtil.getInstance(sqlconfigpath);
propUtil.put("e9_migrationcheckstataus","1");
propUtil.store();
DBUpgradeLogger.write2File("开始执行扫描问题");
RecordSet rs=new RecordSet();
JSONObject json=new JSONObject();
String repotrFilePath=GCONST.getRootPath()+File.separatorChar+"system"+File.separatorChar+"upgradetoe9"+File.separatorChar+"report"+File.separatorChar;//文件的存放的路径
MigrationFileScanReport migrationFileScanReport=new MigrationFileScanReport("ScanXMLFileReport");
boolean flag1=migrationFileScanReport.ScanXmlFileToExcel("action",null,"action.xml");//扫描action.xml
boolean flag2=migrationFileScanReport.ScanXmlFileToExcel("schedule",null,"schedule.xml");//扫描schedule.xml
boolean flag3=migrationFileScanReport.scanTableToExcel("workflow_base","custompage","workflowname");//扫描某张表，某个自定义页面字段的路径
boolean flag4=migrationFileScanReport.scanTableToExcel2("wf_browser_config","clazz","type");//扫描schedule.xml
if(!flag1 || !flag2 || !flag3){
json.put("status","0");//失败的标识符
}else{
json.put("status","1");//成功的标识符
}
migrationFileScanReport.closeFW();//关闭文件流
ReportToExcel.toFile(migrationFileScanReport.getEf(),"ScanXMLFileReport",repotrFilePath);//生成文件列表
}else if("initXMLToDB".equalsIgnoreCase(method)){
DBUpgradeLogger.write2File("开始初始化xml文件");
InitXMLFileToDB initXMLFileToDB=new InitXMLFileToDB();
initXMLFileToDB.initStart();
}
%>