java for update 无效_java 修改数据库时数据无法更新

代码：//修改if("update".equals(type)){//客户端传来的Stringid=request.getParameter("id");Stringusername=request.getParameter("username");Stringpassword=request.getParamete...

代码：

// 修改

if ("update".equals(type)) {

// 客户端传来的

String id = request.getParameter("id");

String username = request.getParameter("username");

String password = request.getParameter("password");

String truename = request.getParameter("truename");

String birthday = request.getParameter("birthday");

String sex = request.getParameter("sex");

String[] interest = request.getParameterValues("interest");

String remark = request.getParameter("remark");

// 将字符串转换成真正的日期类型

java.sql.Date birthdayToDate = null;

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

try {

// 将一个字符串转换成Date

java.util.Date date = sdf.parse(birthday);

birthdayToDate = new java.sql.Date(date.getTime());

} catch (ParseException e) {

// TODO: handle exception

e.printStackTrace();

}

String interestToString = null;

StringBuffer sb = new StringBuffer();

for (int i = 0; i < interest.length; i++) {

sb.append(interest[i]);

}

interestToString = sb.toString();

Users bean = new Users();

//bean.setId(id);

//bean.setUsername(username);

bean.setPassword(password);

bean.setTruename(truename);

bean.setBirthday(birthdayToDate);

bean.setSex(sex);

bean.setInterest(interestToString);

// bean.setRegisterdate(new java.sql.Date(new java.util.Date().getTime()));

bean.setRemark(remark);

UsersDB userDB = new UsersDB();

userDB.update(bean);

//显示所有用户信息

ArrayList arrayList = userDB.getAllUsers();

request.setAttribute("all", arrayList);

request.getRequestDispatcher("/listAllUsers.jsp").forward(request,

response);

//此处查询是java中有值，但查询的时候数据不会改变

System.out.println(id);

System.out.println(username);

System.out.println(password);

System.out.println(truename);

System.out.println(birthdayToDate);

}

// 更新一笔记录

public void update(Users bean) {

try {

//获取连接

Connection con = this.getConnection();

String sql = "update users set password=?,truename=?,birthday=?,sex=?,interest=?,remark=? where id=?";

PreparedStatement ps = con.prepareStatement(sql);

ps.setString(1, bean.getPassword());

ps.setString(2, bean.getTruename());

ps.setDate(3, bean.getBirthday());

ps.setString(4, bean.getSex());

ps.setString(5, bean.getInterest());

ps.setString(6, bean.getRemark());

ps.setInt(7, bean.getId());

ps.executeUpdate();// 真正的完成数据的更新

con.close();

} catch (Exception ex) {

// TODO: handle exception

System.out.println("修改记录发生异常：" + ex.getMessage());

}

System.out.println(bean.getPassword());

System.out.println(bean.getTruename());

System.out.println(bean.getBirthday());

}

展开