Spring连接数据库的几种常用的方式.docVIP

测试主类为: package myspring2; import java.sql.*; import javax.sql.DataSource; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; public class MySpringTest { ? public static void main(String args[]) throws Exception{ ? ??? ApplicationContext ctx=new ClassPathXmlApplicationContext(applicationContext.xml); ?? ?? DataSource dataSource=ctx.getBean(dataSource,DataSource.class); ???? String sql=select * from user_inf; ??? ? Connection connection=dataSource.getConnection(); ? ??? Statement stm=connection.createStatement(); ??? ? ResultSet rs=stm.executeQuery(sql); ? ??? while(rs.next()) ???? { ??? ? System.out.println(用户名为:); ? ?? ? System.out.println(rs.getString(2)); ? ??? } ???? ??? ???? ???? } ? } ? 第一种：使用spring自带的DriverManagerDataSource ? 配置文件如下： ? ?xml version=1.0 encoding=UTF-8? ? beans xmlns=/schema/beans ? xmlns:aop=/schema/aop xmlns:tx=/schema/tx ? xmlns:xsi=/2001/XMLSchema-instance xmlns:context=/schema/context ? xmlns:p=/schema/p ? xsi:schemaLocation=? ??????????/schema/beans????? ???????/schema/beans/spring-beans-3.0.xsd ???????????/schema/tx??????? ?????/schema/tx/spring-tx-3.0.xsd ???????????/schema/context ???????????/schema/context/spring-context-3.0.xsd ???????????/schema/aop ???????????/schema/aop/spring-aop-3.0.xsd ?!-- 使用XML Schema的p名称空间配置 -- ? bean name=dataSource? class=org.springframework.jdbc.datasource.DriverManagerDataSource ? ? p:driverClassName=com.mysql.jdbc.Driver ? ? p:url=jdbc:mysql://localhost:3306/test ? p:username=root ? p:password=123456??/ ? ? !-- 采用property的普通配置 相比之下有点麻烦,但是效果是一样的哦,-- !--? ??? ? bean name=dataSource class=org.springframework.jdbc.datasource.DriverManagerDataSource ? ??? property name=driverClassName? value=com.mysql.jdbc.Driver / ???? property name=url value=jdbc:mysql://localhost:3306/test / ???? property name=username value=root / ???? property name=password value=123456 / ????/bean ??? --??????? /beans ? ? 第二种：C3P0数据源。 需要使c3p0的核心jar包，我使用的是c3p