@Override public void update(User user) { jdbcTemplate.update( "update user set password=?, role=?, corp=?, scopes=? where username=?", new Object[] { user.getPassword(), user.getRole(), user.getCorp(), SysUtils.set2String(user.getScopes(), ","), user.getUserName() }, new int[] {Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR}); }
@Override public void insert(User user) { jdbcTemplate.update( "insert into user(username, password, role, corp, scopes) values(?,?,?,?,?)", new Object[] { user.getUserName(), user.getPassword(), user.getRole(), user.getCorp(), SysUtils.set2String(user.getScopes(), ",") }, new int[] {Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR}); }