sqlserverdaofactory.java

中国移动管理系统

package com.chinamobile.dao;

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

public class SQLServerDAOFactory extends DAOFactory {

	 public static String serverName = "localhost";
		public static String sDBDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
		public static String dbInstance = "ChinaMobile";
		public static String sConnStr = "jdbc:sqlserver://"+serverName+":1433;databaseName="+dbInstance;
		
		public static String dbUser = "sa";
		public static String userPwd = "xiaokan";
	 
		public OperatorDAO getOperatorDAO()
	    	{
	        	return new SQLServerOperatorDAO();
	   	}
		
		public MobileDAO getMobileDAO()
    	{
        	return new SQLServerMobileDAO();
   	    }
		
		public ChargeDAO getChargeDAO()
    	{
        	return new SQLServerChargeDAO();
   	    }
		
		public ChargeRuleDAO getChargeRuleDAO()
    	{
        	return new SQLServerChargeRuleDAO();
   	    }
	  
	    public static Connection getConnection()
	    {
	        Connection conn = null;
	        try {
	            //For SqlServer            
			Class.forName(sDBDriver); 
	            	conn = DriverManager.getConnection(sConnStr, dbUser, userPwd);     
		}		
		catch(ClassNotFoundException e) {
			e.printStackTrace();
		}		
		catch(SQLException e1)
		{
			e1.printStackTrace();
		}
		return conn;
	    }
 
	    public static void closeResultSet(ResultSet rs)
	    {
	         if( rs != null)
	    	 {
	    	    try
	    	    {
	    	        rs.close();
	    	    }
	    	    catch(SQLException e)
	    	    {    	            
	    	    }
	    	 }	    
	    }
	 
	    public static void closeStatement(Statement stmt)
	    {        
	    	    if( stmt != null)
	    	    {
	    	        try
	    	        {
	    	            stmt.close();
	    	        }
	    	        catch(SQLException e)
	    	        { 
	    	        }
	    	    }	
	    }
	  
	    public static void closeConnection(Connection conn)
	    {
		if( conn != null)
	    	{
			try
		    	{
		    		conn.close();
		    	}
		    	catch(SQLException e)
		    	{
		    	}
	    	}
	    }

}