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 SendMail extends HttpServlet{
Connection con;
Statement st;
ResultSet rs;
PreparedStatement ps;
String sql=null;
int mno;
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();
sql="SELECT MAILID FROM MAIL ORDER BY MAILID DESC";
rs=st.executeQuery(sql);
if(rs.next())
mno=Integer.parseInt(rs.getString(1))+1;
else
mno=100;
int rano=Integer.parseInt(req.getParameter("ANO"));
String rmsg=req.getParameter("MSG");
ps=con.prepareStatement("insert into mail values(?,?,?)");
ps.setInt(1,mno);
ps.setInt(2,rano);
ps.setString(3,rmsg);
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 Mail has been Successfully Received.</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 UPDeposit ONLINE BANKING APPLICATION PROJECT
