一、查找一个对象即一条数据
- 写User类(pom文件的依赖也不赘述了)
@Data // 自动生成setter/getter、equals、canEqual、hashCode、toString方法
public class User {
private Integer id;
private String username;
private String password;
}
- 创建UserDao接口、用UserDaoImpl实现:
public interface UserDao {
public int addUser(User user);
public int updateUser(User user);
public int deleteUser(int id);
public User findUserById(int id);
public List<User> findAllUser();
}
这里其他方法的实现就不赘述了:
@Override
public User findUserById(int id) {
String sql = "select * from user where id = ?";
return (User) this.jdbcTemplate.queryForObject(sql,
new BeanPropertyRowMapper<User