|
check this and ifthere is any error then plz mail me the right code
<html>
<head><title>validation of user</title></head>
<body>
<p align="left"><img border="0" src="/forum/deepeeka_logo.jpg" width="135" height="53"></p>
<%@ page language="java" import="java.io.*,java.sql.*" contenttype="text/html" %>
<%
int flag=0,i=0;
String s1=request.getParameter("id");
String s2=request.getParameter("pass");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:ank");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from userrec");
while(rs.next())
{
if((s1.equals(rs.getString(1))) && (s2.equals(rs.getString(2))))
{
response.sendRedirect("/ankit/shop.html");
}
else
{
response.sendRedirect("/ankit/un.html");
}
}
%>
</body>
</html>
|
|
|
|
|
|
|
// |