<%@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" %> <%@page import="druidConnect.JDBCUtils.*,java.sql.Connection"%> <% String gongneng = request.getParameter("gongneng"); String yemian = request.getParameter("yemian"); String sltcSql =request.getParameter("sql"); String anquanma=request.getParameter("anquanma"); Connection con = druidConnect.JDBCUtils.getConnection(); CallableStatement cs =null; try{ if(true){ String flag=""; //sltcSql="{call AXJ_a_largeScreen_glassCut_select()}"; flag=request.getParameter("flag"); String[] sql=sltcSql.split("~"); 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")+"]]"); } } } } }catch(Exception e){ cs =con.prepareCall("{call AXJ_err(?,?,?)}"); cs.setString(1, e.toString()); cs.setString(2, gongneng); cs.setString(3, sltcSql+','+anquanma); cs.execute(); out.print("[['发生未知错误，请联系相关人员']]"); }finally { druidConnect.JDBCUtils.close(cs, con); } %>