本文共 1888 字,大约阅读时间需要 6 分钟。
原文:http://blog.csdn.net/u011179993/article/details/46457015
maven配置
-
- <dependency>
- <groupId>org.apache.commons</groupId>
- <artifactId>commons-dbcp2</artifactId>
- <version>2.1</version>
- </dependency>
-
-
- <dependency>
- <groupId>mysql</groupId>
- <artifactId>mysql-connector-java</artifactId>
- <version>5.1.32</version>
- </dependency>
maven配置后的工程目录:
javase程序为
- package com.laifucard.test.test_dbcp2;
-
- import java.sql.Connection;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.util.Properties;
-
- import org.apache.commons.dbcp2.BasicDataSource;
- import org.apache.commons.dbcp2.BasicDataSourceFactory;
-
-
-
-
-
-
-
- public class Test {
- public static void main(String[] args) throws Exception {
-
-
-
-
-
-
-
-
- Properties pro = new Properties();
- pro.load(Test.class.getClassLoader().getResourceAsStream("DB.properties"));
-
- BasicDataSource bs = BasicDataSourceFactory.createDataSource(pro);
-
-
- Connection conn = bs.getConnection();
-
-
- PreparedStatement ps = conn.prepareStatement("select * from meet_user LIMIT 0,6");
-
-
- ResultSet rs = ps.executeQuery();
- while (rs.next()) {
- for (int i = 1; i <= 3; i++) {
- System.out.print(rs.getString(i) + " ");
-
- }
- System.out.println();
- }
-
-
- rs.close();
-
- ps.close();
-
- conn.close();
-
- bs.close();
-
- }
- }
数据库配置文件为
- driverClassName=com.mysql.jdbc.Driver
- url=jdbc:mysql://localhost:3306/person?useUnicode=true&characterEncoding=utf-8
- username=root
- password=123456