jsp-修改数据~连接数据库版（8.00000）

最新推荐文章于 2022-07-11 07:34:00 发布

不会起名字的程序猿

最新推荐文章于 2022-07-11 07:34:00 发布

阅读量166

点赞数

本文链接：https://blog.csdn.net/amspony/article/details/103080596

版权

package com.anbow.selvet;

import com.anbow.DButils.DruidUtils;
import com.anbow.JDBC.JDBC;
import org.apache.commons.dbutils.DbUtils;
import org.apache.commons.dbutils.QueryRunner;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

@WebServlet("/update")
public class Userupdate extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType(“text/html;charset= UTF-8”);
request.setCharacterEncoding(“utf-8”);
Connection connection = JDBC.getConnection();
String id = request.getParameter(“id”);
String sex = request.getParameter(“user_sex”);
String age = request.getParameter(“age”);
String number = request.getParameter(“userphone”);
String address = request.getParameter(“userAddress”);
String style = request.getParameter(“userlei”);

    String sql = "update userList set id = ?,sex = ?,age = ?,number = ?,address = ?,style = ? where id= id";
    try {
        PreparedStatement ps = connection.prepareStatement(sql);
        ps.setString(1,id);
        ps.setString(2,sex);
        ps.setString(3,age);
        ps.setString(4,number);
        ps.setString(5,address);
        ps.setString(6,style);
        ps.executeUpdate();
        request.getRequestDispatcher("userList.jsp").forward(request,response);


    } catch (SQLException e) {
        e.printStackTrace();
    }
}

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