<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
response.setContentType("text/html; charset=utf-8");
response.setHeader("Access-Control-Allow-Origin","*");
%>
<%@include file="mysql_connect.jsp"%>
<%@page import="java.util.LinkedHashMap"%>
<%@page import="java.util.HashMap"%>
<%@page import="java.util.LinkedList"%>
<%@page import="com.alibaba.fastjson.JSON,com.alibaba.fastjson.JSONObject,com.alibaba.fastjson.JSONArray,com.alibaba.fastjson.parser.Feature"%>
<%@ page import="java.text.SimpleDateFormat,java.util.Date" %>
<%
String gongneng = request.getParameter("gongneng");
String yemian = request.getParameter("yemian");
String sltcSql =request.getParameter("sql");
String anquanma=request.getParameter("anquanma");
try{
Class.forName(driverClass);{
/* Connection conAnquan=DriverManager.getConnection( urlglass,user,password);
Statement stmts=conAnquan.createStatement();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss SSS");
Date time = new Date();
long timestamp = time.getTime() / 1000L;
String anquan="select * from anquanbiao where anquanma = '"+anquanma+"' and cip='"+request.getLocalAddr()+"' and now()<=xiugaitime and now()>=jianlitime; ";
ResultSet rss = stmts.executeQuery(anquan);
int coun=0;
while(rss.next())
{
coun++;
}
rss.close();
stmts.close();
conAnquan.close(); */
//coun>0
if(true){
Connection con=DriverManager.getConnection( url,user,password);
//通过connection数据库链接对象 创建一个statement对象数据库操作对象
String flag="";
flag=request.getParameter("flag");
if(!flag.equals("0")){
String[] sql=sltcSql.split("~");
CallableStatement cs = con.prepareCall(sql[0]);
if(sql.length>1){
HashMap hp = JSON.parseObject(sql[1], LinkedHashMap.class,Feature.OrderedField);
int indexNum=1;
for(String key : hp.keySet()) {
cs.setString(indexNum, String.valueOf(hp.get(key)));
//out.print("cs.setString("+indexNum+", "+String.valueOf(hp.get(key))+")");
indexNum++;
}
cs.registerOutParameter( indexNum , java.sql.Types.LONGNVARCHAR);
}
if(flag.equals("2")){
ResultSet rs = cs.executeQuery();
ResultSetMetaData rsmd = rs.getMetaData();
String[] arr;
LinkedList results = new LinkedList();
while(rs.next()){
LinkedHashMap result = new LinkedHashMap();
for(int i=0;i0 && !fanhui.equals("null")){
out.print("[["+cs.getString("fanhui")+"]]");
}
}
}
cs.close();
}else{
Statement stmtss=con.createStatement();
//stmtss.execute(sltcSql);
//stmtss.close();
}
con.close();
}else{
out.print("[[anquanmaerr]]");
}
}
}catch(Exception e){
Class.forName(driverClass);{
Connection con=DriverManager.getConnection(url,user,password);
CallableStatement bs =con.prepareCall("{call AXJ_err(?,?,?)}");
bs.setString(1, e.toString());
bs.setString(2, gongneng);
bs.setString(3, sltcSql);
bs.execute();
bs.close();
con.close();
}
out.print("[['发生未知错误，请联系相关人员']]");
}
%>