About how Eclispse connects to Mysql Jdbc

1. Create a Java project in Eclipse

2. Introduce the JDBC Library (in extenrnal of bulid path)

3.

1) import the SQL package (import java. SQL .*)

2) load (Register) the mysql jdbc driver

Class. forName ("com. mysql. jdbc. Driver ");

3) connect to the database (url)

Connection connect = DriverManager. getConnection (
"Jdbc: mysql: // localhost: 3306/test", "root", "123 ");

Connection connect = DriverManager. getConnection (
"Jdbc: mysql: // localhost: 3306/test ");

 

OK ..

 

Hierarchy:

Application Layer --- Jdbc interface layer --- jdbc driver layer --- Database

Jdbc interface layer: provides unified interfaces for accessing different databases

Jdbc driver layer: real database interaction is achieved by specific database Manufacturers

 

Jdbc url problems:

Once the Jdbc driver is registered, you can establish a database connection. However, because many drivers have been registered, DriverManager must select the correct driver.

Therefore, Jdbc has a special jdbc url as its self-identification for selection.

 

As follows:

Try
{

Class. forName ("com. mysql. jdbc. Driver ");
System. out. println ("Suceess loading mysql driver ");
}
Catch (Exception e)
{
System. out. print ("EEOR loading mysql driver ");
E. printStackTrace ();
}
Try
{
Connection connect = DriverManager. getConnection (
"Jdbc: mysql: // localhost: 3306/test", "root", "123 ");
System. out. println ("sucess connect server ");
Statement stmt = connect. createStatement ();
ResultSet rs1_stmt.exe cuteQuery ("select * from user ");
While (rs. next ())
{
System. out. println (rs. getString ("name "));
}
}
Catch (Exception e)
{
System. out. print ("get data error! ");
E. printStackTrace ();
}