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
About the Author
0 comments: