class ProcessDetails -ONLINE BANKING PROJECT
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
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
| import java.io.*;import javax.servlet.*;import javax.servlet.http.*;import java.sql.*;import java.util.*;public class ProcessDetails extends HttpServlet{ Connection con; Statement st; ResultSet rs; PreparedStatement ps; 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(); String rano=req.getParameter("ANO"); String rlname=req.getParameter("t1"); String rfname=req.getParameter("t2"); String reid=req.getParameter("t3"); String rhname=req.getParameter("t4"); String rst=req.getParameter("t5"); String rcity=req.getParameter("t6"); String rcountry=req.getParameter("s1"); String rtno=req.getParameter("t7"); String rocc=req.getParameter("t8"); String rinc=req.getParameter("t9"); ps=con.prepareStatement("update
usertab set
LASTNAME=?,FIRSTNAME=?,EMAILID=?,HOUSENAME=?,STREETNAME=?,CITYNAME=?,COUNTRYNAME=?,TELEPHONENO=?,OCCUPATION=?,INCOME=?
WHERE ACCOUNTNO=?"); ps.setString(1,rlname); ps.setString(2,rfname); ps.setString(3,reid); ps.setString(4,rhname); ps.setString(5,rst); ps.setString(6,rcity); ps.setString(7,rcountry); ps.setString(8,rtno); ps.setString(9,rocc); ps.setString(10,rinc); ps.setString(11,rano); ps.executeUpdate(); res.setContentType("text/html"); PrintWriter out=res.getWriter(); Calendar calendar = new GregorianCalendar(); String date=calendar.get(Calendar.DATE)+"/"+(calendar.get(Calendar.MONTH)+1)+"/"+calendar.get(Calendar.YEAR); out.println("<html><head><title>OnLineEntry</title></head>"); out.println("<body background=\"http:\\\\localhost:8080\\examples\\servlets\\images\\globe.jpg\" link=red alink=green vlink=blue>"); out.println("<h2 align=\"center\"><font color=\"#000080\">"); out.println("<img
border=\"0\"
src=\"http:\\\\localhost:8080\\examples\\servlets\\images\\earth.gif\"
align=\"left\" width=\"50\" height=\"49\">"); out.println("</font></h2><h2 align=\"center\"><font color=\"#000080\">UNIVERSAL NET BANK"); out.println("</font></h2><p align=\"center\"> </p>"); out.println("<table border=\"2\" width=\"100%\" bordercolorlight=\"#0000FF\" bordercolordark=\"#0000FF\">"); out.println("<tr><td width=\"12%\" valign=\"top\" align=\"center\">"); out.println("<a href=\"http:\\\\localhost:8080\\examples\\servlet\\Welcome?ANO="+rano+"\">Welcome"); out.println("</a></td><td width=\"18%\" valign=\"top\" align=\"center\">"); out.println("<a href=\"http:\\\\localhost:8080\\examples\\servlet\\ADetail?ANO="+rano+"\">Account Details"); out.println("</a></td><td width=\"14%\" valign=\"top\" align=\"center\">"); out.println("<a href=\"http:\\\\localhost:8080\\examples\\servlet\\WithDraw?ANO="+rano+"\">Withdrawals"); out.println("</a></td><td width=\"12%\" valign=\"top\" align=\"center\">"); out.println("<a href=\"http:\\\\localhost:8080\\examples\\servlet\\Deposit?ANO="+rano+"\">Deposits"); out.println("</a></td><td width=\"12%\" valign=\"top\" align=\"center\">"); out.println("<a href=\"http:\\\\localhost:8080\\examples\\servlet\\Loan?ANO="+rano+"\">Loans"); out.println("</a></td><td width=\"12%\" valign=\"top\" align=\"center\">"); out.println("<a href=\"http:\\\\localhost:8080\\examples\\servlet\\Mail?ANO="+rano+"\">Mail Us"); out.println("</a></td><td width=\"10%\" valign=\"top\" align=\"center\">"); out.println("<a href=\"http:\\\\localhost:8080\\examples\\servlet\\Option?ANO="+rano+"\">Options"); out.println("</a></td><td width=\"11%\" valign=\"top\" align=\"center\">"); out.println("<a href=\"http:\\\\localhost:8080\\examples\\servlets\\Logout.html\">Logout"); out.println("</a></td></tr></table><table border=\"0\" width=\"100%\">"); out.println("<tr><td width=\"50%\"><font color=\"#000080\"><b>"); out.println("Date : </b></font><font color=\"#000080\"><b>"); out.println(date); out.println("</b></font></td><td width=\"50%\" align=\"right\"><font color=\"#000080\">"); out.println("<b>Account No : <font size=\"4\">"); out.println(rano); out.println("</font></b></font></td></tr></table>"); out.println("<p><font color=\"#000080\"><b>"); out.println("Your Details has been Updated </b></font></p>"); out.println("<p><img
border=\"0\"
src=\"http:\\\\localhost:8080\\examples\\servlets\\images\\onlinebg.jpg\"
width=\"403\" height=\"83\"></p>"); out.println("<p>Freedom.............That's what we all cherish. </p>"); out.println("<p>Freedom to enjoy all the things we are otherwise prevented from enjoying in"); out.println("order to make way for all the mundane things we are forced to do........like"); out.println("going to the bank, standing in queue to make a withdrawal etc..etc..</p>"); out.println("<p>That\'s why we brought our unique net banking facility to all our esteemed"); out.println("customers. It\'s one step in the right direction to achieving financial freedom"); out.println("and peace of mind.</p>"); out.println("<p>Happy banking!</p>"); out.println("</body></html>"); } catch(SQLException sqle4){ System.out.println("Sql4 Exception "+sqle4); } catch(ClassNotFoundException cnfe){ System.out.println("Class Not Found "+cnfe); } }//END OF doPost} |
NEXT => class Updiposit OF ONLINE BANKING SYSTEM PROJECT USING JAVA/J2EE
About the Author
0 comments: