JAVA连接SqlServer2008R2和MySql数据库

问题描述：

　　下面是有关连接SqlServer2008R2和MySql数据库的封装类

package com.test;

import java.sql.Connection;
import java.sql.DriverManager;

public class DataBaseConn {
    
    private String databaseName = "";//数据名称
    private String useName = "";//用户登入名
    private String password ="";//登入密码
    
    public DataBaseConn(){
        this.databaseName = "INTRUST";
        this.useName = "sa";
        this.password = "000000";
    }
    
    public DataBaseConn(String databaseName, String useName, String password){
        this.databaseName = databaseName;
        this.useName = useName;
        this.password = password;
    }
    
    public Connection con = null;
    
    private String MYSQLDRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
    private String MYSQLURL = "jdbc:mysql://localhost:3306/" + databaseName + "?use" + useName + "&password" + password + "&useUnicode=true&characterEncoding=gb2312";
    //SQLsServer驱动
    private String MSSQLDRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
    private String MSSQLURL = "jdbc:sqlserver://localhost:1433;DatabaseName=INTRUST";
    
    public void createMysqlConn(){
        con = null;
        try{
            Class.forName(MYSQLDRIVER).newInstance();
            con = DriverManager.getConnection(MYSQLURL);
        }catch(Exception e){
            e.printStackTrace();
        }
    }
    //SQLsServer驱动
    public void createMssqlConn(){
        con = null;
        try{
            Class.forName(MSSQLDRIVER).newInstance();
            con = DriverManager.getConnection(MSSQLURL, "sa", "000000");
        }catch(Exception e){
            e.printStackTrace();
        }
    }
    
    public Connection getMysqlConn(){
        createMysqlConn();
        return con;
    }
    
    public Connection getMssqlConn(){
        createMssqlConn();
        return con;
    }
    
    public void closeCon(){
        if(con != null){
            try {
                con.close();
                con = null;
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }

}