</span>/* this code is intended education purpuse only. all rights reserved .copy right
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="\" text="\"><h3 align="\">");
out.println("<span >Welcome");
out.println(fname+" "+lname);
out.println(" </span></h3><p><span style="font-size:\;color:\;">");
out.println("<marquee behavior="\">");
out.println("Thank you for banking with us.</marquee></span></p>");
out.println("<p><span >Remember your Account No, User ID and Password.");
out.println("</span></p>");
out.println("<p><span >Your Account Number is :");
out.println(" ");
out.println(rano);
out.println("</span> </p>");
out.println("<p><span >Your User ID is ");
out.println(" : ");
out.println(ruid);
out.println("</span></p>");
out.println("</span></p><h2 align="\"><span style="color:blue;">Please click below to proceed</span></h2>");
out.println("<h3 align="\"><span ><a href="\" ano="+rano+" target="\">");
out.println("Consumer Banking</a> </span></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 Deposit SOURCE CODE IN ONLINE BANKING SYSTEM PROJECT
