package com.initSplit;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import com.cku.oa.sys.entity.user.Member;

public class DBUtil {
    static final Logger logger = LoggerFactory.getLogger(DBUtil.class);
    private static final String DRIVER = "com.mysql.jdbc.Driver";
    private static final String USER = "root";
    private static final String PASSWORD = "123456";
    private static final String DATABASE = "jdbc:mysql://192.168.18.152:3306/ckuoa";

    public static Connection getConnection() {
        Connection connection = null;
        String URL = DATABASE +"?characterEncoding=UTF-8";
        try{
            Class.forName(DRIVER);
            connection = DriverManager.getConnection(URL,USER,PASSWORD);
        } catch (ClassNotFoundException | SQLException e) {
            logger.error(URL + "连接MySQL数据库失败！", e);
            return null;
        }
        return connection;
    }
    

}