package util;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

/*

 * 数据库连接工具

 */

public class DBUtil {

    static String ip = "127.0.0.1";

    static int port = 3306;

    static String database = "tmall";      //此处可灵活修改

    static String encoding = "UTF-8";

    static String loginName = "root";      //此处可灵活修改

    static String password = "admin";      //此处可灵活修改

    static {

        try {

            Class.forName("com.mysql.jdbc.Driver");

        } catch (ClassNotFoundException e) {

            e.printStackTrace();

        }

    } 

    public static Connection getConnection() throws SQLException {

        String url = String.format("jdbc:mysql://%s:%d/%s?characterEncoding=%s", ip, port, database, encoding);

        return DriverManager.getConnection(url, loginName, password);

    }

    //测试用例

    public static void main(String[] args) throws SQLException {

        System.out.println(getConnection());

    }

}