@Override public User updateProfile(User user) throws Exception { // TODO Auto-generated method stub // 连接数据库 DatabaseConnection dbc = new DatabaseConnection(); Connection conn = dbc.getConnection(); PreparedStatement pStatement = null; // 声明变量用于存取结果 User updatedUser = new User(); // 搜索语句 String query = "UPDATE user SET Email = ?, FullName = ?, AvatarUrl = ?, Password = ? " + "WHERE uid = ?"; try { // 执行搜索 pStatement = conn.prepareStatement(query); pStatement.setString(1, user.getEmail()); pStatement.setString(2, user.getFullName()); pStatement.setString(3, user.getAvatarUrl()); pStatement.setString(4, user.getPassWord()); pStatement.setInt(5, user.getUID()); int row = pStatement.executeUpdate(); // 判断是否为空 if (row > 0) { updatedUser = user; System.out.println("updateProfile Successful!"); } else { System.out.println("updateProfile No record satisfied!"); user = null; } // 关闭连接,返回结果 // rs.close(); dbc.close(); return updatedUser; } catch (SQLException e) { e.printStackTrace(); } return null; }