third.java

来自「J2EE关于JSP,SERVERLET的多个实用例子」· Java 代码 · 共 51 行

JAVA
51
字号
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 + =
减小字号Ctrl + -
显示快捷键?