运行异常，求解。

zhao_1128 2009-06-10 02:13:54

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.zhao.*" %>
<jsp:useBean id="DbBean" scope="session" class="com.zhao.XO"/>
<%
try{
String sql;
sql = "SELECT count(*) as num FROM XO";
ResultSet rs = DbBean.executeQuery(sql);
%>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>Untitled Document</title>
</head>

<body>

<table width=400 border="1" cellspacing="1" align=center>

<tr bgcolor="#6681D9">
<td height=20 colspan=7>
<div align="center"><b><font color="#ffffff">表的增删改</font></b></div>
</td>
</tr>

<tr height="20">
<td width="87" height="28" bgcolor="#d9e0f9" align="center">姓名</td>
<td width="87" bgcolor="#d9e0f9" align="center">工资</td>
<td width="87" bgcolor="#d9e0f9" align="center">部门</td>
<td valign="top" bgcolor="#d9e0f9" align="center" colspan="4">操作</td>
</tr>
<%
int pagesize=8;
int pagecount=0;
int count=0;
int currentpage=0;
if (rs.next()) {
count = rs.getInt("num");
float f = (float) count / (float) pagesize;
int pages = (int) (count / pagesize);
if (f > pages) pages++;
pagecount = pages ;
}
if(request.getParameter("page")!=null){//假如接收的页面数不为空
currentpage = java.lang.Integer.parseInt(request.getParameter("page"));//就把接收的页面数pagg赋值给gopage
}else{//否则
currentpage=1;//gopage为1，即显示第一页
}

//分页查询

sql = "select * from XO where id between 1 and 160";
// System.out.println(sql);
rs = DbBean.executeQuery(sql);
while(rs.next()){
String id=rs.getString("id");
String xm2=rs.getString("xm");
String gz=rs.getString("gz");
String bm=rs.getString("bm");
%>
<tr>
<td height="20" align="center"><%=xm2 %></td>
<td align="center"><%=gz %></td>
<td align="center"><%=bm %></td>
<td width="53" align="center"><a href="edit.jsp?id=<%=id %>">修改</a></td>
<td align="center" colspan="3"><a href="del.jsp?id=<%=id %>">删除</a></td>
</tr>
<%}
rs.close();
%>
<tr>
<td valign="middle" height="28" align="right" colspan="7"><a href="add.jsp">新增</a></td>

</tr>

</table>
<form action="index.jsp" method="post"><br><br></form>

<table width="300" height="22" border="1" align="center" cellspacing="1" >


<%}catch(Exception e){
out.print("<center>DbBean.executeQuery(sql)</center>");
}
%>

</table>
</body>

</html>

运行结果：
aq.executeQuery: The url cannot be null

...全文

33 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

sangshusen_1988 2009-06-10

打赏
举报

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
会不会是errorPage的关系？？我刚才试了下，没出现效果，不过楼主既然肯定别的
都正确，可以试下咯！