/*
 * This product includes software developed by the
 * Apache Software Foundation (http://www.apache.org/).
 */
package ch06.module;

import java.sql.*;

import javax.servlet.http.*;

import ch06.*;

/**
 * 針對一些共通處理的父類
 * @author ShenYK
 * @version 1.0
 */
public class MCommon
{
    public Connection getDBConnection( HttpSession mySession )
    {
        //嘗試連接數據庫
        try
        {
            //載入MySQL的JDBC驅動類
            Class.forName(CommonConst.DB_DRIVER_CLASSNAME);
            //獲得數據庫連接
            Connection conn = DriverManager.getConnection( CommonConst.DB_CONN_STRING );
            
            return conn;
        }
        catch(Exception ex)
        {
            ex.printStackTrace();
            mySession.setAttribute("errMsg","獲得數據庫連接時出現錯誤！請聯系技術人員。");
            return null;
        }
    }
}