spring如何连接数据库.docVIP

Spring如何连接数据库。 首先准备7个jar包，5个是spring的，1个是commons记录spring的日志的，1个是mysql的 写三个文件，一个xml，一个测试类，数据库类 第一个类： package com.fish; import org.springframework.jdbc.datasource.DriverManagerDataSource; public class DBTools DriverManagerDataSource dataSource; public DriverManagerDataSource getDataSource return dataSource; public void setDataSource DriverManagerDataSource dataSource this.dataSource dataSource; 第二个xml： ?xml version 1.0 encoding UTF-8 beans xmlns /schema/beans xmlns:xsi /2001/XMLSchema-instance xsi:schemaLocation /schema/beans /schema/beans/spring-beans-3.2.xsd bean id dateSource class org.springframework.jdbc.datasource.DriverManagerDataSource property name url value jdbc:mysql://:3306/test property name driverClassName value com.mysql.jdbc.Driver property name username value root property name password value 330127 第三个类： package com.fish; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import org.springframework.jdbc.datasource.DriverManagerDataSource; public class Test public static void main String[] args Connection connection null; Statement statement null; ResultSet resultSet null; ApplicationContext context new ClassPathXmlApplicationContext com/fish/my.xml ;//建立和xml的关联 DriverManagerDataSource dbTools 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 // T