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) ;