Spring4常用信息笔记-1--JDBC，JDBCTemplate

---------------------beans-jdbc.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:jdbc="http://www.springframework.org/schema/jdbc"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-4.0.xsd
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-4.0.xsd">


<!-- 导入资源文件 -->
<context:property-placeholder location="classpath:db.properties"/>

<!-- 配置 C3P0 数据源 -->
<bean id="dataSource"
class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="user" value="${jdbc.user}"></property>
<property name="password" value="${jdbc.password}"></property>
<property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property>
<property name="driverClass" value="${jdbc.driverClass}"></property>


<property name="initialPoolSize" value="${jdbc.initPoolSize}"></property>
<property name="maxPoolSize" value="${jdbc.maxPoolSize}"></property>
</bean>
<!--配置jdbcTemplate  Spring的   -->
<bean class="org.springframework.jdbc.core.JdbcTemplate" id="jdbcTemplate">
<property name="dataSource" ref="dataSource"></property>



</bean>

</beans>

JDBC-----------------------------代码

package com.jdbc;

import java.util.ArrayList;
import java.util.List;


import javax.sql.DataSource;


import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;


public class JDBCTest {
private ApplicationContext ctx = null;
private JdbcTemplate jdbcTemplate=null;
{
ctx = new ClassPathXmlApplicationContext("beans-jdbc.xml");
jdbcTemplate=(JdbcTemplate) ctx.getBean("jdbcTemplate");
}
@Test
public void update() {
String sql="update user set name=? where id=?" ;
jdbcTemplate.update(sql, "呵呵",1);



}
//执行批量更新object[]{}-------------new Object[]{i,"我"+i,"是"+i}
@Test
public  void batchundate() {
String sql="insert into user(id,name,pwd) values(?,?,?)";
List<Object[]> batch=new ArrayList<>();
for(int i=2;i<10;i++){
batch.add(new Object[]{i,"我"+i,"是"+i});
}
jdbcTemplate.batchUpdate(sql, batch);
}
@Test
public void test() throws Exception {
 
DataSource dataSource=ctx.getBean(DataSource.class);
System.out.println(dataSource.getConnection());
}
//获取对象查询
@Test
public  void selectObject() {
String sql="select * from user where id=?";

RowMapper<User> rowMapper=new BeanPropertyRowMapper<>(User.class);
User u=jdbcTemplate.queryForObject(sql, rowMapper, 1);
System.out.println(u);

}



}