spring之jdbcTemplate

1.spring JdbcTemplate基本使用

1.1jdbcTemplate概述

他是spring框架中提供的一个对象，是对原始繁琐的jdbcAPI对象的简单封装。spring框架为我们提供了很多的操作模板类。例如：操作关系型数据库jdbcTemplate和HiberateTemplate，操作nosql数据库的RedisTemplate，操作消息队列的JmsTemplate等等

1.2jdbcTemplate开发步骤

1. 导入spring-jdbc和spring-tx坐标

   <dependency>
           <groupId>org.springframework</groupId>
           <artifactId>spring-jdbc</artifactId>
           <version>5.2.12.RELEASE</version>
       </dependency>
       <dependency>
           <groupId>org.springframework</groupId>
           <artifactId>spring-tx</artifactId>
           <version>5.2.12.RELEASE</version>
       </dependency>

2. 创建数据库表的实体
3. 创建jdbcTemplate对象

 @Test
   public void text2() throws PropertyVetoException, SQLException {
       ResourceBundle rs=ResourceBundle.getBundle("jdbc");
       String driver = rs.getString("driver");
       String url = rs.getString("url");
       String username = rs.getString("username");
       String password = rs.getString("password");
       ComboPooledDataSource dataSource=new ComboPooledDataSource();
       dataSource.setDriverClass(driver);
       dataSource.setJdbcUrl(url);
       dataSource.setUser(username);
       dataSource.setPassword(password);
       Connection connection = dataSource.getConnection();
       System.out.println(connection);
       JdbcTemplate jdbcTemplate=new JdbcTemplate();
       jdbcTemplate.setDataSource(dataSource);
   }

4. 执行数据库操作

1.3封装

xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xmlns:context="http://www.springframework.org/schema/context"
      xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context  http://www.springframework.org/schema/context/spring-context.xsd">
   <context:component-scan base-package="com.blb"></context:component-scan>
  <context:property-placeholder location="jdbc.properties"></context:property-placeholder>
   <bean id="jdbc" class="com.mchange.v2.c3p0.ComboPooledDataSource">
       <property name="driverClass" value="${driver}"></property>
       <property name="jdbcUrl" value="${url}"></property>
       <property name="user" value="${name}"></property>
       <property name="password" value="${password}"></property>
   </bean>
   <bean id="jt" class="org.springframework.jdbc.core.JdbcTemplate">
       <property name="dataSource" ref="jdbc"></property>
   </bean>
</beans>

1.4数据库相关操作

1.4.1增删改操作

    @Test
   public void text3(){
       ApplicationContext applicationContext=new ClassPathXmlApplicationContext("app.xml");
       JdbcTemplate jt =(JdbcTemplate) applicationContext.getBean("jt");
       jt.update("DELETE FROM TEXT WHERE id =?",999);
   }

1.4.2查询操作

    /**
    * 查询所有元素
    */
   @Test
   public void text4(){
       ApplicationContext applicationContext=new ClassPathXmlApplicationContext("app.xml");
       JdbcTemplate jt =(JdbcTemplate) applicationContext.getBean("jt");
       List<User> query = jt.query("SELECT * FROM TEXT", new BeanPropertyRowMapper<User>(User.class));
       for(User user : query)
       {
           System.out.println(user.getId()+' '+user.getTemp());
       }

   }

   /**
    * 查询一个元素
    */
   @Test
   public void text5()
   {
       ApplicationContext applicationContext=new ClassPathXmlApplicationContext("app.xml");
       JdbcTemplate jt =(JdbcTemplate) applicationContext.getBean("jt");
       User user = jt.queryForObject("SELECT * FROM TEXT WHERE id = ?", new BeanPropertyRowMapper<User>(User.class), 5);
       System.out.println(user.getId());
       System.out.println(user.getTemp());
   }
   /**
    * 查询总数
    */
   @Test
   public void text6()
   {
       ApplicationContext applicationContext=new ClassPathXmlApplicationContext("app.xml");
       JdbcTemplate jt =(JdbcTemplate) applicationContext.getBean("jt");
       Long count = jt.queryForObject("SELECT COUNT(*) FROM TEXT", long.class);
       System.out.println(count);
   }