jdbcTemplate操作数据库

1.建.java为定义数据源的类

2.在bean.xml中配置数据源（见前一篇，）配置1中类

3.在测试类中通过语句操作数据库

-------------------------

package Dao;

import javax.sql.DataSource;

public class JdbcTemplate {

private DataSource dataSource;

public DataSource getDataSource() {

return dataSource;

}

public void setDataSource(DataSource dataSource) {

this.dataSource = dataSource;

}

}

bean.xml：

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xmlns="http://www.springframework.org/schema/beans"

    xsi:schemaLocation="http://www.springframework.org/schema/beans

    http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">

<bean id="jdbc" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer" >  

        <property name="locations" value="jdbc.properties"/>      

    </bean>  

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">

 <property name="driverClassName">

   <value>${jdbc.driverClassName}</value>

   </property>

   <property name="url">

   <value>${jdbc.url}</value>

   </property>

   <property name="username">

   <value>${jdbc.username}</value>

   </property>

   <property name="password">

   <value>${jdbc.password}</value>

   </property>

   </bean>

   

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

     <property  name="dataSource">

     <ref local="dataSource"/>

     </property>

     </bean>

Main.java:

package test;

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;

import org.springframework.jdbc.core.JdbcTemplate;

import com.mchange.v2.c3p0.DriverManagerDataSource;

public class Main {

public static void main(String[] args) {

DriverManagerDataSource ds=null;

JdbcTemplate jtl=null;

 

ApplicationContext ac=new ClassPathXmlApplicationContext("bean.xml");

jtl=(JdbcTemplate) ac.getBean("jdbcTemplate");

String sql="insert into user(name,password) values('happy','1111')";

jtl.update(sql);

System.out.println("插入数据成功！");

 

 

 

}

}

Main.java