如何用spring连接数据库

Spring如何连接数据库。

首先准备7个jar包，5个是spring的，1个是commons记录spring的日志的，1个是mysql的

写三个文件，一个xml，一个测试类，数据库类

第一个类：

packagecom.fish;

importorg.springframework.jdbc.datasource.DriverManagerDataSource;

public class DBTools {

DriverManagerDataSource dataSource;

publicDriverManagerDataSource getDataSource() {

return dataSource;

}

public void setDataSource(DriverManagerDataSourcedataSource) {

this.dataSource = dataSource;

}

}

第二个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-3.2.xsd

">

<bean id="dateSource"

class="org.springframework.jdbc.datasource.DriverManagerDataSource">

<property name="url" value="jdbc:mysql://127.0.0.1:3306/test"></property>

<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>

<property name="username" value="root"></property>

<property name="password" value="330127"></property>

</bean>

</beans>

第三个类：

package com.fish;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import org.springframework.context.ApplicationContext;

importorg.springframework.context.support.ClassPathXmlApplicationContext;

importorg.springframework.jdbc.datasource.DriverManagerDataSource;

public class Test {

public static void main(String[] args) {

Connection connection=null;

Statementstatement=null;

ResultSetresultSet=null;

ApplicationContextcontext=new ClassPathXmlApplicationContext("com/fish/my.xml");//建立和xml的关联

DriverManagerDataSourcedbTools=(DriverManagerDataSource)context.getBean("dateSource");

try{

connection=dbTools.getConnection();

statement=connection.createStatement();

String sql="select * from user";

resultSet=statement.executeQuery(sql);

while(resultSet.next()){

System.out.println("用户名:"+resultSet.getString("username")+" 密码："+resultSet.getString("passwrod"));

}

}catch (SQLException e) {

//TODO Auto-generated catch block

e.printStackTrace();

}

finally{

try{

resultSet.close();

}catch (SQLException e) {

//TODO Auto-generated catch block

e.printStackTrace();

}

finally{

try{

statement.close();

}catch (SQLException e) {

//TODO Auto-generated catch block

e.printStackTrace();

}

finally{

try{

connection.close();

}catch (SQLException e) {

//TODO Auto-generated catch block

e.printStackTrace();

}

}

}

}

}

}

要想成功，必须在mysql里面建立一个test数据库，用户名为fish，密码：330127

有一张user表，字段名是username和password。