CheckData.jsp
2.11 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
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="java.util.*,weaver.conn.RecordSet" %>
<%@ page import="weaver.workflow.exchange.DataSourceCols"%>
<%@page import="weaver.workflow.exchange.ExchangeUtil"%>
<%
out.clear();
String type = Util.null2String(request.getParameter("type"));
if(type.equals("checkdbfield")){
DataSourceCols dsc = new DataSourceCols();
String datasourceid = Util.null2String(request.getParameter("datasourceid"));
String tablename = Util.null2String(request.getParameter("tablename"));
String fieldname = Util.null2String(request.getParameter("fieldname"));
ArrayList<String> Fieldlist = dsc.getAllColumns(datasourceid, tablename);
//System.out.println("fieldname = "+fieldname+" datasourceid="+datasourceid+" tablename="+tablename);
for(String s : Fieldlist){
if(s.equalsIgnoreCase(fieldname)){
out.println("1");
break ;
}
}
}else if(type.equals("checkset")){//检查设置
String mainid = Util.null2String(request.getParameter("mainid"));
String fieldid = Util.null2String(request.getParameter("fieldid"));
String fieldtablename = Util.null2String(request.getParameter("tablename"));
String changetype = Util.null2String(request.getParameter("changetype"));//1：发送 0：接收
String tablename = "";
String fieldname = "";
if(changetype.equals("0")){
tablename = "wfec_outdatasetdetail" ;
fieldname = "wffieldid";
}else if(changetype.equals("1")){
tablename = "wfec_indatasetdetail" ;
fieldname = "outerfieldname";
if(fieldtablename.indexOf("_dt")!=-1){
fieldid = fieldtablename+"."+fieldid ;
}
}
//wffieldname,outerfieldname
RecordSet rs = new RecordSet();
String sql = "select count(id) from "+tablename+" where mainid="+mainid+" and "+fieldname+"='"+fieldid+"'" ;
System.out.println("sql = "+sql);
rs.executeSql(sql);
rs.next();
int count = rs.getInt(1);
if(count>0){
count = 1 ;
/*
if(changetype.equals("0")){
rs.executeSql("select id from "+tablename+" where mainid="+mainid+" and "+fieldname+"='-7'");
if(rs.getCounts()==0){
count = 2;
}
}
*/
}
out.println(count);
}
%>