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
0 comments: