package com.zjx.util;

import java.sql.Connection;

import java.sql.DriverManager;

public class DbUtil {

    /**

     * 获取连接

     * @return

     * @throws Exception

     */

    public Connection getCon() throws Exception{

        Class.forName(PropertiesUtil.getValue("jdbcName"));

        Connection con=DriverManager.getConnection(PropertiesUtil.getValue("dbUrl"), PropertiesUtil.getValue("dbUsername"), PropertiesUtil.getValue("dbPassword"));

        return con;

    }

    /**

     * 关闭数据连接

     * @param con

     * @throws Exception

     */

    public void closeCon(Connection con) throws Exception{

        if(con!=null){

            con.close();

        }

    }

    public static void main(String[] args) {

        DbUtil dbUtil=new DbUtil();

        Connection con=null;

        try {

            con=dbUtil.getCon();

            System.out.println("数据库连接成功");

        } catch (Exception e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

            System.out.println("数据库连接失败");

        }finally {

            if(con!=null){

                try {

                    dbUtil.closeCon(con);

                    System.out.println("数据库连接成功关闭");

                } catch (Exception e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

            }

        }

    }

}