JDBCTemplate

1.jar包

2.utils

JDBCtemplate依赖于DataSource 所以对DataSource方法封装

  public static DataSource getDataSource() {
        try {
            ds = DruidDataSourceFactory.createDataSource(pro);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return ds;
    }

3.各种方法的实现

public class Test {

    DruidUtils utils = new DruidUtils();
    //在外面获取jdbcTemplate 以后不用每次都获取
    private JdbcTemplate jdbcTemplate = new JdbcTemplate(utils.getDataSource());

    @org.junit.Test
    //  DML update 修改
    public void update() {
        String sql = "update test1 set username = ? where uid = ?";
        int update = jdbcTemplate.update(sql, 1234, 1);
        System.out.println(update);
    }

    @org.junit.Test
    // DML 添加一条记录
    public void add() {
        String sql = "insert into test1 values(?,?,?,?)";
        int num = jdbcTemplate.update(sql, 2, "古力娜扎", "123", "456");
        System.out.println(num);
    }

    @org.junit.Test
    //DML 删除一条记录
    public void delete() {
        String sql = "delete from test1 where uid = ?";
        int num2 = jdbcTemplate.update(sql, 2);
        System.out.println(num2);

    }

    @org.junit.Test
    //DQL 根据id查询 结果返回一条 一条用map集合装 queryForMap方法
    public void findbyid() {
        String sql = "select * from test1 where uid = ?";
        Map<String, Object> map = jdbcTemplate.queryForMap(sql, 1);
        System.out.println(map);
    }

    @org.junit.Test
    //DQL 全查 结果返回多条map集合 再利用list集合装map queryForList方法
    public void findall() {
        String sql = "select * from test1";
        List<Map<String, Object>> list = jdbcTemplate.queryForList(sql);

        for (Map<String, Object> list1 : list) {
            System.out.println(list1);
        }
    }

    @org.junit.Test
    //查询所有对象  将其封装成javabean对象
    public void javaBean(){
        String sql = "select * from test1";
        List<User> list = jdbcTemplate.query(sql, new BeanPropertyRowMapper<User>(User.class));
        for(User list1:list){
            System.out.println(list1);
        }
    }

    @org.junit.Test
    //查询总记录数
    public void findNumber(){
        String sql = "select count(*) from test1";
        Long aLong = jdbcTemplate.queryForObject(sql, long.class);
        System.out.println(aLong);
    }

}