throws UnsupportedEncodingException, IOException, ServletException {
response.setContentType("text/html;charset=UTF-8");
Integer id = Integer.valueOf(request.getParameter("id"));
String oldPass = request.getParameter("oldPass");
String newPass = request.getParameter("newPass");
User entity = new User(id, null, newPass, null);
boolean flag = userService.update(entity);
if (flag) {
JOptionPane.showMessageDialog(null, "修改成功");
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
工具类：
package com.csdn.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DBConnection {
/*
* 数据库连接对象,数据库的连接都是仿照单例类模式写的 获取数据库连接对象
*/
private static Connection con;
public static Connection getCon() {
if (con == null) {
try {
// 加载数据库驱动
Class.forName("com.mysql.jdbc.Driver");
// 写url的时候一定要看清，写对了，不能马虎，否则测试的时候会报错
String url = "jdbc:mysql://localhost:3306/login user=root&password=root&useUnicode=true&characterEncoding=UTF-8";
con = DriverManager.getConnection(url);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return con;
}
// 释放资源的方法
public static void release(ResultSet rs, PreparedStatement ps) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (ps != null) {
try {
ps.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}