init_sys_matrix.jsp
1.64 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
45
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.util.List" %>
<%@ page import="weaver.conn.RecordSet" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="weaver.matrix.MatrixUtil" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%
try {
String matrixids = "";
List<String> matrixs = new ArrayList<>();
RecordSet rs= new RecordSet();
String sql = "select * from matrixinfo where issystem in(1,2)";
rs.executeQuery(sql);
while (rs.next()){
String id = rs.getString("id");
matrixs.add(id);
matrixids += ","+id;
}
if(matrixids.length() > 0){
matrixids = matrixids.substring(1);
RecordSet rs1 = new RecordSet();
RecordSet rs2 = new RecordSet();
RecordSet rs3 = new RecordSet();
String sql1 = "delete from matrixfieldinfo where "+Util.getSubINClause(matrixids, "matrixid", "in");
rs1.executeUpdate(sql1);
out.print(sql1+"<br/>");
for (String tmp : matrixs){
String tablename = MatrixUtil.MATRIXPREFIX+tmp;
String sql2 = "drop table "+tablename;
rs2.executeUpdate(sql2);
out.print(sql2+"<br/>");
}
String sql3 = "delete from matrixinfo where issystem in(1,2)";
rs3.executeUpdate(sql3);
out.print(sql3+"<br/>");
String str = MatrixUtil.sysE8SubcompanyAndDepartToMatrix();
out.print("str:"+str+"<br/>");
}
} catch (Exception e) {
e.printStackTrace();
out.print(e.getMessage());
}
%>