apayment_edit.java

本软件是一个规模较大网上货物购买管理系统

package data;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;

public class Apayment_edit
    extends HttpServlet {
  private static final String CONTENT_TYPE = "text/html; charset=GBK";

  private String url;
  private String users;
  private String password;
  private String driverClass;

  //Initialize global variables
  public void init() throws ServletException {
    driverClass = "com.mysql.jdbc.Driver";
    url = "jdbc:mysql://localhost:3306/furniture";
    users = "root";
    password = "123123";
    try {
      Class.forName(driverClass);
    }
    catch (ClassNotFoundException ce) {
      throw new UnavailableException("加载数据库驱动失败！");
    }
  }

  //Process the HTTP Get request
  public void doGet(HttpServletRequest request, HttpServletResponse response) throws
      ServletException, IOException {
    response.setContentType(CONTENT_TYPE);
    PrintWriter out = response.getWriter();

    Connection conn = null;
    Statement stmt = null;
    try {
      conn = DriverManager.getConnection(url, users, password);
      stmt = conn.createStatement();
      stmt.executeUpdate("use furniture");

      String paymentNum = request.getParameter("paymentNum");
      String orderId = request.getParameter("orderId");
      String paymentDate = request.getParameter("paymentDate");
      String paymentAmount= request.getParameter("paymentAmount");
      String option = request.getParameter("select");
      if (option.compareTo("add") == 0) {
        String sql2 = "insert into payment values(" + paymentNum + "," + orderId + "," + paymentDate + "," + paymentAmount + ")";
        out.print("sql2:" + sql2);
        stmt.execute(sql2);
      }
      else {
        String sql = "delete from payment where paymentNum=\"" + orderId + "\" ";
        out.println("sql:" + sql);
        stmt.executeUpdate(sql);
      }
      out.println("操作成功" + "<br>");
      out.print("点击进行下一个操作");
      out.println("<form method='post' action='Apayment_edit.jsp' >");
      out.println(" <input type='submit' name='Submit' value='下一个' />");
      out.println("</form>" + "<br>");
      out.print("点击返回主页面");
      out.println("<form method='post' action='Admin.jsp' >");
      out.println(" <input type='submit' name='Submit' value='返回' />");
      out.println("</form>");
      out.close();
    }
    catch (SQLException se) {
      se.printStackTrace();
    }
    finally {
      if (stmt != null) {
        try {
          stmt.close();
        }
        catch (SQLException se) {
          se.printStackTrace();
        }
        stmt = null;
      }
      if (conn != null) {
        try {
          conn.close();
        }
        catch (SQLException se) {
          se.printStackTrace();
        }
        conn = null;
      }
    }
    out.close();
  }

  //Process the HTTP Post request
  public void doPost(HttpServletRequest request, HttpServletResponse response) throws
      ServletException, IOException {
    doGet(request, response);
  }

  //Clean up resources
  public void destroy() {
  }
}