21 Aug 2016

Login Validation using JSP and Oracle

<%@page import="java.io.*" %>
<%@page import="java.util.*" %>
<%@page import="java.sql.*" %>
<html>
<body>
<%
String s1=request.getParameter("t1");
String s2=request.getParameter("p1");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("Jdbc:Odbc:orcl","system","orcl");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from registration);
while(rs.next())
{
if((s1.equals(rs.getString("uname"))) && (s2.equals(rs.getString("pass"))))
{
                       out.write("Welcome to the site" +rs.getString("uname")");

}
else
{
response.sendRedirect("logfail.html");
}
}
}
catch(Exception e)
{
                            out.write("Exception"+e);
}
%>
</body>
</html>

No comments:

Post a Comment