程序/jxglxt/WebRoot/factory/checkno.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@page import="dao.CommDAO"%>
<%@page import="util.Info"%>
<%
String table = request.getParameter("table")==null?"":request.getParameter("table");
String col = request.getParameter("col")==null?"":request.getParameter("col");
String value = request.getParameter("value")==null?"":request.getParameter("value");
String checktype = request.getParameter("checktype")==null?"":request.getParameter("checktype");
String valuecopy = "";
for(String str:value.split(","))
{
if(str.startsWith("sysuser-"))
{
str = Info.getUser(request).get(str.split("-")[1]).toString();
}
valuecopy+=str+",";
}
if(valuecopy.length()>1)valuecopy=valuecopy.substring(0,valuecopy.length()-1);
value = valuecopy;
if(checktype.equals("insert"))
{
value = Info.getGBKStr(value);
System.out.println(value);
List list = new CommDAO().select("select * from "+table+" where "+col+"='"+value+"'");
if(list.size()>0)
{
out.print("Y");
}else{
out.print("N");
}
}

if(checktype.equals("zhinsert"))
{
value = Info.getGBKStr(value);
System.out.println(value);
String sql = "select * from "+table+" where 1=1 ";
String[] cols = col.split(",");
String[] values = value.split(",");
for(int i=0;i<cols.length;i++)
{
String pcol = cols[i]==null?"":cols[i];
String pvalue = values[i]==null?"":values[i];
if(pcol.equals(""))continue;
if(pvalue.equals(""))continue;
sql+=" and "+pcol+"='"+pvalue+"' " ;
}
System.out.println(sql);
List list = new CommDAO().select(sql);
if(list.size()>0)
{
out.print("Y");
}else{
out.print("N");
}
}

if(checktype.equals("update"))
{
String id = request.getParameter("id")==null?"":request.getParameter("id");