SpringJDBC——jdbcTemplate模板

public class Templatedemo1 {
    public static void main(String[] args) {
        //1.导包
        //2.创建JDBCTemplate对象，依赖于DataSource
        JdbcTemplate template=new JdbcTemplate(JDBCUtils.getDataSource());
        //3.调用JDBCTemplate方法
        String sql="insert into coount values(3,?,?)";
        int i = template.update(sql, "abcd", 1000);
        System.out.println(i);
    }
}

public class Templatedemo2 {
        //创建template对象
        JdbcTemplate template=new JdbcTemplate(JDBCUtils.getDataSource());
        //Junit单元测试，可以让方法独立运行
    @Test
    //1.修改emp表中id为1的salary为10000
    public void test1(){
            //创建JDBCTemplate对象，依赖于DataSource
            String sql="update emp set salary=10000 where id=?";
            int i = template.update(sql, 1002);
            System.out.println(i);
        }
    @Test
    //给表emp添加信息
    public void test2(){
           String sql="insert into emp (id,ename,dept_id) values (?,?,?)";
           int i = template.update(sql, 1016, "du", 10);
           System.out.println(i);
        }
    @Test
    //查询所有，封装成LIst集合
    public void test3(){
            String sql="select * from emp";
        List<Map<String, Object>> maps = template.queryForList(sql);
        for (Map<String, Object> stringObjectMap: maps){
            System.out.println(stringObjectMap);
        }
    }
}

  @Test
 //查询emp表的记录
     public void test4(){
        String sql="select * from emp";
        List<Emp>list = template.query(sql, new BeanPropertyRowMapper<Emp>(Emp.class));
        for (Emp emp:list){
            System.out.println(emp);
        }
    }

public class Emp {
    private int id;
    private String ename;
    private Integer job_id;
    private Integer mgr;
    private Date joindate;
    private Double salary;
    private Double bonus;
    private Integer dept_id;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getEname() {
        return ename;
    }

    public void setEname(String ename) {
        this.ename = ename;
    }

    public Integer getJob_id() {
        return job_id;
    }

    public void setJob_id(Integer job_id) {
        this.job_id = job_id;
    }

    public Integer getMgr() {
        return mgr;
    }

    public void setMgr(Integer mgr) {
        this.mgr = mgr;
    }

    public Date getJoindate() {
        return joindate;
    }

    public void setJoindate(Date joindate) {
        this.joindate = joindate;
    }

    public Double getSalary() {
        return salary;
    }

    public void setSalary(Double salary) {
        this.salary = salary;
    }

    public Double getBonus() {
        return bonus;
    }

    public void setBonus(Double bonus) {
        this.bonus = bonus;
    }

    public Integer getDept_id() {
        return dept_id;
    }

    public void setDept_id(Integer dept_id) {
        this.dept_id = dept_id;
    }

    @Override
    public String toString() {
        return "Emp{" +
                "id=" + id +
                ", ename=‘" + ename + ‘\‘‘ +
                ", job_id=" + job_id +
                ", mgr=" + mgr +
                ", joindate=" + joindate +
                ", salary=" + salary +
                ", bonus=" + bonus +
                ", dept_id=" + dept_id +
                ‘}‘;
    }
}