mysql 1701_1701-MySQL-JDBC-连接池使用

注意：使用装饰者模式增强Connection的close方法

1. 测试部分

package com.it.jdbc.TestDataSoure;

import java.sql.Connection;

import java.sql.PreparedStatement;

import javax.management.RuntimeErrorException;

import org.junit.Test;

import com.it.jdbc.DataSoure.MyDataSoure;

import com.it.jdbc.utils.JDBCUtils_V3;

public class TestMyDataSoure {

/**

* 添加用户

* 使用改造Connection

*/

@Test

public void testAdduser1() {

Connection conn = null;

PreparedStatement pstmt = null;

// 自定义连接池对象

MyDataSoure datasoure = new MyDataSoure();

try {

// 从连接池获得链接

conn = datasoure.getConnection();

String sql = "insert into use1 value(null,?,?)";

pstmt =conn.prepareStatement(sql);

pstmt.setString(1, "何一");

pstmt.setString(2, "李二");

int rows = pstmt.executeUpdate();

if (rows > 0) {

System.out.println("添加成功");

} else {

System.out.println("添加失败");

}

} catch (Exception e) {

throw new RuntimeException(e);

} finally {

JDBCUtils_V3.release(conn, pstmt, null);

}

}

}

2.MyConnection

package com.it.jdbc.DataSoure;

import java.sql.Array;

import java.sql.Blob;

import java.sql.CallableStatement;

import java.sql.Clob;

import java.sql.Connection;

import java.sql.DatabaseMetaData;

import java.sql.NClob;

import java.sql.PreparedStatement;

import java.sql.SQLClientInfoException;

import java.sql.SQLException;

import java.sql.SQLWarning;

import java.sql.SQLXML;

import java.sql.Savepoint;

import java.sql.Statement;

import java.sql.Struct;

import java.util.LinkedList;

import java.util.Map;

import java.util.Properties;

//1，实现同一个接口

public class MyConnection implements Connection{

//3,定义一个变量

private Connection conn;

private LinkedList pool;

//写构造方法(参数使用了面向对象-多态)

public MyConnection (Connection conn,LinkedList pool){

this.conn =conn;

this.pool=pool;

}

//增强的方法

@Override

public void close() throws SQLException {

// TODO Auto-generated method stub

pool.add(conn);

}

@Override

//此方法必须覆盖，否则空指针异常

public PreparedStatement prepareStatement(String sql) throws SQLException {

// TODO Auto-generated method stub

return conn.prepareStatement(sql);

}

}

3.MyDataSoure

package com.it.jdbc.DataSoure;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.SQLException;

import java.util.LinkedList;

import javax.sql.DataSource;

import com.it.jdbc.utils.JDBCUtils_V3;

public class MyDataSoure implements DataSource {

// 1,创建一个容器，存储Connection对象

private static LinkedList pool = new LinkedList();

// 2,创建5个链接放到容器中

static {

for (int i = 0; i < 5; i++) {

Connection conn = JDBCUtils_V3.getConnection();

MyConnection myconn= new MyConnection(conn, pool);

pool.add(myconn);

}

}

@Override

public Connection getConnection() throws SQLException {

Connection conn = null;

// 3，使用前判断

if (pool.size() == 0) {

// 4,添加链接

for (int i = 0; i < 5; i++) {

conn = JDBCUtils_V3.getConnection();

//连接池中的自定义myconn

MyConnection myconn= new MyConnection(conn, pool);

pool.add(myconn);

}

}

// 5,从连接池获取一个链接对象Connection

conn = pool.remove(0);

return conn;

}

public void backConnection(Connection conn) {

// 归还连接池

pool.add(conn);

}

}