import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class Test {

/**

* 獲取數(shù)據(jù)庫(kù)連接方法

* @param driverName 驅(qū)動(dòng)

* @param url url

* @param userName 用戶(hù)名

* @param password 密碼

* @return

*/

public static Connection getConn(String driverName, String url, String userName, String password) {

Connection connection = null;

try {

Class.forName(driverName);

connection = DriverManager.getConnection(url, userName, password);

} catch (SQLException e) {

e.printStackTrace();

} catch (ClassNotFoundException e) {

e.printStackTrace();

}

return connection;

}

public static void main(String[] args) {

//mysql

Connection conn = getConn("com.mysql.jdbc.Driver", "jdbc:mysql://localhost:3306/[數(shù)據(jù)庫(kù)名]", "用戶(hù)名", "密碼");

sqlserver

//Connection conn = getConn("com.microsoft.sqlserver.jdbc.SQLServerDriver", "jdbc:sqlserver://[遠(yuǎn)程IP]:[端口];Database Name=[數(shù)據(jù)庫(kù)名]", "用戶(hù)名", "密碼");

// //hsql

//Connection conn = getConn("org.hsqldb.jdbcDriver", "jdbc:hsqldb:hsql://[遠(yuǎn)程IP]:[端口]/[數(shù)據(jù)庫(kù)名]","用戶(hù)名", "密碼");

oracle

//Connection conn = getConn("oracle.jdbc.OracleDriver", "jdbc:oracle:thin:@[遠(yuǎn)程IP]:[端口]:[數(shù)據(jù)庫(kù)名]","用戶(hù)名", "密碼");

db2

//Connection conn = getConn("com.ibm.db2.jcc.DB2Driver", "jdbc:db2://[遠(yuǎn)程IP]:[端口]/[數(shù)據(jù)庫(kù)名]", "用戶(hù)名", "密碼");

System.out.println(conn); //打印數(shù)據(jù)庫(kù)驅(qū)動(dòng)

}

}

sql分頁(yè)查詢(xún)：

//oracle

select? * ?from (select ?rownum? rm,? * ?from? tableName? where? rownum=startRow;

//mysql

select? *? from? tableName? limit??startRow , rowNum ;

//sqlserver

select? top? (startRow + rowNmu)? from? tableName ;

//db2

select? *? from? tableName? limit??startRow , rowNum ;

//hsql

select? limit? startRow? rowNum? *? from (select? *? from? tableName) ;

總結(jié)

以上是生活随笔為你收集整理的db2 oracle mysql sqlserver_mysql、sqlserver、db2、oracle、hsql数据库获取数据库连接方法及分页函数...的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。