1.定义连接池类
package com.whx.conpool;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.LinkedList;
import javax.xml.ws.FaultAction;
import com.mysql.jdbc.Connection;
public class DBPool extends Thread {
private static LinkedList<Connection> pool = new LinkedList<Connection>();
public DBPool( ){
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
for(int i = 0 ; i < 5; i ++){
try {
Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://192.168.0.107:3306/test","root","123456");
po