/*PreparedStatement是Statement的子接口(如图所示),表示预编译的 SQL 语句的对象,SQL 语句被预编译并存储在PreparedStatement对象中。然后可以使用此对象多次高效地执行该语句。*/
String id = request.getParameter("id");
String sql = "UPDATE tb_person SET name = ?,english_name = ?,sex = ?,age = ?,birthday = ?,description = ? WHERE id = ? "; //7个问号代表7个字段预先要保留的值
Connection conn = null;
PreparedStatement preStmt = null;
try{
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/databaseWeb?characterEncoding=UTF-8",
"root",
"admin");
preStmt = conn.prepareStatement(sql);// 使用PreparedStatement对象来构建并执行SQL语句
preStmt.setString(1, name);//把name设置到SQL中的第1个问号处 preStmt.setString(2, englishName);
preStmt.setString(3, sex);
preStmt.setInt(4, Integer.parseInt(age));
preStmt.setDate(5, new Date(new SimpleDateFormat("yyyy-MM-dd").parse(birthday).getTime()));
preStmt.setString(6, description);
preStmt.setInt(7, Integer.parseInt(id));
// 使用 preStmt 执行 SQL 语句
int result = preStmt.executeUpdate(sql);
out.println("<html><style>body{font-size:12px; line-height:25px; }</style><body>");
if(result == 0) out.println("影响数目为 0, 修改失败. ");
else out.println(result + " 条记录被修改。");
out.println("<a href='listPerson.jsp'>返回人员列表</a>");
// 将执行的 SQL 语句输出到客户端
out.println("<br/><br/>执行的 SQL 语句为:<br/>" + sql);
}catch(SQLException e){
out.println("执行SQL\"" + sql + "\"时发生异常:" + e.getMessage());
e.printStackTrace();
}finally{
if(preStmt != null) preStmt.close();
if(conn != null) conn.close();
}
}