class Loan module of online banking system java academic 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
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
| import java.io.*;import javax.servlet.*;import javax.servlet.http.*;import java.sql.*;import java.util.*;public class Loan 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(); 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); String sql="SELECT * FROM LITABLE ORDER BY DURATION"; rs=st.executeQuery(sql); int ano=Integer.parseInt(req.getParameter("ANO")); out.println("<html><head><title>Options</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="+ano+"\">Welcome"); out.println("</a></td><td width=\"18%\" valign=\"top\" align=\"center\">"); out.println("<a href=\"http:\\\\localhost:8080\\examples\\servlet\\ADetail?ANO="+ano+"\">Account Details"); out.println("</a></td><td width=\"14%\" valign=\"top\" align=\"center\">"); out.println("<a href=\"http:\\\\localhost:8080\\examples\\servlet\\WithDraw?ANO="+ano+"\">Withdrawals"); out.println("</a></td><td width=\"12%\" valign=\"top\" align=\"center\">"); out.println("<a href=\"http:\\\\localhost:8080\\examples\\servlet\\Deposit?ANO="+ano+"\">Deposits"); out.println("</a></td><td width=\"12%\" valign=\"top\" align=\"center\">"); out.println("<a href=\"http:\\\\localhost:8080\\examples\\servlet\\Option?ANO="+ano+"\">Options"); out.println("</a></td><td width=\"12%\" valign=\"top\" align=\"center\">"); out.println("<a href=\"http:\\\\localhost:8080\\examples\\servlet\\Mail?ANO="+ano+"\">Mail Us"); 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=\"3\">"); out.println(ano); out.println("</font></b></font></td></tr></table>"); out.println("<p
align=\"center\"> <img border=\"0\"
src=\"http:\\\\localhost:8080\\examples\\servlets\\images\\update.jpg\"
width=\"403\" height=\"83\"></p>"); out.println("<p align=\"center\"><font size=\"4\" color=\"#000080\"><b>LOAN APPLICATION FORM"); out.println("</b></font></p><p
align=\"center\"><b> "); out.println(" "); out.println(" "); out.println(" "); out.println(" "); out.println(" "); out.println(" "); out.println(" "); out.println(" Interest Rates</b></p>"); out.println("<form method=\"POST\" action=\"http:\\\\localhost:8080\\examples\\servlet\\UpdateLoan\""); out.println("style=\"position: absolute; left: 20; top: 400; width: 675; height: 120\" >"); out.println("<input type=hidden name=\"ANO\" value=\"1000\">"); out.println("<table border=\"3\" width=\"55%\" height=\"109\">"); out.println("<tr><td width=\"39%\" height=\"23\"><font size=\"3\"><b>"); out.println("Loan Amount Required </b></font></td><td width=\"35%\" height=\"23\">"); out.println("<input type=\"text\" name=\"AMOUNT\" size=\"20\"></td></tr><tr>"); out.println("<td width=\"39%\" height=\"18\"><font size=\"3\"><b>Loan Duration </b>"); out.println("</font></td><td width=\"35%\" height=\"18\">"); out.println("<select size=\"1\" name=\"DURATION\">"); while(rs.next()) { out.println("<option>"+rs.getString(1)+"</option>"); } out.println("</select></td>"); out.println("</tr><tr><td width=\"39%\" height=\"19\"> </td>"); out.println("<td width=\"35%\" height=\"19\"> </td></tr><tr>"); out.println("<td width=\"39%\" height=\"25\"> </td><td width=\"10%\" height=\"25\">"); out.println("<p align=\"right\"><input type=\"submit\" value=\"Submit\" name=\"B1\"></td>"); out.println("</tr></table></form><div align=\"right\">"); out.println("<table border=\"2\" width=\"40%\"><tr>"); out.println("<td width=\"44%\" align=\"center\" bgcolor=\"#FFFFFF\"><b><font color=\"#000080\">Loan"); out.println(" Duration</font></b></td>"); out.println("<td width=\"56%\" align=\"center\" bgcolor=\"#FFFFFF\"><b>"); out.println("<font color=\"#000080\">Loan Interest Rate</font></b></td></tr>"); rs=st.executeQuery(sql); while(rs.next()) { out.println("<tr>"); out.println("<td width=\"44%\" align=\"left\">"+rs.getString(1)+" Year</td>"); out.println("<td width=\"56%\" align=\"left\">"+rs.getString(2)+"%</td></tr>"); out.println("</tr>"); } out.println("</table></div>"); out.println("<font color=red><MARQUEE><I>This option is for future enhancement (ATM Facility). The page is just displayed for knowing the facilities</I></MARQUEE></font>"); out.println("</body></html>"); } catch(SQLException sqle4){ System.out.println("Sql4 Exception "+sqle4); } catch(ClassNotFoundException cnfe){ System.out.println("Class Not Found "+cnfe); } } public void doGet(HttpServletRequest req,HttpServletResponse res) throws IOException,ServletException{ doPost(req,res); }} |
NEXT =>class processDetails OF ONLINE BANKING SYSTEM
About the Author
0 comments: