druid连接池的使用

配置文件

url:jdbc:mysql://localhost/web_test4?serverTimezone=UTC
driverClassName:com.mysql.cj.jdbc.Driver
username:root
password:123456

druid连接池工具类

package com.itheima.jdbc.utils;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

import javax.sql.DataSource;

import com.alibaba.druid.pool.DruidDataSourceFactory;

public class JDBCUitel1 {
		
		private static DataSource dataSource=null;//初始化连接池
		
		static {
			
		//创建连接池
		Properties properties = new Properties();
		try {
			
		properties.load(new FileInputStream("src/druid.properties"));//读取配置文件，设置参数
		dataSource = DruidDataSourceFactory.createDataSource(properties);
		
		}catch(Exception e) {
			e.printStackTrace();
		}
		
		}
		
	
		public static Connection getconnection() {
			Connection conn = null;
			try {
				
			conn = dataSource.getConnection();
			//获取连接池中的连接
				
			}catch(Exception e) {
				e.printStackTrace();
			}
			return conn;
		}
		public static DataSource getdatasource() {
			return dataSource;
			
			
		}

			public static void release(Statement stmt,Connection conn) {
						if(stmt!=null) {
							try {
								stmt.close();
							}catch(SQLException e) {
								e.printStackTrace();
							}
							stmt=null;
						}
							
					
						if(conn!=null) {
							
							try {
								conn.close();
							}catch(SQLException e) {
								e.printStackTrace();
							}
							conn=null;
						}
			}
			public static void release(ResultSet rs,Statement stmt,Connection conn) {
				if(stmt!=null) {
					try {
						stmt.close();
					}catch(SQLException e) {
						e.printStackTrace();
					}
					stmt=null;
				}
					
			
				if(conn!=null) {
					
					try {
						
						conn.close();
					}catch(SQLException e) {
						e.printStackTrace();
					}
					conn=null;
				}
				if(rs!=null) {
						
						try {
							rs.close();
						}catch(SQLException e) {
							e.printStackTrace();
						}
						rs=null;
					}
}
}

druid 测试类

package com.itheima.druid;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.junit.Test;

import com.itheima.jdbc.utils.JDBCUitel1;

public class JDBC_druid1 {
	@Test
	public void demo1() {
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs=null;
		
		conn = JDBCUitel1.getconnection();//获取连接
		String sql="select * from user";
		try {
			pstmt=conn.prepareStatement(sql);
			rs=pstmt.executeQuery();
			while(rs.next()) {
				System.out.println(rs.getInt("id")+" "+rs.getString("username")+" "+rs.getDouble("money"));
			}
			
		}catch(Exception e) {
			e.printStackTrace();
		}finally {
			JDBCUitel1.release(rs, pstmt, conn);
		}
		
		
	}

}