部分原代码如下:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.net.*"%><%String WebmasterIP="127.0.0.1";
boolean IsWebmasterIP=false;
String RemoteAddr=new String();
RemoteAddr=request.getRemoteAddr();
if(RemoteAddr.equals(WebmasterIP))
{
IsWebmasterIP=true;
}int pagesize;
int rowcount=5;
int pagecount;
int intpage;
String strpage;
int i;
pagesize=5;
strpage=request.getParameter("page");
if(strpage==null){
intpage=1;
}
else
{
intpage=Integer.parseInt(strpage);
if(intpage<1) intpage=1;
}
String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException ae)
{
System.err.println("ae:"+ae.getMessage());
}
String sConnStr="jdbc.odbc:zdl";
Connection conn=null;
conn=DriverManager.getConnection(sConnStr,"stud","");
String strSQL;
strSQL="SELECT*FROM guestbook WHERE flag=1";
Statement stmt=
conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet result=null;
try
{
result=stmt.executeQuery(strSQL);
}
catch(SQLException be)
{
System.err.println("be.executeQuery:"+be.getMessage());
}
result.last();
rowcount=result.getRow();
pagecount=(rowcount+pagesize-1)/pagesize;
if(intpage>pagecount) intpage=pagecount;
%>
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.net.*"%><%String WebmasterIP="127.0.0.1";
boolean IsWebmasterIP=false;
String RemoteAddr=new String();
RemoteAddr=request.getRemoteAddr();
if(RemoteAddr.equals(WebmasterIP))
{
IsWebmasterIP=true;
}int pagesize;
int rowcount=5;
int pagecount;
int intpage;
String strpage;
int i;
pagesize=5;
strpage=request.getParameter("page");
if(strpage==null){
intpage=1;
}
else
{
intpage=Integer.parseInt(strpage);
if(intpage<1) intpage=1;
}
String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException ae)
{
System.err.println("ae:"+ae.getMessage());
}
String sConnStr="jdbc.odbc:zdl";
Connection conn=null;
conn=DriverManager.getConnection(sConnStr,"stud","");
String strSQL;
strSQL="SELECT*FROM guestbook WHERE flag=1";
Statement stmt=
conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet result=null;
try
{
result=stmt.executeQuery(strSQL);
}
catch(SQLException be)
{
System.err.println("be.executeQuery:"+be.getMessage());
}
result.last();
rowcount=result.getRow();
pagecount=(rowcount+pagesize-1)/pagesize;
if(intpage>pagecount) intpage=pagecount;
%>
解决方案 »
- java 中删除浏览器的cookie 求高手 坐等
- 急!!!如何再利用页面上list数据,完成其他任务
- java GUI 设计问题
- 急,大家看下!
- Tomcat用Linux做服务器,写文件时UTF-8和GBK的转换
- annotation hibernate pojo
- 求助,编译一SQL server服务器,出现Apache Tomcat/4.0.6 - HTTP Status 500 - Internal Server Error,具体如下,高手帮忙啊~
- 我怎么不能对tomcat4.0.4进行管理?
- 在线等待...如何利用applet读取客户端用户的登陆帐号?
- Servlet的运行目录的问题,请进来看,解决问题者高分相送,进来看
- 请问这个网站的登陆框是怎么做的阿?请教高手!!!!
- applet在ie6.0客户端运行的问题
at java.sql.DriverManager.getConnection(DriverManager.java:171)
需要数据驱动支持 实际上就是数据库的接口调用
没有合适的驱动No suitable driver估计是找不到驱动程序把驱动程序*.jar文件放到web-inf/lib里面重起服务器