package com.hotdon.web;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import javax.sql.*;
import java.sql.*;
public class fourthservlet extends HttpServlet {
String accountnumber;
Connection dbcon;
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dbcon = DriverManager.getConnection("jdbc:odbc:test",
"neteva", "neteva");
System.out.println("connection est");
} catch (ClassNotFoundException e) {
System.out.println("Database driver not found");
System.out.println(e.toString());
} catch (Exception e) {
System.out.println("UNKNOWN!?");
} // end catch
ServletContext context = getServletContext();
Object obj = context.getAttribute("accountnumber");
String accnum = obj.toString();
PrintWriter out = res.getWriter();
res.setContentType("text/html");
out.println("<HTML>");
out.println("<BODY bgcolor=#993366 background=images/2003121210322574350[1].jpg style=background-position:center; background-repeat:no-repeat>");
out.println("<head>");
out.println("<title>");
out.println("Information");
out.println("</title>");
out.println("</head>");
out.println("<center>");
out.println("<b><u>Your balance details</u></b>");
out.println("<br>");
out.println("Account number: " + accnum);
out.println("<br>");
out.println("<br>");
out
.println("<b><font size=5 color=green> Balance statement </font> </b>");
boolean rowfound = true;
out.println("<hr>");
out.println("<table cellpadding =20>");
out.println("<tr>");
out.println("<td>");
out.println("Name ");
out.println("</td>");
out.println("<td>");
out.println("City ");
out.println("</td>");
out.println("<td>");
out.println("Sex ");
out.println("</td>");
out.println("<td>");
out.println("QQ ");
out.println("</td>");
out.println("<td>");
out.println("Phone ");
out.println("</td>");
out.println("<td>");
out.println("E-mail ");
out.println("</td>");
out.println("</tr>");
out.println("</table>");
out.println("<hr>");
int totalrows = 0;
try {
PreparedStatement s1 = dbcon
.prepareStatement("select count(*) from Information where cAccount_id=?");
s1.setString(1, accnum);
ResultSet r = s1.executeQuery();
r.next();
totalrows = r.getInt(1);
totalrows -= 20;
} catch (Exception e) {
}
try {
PreparedStatement s2 = dbcon
.prepareStatement("Select name,city,sex,QQ,phone,Email from Information where cAccount_id=?");
s2.setString(1, accnum);
ResultSet result = s2.executeQuery();
rowfound = result.next();
int numrows = 0;
if (rowfound)
numrows = 1;
String d = new String(" ");
while (rowfound) {
if (numrows > totalrows) {
String name = result.getString(1);
String city = result.getString(2);
String sex = result.getString(3);
int QQ = result.getInt(4);
int phone = result.getInt(5);
String Email = result.getString(6);
out.println(name);
out.println("             ");
out.println(city);
out.println("             ");
out.println(sex);
out.println("             ");
out.println(QQ);
out.println("             ");
out.println(phone);
out.println("             ");
out.println(Email);
out.println("<br>");
}
rowfound = result.next();
numrows++;
}// end while
}catch (Exception e) {
System.out.println(e.toString());
}
out.println("</center>");
out.println("</BODY>");
out.println("</HTML>");
out.close();
}
}