Java-SE 数据库连接 Alibaba德鲁伊连接池使用并删除数据

原德鲁伊连接池连接+删除数据

package demo3_25;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.Statement;
import java.util.Properties;
import javax.sql.DataSource;
import org.junit.jupiter.api.Test;
import com.alibaba.druid.pool.DruidDataSourceFactory;
/**
 * @author 张昭光
 * @data 创建时间：2020年3月25日下午5:50:50
 * @version 1.0
 * @parameter
 * @since
 * @return
 */
public class JdbcSource {
	@Test
	public void JDBCtest() throws Exception  {
		Properties properties=new Properties();
		properties.load(new FileInputStream("src\\druid.properties"));
		DataSource ds=DruidDataSourceFactory.createDataSource(properties);
		Connection connection=ds.getConnection();
		System.out.println("連接成功");
		String sql="DELETE FROM `table` WHERE id =5";
		Statement statement= connection.createStatement();
		int delete=statement.executeUpdate(sql);
		System.out.println(delete>0?"删除成功":"删除失败");
		connection.close();
	}
}

改进后德鲁伊 封装连接池连接关闭

package demo3_25;

import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;
import javax.sql.DataSource;
import org.junit.jupiter.api.Test;
import com.alibaba.druid.pool.DruidDataSourceFactory;
/**
 * @author 张昭光
 * @data 创建时间：2020年3月25日下午5:50:50
 * @version 1.0
 * @parameter
 * @since
 * @return
 */
public class JdbcSource {
	static DataSource ds=null;
	static {
		try {
			Properties properties=new Properties();
			properties.load(new FileInputStream("src\\druid.properties"));
			ds=DruidDataSourceFactory.createDataSource(properties);
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	public static Connection getConnection() throws Exception{
		
		return ds.getConnection();
	}
	@Test
	public void JDBCtest() throws Exception  {
		Connection connection=getConnection();
		System.out.println("連接成功");
		String sql="DELETE FROM `table` WHERE id =1";
		Statement statement= connection.createStatement();
		int delete=statement.executeUpdate(sql);
		System.out.println(delete>0?"删除成功":"删除失败");
		close(null, statement, connection);
	}
	public static void close(ResultSet set,Statement statement,Connection connection) {
		try {
			if (set!=null) {
				set.close();
				System.out.println("关闭resultset成功");
			}
			if (statement!=null) {
				statement.close();
				System.out.println("关闭statement成功");
			}
			if (connection!=null) {
				connection.close();
				System.out.println("关闭connection成功");
			}
			
		} catch (Exception e) {
			throw new RuntimeException(e);
		}
	}
}

配置文件druid.properties

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/demo?rewriteBatchedStatements=true&useSSL=false
username=root
password=root
initialSize=10
maxActive=20
maxWait=5000
minIdle=5