📄 a_edit.java

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

💻 JAVA

字号:

package data;

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

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

  private String url;
  private String user;
  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";
    user = "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);
    response.setContentType(CONTENT_TYPE);
    PrintWriter out = response.getWriter();
    Connection conn = null;
    Statement stmt = null;

    String aId = request.getParameter("aId");
    String aPassword = request.getParameter("aPassword");
    String npassword = request.getParameter("npassword");
    try {
      conn = DriverManager.getConnection(url, user, password);
      stmt = conn.createStatement();
      stmt.executeUpdate("use furniture");
      out.println("aId:" + aId);
      out.println("aPassword:" + aPassword);


      String sql = "select * from admin where aId=\"" + aId +
          "\" and aPassword=\"" + aPassword + "\"";
      out.println("sql:"+sql);
      ResultSet rs = stmt.executeQuery(sql);
      if (rs.next()) {
        stmt.executeUpdate("delete from admin where aId='" + aId + "'");
        stmt.executeUpdate("insert into admin values('" + aId + "','" + npassword + "')");
        out.println("<HTML>");
        out.println("<HEAD>");
        out.println("<TITLE>");
        out.println("修改成功");
        out.println("</TITLE>");
        out.println("<BODY>");
        out.println("<H1>您修改已成功！</H1>");
        out.println("<H2>点击这里返回首页</H2>");
        out.println("<p align='center'>");
        out.println("<a href='Login.jsp'>");
        out.println("返回");
        out.println("</a>");
        out.println("</p>");
        out.println("</BODY>");
        out.println("<HTML>");

      }
      else {
        out.println("用户名或密码错误！");
      }
      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();
  }

  public void doPost(HttpServletRequest request, HttpServletResponse response) throws
      ServletException, IOException {
    doGet(request, response);
  }

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

  public void jbInit() throws Exception {
  }
}

💿 文件大小 411 K

👤 上传用户 xiao11tian

📂 所属分类 Java编程

🏷️ 相关标签

#软件 #模 #管理系统

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -