Spring连接Mysql数据库

刚接触Spring，试着用BDCP连接池技术来连接Mysql数据库

1.导入jar包

  百度搜一下jar包的名字都可以直接官网下载的

  

2.配置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"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
    <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
        <property name="url" value="jdbc:mysql://localhost:3306/students"></property>
        <property name="username" value="root"></property>
        <property name="password" value=""></property>
    </bean>
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"></property>
    </bean>
    <bean id="spitterDAO" class="classes.book.DAO.JdbcSpitterDAO">
        <property name="jdbcTemplate" ref="jdbcTemplate"></property>
    </bean>
</beans>

 其中，students对应的是你的数据库的名称

3.编写DAO类

package classes.book.DAO;

import classes.book.INTERFACE.SpitterDAO;
import org.springframework.jdbc.core.JdbcTemplate;
import  org.springframework.jdbc.core.support.JdbcDaoSupport;

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

public class JdbcSpitterDAO implements SpitterDAO {
    private static final String SQL_SELECT_SPITTER = "select * from stu";
    private  JdbcTemplate jdbcTemplate;

    @Override
    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    public List findAll()
    {
        List list = jdbcTemplate.queryForList(SQL_SELECT_SPITTER);
        return list;
    }

    public void show() {
        List<Map> list = findAll();
        for(int i = 0 ; i < list.size() ; i++){
            Map map =  list.get(i);
            System.out.println("编号："+map.get("Sid")+" 姓名："+map.get("Sname")+" 电话："+map.get("Stel"));
        }
    }

}

太简陋了，就是为了快点测试sql的连接。

期间因为url写错导致报错，下面附上url的正确写法：

感谢：http://blog.csdn.net/liwuyang2013/article/details/25986597?utm_source=tuicool&utm_medium=referral