11、Spring核心-连接池中使用jdbcTemplate

要使用jdbcTemplate首先需要导包

jdbcTemplate依赖

<dependency>
    <groupId>io.github.daosupport</groupId>
    <artifactId>jdbcTemplate-support</artifactId>
    <version>1.0.1-RELEASE</version>
</dependency>

配置连接池和jdbcTemplate

<!--引入外部*.properties文件-->
<context:property-placeholder location="classpath:jdbc.properties" ignore-unresolvable="true"/>

<!--配置阿里druid连接池-->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="clone">
    <property name="driverClassName" value="${jdriver}"/>
    <property name="url" value="${jurl}"/>
    <property name="username" value="${jusername}"/>
    <property name="password" value="${jpassword}"/>
</bean>
<!--创建jdbcTemplete并引用druid数据源-->
<bean id="jdbcTemplete" class="org.springframework.jdbc.core.JdbcTemplate">
    <constructor-arg name="dataSource" ref="dataSource"/>
</bean>
<context:component-scan base-package="com.jdbctemplete"/>

创建用来存取数据的实体类User

@Data
@NoArgsConstructor
@AllArgsConstructor
public class User implements Serializable {
    private static final long serialVersionUID = 760803936321762172L;

    private Integer uid;

    private String uname;

    private String pwd;

    private Integer age;

}

编写测试类

public class Test01 {
    ApplicationContext ioc = new ClassPathXmlApplicationContext("applicationContext.xml");
    JdbcTemplate jdbcTemplate = (JdbcTemplate) ioc.getBean("jdbcTemplete");

    /**
     * 查询当条数据
     */
    @Test
    public void test01() {
        String sql = "select * from user where uid=?";
        User user = jdbcTemplate.queryForObject(sql, new BeanPropertyRowMapper<>(User.class), 1);
        System.out.println(user);
    }

    /**
     * 查询所有数据
     */
    @Test
    public void test02() {
        String sql = "select * from user";
        List<User> query = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(User.class));
        for (User user : query) {
            System.out.println(user);
        }
    }

    /**
     * 批量插入数据
     */
    @Test
    public void test03() {
        String sql = "insert into user(uname, pwd, age) values (?,?,?)";
        List<Object[]> list = new ArrayList<>();
        list.add(new Object[]{"wangww", "ww123", 18});
        list.add(new Object[]{"zhaoqi", "zq123", 20});
        list.add(new Object[]{"laoliu", "ll123", 22});
        int[] count = jdbcTemplate.batchUpdate(sql, list);
        for (int i : count) {
            System.out.println(i);
        }
    }

    /**
     * 更新数据
     */
    @Test
    public void test04() {
        String sql = "update user set uname=?,pwd=?,age=? where uid=?";
        List<Object[]> list = new ArrayList<>();
        list.add(new Object[]{"wangww", "ww123", 25, 10});
        list.add(new Object[]{"zhaoqi", "zq123", 30, 11});
        list.add(new Object[]{"laoliu", "ll123", 35, 12});
        int[] count = jdbcTemplate.batchUpdate(sql, list);
        for (int i : count) {
            System.out.println(i);
        }
    }
}

真的是太过于简单了。。。。插入和修改数据都是要将数据封装成list集合