public List<User> selectByCriteria(User paramUser) { List userList = this.userDao.selectByCriteria(paramUser); List results = new ArrayList(); if (userList != null) { for (int i = 0; i < userList.size(); i++) { User user = (User) userList.get(i); user.setBirthdayStr(DateUtils.formatDate2Str(user.getBirthday(), "yyyy-MM-dd")); user.setSex((String) Constants.SEX_MAP.get(user.getSex())); user.setStatus((String) Constants.USER_STATUS_MAP.get(user.getStatus())); user.setCreateDateStr( DateUtils.formatDate2Str(user.getCreateTime(), "yyyy-MM-dd HH:mm:ss")); results.add(user); } } return results; }
/** 插入数据 */ public Integer insertUser(User user) { QueryRunner queryRunner = new QueryRunner(JdbcUtils.getDataSource()); try { String sql = "INSERT INTO user VALUES (?, ?, ?, ?, ?, ?, ?, ?)"; Object param[] = { getID(), user.getUsername(), user.getPassword(), user.getSex(), user.getProfession(), user.getFavourite(), user.getNote(), user.getType() }; int update = queryRunner.update(sql, param); return update; } catch (SQLException e) { e.printStackTrace(); return null; } }
public List<User> selectByCriteriaForPaging(User paramUser) { if ("1".equals(SessionUtils.getUserRole())) paramUser.setRole("'2','3'"); else { paramUser.setRole("'3'"); } List userList = this.userDao.selectByCriteriaForPaging( paramUser, paramUser.getStart(), paramUser.getLimit()); List results = new ArrayList(); if (userList != null) { for (int i = 0; i < userList.size(); i++) { User user = (User) userList.get(i); user.setBirthdayStr(DateUtils.formatDate2Str(user.getBirthday(), "yyyy-MM-dd")); user.setRole((String) Constants.ROLE_MAP.get(user.getRole())); user.setSex((String) Constants.SEX_MAP.get(user.getSex())); user.setStatus((String) Constants.USER_STATUS_MAP.get(user.getStatus())); results.add(user); } } return results; }
/** * 数据库操作 更新个人用户数据 * * @param user */ public void updateinfo(User user) { QueryRunner queryRunner = new QueryRunner(JdbcUtils.getDataSource()); String sql = "UPDATE user SET username = ?, password = ?, sex = ?, profession = ?, favourite = ?, note = ? WHERE id = ?;"; try { queryRunner.update( sql, new Object[] { user.getUsername(), user.getPassword(), user.getSex(), user.getProfession(), user.getFavourite(), user.getNote(), user.getId() }); } catch (SQLException e) { e.printStackTrace(); } }