<%@page import="javax.swing.text.html.HTML"%>
<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
Insert title here
<%@include file="../mysqlconnect.jsp"%>
<%
String zdygh=request.getParameter("adminid");
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 con1=DriverManager.getConnection( urlglass,user,password);
CallableStatement cs1 = con1.prepareCall("{call chaxunmima(?)}");
cs1.setString(1, zdygh);
ResultSet rs1 = cs1.executeQuery();
int i=0;
while(rs1.next())
{
zdygh=rs1.getString(1);
i++;
}
}
%>