📄 third.java
字号:
import java.sql.*;
import javax.servlet.http.*;
import javax.servlet.*;
import java.io.*;
public class third extends HttpServlet
{
public void doPost(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
Connection con;
String accnum=String.valueOf(getServletContext().getAttribute("accnumber"));
String checknum=req.getParameter("chenum");
double money=Double.parseDouble(req.getParameter("money"));
try
{
res.setContentType("text/html");
PrintWriter out=res.getWriter();
out.println("<html>");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:MyDatabase","faculty","");
PreparedStatement ps=con.prepareStatement("insert into account_holder_transaction values(?,getdate(),?,?,?)");
ps.setString(1,accnum.trim());
ps.setString(2,"cheque");
ps.setString(3,"checknum");
ps.setDouble(4,money);
int rows=ps.executeUpdate();
con.close();
if (rows>0)
{
out.println("您的数据已经加入数据库");
out.println("<br>");
out.println("察看请点确定");
out.println("<form method = post action=/servlet/fourth>");
out.println("<input type=submit value=submit>");
out.println("</form>");
out.println("</html>");
}
else
{
out.println("数据库操作失败");
out.println("</html>");
}
}
catch(Exception e)
{
System.out.println(e);
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -