class logincheck1 ONLINE BANKING USING JSP ACADEMIC PROJECT SOURCE CODE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
| 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
About the Author
0 comments: