初学者J2EE问题连接Oracle问题

来源：百度知道 编辑：UC知道 时间：2024/06/23 23:23:01
我的程序代码是：
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<%
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oralce:thin://@192.168.0.4:1521:ora9";
conn=DriverManager.getConnection(url,"scott","yyzrj3");
stmt=conn.createStatement();
rs=stmt.executeQuery("select * from guestbook");
while(rs.next())
{
out.print(" " + rs.getInt(1));
out.print(" " + rs.getInt(2));
out.print(" " + rs.getInt(3));
out.print(" " + rs.getInt(4));
out.print(" " + rs.getInt(5));
out.print(" " + rs.getInt(6));
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e){
e.printStackTrace();
}
%>
错误的

你把Oracle的Jar包放到Lib文件夹下面了吗？

看看这个吧，我有二个月没动JB了，这个大体看了看，该满足你的要求：

<%String sConn="你的连接"
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn=DriverManager.getConnection(sConn,"你的用户名","密码");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
Statement stmtcount=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

ResultSet rs=stmt.executeQuery("select * from mytable_view");
String sqlcount="select count(*) from mytable_view";
ResultSet rscount=stmtcount.executeQuery(sqlcount);

int pageSize=你的每页显示纪录数；
int rowCount=0; //总的记录数
while (rscount
int pageCount; //总的页数
int currPage; //当前页数
String strPage;
strPage=request.getParameter("page");
if (strPage==null){
currPage=1;
}
else{
currPage=Int