JDBC加载驱动程序
oracle驱动加载:Class.forName("oracle.jdbc.driver.OracleDriver"); mysql驱动加载:Class.forName("com.mysql.jdbc.Driver"); JDBC获得数据库连接 DriverManager.getConnection("jdbc:mysql:://127.0.0.1:3306/mysql?characterEncoding=utf8","root","root"); 创建Statement对象: conn.createStatement();package com.db;
import java.sql.Connection;
import java.sql.DriverManager; import java.sql.SQLException;public class DBUtil {
private static final String URL="jdbc:mysql://127.0.0.1:3306/imooc?characterEncoding=utf8";
private static final String USER="root"; private static final String PASSWORD="root"; private static Connection conn=null; static { try { //1.加载驱动程序 Class.forName("com.mysql.jdbc.Driver"); //2.获得数据库的连接 conn=DriverManager.getConnection(URL, USER, PASSWORD); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } public static Connection getConnection(){ return conn; }}