那些年、一起追过的Spring--（6）----Spring JDBC框架操作数据库（JdbcTemplate的使用）

实现代码：

导包：

spring.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:p="http://www.springframework.org/schema/p"
    xmlns:context="http://www.springframework.org/schema/context"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xsi:schemaLocation="http://www.springframework.org/schema/beans 
    http://www.springframework.org/schema/beans/spring-beans-3.0.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-3.0.xsd">

<context:component-scan base-package="com.spring.jdbc"></context:component-scan>

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
    destroy-method="close" 
    p:driverClassName="com.mysql.jdbc.Driver"
    p:url="jdbc:mysql://localhost:3306/mybatis" 
    p:username="root"
    p:password="root" />

<bean id="jdbctemplate" class="org.springframework.jdbc.core.JdbcTemplate" 
p:dataSource-ref="dataSource"></bean>

</beans>

package com.spring.jdbc;

import java.util.List;
import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;

@Component
public class Springjdbc {

    @Autowired
    private JdbcTemplate jdbcTemplate;
    public void find(){
        String sql="select * from student";
        List<Map<String,Object>> list=jdbcTemplate.queryForList(sql);
        for(Map<String,Object> map:list){
            System.out.println(map.get("sid")+"--"+map.get("sname")+"--"+map.get("t_id"));
        }
    }
}

测试：

package com.spring.jdbc;

import org.springframework.beans.factory.BeanFactory;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class test {
    public static void main(String[] args) {
        BeanFactory beanFactory = new ClassPathXmlApplicationContext(
                "spring.xml");
        Springjdbc jd = beanFactory.getBean(Springjdbc.class);
        jd.find();
    }
}

结果：

1--asfsaf--1
2--dsagdhfa--2
2--ad--1

数据库中的数据：