先在本地mysql创建数据库luo,再建立表user。

1,建立maven项目HelloSpring

2，pom.xml添加需要用到的Jar包

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

4.0.0

com.aluo

HelloSpring

0.0.1-SNAPSHOT

org.springframework

spring-core

4.1.4.RELEASE

org.springframework

spring-context

4.1.4.RELEASE

org.springframework

spring-jdbc

4.1.4.RELEASE

mysql

mysql-connector-java

5.1.15

c3p0

c3p0

0.9.1

commons-dbcp

commons-dbcp

1.2.2

其中导入mysql-connector-java总是有问题，后面是先下载mysql-connector-java-5.1.15.jar到本地仓库。

3，beans2.xml

4,创建类MainJdbcTest

packagecom.aluo.spring;importjava.sql.Connection;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjavax.sql.DataSource;importorg.springframework.context.ApplicationContext;importorg.springframework.context.support.ClassPathXmlApplicationContext;public classMainJdbcTest {public static void main(String[] args) throwsSQLException {

ApplicationContext ctx= new ClassPathXmlApplicationContext("beans2.xml");

DataSource dataSource= (DataSource) ctx.getBean("dataSource");

String sql= "select * from user";

Connection connection=dataSource.getConnection();

System.out.println(connection);

Statement stm=connection.createStatement();

ResultSet rs=stm.executeQuery(sql);while(rs.next())

{

System.out.println("手机号码为:");

System.out.println(rs.getString(2));

}

}

}

运行output:

jdbc:mysql://localhost:3306/luo, UserName=root@localhost, MySQL-AB JDBC Driver

手机号码为:

123456

手机号码为:

111

手机号码为:

112