String str1=(String)request.getParameter("name1");
String str2=(String)request.getParameter("name2");
Connection conn=null;
Statement sta=null;
ResultSet re=null;
Statement st=null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:Administrivia");
sta = conn.createStatement();
String sql="select * from hao";
re=sta.executeQuery(sql);
} catch (SQLException ex) {
} catch (ClassNotFoundException ex) {
}
int n=0;
String s[] = new String[2];
try {
while (re.next()) {
s[0] = re.getString("id");
s[1] = re.getString("mima");
n++;
String ss[]=new String[2];
ss[0]=s[0].trim();
ss[1]=s[1].trim();
for(int t=0;t<=n;t++){
if(ss[0].equals(str1)&&ss[1].equals(str2)){
response.sendRedirect("ok.jsp");
break;
}
else
response.sendRedirect("error.jsp");
}
}
} catch (SQLException ex1) {
}
}








