online banking system java file - class ADetail
</span>/* this code is intended education purpuse only. all rights reserved .copy right
*/
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
| 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
0 comments: