springJDBC使用

1.demo
demo 地址 https://gitee.com/yuhaifei/springJDBC
2.jar包

3.xml配置 applicationContext.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:context="http://www.springframework.org/schema/context"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xsi:schemaLocation="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.xsd
    http://www.springframework.org/schema/aop
    http://www.springframework.org/schema/aop/spring-aop.xsd
    http://www.springframework.org/schema/tx 
    http://www.springframework.org/schema/tx/spring-tx.xsd">

    <!-- 内置的连接池：先配置连接池 
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql:///mybatis"/>
        <property name="username" value="root"/>
        <property name="password" value="123456"/>
    </bean>
    -->

    <!-- 配置DBCP的连接池
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql:///spring_day03"/>
        <property name="username" value="root"/>
        <property name="password" value="root"/>
    </bean>
     -->

    <!-- 配置C3P0的连接池 -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="com.mysql.jdbc.Driver"/>
        <property name="jdbcUrl" value="jdbc:mysql:///mybatis"/>
        <property name="user" value="root"/>
        <property name="password" value="123456"/>
    </bean>

    <!-- 配置JDBC的模板类 -->
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"/>
    </bean>


</beans>

4.测试代码

package com.jdbc.test;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import java.util.logging.Logger;

import javax.annotation.Resource;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import com.jdbc.bean.UserBean;

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

    @Resource(name="jdbcTemplate")
    private JdbcTemplate jdbcTemplate;


    private Logger logger = Logger.getLogger("log");

    @Test
    public void run1(){

        jdbcTemplate.update("UPDATE `user` a SET a.username = ? where a.id = 10","DDDDDDDDDDDDDDDDD");
    }

    /*********查询功能 **********/
    @Test
    public void run2(){

        //单个查询("sql 语句", "回调方法，在里面组装","查询数据");
        UserBean queryForObject = jdbcTemplate.queryForObject("SELECT * from user a WHERE a.id = ?", new TestRowMap(),10);
        System.out.println(queryForObject.getUsername());
    }

    //查询多条数据
    @Test
    public void run3(){

        List<UserBean> query = jdbcTemplate.query("SELECT * from user", new TestRowMap());
        for (UserBean userBean : query) {
            System.out.println(userBean.getUsername());
        }
    }

    class TestRowMap implements RowMapper<UserBean>{

        @Override
        public UserBean mapRow(ResultSet resultSet, int arg1) throws SQLException {

            UserBean userBean = new UserBean();
            userBean.setId(resultSet.getInt("id"));
            userBean.setSex(resultSet.getString("sex"));
            userBean.setUsername(resultSet.getString("username"));
            userBean.setBirthday(resultSet.getDate("birthday"));
            userBean.setAddress(resultSet.getString("address"));
            return userBean;
        }

    }
}

---