protected .www.freejavaprojectsonline.blogspot.com . mails to : johnjustin@in.com */
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
