📄 fourthservlet.java
字号:
import java.sql.*;
import javax.servlet.http.*;
import javax.servlet.*;
import java.io.*;
public class fourthServlet extends HttpServlet
{
public void doPost(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
try
{
Connection con;
String accnum=String.valueOf(getServletContext().getAttribute("accnumber"));
PrintWriter out = res.getWriter();
res.setContentType("text/html");
out.println("<html>");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:MyDatabase","faculty","");
PreparedStatement ps=con.prepareStatement("select count(*) from account_holder_transaction where cAccount_id='" + accnum.trim() +"'");
ResultSet rs=ps.executeQuery();
rs.next();
int rowCount=rs.getInt(1);
rowCount=rowCount-20;
// System.out.println("select datepart(yy,ddate_of_transaction),datepart(m,ddate_of_transaction),datepart(d,ddate_of_transaction),mamount from account_holder_transaction where caccount_id=" + accnum);
ps=con.prepareStatement("select datepart(yy,ddate_of_transaction),datepart(m,ddate_of_transaction),datepart(d,ddate_of_transaction),mamount from account_holder_transaction where caccount_id='" + accnum.trim() +"'");
ResultSet rs1=ps.executeQuery();
int row=0;
// rs.next();
while (rs1.next())
{
if(row>rowCount)
{
out.println(rs1.getInt(1) + "年");
out.println(rs1.getInt(2) + "月");
out.println(rs1.getInt(3) + "日");
out.println("          ");
out.println(rs1.getDouble(4) + "圆");
out.println("<br>");
}
row++;
}
out.println("</html>");
}
catch(Exception e)
{
System.out.println(e);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -