67,513
社区成员
发帖
与我相关
我的任务
分享
try{
if(dbtype.equals("1")){ //db2
Class.forName("com.ibm.db2.jdbc.app.DB2Driver").newInstance();
dbURL = "jdbc:db2://"+ipaddress+":"+port+"/"+dbname;
}else if(dbtype.equals("2")){ //oracle
Class.forName("Oracle.jdbc.driver.OracleDriver").newInstance();
dbURL = "jdbc:oracle:thin:@"+ipaddress+":"+port+":"+dbname;
}else if(dbtype.equals("3")){ //sqlserver
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
dbURL = "jdbc:microsoft:sqlserver://"+ipaddress+":"+port+";DatabaseName="+dbname;
}else{ //mysql
// Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Class.forName("com.mysql.jdbc.Driver");
dbURL = "jdbc:mysql://"+ipaddress+":"+port+"/"+dbname;
}
if (logger.isDebugEnabled()) {
logger.debug("============测试数据库连接加载驱动成功============");
}
}catch(Exception e){
e.printStackTrace();
entity.setCodeMsg(-1, e.getMessage());
logger.error(e.getMessage(), e);
}
try{
Connection dbConn=DriverManager.getConnection(dbURL,username,password);
entity.setCodeMsg(1, "数据库连接成功!");
if(dbConn != null) {
try {
dbConn.close();
} catch(Exception e) {
e.printStackTrace();
}
dbConn = null;
}
}catch(Exception e){
e.printStackTrace();
entity.setCodeMsg(-1, e.getMessage());
}
return entity;
}