mysql、sqlserver、db2、oracle、hsql数据库获取数据库连接方法及分页函数

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Test {
	/**
	 * 获取数据库连接方法
	 * @param driverName 驱动
	 * @param url url
	 * @param userName 用户名
	 * @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/[数据库名]", "用户名", "密码");
//		//sqlserver
//		Connection conn = getConn("com.microsoft.sqlserver.jdbc.SQLServerDriver", "jdbc:sqlserver://[远程IP]:[端口];Database                Name=[数据库名]", "用户名", "密码");
//              //hsql
//		Connection conn = getConn("org.hsqldb.jdbcDriver", "jdbc:hsqldb:hsql://[远程IP]:[端口]/[数据库名]","用户名", "密码");
//		//oracle
//		Connection conn = getConn("oracle.jdbc.OracleDriver", "jdbc:oracle:thin:@[远程IP]:[端口]:[数据库名]","用户名", "密码");
//		//db2
//		Connection conn = getConn("com.ibm.db2.jcc.DB2Driver", "jdbc:db2://[远程IP]:[端口]/[数据库名]", "用户名", "密码");
		
		System.out.println(conn);   //打印数据库驱动

	}
}

sql分页查询：

//oracle

select * from (select rownum rm, * from tableName where rownum<(startRow+rowNum)) where rm>=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) ;