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;        }    }}

---