dbcommon.java

Jsp做的网络邮件管理系统

/**
 * 
 */
package webMail;


import java.sql.*;
import webMail.CommonConst;
//import java.util.*;
import javax.servlet.http.HttpServlet;

/** 针对一些数据库连接的通用处理的父类
 * @author up
 *
 */
public class DBCommon extends HttpServlet 
{
	    public static String ConnectionStr=new String();
		public DBCommon()
		{
			super();
		} 		
		public static Connection getDBConnection()
	    {
	        //尝试连接数据库
	         try
	         {
	        	   Connection conn;
	        	   if(CommonConst.DBSEL.equals("ACCESS"))
	        	   {
		               //载入ACCESS的JDBC驱动类
		               Class.forName( CommonConst.ACCESS_DB_DRIVER_CLASSNAME );
		               //获得数据库连接	
		               conn = DriverManager.getConnection(ConnectionStr );
	        	   }
	        	   else
	        	   {
                       // 载入MySQL的JDBC驱动类
		               Class.forName( CommonConst.MYSQL_DB_DRIVER_CLASSNAME );
		               //获得数据库连接
		               conn = DriverManager.getConnection(CommonConst.MYSQL_DB_CONN_STRING );	
	        	   }
	               return conn;
	         }
	         catch(Exception ex)
	         {
	               ex.printStackTrace();
	               return null;
	         }
	    }
		public static void setConnStr(String AccessPath)
	    {
	         //设置数据库连接字符串
	         ConnectionStr="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+ AccessPath;
			//ConnectionStr="driver={Microsoft Access Driver (*.mdb)};="+ AccessPath;
	    }
		
}