[jdbc封装]许多种数据库的连接地址 ,也是怀旧的代码.

package AllchiSql; import java.sql.*; public class SuperSQL { /** * Var * */ /* // DataBase kinds public static final String ORACLE="Oracle"; public static final String SQLSERVER="SqlServer"; public static final String DB2="DB2"; public static final String INFORMIX="Informix"; public static final String SYBASE="SyBase"; public static final String MYSQL="MySql"; public static final String POSTGRESQL="PostgreSQL"; public static final String ACCESS="Access"; */ // Drivers kinds public static final String ORACLEDRIVER="oracle.jdbc.driver.OracleDriver"; public static final String SQLSERVERDRIVER="com.microsoft.JDBC.sqlserver.SQLServerDriver"; public static final String DB2DRIVER="com.ibm.db2.JDBC.app.DB2Driver "; public static final String INFORMIXDRIVER="com.informix.JDBC.IfxDriver"; public static final String SYBASEDRIVER="com.sybase.JDBC.SybDriver"; public static final String MYSQLDRIVER="com.mysql.jdbc.Driver"; public static final String POSTGRESQLDRIVER="org.postgresql.Driver"; public static final String ACCESSDRIVER="sun.jdbc.odbc.JdbcOdbcDriver"; public static final String ODBCDRIVER="sun.jdbc.odbc.JdbcOdbcDriver"; Connection con=null; Statement stmt=null; ResultSet rs=null; String driverKind,IP,port,dataSource,loginName,pwd,url; /** * Methods * */ SuperSQL(String driverKind,String IP,String port,String dataSource,String loginName,String pwd){ try { this.driverKind=driverKind; this.IP=IP; this.port=port; this.dataSource=dataSource; this.loginName=loginName; this.pwd=pwd; if(driverKind==ORACLEDRIVER) { //String url="jdbc:oracle:thin:@localhost:1521:orcl"; url="jdbc:oracle:thin:@"+IP+":"+port+":"+dataSource; } else if(driverKind==SQLSERVERDRIVER) { //Stirng url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs"; url="jdbc:microsoft:sqlserver://"+IP+":"+port+";"+"DatabaseName="+"dataSource";; } else if(driverKind==DB2DRIVER) { //String url = "jdbc:db2://localhost:5000/sample"; url="jdbc:db2://"+IP+":"+port+"/"+dataSource; } else if(driverKind==INFORMIXDRIVER) { //String url = "jdbc:informix-sqli://123.45.67.89:1533/testDB:INFORMIXSERVER=myserver; url="jdbc:informix-sqli://"+IP+":"+port+"/"+dataSource+":INFORMIXSERVER=myserver"; } else if(driverKind==SYBASEDRIVER) { //String url = "jdbc:sybase:Tds:localhost:5007/tsdata";//tsdata为你的数据库名 url="jdbc:sybase:Tds:"+IP+":"+port+"/"+dataSource; } else if(driverKind==MYSQLDRIVER) { //String url = "JDBC:mysql://localhost/softforum?user=soft&password=soft1234 url="JDBC:mysql://"+IP+"/"+dataSource+"?user="+loginName+"&password="+pwd; } else if(driverKind==POSTGRESQLDRIVER) { //String url = "JDBC:postgresql://localhost/soft";//soft为你的数据库名 url="JDBC:postgresql://"+IP+"/"+dataSource; } else if(driverKind==ACCESSDRIVER) { //String url="jdbc:odbc:db1"; url="jdbc:odbc:"+dataSource; } else if(driverKind==ODBCDRIVER) { //String url="jdbc:odbc:db1"; url="jdbc:odbc:"+dataSource; } if(url!=null) { Class.forName(driverKind); con=DriverManager.getConnection(url,loginName,pwd); stmt=con.createStatement(); } else{System.out.println("Not support such DataBase");} } catch (Exception SS) { SS.printStackTrace(); } } public ResultSet query(String sql){ try { if(stmt!=null) { rs=stmt.executeQuery(sql); } } catch(Exception q){q.printStackTrace();} finally{return rs;} } public static void help(){ System.out.println("SuperSQL sql=new SuperSQL(String driverKind,String IP,String port,String dataSource,String loginName,String pwd"); System.out.println(""); System.out.println(""); System.out.println(""); System.out.println(""); } }

It's tester

package AllchiSql; import java.sql.*; public class trySuperSQL { /** * @param args */ public static void main(String[] args) { test(); } public static void test(){ SuperSQL sql=new SuperSQL(SuperSQL.ODBCDRIVER,"","","LocalServer","",""); ResultSet rs=sql.query("select * from allchi_bro"); try { while(rs.next()) { System.out.println(rs.getString("name")); System.out.println(rs.getString("tel")); //System.out.println(rs.getString("")); } SuperSQL.help(); } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } } }