SpringJDBCTemplate数据库连接池

1.接着前面druid数据连接池https://www.cnblogs.com/dzw159/p/16105009.html

2.引入jar包

 

 3.代码：

import org.springframework.jdbc.core.JdbcTemplate;
import util.JDBCUtils;

public class DruidDemo3 {
    public static void main(String[] args){
        //导入jar包
        //创建JDBCTemplate对象
        JdbcTemplate temp = new JdbcTemplate(JDBCUtils.getDataSource());
        //调用方法
        String sql = "update user set Name= ? where id = ?";
        int count = temp.update(sql,"dzw345",3);
        System.out.println(count);
    }
}

4.结果：

 

 

 5.补充操作

import Models.User;
import org.junit.Test;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import util.JDBCUtils;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

public class DruidDemo3 {

    //更新
    @Test
    public void test1(){
        //导入jar包
        //创建JDBCTemplate对象
        JdbcTemplate temp = new JdbcTemplate(JDBCUtils.getDataSource());
        //调用方法
        String sql = "update user set age = ? where id = ?";
        int count = temp.update(sql,1,1);
        System.out.println(count);
    }

    //查询
    @Test
    public void test2(){
        //导入jar包
        //创建JDBCTemplate对象
        JdbcTemplate temp = new JdbcTemplate(JDBCUtils.getDataSource());
        //调用方法
        String sql = "select * from user where id = ?";
        Map<String,Object> map = temp.queryForMap(sql,1);
        System.out.println(map);
    }

    //查询
    @Test
    public void test3(){
        //导入jar包
        //创建JDBCTemplate对象
        JdbcTemplate temp = new JdbcTemplate(JDBCUtils.getDataSource());
        //调用方法
        String sql = "select * from user where id = ? or id = ?";
        List<Map<String,Object>> list = temp.queryForList(sql,1,2);
        for(Map<String,Object> s : list){
            System.out.println(s);
        }
    }

    //查询
    @Test
    public void test4(){
        //导入jar包
        //创建JDBCTemplate对象
        JdbcTemplate temp = new JdbcTemplate(JDBCUtils.getDataSource());
        //调用方法
        String sql = "select * from user where id = ? or id = ?";
        List<User> list = temp.query(sql,new RowMapper<User>(){
            @Override
            public User mapRow(ResultSet resultSet, int i) throws SQLException {
                User u = new User();
                int id = resultSet.getInt("id");
                String name = resultSet.getString("name");
                int age = resultSet.getInt("age");
                u.setId(id);
                u.setName(name);
                u.setAge(age);
                return u;
            }
        },3,4);
        for(User s : list){
            System.out.println(s.getName());
        }
    }

    //查询
    @Test
    public void test5(){
        //导入jar包
        //创建JDBCTemplate对象
        JdbcTemplate temp = new JdbcTemplate(JDBCUtils.getDataSource());
        //调用方法
        String sql = "select * from user where id = ? or id = ?";
        List<User> list = temp.query(sql,new BeanPropertyRowMapper<User>(User.class),3,4);
        for(User s : list){
            System.out.println(s.getName());
        }
    }

    //查询记录数
    @Test
    public void test6(){
        //导入jar包
        //创建JDBCTemplate对象
        JdbcTemplate temp = new JdbcTemplate(JDBCUtils.getDataSource());
        //调用方法
        String sql = "select count(id) from user";
        long total = temp.queryForObject(sql,long.class);
        System.out.println(total);
    }

    public static void main(String[] args){
        //导入jar包
        //创建JDBCTemplate对象
        JdbcTemplate temp = new JdbcTemplate(JDBCUtils.getDataSource());
        //调用方法
        String sql = "insert into user (`Name`,`Age`) VALUES (?,?)";
        int count = temp.update(sql,"99", 20);
        System.out.println(count);
    }
}

 

 

 

 参阅：https://www.bilibili.com/video/BV1vk4y117fU?p=522