阿里巴巴:druid连接池的简单用法

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3307/xx
username=root
password=root
initialSize=5

//
//
//
//
//

Properties pro = new Properties();
pro.load(JdbcUtils.class.getClassLoader().getResourceAsStream(“druid.properties”))
ds=DruidDataSourceFactory.createDataSource(pro);

//
//
//
//
//
//

package com.qf.jdbcUtils;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

import javax.sql.DataSource;

import com.alibaba.druid.pool.DruidDataSourceFactory;

public class JdbcUtils {

public static DataSource ds = null;

static{
	try {
	//读取properties的文件
			Properties pro = new Properties();
			//使用load方法将properties文件载入
			pro.load(JdbcUtils.class.getClassLoader().getResourceAsStream("druid.properties"));
			//使用DruidDataSourceFactory
			ds=DruidDataSourceFactory.createDataSource(pro);
	
} catch (Exception e) {
	// TODO: handle exception
	e.printStackTrace();
}
}

public static Connection getConnect() throws SQLException{
	return ds.getConnection();
}


public static void Close(Statement statement,Connection connection){
	if(statement != null){
		try{
			statement.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	if(connection != null){
		try {
			connection.close();
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}
	}
}

}

//
//
//
//
//
package com.qf.JdbcServer;
import java.sql.Connection;
import java.sql.PreparedStatement;

import com.qf.jdbcUtils.JdbcUtils;

public class JdbcServer {
//import com.alibaba.druid.util.JdbcUtils;
//增
public static void Insert(){
Connection connection = null;
PreparedStatement statement = null;
try {
connection =JdbcUtils.getConnect();
String sql = “insert into student values(2,‘哈哈哈’,100000)”;
statement = connection.prepareStatement(sql);
statement.executeUpdate();

	} catch (Exception e) {
		// TODO: handle exception
		e.printStackTrace();
	}finally{
		JdbcUtils.Close(statement, connection);
	}
}

}

//

//
//

//

package com.qf.JdbcTest;

import com.qf.JdbcServer.JdbcServer;

public class JdbcTest {

public static void main(String[] args) {
	JdbcServer jdbcServer = new JdbcServer();
	jdbcServer.Insert();
}

}