<% String erjibianhao1=request.getParameter("erjibianhao1"); String caidanid=request.getParameter("erjibianhao1"); //装载一个类并且对其进行实例化的操作 Class.forName(driverClass);{ Connection con=DriverManager.getConnection( urlglass,user,password); //调用存储过程 CallableStatement cs = con.prepareCall("{call quanxiangongengchaxun(?,?)}"); /* if(erjibianhao1==""){ cs.setString(2, erjibianhao1); }else{ cs.setString(2, erjibianhao1); } */ cs.setString(1, adminid); cs.setString(2, erjibianhao1); //判断订单日期是否为null ResultSet rs = cs.executeQuery(); int i=1; while(rs.next()) { if(i%2!=0){ out.println(""); } else { out.println(""); } out.print(""); out.print(""); out.print(""); out.print(""); out.print(""); out.print(""); out.print(""); out.print(""); out.print(""); out.println(""); i++; } con.close(); } %> <% try{ String id3 =request.getParameter("id2"); String mid2 =request.getParameter("mid"); String gongnengid2 =request.getParameter("gongnengid"); String caidanid1 =request.getParameter("caidanid"); String zhuangtai2 =request.getParameter("zhuangtai"); if(request.getParameter("tj")!=null){ //装载一个类并且对其进行实例化的操作 Class.forName(driverClass);{ Connection con=DriverManager.getConnection( urlglass,user,password); CallableStatement cs = con.prepareCall("{call shezhiquanxian(?,?,?,?,?,?,?,?)}"); cs.setString(1, id3); cs.setString(2, mid2); cs.setString(3, caidanid1); cs.setString(4, gongnengid2); cs.setString(5, zhuangtai2); cs.setString(6, request.getRemoteAddr()); cs.setString(7, request.getParameter("adminid")); cs.registerOutParameter(8 , java.sql.Types.INTEGER); cs.execute(); int fanhui=cs.getInt(8); if(fanhui==5000){ out.print(""); }else{ out.print(""); } con.close(); } } }catch(Exception e){ out.print(""); } %>

序号	用户名id	模块id	菜单id	功能id	选择	用户名	功能	状态