JdbcSupport

用法

App.java

import com.mj.dao.JdbcSupportDao;
import com.mj.dao.JdbcTempDao;
import com.mj.dao.UserDao;
import com.mj.model.ModelUser;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.support.JdbcDaoSupport;

import javax.jws.WebParam;
import java.io.FileNotFoundException;

public class App {



    public static void main(String args[]) throws FileNotFoundException{
        /*
        //ClassPathXmlApplicationContext
        ApplicationContext context = new ClassPathXmlApplicationContext("com/mj/xml/Bean.xml");
        BeanSay sa = (BeanSay) context.getBean("BeanSay");
        sa.setMsg("__Spring");
        sa.talk();

        //FileSystemXmlApplicationContext
        ApplicationContext fileContext = new FileSystemXmlApplicationContext("/src/com/mj/xml/Bean.xml");
        BeanSay sa1 = (BeanSay) fileContext.getBean("BeanSay");
        sa1.setMsg("=Spring====");
        sa1.talk();

        ApplicationContext animalContext = new ClassPathXmlApplicationContext("com/mj/xml/Bean.xml");
        BeanAnimal ani =  (BeanAnimal) animalContext.getBean("Animal");
        ani.setAnimalName("dog");
        ani.showAnimal();

        BeanAnimal animal =  (BeanAnimal) animalContext.getBean("Animal");
        animal.setAnimalName("pig");
        animal.showAnimal();

        // init method   destroy method
        BeanLife life = (BeanLife) context.getBean("BeanLife");
        life.showName();

        //BeanDog 继承  BeanAnimal
        BeanDog dog = (BeanDog)context.getBean("BeanDog");
        dog.showAnimal();
        //加载多配置文件
        BeanUser user = (BeanUser)context.getBean("BeanUser");
        user.showUser();
        */


        /*
        ApplicationContext annotationCtx = new AnnotationConfigApplicationContext(BeanConfig.class);
        IBean beanPerson = (IBean) annotationCtx.getBean("beanPerson");
        beanPerson.show();

        IBean beanStu = (IBean)annotationCtx.getBean("beanStu");
        beanStu.show();

        IBean beanTch = (IBean)annotationCtx.getBean("beanTch");
        beanTch.show();
        */

        /*
        // Setter 注入
        ApplicationContext context = new ClassPathXmlApplicationContext("com/mj/xml/BeanDL.xml");
        BeanShowHelper hps = (BeanShowHelper) context.getBean("BeanShowHelper");
        hps.show();

        //构造函数注入
        BeanHideHelper bhh = (BeanHideHelper) context.getBean("BeanHideHelper");
        bhh.show();
        */

        // Jdbc
        ApplicationContext context = new ClassPathXmlApplicationContext("com/mj/xml/jdbc/BeanJdbc.xml");
        UserDao ud = (UserDao) context.getBean("UserDao");
        ModelUser modelU = new ModelUser();
        modelU.setName("mjjjjjj");
        ud.insert(modelU);

        ModelUser rsU = ud.findByID(4);
        System.out.println( rsU.getName());

        // JdbcTemplate
        ModelUser tempU = new ModelUser();
        tempU.setName("=JdbcTemplate=");
        JdbcTempDao jt = (JdbcTempDao)context.getBean("JdbcTempDao");
        jt.insert(tempU);

        //JdbcSupport
        ModelUser supportU = new ModelUser();
        supportU.setName("==JdbcSupport==");
        JdbcSupportDao sd = (JdbcSupportDao)context.getBean("JdbcSupportDao");
        sd.insert(supportU);





    }
}

JdbcSupportDao.java

package com.mj.dao;

import com.mj.model.ModelUser;
import org.springframework.jdbc.core.support.JdbcDaoSupport;

import javax.sql.DataSource;

public class JdbcSupportDao extends JdbcDaoSupport {

public  void insert(ModelUser u){

    String sql = "INSERT INTO user (name) VALUES (?)";

    getJdbcTemplate().update(sql, new Object[] {u.getName()});

}

}

BeanJdbc.xml

<!--
<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-2.5.xsd">

    <import resource="Spring-datasource.xml" />
    <import resource="UserDao.xml" />

</beans>
-->

<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-2.5.xsd">

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

        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://127.0.0.1:3306/Person" />
        <property name="username" value="root" />
        <property name="password" value="654321" />
    </bean>

    <bean id="UserDao" class="com.mj.dao.UserDao" >
        <property name="dataSource" ref="dataSource" ></property>
    </bean>

    <!-- JdbcTemplate -->
    <bean id="JdbcTempDao" class="com.mj.dao.JdbcTempDao" >
        <property name="dataSource" ref="dataSource" ></property>
    </bean>

    <!-- JdbcSupport -->
    <bean id="JdbcSupportDao" class="com.mj.dao.JdbcSupportDao">
        <property name="dataSource" ref="dataSource" ></property>

    </bean>

</beans>

运行

[mysql:][db:Person]>[mysql:][db:Person]>select * from user;
+----+-----------------+
| id | name |
+----+-----------------+
| 1 | jgg |
| 2 | MJ |
| 3 | mjjjjjj |
| 4 | mjjjjjj |
| 5 | mjjjjjj |
| 6 | mjjjjjj |
| 7 | mjjjjjj |
| 8 | mjjjjjj |
| 9 | mjjjjjj |
| 10 | mjjjjjj |
| 11 | mjjjjjj |
| 12 | =JdbcTemplate= |
| 13 | mjjjjjj |
| 14 | =JdbcTemplate= |
| 15 | ==JdbcSupport== |
+----+-----------------+
15 rows in set (0.00 sec)