protected .www.freejavaprojectsonline.blogspot.com . mails to : johnjustin@in.com */
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.util.*;
public class logincheck1 extends HttpServlet{
Connection con;
Statement st;
ResultSet rs;
public void doPost(HttpServletRequest req,HttpServletResponse res) throws IOException,ServletException{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:bank");
st=con.createStatement();
int rano=Integer.parseInt(req.getParameter("accno"));
String ruid=req.getParameter("usrid");
String rupwd=req.getParameter("pswrd");
rs=st.executeQuery("SELECT * FROM USERTAB WHERE ACCOUNTNO="+rano+" AND USERID=\'"+ruid+"\' AND USERPWD=\'"+rupwd+"\'");
if (rs.next()){
res.setContentType("text/html");
PrintWriter out=res.getWriter();
String lname=rs.getString("lastname");
String fname=rs.getString("firstname");
out.println("<html><head><title>Welcome Page</title></head>");
out.println("<body background=\"http:\\\\localhost:8080\\examples\\servlets\\images\\globe.jpg\" text=\"#000080\"><h3 align=\"center\">");
out.println("<font color=\"#FF0000\">Welcome");
out.println(fname+" "+lname);
out.println(" </font></h3><p><font size=\"5\" color=\"#FF0066\">");
out.println("<marquee behavior=\"alternate\">");
out.println("Thank you for banking with us.</marquee></font></p>");
out.println("<p><font size=\"4\" color=\"#000000\">Remember your Account No, User ID and Password.");
out.println("</font></p>");
out.println("<p><font color=\"#000000\" size=\"4\">Your Account Number is :");
out.println(" ");
out.println(rano);
out.println("</font> </p>");
out.println("<p><font color=\"#000000\" size=\"4\">Your User ID is ");
out.println(" : ");
out.println(ruid);
out.println("</font></p>");
out.println("</font></p><h2 align=\"right\"><font color=blue>Please click below to proceed</font></h2>");
out.println("<h3 align=\"right\"><font color=\"#00FF00\"><a href=\"http:\\\\localhost:8080\\examples\\servlet\\OnLineEntry\\?ANO="+rano+"\" target=\"_top\" >");
out.println("Consumer Banking</a> </font></h3></body></html>");
}
else
res.sendRedirect("http:\\\\localhost:8080\\examples\\servlets\\login1.html");
}
catch(SQLException sqle4){
System.out.println("Sql Exception "+sqle4); }
catch(ClassNotFoundException cnfe){
System.out.println("Class Not Found "+cnfe);
}
}//END OF doPost
}
NEXT =>> class Option ONLINE BANKING PROJECT
