各种JDBC连接数据库的惯用代码

各种JDBC连接数据库的常用代码

MySQL：
String Driver="com.mysql.jdbc.Driver";    //驱动程序
String URL="jdbc:mysql://localhost:3306/db_name"?useUnicode=true&amp;characterEncoding=UTF-8;    //连接的URL,db_name为数据库名，注意修改编码类型
String Username="username";    //用户名
String Password="password";    //密码
Class.forName(Driver).new Instance();
Connection con=DriverManager.getConnection(URL,Username,Password);
JTDS2.0：
String Driver=" net.sourceforge.jtds.jdbc.Driver";    //驱动程序
String URL="jdbc:jtds:sqlserver://localhost:1433/db_name";
String Username="username";    //用户名
String Password="password";    //密码
Class.forName(Driver).new Instance();
Connection con=DriverManager.getConnection(URL,Username,Password);
Microsoft SQL Server 2.0驱动(3个jar的那个):
String Driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";    //连接SQL数据库的方法
String URL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_name";    //db_name为数据库名
String Username="username";    //用户名
String Password="password";    //密码
Class.forName(Driver).new Instance();    //加载数据可驱动
Connection con=DriverManager.getConnection(URL,UserName,Password);    //
Microsoft SQL Server 3.0驱动(1个jar的那个):
String Driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";    //连接SQL数据库的方法
String URL="jdbc:sqlserver://localhost:1433;DatabaseName=db_name";    //db_name为数据库名
String Username="username";    //用户名
String Password="password";    //密码
Class.forName(Driver).new Instance();    //加载数据可驱动
Connection con=DriverManager.getConnection(URL,UserName,Password);    //
Sysbase:
String Driver="com.sybase.jdbc.SybDriver";    //驱动程序
String URL="jdbc:Sysbase://localhost:5007/db_name";    //db_name为数据可名
String Username="username";    //用户名
String Password="password";    //密码
Class.forName(Driver).newInstance();
Connection con=DriverManager.getConnection(URL,Username,Password);
Oracle(用thin模式):
String Driver="oracle.jdbc.driver.OracleDriver";    //连接数据库的方法
String URL="jdbc:oracle:thin:@loaclhost:1521:orcl";    //orcl为数据库的SID
String Username="username";    //用户名
String Password="password";    //密码
Class.forName(Driver).newInstance();    //加载数据库驱动
Connection con=DriverManager.getConnection(URL,Username,Password);

PostgreSQL:
String Driver="org.postgresql.Driver";    //连接数据库的方法
String URL="jdbc:postgresql://localhost/db_name";    //db_name为数据可名
String Username="username";    //用户名
String Password="password";    //密码
Class.forName(Driver).newInstance();
Connection con=DriverManager.getConnection(URL,Username,Password);
DB2：
String Driver="com.ibm.db2.jdbc.app.DB2.Driver";    //连接具有DB2客户端的Provider实例
//String Driver="com.ibm.db2.jdbc.net.DB2.Driver";    //连接不具有DB2客户端的Provider实例
String URL="jdbc:db2://localhost:5000/db_name";    //db_name为数据可名
String Username="username";    //用户名
String Password="password";    //密码
Class.forName(Driver).newInstance();
Connection con=DriverManager.getConnection(URL,Username,Password);
Informix:
String Driver="com.informix.jdbc.IfxDriver";
String URL="jdbc:Informix-sqli://localhost:1533/db_name:INFORMIXSER=myserver";    //db_name为数据可名
String Username="username";    //用户名
String Password="password";    //密码
Class.forName(Driver).newInstance();
Connection con=DriverManager.getConnection(URL,Username,Password);
JDBC-ODBC:
String Driver="sun.jdbc.odbc.JdbcOdbcDriver";
String URL="jdbc:odbc:dbsource";    //dbsource为数据源名
String Username="username";    //用户名
String Password="password";    //密码
Class.forName(Driver).newInstance();
Connection con=DriverManager.getConnection(URL,Username,Password);

1 楼 ahack 2 小时前

<JDBC-Drivers>
    <Driver>
        <DriverName>IBM Type 2 Driver for DB2 7.x/8.x</DriverName>
        <ClassName>COM.ibm.db2.jdbc.app.DB2Driver</ClassName>
        <URL>jdbc:db2:[dbname]</URL>
        <level>system</level>
        <TestSql>SELECT COUNT(*) FROM SYSIBM.SYSTABLES</TestSql>
    </Driver>
 
    <Driver>
        <DriverName>IBM Type 2 XA Driver for DB2 7.x/8.x</DriverName>
        <ClassName>COM.ibm.db2.jdbc.DB2XADataSource</ClassName>
        <URL>jdbc:db2:[dbname]</URL>
        <level>system</level>
        <TestSql>SELECT COUNT(*) FROM SYSIBM.SYSTABLES</TestSql>
    </Driver>
 
    <Driver>
        <DriverName>IBM Type 4 Driver for DB2 7.x/8.x</DriverName>
        <ClassName>COM.ibm.db2.jdbc.net.DB2Driver</ClassName>
        <URL>jdbc:db2://[host]:6789/[dbName]</URL>
        <level>system</level>
        <TestSql>SELECT COUNT(*) FROM SYSIBM.SYSTABLES</TestSql>
    </Driver>
 
    <Driver>
        <DriverName>IBM Type 4 Driver for Informix</DriverName>
        <ClassName>com.informix.jdbc.IfxDriver</ClassName>
        <URL>jdbc:informix-sqli://[host]:[1526]/[dbName]:informixserver=[myserver];user=[username];password=[password]
        </URL>
        <level>system</level>
        <TestSql>SELECT COUNT(*) FROM SYSTABLES</TestSql>
    </Driver>
 
    <Driver>
        <DriverName>IBM Type 4 XA Driver for Informix</DriverName>
        <ClassName>com.informix.jdbcx.IfxXADataSource</ClassName>
        <URL>jdbc:informix-sqli://[host]:[1526]/[dbName]:informixserver=[myserver];user=[username];password=[password]
        </URL>
        <level>system</level>
        <TestSql>SELECT COUNT(*) FROM SYSTABLES</TestSql>
    </Driver>
 
    <Driver>
        <DriverName>Derby Client Driver</DriverName>
        <ClassName>org.apache.derby.jdbc.ClientDriver</ClassName>
        <URL>jdbc:derby://[host]:[port]/[database]</URL>
        <level>system</level>
        <TestSql>SELECT COUNT(*) FROM SYS.SYSTABLES</TestSql>
    </Driver>
 
    <Driver>
        <DriverName>Microsoft Type 4 XA Driver for MS SQL Server 2000
        </DriverName>
        <ClassName>com.microsoft.sqlserver.jdbc.SQLServerDriver</ClassName>
        <URL>jdbc:microsoft:sqlserver://[host]:[1433];DatabaseName=[dbName]
        </URL>
        <level>system</level>
        <TestSql>SELECT COUNT(*) FROM sysobjects</TestSql>
    </Driver>
     
    <Driver>
        <DriverName>Microsoft Driver for MS SQL Server 2005+</DriverName>
        <ClassName>com.microsoft.jdbc.sqlserver.SQLServerDriver</ClassName>
        <URL>jdbc:sqlserver://[host]:[1433];DatabaseName=[dbName]</URL>
        <level>system</level>
        <TestSql>SELECT COUNT(*) FROM sysobjects</TestSql>
    </Driver>
     
    <Driver>
        <DriverName>MySQL Connector/J Type 4 Driver for MySQL</DriverName>
        <ClassName>com.mysql.jdbc.Driver</ClassName>
        <URL>jdbc:mysql://[host]:[3306]/[dbName]?user=test</URL>
        <level>system</level>
        <TestSql>SELECT 1</TestSql>
    </Driver>
     
    <Driver>
        <DriverName>MM.MySQL Type 4 Driver for MySQL</DriverName>
        <ClassName>org.gjt.mm.mysql.Driver</ClassName>
        <URL>jdbc:mysql://[host]:[3306]/[dbName]?user=test</URL>
        <level>system</level>
        <TestSql>SELECT 1</TestSql>
    </Driver>
     
    <Driver>
        <DriverName>Oracle Type 4 Driver for Oracle 8.1.7,9.0.1,9.2.0
        </DriverName>
        <ClassName>oracle.jdbc.driver.OracleDriver</ClassName>
        <URL>jdbc:oracle:thin:@[host]:[1521]:[dbName]</URL>
        <level>system</level>
        <TestSql>SELECT 1 from DUAL</TestSql>
    </Driver>
     
    <Driver>
        <DriverName>Oracle Type 4 XA Driver for Oracle 8.1.7,9.0.1,9.2.0
        </DriverName>
        <ClassName>oracle.jdbc.xa.client.OracleXADataSource</ClassName>
        <URL>jdbc:oracle:thin:@[host]:[1521]:[dbName]</URL>
        <level>system</level>
        <TestSql>SELECT 1 from DUAL</TestSql>
    </Driver>
     
    <Driver>
        <DriverName>Oracle OCI Driver for Oracle 8.1.7,9.0.1,9.2.0
        </DriverName>
        <ClassName>oracle.jdbc.driver.OracleDriver</ClassName>
        <URL>jdbc:oracle:oci8:@[dbName]</URL>
        <level>system</level>
        <TestSql>SELECT 1 from DUAL</TestSql>
    </Driver>
     
    <Driver>
        <DriverName>Oracle OCI XA Driver for Oracle 8.1.7,9.0.1,9.2.0
        </DriverName>
        <ClassName>oracle.jdbc.xa.client.OracleXADataSource</ClassName>
        <URL>jdbc:oracle:oci8:@[dbName]</URL>
        <level>system</level>
        <TestSql>SELECT 1 from DUAL</TestSql>
    </Driver>
     
    <Driver>
        <DriverName>TongTech Driver Wrapper for Oracle </DriverName>
        <ClassName>com.tongweb.jdbc.OracleDriverWrapper</ClassName>
        <URL>jdbc:oracle:thin:@[host]:[1521]:[dbName]</URL>
        <level>system</level>
        <TestSql>SELECT * from duel</TestSql>
    </Driver>
     
    <Driver>
        <DriverName>postgreSQL type 4 Driver for postgreSq</DriverName>
        <ClassName>org.postgresql.Driver</ClassName>
        <URL>jdbc:postgresql://[host]:[5432]/[dbName]</URL>
        <level>system</level>
        <TestSql>SELECT 1</TestSql>
    </Driver>
     
    <Driver>
        <DriverName>Sybase type 4 Driver for Sybase 11.x</DriverName>
        <ClassName>com.sybase.jdbc.SybDriver</ClassName>
        <URL>jdbc:sybase:Tds:[host]:[2048]/[dbName]</URL>
        <level>system</level>
        <TestSql>SELECT COUNT(*) FROM sysobjects</TestSql>
    </Driver>
     
    <Driver>
        <DriverName>Sybase type 4 XA Driver for Sybase 12.x</DriverName>
        <ClassName>com.sybase.jdbc2.jdbc.SybXADataSource</ClassName>
        <URL>jdbc:sybase:Tds:[host]:[2048]/[dbName]?charset=eucgb</URL>
        <level>system</level>
        <TestSql>SELECT COUNT(*) FROM sysobjects</TestSql>
    </Driver>
     
    <Driver>
        <DriverName>HSQL JDBC Driver</DriverName>
        <ClassName>org.hsqldb.jdbcDriver</ClassName>
        <URL>jdbc:hsqldb:hsql://[host]:[9001]/default</URL>
        <level>system</level>
        <TestSql>SELECT 1</TestSql>
    </Driver>
    <Driver>
        <DriverName>Sybase15 JDBC Driver</DriverName>
        <ClassName>com.sybase.jdbc3.jdbc.SybDriver</ClassName>
        <URL>jdbc:sybase:Tds:[host]:[5000]/[dbName]</URL>
        <level>system</level>
        <TestSql>SELECT COUNT(*) FROM sysobjects</TestSql>
    </Driver>
     
    <Driver>
        <DriverName>Kingbase JDBC Driver</DriverName>
        <ClassName>com.kingbase.Driver</ClassName>
        <URL>jdbc:kingbase://[host]:[54321]/[dbName]</URL>
        <level>system</level>
        <TestSql>SELECT 1</TestSql>
    </Driver>
     
    <Driver>
        <DriverName>dameng JDBC Driver</DriverName>
        <ClassName>dm.jdbc.driver.DmDriver</ClassName>
        <URL>jdbc:dm://127.0.0.1:12345/TEST</URL>
        <level>system</level>
        <TestSql>SELECT 1</TestSql>
    </Driver>
     
</JDBC-Drivers>

各种JDBC连接数据库的惯用代码

相关推荐