jsp连接mssql数据库时，出现错误（Generated servlet error:rs cannot be resolved）帮忙啊

<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.sql.*"%>
<html>
<head>
<title>工作票数据查看</title>
</head>
<body bgcolor="#ffffff">
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
< th>工作票编号</th><th>工作票的类型</th><th>工作票起草时间< /th><th>起草人</th><th>签发人</th><th>工作票当前的状态</th><th>工作任务</th><th>变电站名称</th>
</tr>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pxxx";
//test为你的数据库名，127.0.0.1为本机ip地址
String user="sa";
String password="123";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
String sql="select * from WorkTicketInfo";
try{
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) { %>
<tr>
<td>
<%=rs.getString("TicketNum")%>
</td>
<td>
<%=rs.getString("TicketType")%>
</td>
<td>
<%=rs.getString("DateTime_Draft")%>
</td>
<td>
<%=rs.getString("DraftPerson")%>
</td>
<td>
<%=rs.getString("SignPerson")%>
</td>
<td>
<%=rs.getString("TicketState")%>
</td>
<td>
<%=rs.getString("WorkTask")%>
</td>
<td>
<%=rs.getString("StationName")%>
</td>
</tr>
<%}%>
</table>
<%
rs.close();
stmt.close();
conn.close();
}catch(Exception e){
System.out.println(e);
}finally{
System.out.println("haha");
}
%></body>
</html>