数据库相关

创建数据库连接

import java.util.Properties;

public class DatabaseUtils {
    public static Connection getConnection(DataBase dataBase) throws ClassNotFoundException, SQLException {
        Properties props = new Properties();
        props.put("remarksReporting","true");//获取数据库备注信息
        props.put("user","root");
        props.put("password","这里填写root用户密码");

        Class.forName("com.mysql.jdbc.Driver");
        String url = "jdbc:mysql://localhost:3306?useUnicode=true&characterEncoding=utf8";
        return DriverManager.getConnection(url,props);
    }
}