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