JDBCTemplate基础

public class JDBCTemplate1 {
    public static void main(String[] args) {

        JdbcTemplate jdbcTemplate=new JdbcTemplate(JDBCUtils.dataSource);
        //int i = jdbcTemplate.update("insert into dept values (?,?,?)", 70, "ljh", "nan");
        //System.out.println("被影响"+i);
        //

        //int i = jdbcTemplate.update("delete from dept where id=?", 70);
        //        //System.out.println("被影响"+i);

                     //注意queryForObject方法只能查询一条记录
        //String s = jdbcTemplate.queryForObject("select dname from dept where id=10", String.class);
        //System.out.println(s);
        //Map<String, Object> map = jdbcTemplate.queryForMap("select * from dept where id=10");
        //System.out.println(map);

                 //可查询多条记录queryForList方法
        List<Map<String, Object>> maps = jdbcTemplate.queryForList("select * from dept");
        System.out.println(maps);

    }
}





**query 方法     queryForObject方法：**
public class TemplateTest1 {
    public static void main(String[] args) {
        JdbcTemplate jdbc=new JdbcTemplate(JDBCUtils.dataSource);
        //List<TemplateTest2> query = jdbc.query("select * from dept ", new RowMapper<TemplateTest2>() {
        //    @Override
        //    public TemplateTest2 mapRow(ResultSet resultSet, int i) throws SQLException {
        //
        //                            int id = resultSet.getInt("id");
        //                            String dname = resultSet.getString("dname");
        //                            String loc = resultSet.getString("loc");
        //
        //                            TemplateTest2 templateTest2=new TemplateTest2(id,dname,loc);
        //
        //                            return templateTest2;
        //                            }
        //
        //});
        //System.out.println(query);

        TemplateTest2 templateTest2 = jdbc.queryForObject("select * from dept where id=10", new BeanPropertyRowMapper<>(TemplateTest2.class));
        System.out.println(templateTest2);
    }
}