Java连接各个版本Oracle/Mysql/DB2…数据库代码

package com.entity; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; import java.sql.Statement; import com.ibm.db2.jcc.am.Connection; import com.ibm.db2.jcc.am.ResultSet; public class InfomixConnect { /** 设置参数 **/ private Connection conn = null; private Statement stmt = null; private ResultSet rs = null; /** 构造方法，链接数据库 **/ public InfomixConnect(String dbName, String dbIp, String port, String dbUserName, String dbUserPwd) { try { System.out.println("正在连接Infomix数据库.........."); Class.forName("com.informix.jdbc.IfxDriver");// 加载mysql驱动程序类 String url = "jdbc:informix-sqli://" + dbIp + ":" + port + "/db:INFORMIXSERVER=" + dbName;// url为连接字符串 String user = dbUserName;// 数据库用户名 String pwd = dbUserPwd;// 数据库密码 conn = (Connection) DriverManager.getConnection(url, user, pwd); System.out.println("数据库连接成功！！！"); } catch (Exception e) { e.printStackTrace(); } } public boolean testConnect() { return conn == null ? false : true;//conn为空 则连接失败返回false，否则返回true } public void close(ResultSet rs, PreparedStatement ps, Connection conn) { if (rs != null) { try { rs.close(); rs = null; } catch (SQLException e) { e.printStackTrace(); System.out.println("关闭ResultSet失败"); } } if (ps != null) { try { ps.close(); ps = null; } catch (SQLException e) { e.printStackTrace(); System.out.println("关闭PreparedStatement失败"); } } if (conn != null) { try { conn.close(); conn = null; } catch (SQLException e) { e.printStackTrace(); System.out.println("关闭Connection失败"); } } } public Connection getConn() { return conn; } public void setConn(Connection conn) { this.conn = conn; } public Statement getStmt() { return stmt; } public void setStmt(Statement stmt) { this.stmt = stmt; } public ResultSet getRs() { return rs; } public void setRs(ResultSet rs) { this.rs = rs; } }