需要用纯jdbc,先下载一个你想使用数据库的jdbc,放到你jdk的classpath下。代码如下import java.io.*;
import java.sql.*;
import java.util.*;public class JDBCtest{
public static void main(String args[]){
//上面两个括号 Vector drivers = new Vector();
Connection con;
String driverClassName = "oracle.jdbc.driver.OracleDriver";
//String URL = "jdbc:oracle:thin:@172.16.58.160:1521:orc1";
String URL = "jdbc:oracle:thin:@211.138.113.26:1521:orc1";
String user = "test";
String password = "test";
try { //注册数据库驱动
Driver driver = (Driver)Class.forName(driverClassName).newInstance();
DriverManager.registerDriver(driver);
drivers.addElement(driver);
System.out.println("Registered JDBC driver " + driverClassName);
}
catch (Exception e) {
System.out.println("Can't register JDBC driver: " +
driverClassName + ", Exception: " + e);
}
try { //创建连接
if (user == null) {
con = DriverManager.getConnection(URL);
}
else {
con = DriverManager.getConnection(URL,user,password);
}
System.out.println("Created a new connection in pool " + user);
String sql = "select * from dual";
Statement stmt = con.createStatement();
ResultSet rs=stmt.executeQuery(sql);
rs.next();
System.out.println("abc");
System.out.println(rs.getString(1));
}
catch (SQLException e) {
System.out.println("Can't create a new connection for " + URL);
}
finally{
}
//下面两个括号
}
}
import java.sql.*;
import java.util.*;public class JDBCtest{
public static void main(String args[]){
//上面两个括号 Vector drivers = new Vector();
Connection con;
String driverClassName = "oracle.jdbc.driver.OracleDriver";
//String URL = "jdbc:oracle:thin:@172.16.58.160:1521:orc1";
String URL = "jdbc:oracle:thin:@211.138.113.26:1521:orc1";
String user = "test";
String password = "test";
try { //注册数据库驱动
Driver driver = (Driver)Class.forName(driverClassName).newInstance();
DriverManager.registerDriver(driver);
drivers.addElement(driver);
System.out.println("Registered JDBC driver " + driverClassName);
}
catch (Exception e) {
System.out.println("Can't register JDBC driver: " +
driverClassName + ", Exception: " + e);
}
try { //创建连接
if (user == null) {
con = DriverManager.getConnection(URL);
}
else {
con = DriverManager.getConnection(URL,user,password);
}
System.out.println("Created a new connection in pool " + user);
String sql = "select * from dual";
Statement stmt = con.createStatement();
ResultSet rs=stmt.executeQuery(sql);
rs.next();
System.out.println("abc");
System.out.println(rs.getString(1));
}
catch (SQLException e) {
System.out.println("Can't create a new connection for " + URL);
}
finally{
}
//下面两个括号
}
}
<%@ page contentType="text/html;charset=8859_1" %>
<%
//变量声明
Java.sql.Connection sqlCon; //数据库连接对象
Java.sql.Statement sqlStmt; //SQL语句对象
Java.sql.ResultSet sqlRst; //结果集对象Java.lang.String strCon; //数据库连接字符串
Java.lang.String strSQL; //SQL语句int intPageSize; //一页显示的记录数
int intRowCount; //记录总数
int intPageCount; //总页数
int intPage; //待显示页码
Java.lang.String strPage;int i;//设置一页显示的记录数
intPageSize = 2;//取得待显示页码
strPage = request.getParameter("page");
if(strPage==null){//表明在QueryString中没有page这一个参数,此时显示第一页数据
intPage = 1;
}
else{//将字符串转换成整型
intPage = Java.lang.Integer.parseInt(strPage);
if(intPage<1) intPage = 1;
}//装载JDBC驱动程序
Java.sql.DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());//设置数据库连接字符串
strCon = "jdbc:oracle:thin:@linux:1521:ora4cweb";//连接数据库
sqlCon = Java.sql.DriverManager.getConnection(strCon,"hzq","hzq");//创建一个可以滚动的只读的SQL语句对象
sqlStmt = sqlCon.createStatement(Java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,Java.sql.ResultSet.CONCUR_READ_ONLY);//准备SQL语句
strSQL = "select name,age from test";//执行SQL语句并获取结果集
sqlRst = sqlStmt.executeQuery(strSQL);//获取记录总数
sqlRst.last();
intRowCount = sqlRst.getRow();//记算总页数
intPageCount = (intRowCount+intPageSize-1) / intPageSize;//调整待显示的页码
if(intPage>intPageCount) intPage = intPageCount;
%><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>JSP数据库操作例程 - 数据分页显示 - JDBC 2.0 - Oracle</title>
</head><body><table border="1" cellspacing="0" cellpadding="0">
<tr>
<th>姓名</th>
<th>年龄</th>
</tr><%
if(intPageCount>0){
//将记录指针定位到待显示页的第一条记录上
sqlRst.absolute((intPage-1) * intPageSize + 1);//显示数据
i = 0;
while(i<intPageSize && !sqlRst.isAfterLast()){
%>
<tr>
<td><%=sqlRst.getString(1)%></td>
<td><%=sqlRst.getString(2)%></td>
</tr>
<%
sqlRst.next();
i++;
}
}
%>