jdbc遍历oracle数据库,JDBC获取数据库连接方式

Oracle

Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();

String url="jdbc:oracle:thin:@localhost:1521:DBNAME";

String user="abc";

String password="123";

Connection conn= DriverManager.getConnection(url,user,password);

Sql Server

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();

String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=DBNAME";

String user="abc";

String password="123";

Connection conn= DriverManager.getConnection(url,user,password);

DB2

Class.forName("com.ibm.db2.jdbc.app.DB2Driver ").newInstance();

String url="jdbc:db2://localhost:5000/DBNAME";

String user="abc";

String password="123";

Connection conn= DriverManager.getConnection(url,user,password);

Informix

Class.forName("com.informix.jdbc.IfxDriver").newInstance();

String url ="jdbc:informix-sqli://127.0.0.1:1533/DBNAME:INFORMIXSERVER=myserver;user=abc;password=123";

Connection conn= DriverManager.getConnection(url);

SyBase

Class.forName("com.sybase.jdbc.SybDriver").newInstance();

String url =" jdbc:sybase:Tds:localhost:5007/DBNAME";

Properties sysProps = System.getProperties();

SysProps.put("user","abc");

SysProps.put("password","123");

Connection conn= DriverManager.getConnection(url, SysProps);

MySql

Class.forName("org.gjt.mm.mysql.Driver").newInstance();

String url ="jdbc:mysql://localhost/DBNAME?user=abc&password=123&useUnicode=true&characterEncoding=8859_1" ;

Connection conn= DriverManager.getConnection(url);

PostgreSQL

Class.forName("org.postgresql.Driver").newInstance();

String url ="jdbc:postgresql://localhost/DBNAME" ;

String user="abc";

String password="123";

Connection conn= DriverManager.getConnection(url,user,password);

/*ConnectionUtil .java

*/

package com.cai.jdbc;

import java.sql.Connection;

import java.sql.DriverManager;

import java.util.Properties ;

public class ConnectionUtil {

/**

1

*在方法中固化连接参数

@return 数据库连接

*/

public Connection getConnection(){

Connection conn = null ;

try{

Class.forName("com.mysql.jdbc.Driver") ;

conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/stud", "root", "root") ;

return conn ;

}catch(Exception e){

e.printStackTrace() ;

}

return null ;

}

/**

2

*通过方法参数方式传递连接参数

@return 数据库连接

*/

public Connection getConnection(String driver, String url, String user, String password){

Connection conn = null ;

try{

Class.forName(driver) ;

conn = DriverManager.getConnection(url, user, password) ;

return conn ;

}catch(Exception e){

e.printStackTrace();

}

return null ;

}

/**

3

*通过properties配置文件的方式灵活配置连接参数，properties中的属性名固化

@return 数据库连接

*/

public Connection openConnection(){

Connection conn = null ;

String driver = "" ;

String url = "" ;

String user = "" ;

String password = "" ;

Properties props = new Properties() ;

try{

props.load(this.getClass().getClassLoader().getResourceAsStream("DBConfig.properties")) ;

driver = props.getProperty("driver") ;

url = props.getProperty("url") ;

user = props.getProperty("user") ;

password = props.getProperty("password") ;

Class.forName(driver) ;

conn = DriverManager.getConnection(url, user, password) ;

return conn ;

}catch(Exception e){

e.printStackTrace() ;

}

return null ;

}

public static void main(String []args){

ConnectionUtil cu = new ConnectionUtil() ;

System.out.println("1、---->" + cu.getConnection()) ;

System.out.println("2、---->" + cu.getConnection("com.mysql.jdbc.Driver",

"jdbc:mysql://localhost:3306/stud", "root", "root")) ;

System.out.println("3、---->" + cu.openConnection()) ;

}

}