學習JDBC這一篇就夠了

輕鬆的小希發表於2020-07-31

配套資料，免費下載
連結:https://pan.baidu.com/s/1Xq21-Wasev-nKQlO4Xd9xQ
提取碼:mgj3
複製這段內容後開啟百度網盤手機App，操作更方便哦

第一章概述

JDBC（Java Database Connectivity）是SUN公司提供的一種資料庫訪問規則、規範，由於資料庫種類較多且Java語言使用比較廣泛，SUN公司就提供了一種規範，讓其它的資料庫提供商去實現底層的訪問規則，我們的Java程式只要使用SUN公司提供的jdbc驅動就可以連線不同廠商的資料庫了

第二章資料庫連線

1、工具類

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

public class JDBCUtil {
	private static String driverClass = "com.mysql.jdbc.Driver";
	private static String url = "jdbc:mysql://127.0.0.1:3306/mytest";
	private static String user = "root";
	private static String password = "root";

	static {
		try {
			Class.forName(driverClass);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}

	public static Connection getConnection() {
		try {
			return DriverManager.getConnection(url, user, password);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return null;
	}

	public static void release(Connection connection, PreparedStatement preparedStatement, ResultSet resultSet) {
		closeConnection(connection);
		closePreparedStatement(preparedStatement);
		closeResultSet(resultSet);
	}

	public static void release(Connection connection, PreparedStatement preparedStatement) {
		closeConnection(connection);
		closePreparedStatement(preparedStatement);
	}

	public static void closeConnection(Connection connection) {
		if (connection != null) {
			try {
				connection.close();
			} catch (SQLException e) {
				e.printStackTrace();
			} finally {
				connection = null;
			}
		}
	}

	public static void closePreparedStatement(PreparedStatement preparedStatement) {
		if (preparedStatement != null) {
			try {
				preparedStatement.close();
			} catch (SQLException e) {
				e.printStackTrace();
			} finally {
				preparedStatement = null;
			}
		}
	}

	public static void closeResultSet(ResultSet resultSet) {
		if (resultSet != null) {
			try {
				resultSet.close();
			} catch (SQLException e) {
				e.printStackTrace();
			} finally {
				resultSet = null;
			}
		}
	}

}

2、測試類

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

import org.junit.Test;

public class JDBCTest {

	@Test
	public void testQuery() {
		Connection connection = null;
		PreparedStatement preparedStatement = null;
		ResultSet resultSet = null;
		try {
			connection = JDBCUtil.getConnection();
			String sql = "select * from admin";
			preparedStatement = connection.prepareStatement(sql);
			resultSet = preparedStatement.executeQuery();
			while (resultSet.next()) {
				Object id = resultSet.getObject(1);
				Object username = resultSet.getObject(2);
				Object password = resultSet.getObject(3);

				System.out.println(id + ":" + username + ":" + password);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JDBCUtil.release(connection, preparedStatement, resultSet);
		}
	}

	@Test
	public void testInsert() {
		Connection connection = null;
		PreparedStatement preparedStatement = null;
		try {
			connection = JDBCUtil.getConnection();
			String sql = "insert into admin values(NULL,'xiaowu','123456')";
			preparedStatement = connection.prepareStatement(sql);
			int rows = preparedStatement.executeUpdate(sql);
			if (rows > 0) {
				System.out.println("插入成功");
			} else {
				System.out.println("插入失敗");
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JDBCUtil.release(connection, preparedStatement);
		}
	}
	
	@Test
	public void testUpdate() {
		Connection connection = null;
		PreparedStatement preparedStatement = null;
		try {
			connection = JDBCUtil.getConnection();
			String sql = "update admin set username = 'xiaoqi' where id = 5";
			preparedStatement = connection.prepareStatement(sql);
			int rows = preparedStatement.executeUpdate(sql);
			if (rows > 0) {
				System.out.println("修改成功");
			} else {
				System.out.println("修改失敗");
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JDBCUtil.release(connection, preparedStatement);
		}
	}
	
	@Test
	public void testDelete() {
		Connection connection = null;
		PreparedStatement preparedStatement = null;
		try {
			connection = JDBCUtil.getConnection();
			String sql = "delete from admin where id = 5";
			preparedStatement = connection.prepareStatement(sql);
			int rows = preparedStatement.executeUpdate(sql);
			if (rows > 0) {
				System.out.println("刪除成功");
			} else {
				System.out.println("刪除失敗");
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JDBCUtil.release(connection, preparedStatement);
		}
	}

}

第三章資料庫事務

@Test
public void testTransaction() {
	Connection connection = null;
	PreparedStatement preparedStatement = null;
	try {
		connection = JDBCUtil.getConnection();

		// 前提：關閉事務
		connection.setAutoCommit(false);

		String sql = "update account set money = money - ? where id = ?";
		preparedStatement = connection.prepareStatement(sql);

		// 扣錢， 扣ID為 1 的100塊錢
		preparedStatement.setInt(1, 100);
		preparedStatement.setInt(2, 1);
		preparedStatement.executeUpdate();

        // 模擬異常
		int a = 10 / 0;

		// 加錢， 給ID為 2 加100塊錢
		preparedStatement.setInt(1, -100);
		preparedStatement.setInt(2, 2);
		preparedStatement.executeUpdate();

		// 成功：提交事務
		connection.commit();
	} catch (SQLException e) {
		try {
			// 失敗：回滾事務
			connection.rollback();
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		e.printStackTrace();
	} finally {
		JDBCUtil.release(connection, preparedStatement);
	}
}

第四章資料庫連線池

4.1、DBCP

1、基本使用

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

import org.apache.commons.dbcp2.BasicDataSource;

public class DBCPTest {

	public static void main(String[] args) throws SQLException {
		BasicDataSource dataSource = new BasicDataSource();
		dataSource.setUrl("jdbc:mysql://127.0.0.1:3306/mytest");
		dataSource.setUsername("root");
		dataSource.setPassword("root");

		Connection connection = dataSource.getConnection();
		String sql = "select * from admin";
		PreparedStatement prepareStatement = connection.prepareStatement(sql);
		ResultSet resultSet = prepareStatement.executeQuery();
		while (resultSet.next()) {
			Object id = resultSet.getObject(1);
			Object username = resultSet.getObject(2);
			Object password = resultSet.getObject(3);
			System.out.println(id + ":" + username + ":" + password);
		}
		resultSet.close();
		connection.close();
		dataSource.close();
	}

}

2、高階使用

dbcp-config.properties

#基本設定
driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/mytest
username=root
password=root
#資料庫連線池初始化數量
initialSize=10
#資料庫連線池中的最大的資料庫連線數
maxActive=50
#資料庫連線池中的最小的資料庫連線數
minIdle=5

DBCPWithConfig.java

import java.io.InputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Properties;

import javax.sql.DataSource;

import org.apache.commons.dbcp2.BasicDataSourceFactory;

public class DBCPWithConfig {

	@SuppressWarnings("static-access")
	public static void main(String[] args) throws Exception {
		BasicDataSourceFactory dataSourceFactory = new BasicDataSourceFactory();
		Properties properties = new Properties();
		InputStream is = DBCPWithConfig.class.getClassLoader().getResourceAsStream("dbcp-config.properties");
		properties.load(is);
		DataSource dataSource = dataSourceFactory.createDataSource(properties);

		Connection connection = dataSource.getConnection();
		String sql = "select * from admin";
		PreparedStatement prepareStatement = connection.prepareStatement(sql);
		ResultSet resultSet = prepareStatement.executeQuery();
		while (resultSet.next()) {
			Object id = resultSet.getObject(1);
			Object username = resultSet.getObject(2);
			Object password = resultSet.getObject(3);
			System.out.println(id + ":" + username + ":" + password);
		}
		resultSet.close();
		connection.close();
	}

}

4.2、Druid

1、基本使用

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

import com.alibaba.druid.pool.DruidDataSource;

public class DruidTest {

	public static void main(String[] args) throws SQLException {
		DruidDataSource dataSource = new DruidDataSource();
		dataSource.setUrl("jdbc:mysql://127.0.0.1:3306/mytest");
		dataSource.setUsername("root");
		dataSource.setPassword("root");

		Connection connection = dataSource.getConnection();
		String sql = "select * from admin";
		PreparedStatement prepareStatement = connection.prepareStatement(sql);
		ResultSet resultSet = prepareStatement.executeQuery();
		while (resultSet.next()) {
			Object id = resultSet.getObject(1);
			Object username = resultSet.getObject(2);
			Object password = resultSet.getObject(3);
			System.out.println(id + ":" + username + ":" + password);
		}
		resultSet.close();
		connection.close();
		dataSource.close();
	}

}

2、高階使用

druid-config.properties

#基本設定
driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/mytest
username=root
password=root
#資料庫連線池初始化數量
initialSize=10
#資料庫連線池中的最大的資料庫連線數
maxActive=50
#資料庫連線池中的最小的資料庫連線數
minIdle=5

DruidWithConfig.java

import java.io.InputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Properties;

import javax.sql.DataSource;

import com.alibaba.druid.pool.DruidDataSourceFactory;

public class DruidWithConfig {

	@SuppressWarnings("static-access")
	public static void main(String[] args) throws Exception {
		DruidDataSourceFactory dataSourceFactory = new DruidDataSourceFactory();
		Properties properties = new Properties();
		InputStream is = DruidWithConfig.class.getClassLoader().getResourceAsStream("druid-config.properties");
		properties.load(is);
		DataSource dataSource = dataSourceFactory.createDataSource(properties);

		Connection connection = dataSource.getConnection();
		String sql = "select * from admin";
		PreparedStatement prepareStatement = connection.prepareStatement(sql);
		ResultSet resultSet = prepareStatement.executeQuery();
		while (resultSet.next()) {
			Object id = resultSet.getObject(1);
			Object username = resultSet.getObject(2);
			Object password = resultSet.getObject(3);
			System.out.println(id + ":" + username + ":" + password);
		}
		resultSet.close();
		connection.close();
	}

}

4.3、C3P0

1、基本使用

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

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class C3P0Test {

	public static void main(String[] args) throws SQLException {
		ComboPooledDataSource dataSource = new ComboPooledDataSource();
		dataSource.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/mytest");
		dataSource.setUser("root");
		dataSource.setPassword("root");

		Connection connection = dataSource.getConnection();
		String sql = "select * from admin";
		PreparedStatement prepareStatement = connection.prepareStatement(sql);
		ResultSet resultSet = prepareStatement.executeQuery();
		while (resultSet.next()) {
			Object id = resultSet.getObject(1);
			Object username = resultSet.getObject(2);
			Object password = resultSet.getObject(3);
			System.out.println(id + ":" + username + ":" + password);
		}
		resultSet.close();
		connection.close();
		dataSource.close();
	}

}

2、高階使用

c3p0-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
	<default-config>
		<!-- 基本設定 -->
		<property name="driverClass">com.mysql.jdbc.Driver</property>
		<property name="jdbcUrl">jdbc:mysql://127.0.0.1/mytest</property>
		<property name="user">root</property>
		<property name="password">root</property>
		<!-- 資料庫連線池初始化數量 -->
		<property name="initialPoolSize">10</property>
		<!-- 資料庫連線池中的最大的資料庫連線數 -->
		<property name="maxPoolSize">100</property>
		<!-- 資料庫連線池中的最小的資料庫連線數 -->
		<property name="minPoolSize">10</property>
	</default-config>
</c3p0-config>

C3P0WithConfig.java

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

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class C3P0WithConfig {

	public static void main(String[] args) throws SQLException {
		ComboPooledDataSource dataSource = new ComboPooledDataSource();

		Connection connection = dataSource.getConnection();
		String sql = "select * from admin";
		PreparedStatement prepareStatement = connection.prepareStatement(sql);
		ResultSet resultSet = prepareStatement.executeQuery();
		while (resultSet.next()) {
			Object id = resultSet.getObject(1);
			Object username = resultSet.getObject(2);
			Object password = resultSet.getObject(3);
			System.out.println(id + ":" + username + ":" + password);
		}
		resultSet.close();
		connection.close();
		dataSource.close();
	}

}

第五章 DButils

1、基本的使用

Admin.java

public class Admin {
	private Integer id;
	private String username;
	private String password;

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getUsername() {
		return username;
	}

	public void setUsername(String username) {
		this.username = username;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}

	@Override
	public String toString() {
		return "Admin [id=" + id + ", username=" + username + ", password=" + password + "]";
	}
}

DBUtilsTest.java

import java.sql.SQLException;
import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.junit.Test;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class DBUtilsTest {

	@Test
	public void testQueryOne() {
		try {
			ComboPooledDataSource dataSource = new ComboPooledDataSource();
			dataSource.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/mytest");
			dataSource.setUser("root");
			dataSource.setPassword("root");
			QueryRunner queryRunner = new QueryRunner(dataSource);
			String sql = "select * from admin where id = ?";
			Admin admin = queryRunner.query(sql, new BeanHandler<Admin>(Admin.class), 1);
			System.out.println(admin);
			dataSource.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	@Test
	public void testQueryAll() {
		try {
			ComboPooledDataSource dataSource = new ComboPooledDataSource();
			dataSource.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/mytest");
			dataSource.setUser("root");
			dataSource.setPassword("root");
			QueryRunner queryRunner = new QueryRunner(dataSource);
			String sql = "select * from admin";
			List<Admin> admins = queryRunner.query(sql, new BeanListHandler<Admin>(Admin.class));
			for (Admin admin : admins) {
				System.out.println(admin);
			}
			dataSource.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	@Test
	public void testInsert() {
		try {
			ComboPooledDataSource dataSource = new ComboPooledDataSource();
			dataSource.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/mytest");
			dataSource.setUser("root");
			dataSource.setPassword("root");
			QueryRunner queryRunner = new QueryRunner(dataSource);
			String sql = "insert into admin values(NULL,?,?)";
			int rows = queryRunner.update(sql, "xiaojiu", "123456");
			if (rows > 0) {
				System.out.println("插入成功");
			} else {
				System.out.println("插入失敗");
			}
			dataSource.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	@Test
	public void testUpdate() {
		try {
			ComboPooledDataSource dataSource = new ComboPooledDataSource();
			dataSource.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/mytest");
			dataSource.setUser("root");
			dataSource.setPassword("root");
			QueryRunner queryRunner = new QueryRunner(dataSource);
			String sql = "update admin set username = 'xiaoqi' where id = ?";
			int rows = queryRunner.update(sql, 4);
			if (rows > 0) {
				System.out.println("修改成功");
			} else {
				System.out.println("修改失敗");
			}
			dataSource.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	@Test
	public void testDelete() {
		try {
			ComboPooledDataSource dataSource = new ComboPooledDataSource();
			dataSource.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/mytest");
			dataSource.setUser("root");
			dataSource.setPassword("root");
			QueryRunner queryRunner = new QueryRunner(dataSource);
			String sql = "delete from admin where id = ?";
			int rows = queryRunner.update(sql, 6);
			if (rows > 0) {
				System.out.println("刪除成功");
			} else {
				System.out.println("刪除失敗");
			}
			dataSource.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

}

注意問題：

BeanHandler，查詢到的單個資料封裝成一個物件
BeanListHandler，查詢到的多個資料封裝成一個List<物件>
    
ArrayHandler，查詢到的單個資料封裝成一個陣列
ArrayListHandler，查詢到的多個資料封裝成一個集合，集合裡面的元素是陣列
    
MapHandler，查詢到的單個資料封裝成一個map
MapListHandler，查詢到的多個資料封裝成一個集合，集合裡面的元素是Map
    
ColumnListHandler
KeyedHandler
ScalarHandler

2、自定義實現

ResultSetHandler.java

import java.sql.ResultSet;
import java.sql.SQLException;

public interface ResultSetHandler<T> {

	/**
	 * 定義資料封裝的規則
	 * 
	 * @param <T>
	 * @param rs
	 */
	T handle(ResultSet rs) throws SQLException;

}

MyQueryRunner.java

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

import javax.sql.DataSource;

public class MyQueryRunner {

	private DataSource dataSource = null;

	public MyQueryRunner() {
		super();
	}

	public MyQueryRunner(DataSource dataSource) {
		super();
		this.dataSource = dataSource;
	}

	public <T> T query(String sql, ResultSetHandler<T> handler, Object... args) {
		Connection connection = null;
		PreparedStatement preparedStatement = null;
		try {
			connection = dataSource.getConnection();
			preparedStatement = connection.prepareStatement(sql);
			ParameterMetaData parameterMetaData = preparedStatement.getParameterMetaData();
			for (int i = 0; i < parameterMetaData.getParameterCount(); i++) {
				preparedStatement.setObject(i + 1, args[i]);
			}
			ResultSet resultSet = preparedStatement.executeQuery();
			return (T) handler.handle(resultSet);
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JDBCUtil.release(connection, preparedStatement);
		}
		return null;
	}

	public int update(String sql, Object... args) {
		Connection connection = null;
		PreparedStatement preparedStatement = null;
		try {
			connection = dataSource.getConnection();
			preparedStatement = connection.prepareStatement(sql);
			ParameterMetaData parameterMetaData = preparedStatement.getParameterMetaData();
			for (int i = 0; i < parameterMetaData.getParameterCount(); i++) {
				preparedStatement.setObject(i + 1, args[i]);
			}
			return preparedStatement.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JDBCUtil.release(connection, preparedStatement);
		}
		return 0;
	}

}

Admin.java

public class Admin {
	private Integer id;
	private String username;
	private String password;

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getUsername() {
		return username;
	}

	public void setUsername(String username) {
		this.username = username;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}

	@Override
	public String toString() {
		return "Admin [id=" + id + ", username=" + username + ", password=" + password + "]";
	}
}

MyQueryRunnerTest.java

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.junit.Test;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class MyQueryRunnerTest {

	@Test
	public void testQueryOne() {
		ComboPooledDataSource dataSource = new ComboPooledDataSource();
		dataSource.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/mytest");
		dataSource.setUser("root");
		dataSource.setPassword("root");
		MyQueryRunner queryRunner = new MyQueryRunner(dataSource);
		String sql = "select * from admin where id = ?";
		Admin admin = queryRunner.query(sql, new ResultSetHandler<Admin>() {
			@Override
			public Admin handle(ResultSet rs) throws SQLException {
				while (rs.next()) {
					Admin admin = new Admin();
					int id = rs.getInt("id");
					String username = rs.getString("username");
					String password = rs.getString("password");
					admin.setId(id);
					admin.setUsername(username);
					admin.setPassword(password);
					return admin;
				}
				return null;
			}
		}, 1);
		System.out.println(admin);
		dataSource.close();
	}

	@Test
	public void testQueryAll() {
		ComboPooledDataSource dataSource = new ComboPooledDataSource();
		dataSource.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/mytest");
		dataSource.setUser("root");
		dataSource.setPassword("root");
		MyQueryRunner queryRunner = new MyQueryRunner(dataSource);
		String sql = "select * from admin";
		List<Admin> admins = queryRunner.query(sql, new ResultSetHandler<List<Admin>>() {
			@Override
			public List<Admin> handle(ResultSet rs) throws SQLException {
				List<Admin> admins = new ArrayList<Admin>();
				while (rs.next()) {
					Admin admin = new Admin();
					int id = rs.getInt("id");
					String username = rs.getString("username");
					String password = rs.getString("password");
					admin.setId(id);
					admin.setUsername(username);
					admin.setPassword(password);
					admins.add(admin);
				}
				return admins;
			}
		});
		for (Admin admin : admins) {
			System.out.println(admin);
		}
		dataSource.close();
	}

	@Test
	public void testInsert() {
		ComboPooledDataSource dataSource = new ComboPooledDataSource();
		dataSource.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/mytest");
		dataSource.setUser("root");
		dataSource.setPassword("root");
		MyQueryRunner queryRunner = new MyQueryRunner(dataSource);
		String sql = "insert into admin values(NULL,?,?)";
		int rows = queryRunner.update(sql, "xiaoqiang", "123456");
		if (rows > 0) {
			System.out.println("插入成功");
		} else {
			System.out.println("插入失敗");
		}
		dataSource.close();
	}

	@Test
	public void testUpdate() {
		ComboPooledDataSource dataSource = new ComboPooledDataSource();
		dataSource.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/mytest");
		dataSource.setUser("root");
		dataSource.setPassword("root");
		MyQueryRunner queryRunner = new MyQueryRunner(dataSource);
		String sql = "update admin set username = 'mingming' where id = ?";
		int rows = queryRunner.update(sql, 4);
		if (rows > 0) {
			System.out.println("修改成功");
		} else {
			System.out.println("修改失敗");
		}
		dataSource.close();
	}

	@Test
	public void testDelete() {
		ComboPooledDataSource dataSource = new ComboPooledDataSource();
		dataSource.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/mytest");
		dataSource.setUser("root");
		dataSource.setPassword("root");
		MyQueryRunner queryRunner = new MyQueryRunner(dataSource);
		String sql = "delete from admin where id = ?";
		int rows = queryRunner.update(sql, 7);
		if (rows > 0) {
			System.out.println("刪除成功");
		} else {
			System.out.println("刪除失敗");
		}
		dataSource.close();
	}

}

學習MySQL這一篇就夠了
2020-09-02
MySql
學習Jmeter，這一篇就夠了
2020-10-10
JMeter
學習git這一篇就夠了！！！
2020-10-07
Git
學Nginx,這一篇就夠了
2020-09-25
Nginx
學習Hibernate5這一篇就夠了
2020-08-07
學習AIDL，這一篇文章就夠了
2016-12-28
AI
學習Hibernate5 JPA這一篇就夠了
2020-08-08
學習Spring5 WebFlux這一篇就夠了
2020-12-29
SpringWebUX
學習HTML5 Canvas這一篇文章就夠了
2019-02-16
HTMLCanvas
iOS 動畫詳解（學習動畫看這一篇就夠了）
2016-12-13
iOS動畫
APP瘦身這一篇就夠了
2019-04-10
APP
深入Babel，這一篇就夠了
2018-12-25
Babel
Git 看這一篇就夠了
2020-10-14
Git
【詳細圖解】學習佇列，看這一篇就夠了！
2021-04-06
圖解佇列
rodert教你學FFmpeg實戰這一篇就夠了
2022-03-18
Ubuntu搭建Pytorch，就這一篇就夠了
2022-07-18
UbuntuPyTorch
Flutter DataTable 看這一篇就夠了
2020-03-04
Flutter
Git【入門】這一篇就夠了
2020-07-04
Git
代理模式看這一篇就夠了
2018-11-13
模式
MySQL查詢這一篇就夠了
2020-11-09
MySql
Java 集合看這一篇就夠了
2020-10-15
Java
[譯] 理解CORS這一篇就夠了
2018-02-02
CORS
AJAX入門這一篇就夠了
2018-02-13
html css js（這一篇就夠了）
2024-09-23
HTMLCSSJS
學習Less-看這篇就夠了
2017-12-10
[收藏]學習sed，看這篇就夠了
2016-03-23
學Mybatis，入門看這一篇就夠你學的了！
2020-11-19
MyBatis
學Redis這篇就夠了
2019-07-14
Redis
c語言入門這一篇就夠了-學習筆記(一萬字)
2018-07-19
C語言筆記
瞭解 MongoDB 看這一篇就夠了
2020-01-08
MongoDB
關於SwiftUI，看這一篇就夠了
2020-06-24
SwiftUI
瞭解HandlerThread這一篇就夠了
2019-02-26
thread
這一篇就夠了——APP瘦身總結
2019-04-11
APP
Spring入門這一篇就夠了
2019-06-23
Spring
入門Hbase，看這一篇就夠了
2019-02-15
jQuery入門看這一篇就夠了
2021-04-18
jQuery
Elasticsearch入門，看這一篇就夠了
2021-05-17
Elasticsearch
關於MyBatis框架這一篇就夠了
2021-05-21
MyBatis框架

學習JDBC這一篇就夠了

第一章 概述

第二章 資料庫連線

第三章 資料庫事務

第四章 資料庫連線池

4.1、DBCP

4.2、Druid

4.3、C3P0

第五章 DButils

相關文章

第一章概述

第二章資料庫連線

第三章資料庫事務

第四章資料庫連線池