原文地址:https://www.mysqltutorial.org/mysql-jdbc-tutorial/
Java JDBC provides a standard interface to interact with any relational databases. In this tutorial series, you will learn how to use the MySQL JDBC Connector to connect Java programs to MySQL databases.
- Overview of JDBC
- Setting up MySQL JDBC environment
- Perform common database operations including selecting, inserting, updating, and deleting data.
- Transactions
- Calling stored procedures
- Working with BLOB data
- Basic knowledge of MySQL
- Fundamental Java programming
- Introduction to JDBC – Learn about JDBC so that you can use it for interacting with MySQL databases.
- Setting Up MySQL JDBC Development Environment – Show you how to set up a development environment that helps you work with MySQL and JDBC.
- Connecting to MySQL Using JDBC Driver – Learn how to connect to the MySQL database using the JDBC Connection object.
- Querying Data From MySQL Using JDBC – Guide you on how to query data from MySQL using JDBC Statement and ResultSet objects.
- Updating Data in MySQL Using JDBC PreparedStatement -Learn how to update data in the MySQL database using the JDBC PreparedStatement interface.
- Inserting Data Into Table Using JDBC PreparedStatement – Learn how to use the PreparedStatement object to insert data into a table and get the inserted ID back.
- MySQL JDBC Transaction – Learn how to use commit() and rollback() methods of the Connection object to control transactions.
- Calling MySQL Stored Procedures from JDBC – Show you how to call MySQL stored procedures from JDBC using the CallableStatement object.
- Writing and Reading MySQL BLOB Using JDBC – Show you how to write and read MySQL BLOB data using JDBC API.