jdbc Template query

自定义数据封装规则

public class MyMapper implements RowMapper<User> {
    @Override
    public User mapRow(ResultSet resultSet, int i) throws SQLException {
        int id = resultSet.getInt("id");
        String usename = resultSet.getString("username");
        int password = resultSet.getInt("password");
        User user = new User();
        user.setId(id);
        user.setPassword(password);
        user.setUsername(usename);
        return user;
    }
}

查询

public class DataSource {
    public static void main(String[] args) {
        // 配置datasource
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.setUrl("jdbc:mysql:///hello");
        dataSource.setUsername("test");
        dataSource.setPassword("test");
        // ------查询方式1---------
        String sql = "select * from user";
        BeanPropertyRowMapper<User> mapper = new BeanPropertyRowMapper<>(User.class);
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
        List<User> query = jdbcTemplate.query(sql, mapper);
        for (User user : query) {
            System.out.println(user);
        }
        // ------查询方式2---------
        String sql2 = "select * from user where id=?";
        List<User> userList = jdbcTemplate.query(sql2, new MyMapper(), 1);
        for (User user : userList) {
            System.out.println(user);
        }
    }
}