Java 超详细讲解核心类Spring JdbcTemplate

<!--导入spring的jdbc坐标-->

< dependency >

  < groupId >org.springframework</ groupId >

  < artifactId >spring-jdbc</ artifactId >

  < version >5.0.5.RELEASE</ version >

</ dependency >

<!--导入spring的tx坐标-->

< dependency >

  < groupId >org.springframework</ groupId >

  < artifactId >spring-tx</ artifactId >

  < version >5.0.5.RELEASE</ version >

</ dependency >

public class Account {

     private String name;

     private double money;

     //为方便展示省略get和set方法，具体开发中不能省。

}

//1、创建数据源对象

ComboPooledDataSource dataSource = new ComboPooledDataSource();

dataSource.setDriverClass( "com.mysql.jdbc.Driver" );

dataSource.setJdbcUrl( "jdbc:mysql://localhost:3306/test" );

dataSource.setUser( "root" );

dataSource.setPassword( "root" );

//2、创建JdbcTemplate对象

JdbcTemplate jdbcTemplate = new JdbcTemplate();

//3、设置数据源给JdbcTemplate

jdbcTemplate.setDataSource(dataSource);

//4、执行操作

jdbcTemplate.update( "insert into account values(?,?)" , "tom" , 5000 );

<!--数据源DataSource-->

< bean id = "dataSource" class = "com.mchange.v2.c3p0.ComboPooledDataSource" >

  < property name = "driverClass" value = "com.mysql.jdbc.Driver" ></ property >

  < property name = "jdbcUrl" value = "jdbc:mysql:///test" ></ property >

  < property name = "user" value = "root" ></ property >

  < property name = "password" value = "root" ></ property >

</ bean >

<!--JdbcTemplate-->

< bean id = "jdbcTemplate" class = "org.springframework.jdbc.core.JdbcTemplate" >

  < property name = "dataSource" ref = "dataSource" ></ property >

</ bean >

@Test

public void testSpringJdbcTemplate() throws PropertyVetoException {

     ApplicationContext applicationContext = new

         ClassPathXmlApplicationContext( "applicationContext.xml" );

     JdbcTemplate jdbcTemplate = applicationContext.getBean(JdbcTemplate. class );

     jdbcTemplate.update( "insert into account values(?,?)" , "lucy" , 5000 );

}

@RunWith (SpringJUnit4ClassRunner. class ) @ContextConfiguration ( "classpath:applicationContext.xml" )

public class JdbcTemplateCRUDTest {

     @Autowired

     private JdbcTemplate jdbcTemplate;

     @Test

     //测试修改操作

     public void testUpdate(){

     jdbcTemplate.update( "update account set money=? where name=?" , 1000 , "tom" );

     }

}

@Test

public void testDelete(){

     jdbcTemplate.update( "delete from account where name=?" , "tom" );

}

@Test

public void testQueryAll(){

     List<Account> accounts = jdbcTemplate.query( "select * from account" , new

  BeanPropertyRowMapper<Account>(Account. class ));

     for (Account account : accounts) {

         System.out.println(account.getName());

     }

}

@Test

//测试查询单个对象操作

public void testQueryOne(){

     Account account = jdbcTemplate.queryForObject( "select * from account where name=?" , new BeanPropertyRowMapper<Account>(Account. class ), "tom" );

     System.out.println(account.getName());

}

@Test

//测试查询单个简单数据操作(聚合查询)

public void testQueryCount(){

     Long aLong = jdbcTemplate.queryForObject( "select count(*) from account" , Long. class );

     System.out.println(aLong);

}