Spring JDBC( 以 SQLSERVER 为例 ) jdbcTemplate

< 1 > 配置文件

<?xml version="1.0" encoding="UTF-8"?>
<beans 
    xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.springframework.org/schema/beans 
    http://www.springframework.org/schema/beans/spring-beans.xsd"
>
    <!-- 配置 C3P0 连接池数据源, 已 SQLSERVER 为例, 四个注入属性为 连接的四个信息-->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="jdbcUrl" value="jdbc:sqlserver://localhost:1433; DatabaseName=SQL"></property>
        <property name="driverClass" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"></property>
        <property name="user" value="sa"></property>
        <property name="password" value="920619.hwq"></property>
    </bean>
    
    <!-- 配置 JDBC 模板类 jdbcTemplate -->
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"></property>
    </bean>

</beans>

< 二 > 使用方式 ( 新增为例 )

package spring.amain;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;

public class JdbcTest {
    public static void main(String[] args) {
        @SuppressWarnings("resource")
        ApplicationContext ac = new ClassPathXmlApplicationContext("config/spring2jdbc.xml");
        JdbcTemplate jdbcTemplate = (JdbcTemplate) ac.getBean("jdbcTemplate");
        String sql = "insert into [User] (Name) values (?)";
        jdbcTemplate.update(sql, "姓名");
    }
}