package com.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
public class DBHelper {
private static final String driver="com.mysql.jdbc.Driver";
private static final String url="jdbc:mysql://localhost:3306/数据库名?useUnicode=true&characterEncoding=UTF-8";
private static final String username="root";
private static final String password="root";
private static Connection conn = null;
//静态代码块负责加载驱动
static {
try {
Class.forName(driver);
}catch (Exception e) {
e.printStackTrace();
}
}
public static Connection getConection() throws Exception {
if(conn == null) {
conn = DriverManager.getConnection(username, password, url);
return conn;
}
return conn;
}
}