package com.bright.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Util {
private static final String DRIVER="com.mysql.jdbc.Driver";//加载数据库的驱动(D要大写)
private static final String URL="jdbc:mysql://localhost:3306/prac"; //url地址
private static final String USERNAME="root"; //数据库的用户名
private static final String PASSWORD="123"; //数据库的登录密码
private static Connection conn=null;
//静态代码块负责加载驱动
static{
try {
Class.forName(DRIVER); //加载驱动
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
//对外提供一个连接数据库的方法
public static Connection getConnection() throws Exception{
return DriverManager.getConnection(URL, USERNAME, PASSWORD);
}
}