jsp连mysql上的困惑
小弟刚开始学习Jsp不久,在连mysql数据库时遇到太多问题了,望大家能帮帮我.
调用几次连接Mysql数据库javabean类后,出现无法得到正确的查询数据集
(index.jsp代码)
<jsp:useBean id= "mysql " scope= "page " class= "myblog.MyDataSource "> </jsp:useBean>
<%
String sql= "select * from myblog ";
String ID=null;
ResultSet rs =mysql.query(sql);
rs.previous();
int i=1;
while(rs.next())
{
%>
<tr>
<td width= "16 " height= "20 "> <%=i%> </td>
<td width= "371 "> <a href= "Showblog.jsp?ID= <%=rs.getString(1)%> "> <%=rs.getString(3)%> </a> </td>
<td width= "77 "> <%=rs.getString(2)%> </td>
</tr>
<%
i++;
}
mysql.closestmt();
mysql.closeconn();
mysql.closers();
rs.close();
%>
这个是我第一次连数据库,查询myblog表里的所有数据,并通过超连接传递参数ID在showblog.jsp里显示所点击的数据
(showblog.jsp代码)
<jsp:useBean id= "mysql " scope= "page " class= "myblog.MyDataSource "> </jsp:useBean>
<% String ID=null;
String time=null;
ID=request.getParameter( "ID ");
String sql= "select * from myblog where msgID= ' "+ID+ " ' ";
ResultSet rs =mysql.query(sql);
rs.previous();
if(rs!=null)
{%>
<%=rs.getString( "msgID ")%>
<%
return;
}
%>
通过以上语句理论上应该是输出msgID的值,rs数据集不为空
但却出现以下错误
org.apache.jasper.JasperException: Exception in JSP: /Showblog.jsp:85
82: rs.previous();
83: