Getting Started with JDBC

1.1 Working with database methods before

1) Log in to the database server via the MySQL client tool (or log in to the database using cmd: mysql-u root-p password)

2) Writing SQL statements

3) Send SQL statement to database server execution

1.2 What is JDBC?

The technique of sending SQL statements using Java Code (Programs) is JDBC Technology!

In order to simplify and unify the operation of database, Sun Company defines a set of Java Operation Database Specification (interface), called JDBC. This interface is implemented by the database vendor, so that developers can manipulate the database by simply learning the JDBC interface and loading the specific driver through JDBC.

1.3 using JDBC to send SQL premises

Connecting to the database server

IP address of database: Port number/database name

Database user Name

Password

Getting Started with JDBC