SpringBoot项目(7)—更新查询用户信息
预更新操作:
1.添加service接口
2.添加dao接口
3.在dao接口实现类中添加dao接口实现
@Override
public Users selectUserById(Integer id) {
Users user = new Users();
String sql = "select * from users where userid = ?";
Object[] arr = new Object[]{
id};
this.jdbcTemplate.query(sql, arr, new RowCallbackHandler() {
@Override
public void processRow(ResultSet resultSet) throws SQLException {
user.setUserid(resultSet.getInt("userid"));
user.setUsername(resultSet.getString("username"));
user.setUsersex(resultSet.