1. Driver loading
package JavaJDBC.Chap02.Sec03;
/**
* Created by linux_ccmj on 16-5-10.
*/
public class Demo1 {
// JDBC driver name
private static String namJDBC = "com.mysql.jdbc.Driver";
// JDBC loading test
public static void main(String[] args) {
try {
Class.forName(namJDBC);
System.out.println("加载驱动成功!");
} catch (ClassNotFoundException e) {
e.printStackTrace();
System.out.println("加载驱动失败!");
}
}
}
2. Connection
package JavaJDBC.Chap02.Sec04;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
* Created by linux_ccmj on 16-5-10.
*/
public class Demo01 {
// MySQL url address
private static String urlJdb = "jdbc:mysql://localhost:3306/db_book";
// MySQL user name
private static String namUseDb = "root";
// MySQL user password
private static String pasUseDb = "ccmj";
// MySQL driver name
private static String namDriDb = "com.mysql.jdbc.Driver";
// Test main
public static void main(String[] args) {
// Loading database driver
try {
Class.forName(namDriDb);
System.out.println("JDBC driver is loaded successfully!");
} catch (ClassNotFoundException e) {
e.printStackTrace();
System.out.println("JDBC driver is loaded unsuccessfully!");
}
// MySQL connection test
Connection con = null;
try {
con = DriverManager.getConnection(urlJdb, namUseDb, pasUseDb);
System.out.println("MySQL is connected!");
System.out.println("Begin data operation!");
} catch (SQLException e) {
e.printStackTrace();
}
try {
// Connection closing
con.close();
System.out.println("The connection is closed!");
} catch (SQLException e) {
e.printStackTrace();
}
}
}