JAVA连接SqlServer2008R2和MySql数据库

问题描述：

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

 1 package com.test;
 2 
 3 import java.sql.Connection;
 4 import java.sql.DriverManager;
 5 
 6 public class DataBaseConn {
 7     
 8     private String databaseName = "";//数据名称
 9     private String useName = "";//用户登入名
10     private String password ="";//登入密码
11     
12     public DataBaseConn(){
13         this.databaseName = "INTRUST";
14         this.useName = "sa";
15         this.password = "000000";
16     }
17     
18     public DataBaseConn(String databaseName, String useName, String password){
19         this.databaseName = databaseName;
20         this.useName = useName;
21         this.password = password;
22     }
23     
24     public Connection con = null;
25     
26     private String MYSQLDRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
27     private String MYSQLURL = "jdbc:mysql://localhost:3306/" + databaseName + "?use" + useName + "&password" + password + "&useUnicode=true&characterEncoding=gb2312";
28     //SQLsServer驱动
29     private String MSSQLDRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
30     private String MSSQLURL = "jdbc:sqlserver://localhost:1433;DatabaseName=INTRUST";
31     
32     public void createMysqlConn(){
33         con = null;
34         try{
35             Class.forName(MYSQLDRIVER).newInstance();
36             con = DriverManager.getConnection(MYSQLURL);
37         }catch(Exception e){
38             e.printStackTrace();
39         }
40     }
41     //SQLsServer驱动
42     public void createMssqlConn(){
43         con = null;
44         try{
45             Class.forName(MSSQLDRIVER).newInstance();
46             con = DriverManager.getConnection(MSSQLURL, "sa", "000000");
47         }catch(Exception e){
48             e.printStackTrace();
49         }
50     }
51     
52     public Connection getMysqlConn(){
53         createMysqlConn();
54         return con;
55     }
56     
57     public Connection getMssqlConn(){
58         createMssqlConn();
59         return con;
60     }
61     
62     public void closeCon(){
63         if(con != null){
64             try {
65                 con.close();
66                 con = null;
67             } catch (Exception e) {
68                 // TODO Auto-generated catch block
69                 e.printStackTrace();
70             }
71         }
72     }
73 
74 }

 

转载于:https://www.cnblogs.com/atp-sir/p/6118395.html