JSP Registration page:
<%@page import="java.io.*" %>
<%@page import="java.util.*" %>
<%@page import="java.sql.*" %>
<html>
<body>
<%
String s1=request.getParameter("fullname");
String s2=request.getParameter("gender");
String s3=request.getParameter("dates");
String s4=request.getParameter("months");
String s5=request.getParameter("years");
String s6=request.getParameter("bg");
String s7=request.getParameter("mobile");
String s8=request.getParameter("amobile");
String s9=request.getParameter("email");
String s10=request.getParameter("aemail");
String s11=request.getParameter("address");
String s12=request.getParameter("uname");
String s13=request.getParameter("pass");
String s14=request.getParameter("cpass");
Class.forName("oracle.jdbc.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","orcl");
Statement stmt=con.createStatement();
PreparedStatement pstmt=con.prepareStatement("insert into register(name,gender,dates,months,years,bg,mobile,amobile,email,aemail,address,uname,pass,cpass) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
pstmt.setString(1,s1);
pstmt.setString(2,s2);
pstmt.setString(3,s3);
pstmt.setString(4,s4);
pstmt.setString(5,s5);
pstmt.setString(6,s6);
pstmt.setString(7,s7);
pstmt.setString(8,s8);
pstmt.setString(9,s9);
pstmt.setString(10,s10);
pstmt.setString(11,s11);
pstmt.setString(12,s12);
pstmt.setString(13,s13);
pstmt.setString(14,s14);
pstmt.executeUpdate();
%>
<font color="#AABB00" size="5">Thanks for Registering with our site. Now you take first step to save a life<br/>
<a href="mainpage.jsp" target="body">Click Here to Continue</a></font>
</body>
</html>
Login Validation Page:
<%@page import="java.io.*" %>
<%@page import="java.util.*" %>
<%@page import="java.sql.*" %>
<html>
<body>
<%
String s1=request.getParameter("uname");
String s2=request.getParameter("pass");
Class.forName("oracle.jdbc.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","orcl");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from register where uname='"+ s1 +"' AND pass='" + s2 + "'");
if(rs.next())
{
session.setAttribute("userkey", s1);
response.sendRedirect("mainpage.jsp");
}
else
{
response.sendRedirect("logfail.html");
}
%>
</body>
</html>
No comments:
Post a Comment