<% String id1=request.getParameter("adminid"); String anquanma=request.getParameter("anquanma"); System.out.println(id1); String cn="cn"; int mid=0; //连接数据库 Class.forName(driverClass);{ Connection con=DriverManager.getConnection( urlglass,user,password); //通过connection数据库链接对象 创建一个statement对象数据库操作对象 Statement stmts=con.createStatement(); //执行sql语句 String anquan="select * from anquanbiao where anquanma = '"+request.getParameter("anquanma")+"' "; ResultSet rss = stmts.executeQuery(anquan); int coun=0; while(rss.next()) { coun++; } if(coun==0){ out.print(""); } con.close(); } Class.forName(driverClass);{ Connection con=DriverManager.getConnection( urlglass,user,password); CallableStatement cs = con.prepareCall("{call mokuaichaxun()}"); ResultSet rs = cs.executeQuery(); while(rs.next()) { mid=rs.getInt(1); String mokuainame=rs.getString(2); out.println("

"); CallableStatement css = con.prepareCall("{call quanxiancaidanchaxun(?,?)}"); css.setInt(1, mid); css.setString(2, cn); ResultSet rss = css.executeQuery(); while(rss.next()){ String caidanname=rss.getString(1); String yemian=rss.getString(2); String caidanid=rss.getString(3); //out.println("
• "+caidanname+"
"); /* out.println("
• "+caidanname+"
"); */ out.print("
• "+caidanname+"
"); out.println("
"); } out.println("

"); /* */ } con.close(); } %>