jsp，rs cannot be resolved
<html><head><scriptsrc="selectUserPhoto.js"></script><title></title></head><body><%@p...
<html>
<head>
<script src="selectUserPhoto.js"></script>
<title></title>
</head>
<body>
<%@page contentType = "text/html;charset=Big5" import = "java.sql.*" %>
<%
String pos_name = request.getParameter("pos");
if(pos_name.equals("all")){
response.sendRedirect("admin.jsp");
}
else{
Class.forName("com.mysql.jdbc.Driver");
Connection con =
DriverManager.getConnection("jdbc:mysql://localhost:3306/recruit", "root",
"bb201751");
Statement smt = con.createStatement();
String sql = "select * from user where position_applied ='" + pos_name + "'";
ResultSet rs = smt.executeQuery(sql);}
%>
<table style="border : solid 1px yellow">
<font size="5">
<tr><th>User Id</th><th>User Name</th><th>Position applied</th><th>Status</th><th>Profile</th></tr>
<%
while(rs.next())
{
out.println("<tr><td>" + rs.getString(1) + "</td>");
out.println("<td>" + rs.getString(2) + "</td>");
out.println("<td>" + rs.getString(11) + "</td>");
out.println("<td>" + "<select name='status' onchange='update(this.value)'><option value = 'no signed'>no signed "+
"<option value = 'approve'>approve <option value = 'failed'>failed"+"</select></td>");
out.println("<td><input type=button value=Profile onClick=display_profile('" + rs.getString(1) + "') ></td></tr>");
}
con.close();
%>
</table>
</body>
</html>
老报错rs cannot be resolved，求大神指教 展开
<head>
<script src="selectUserPhoto.js"></script>
<title></title>
</head>
<body>
<%@page contentType = "text/html;charset=Big5" import = "java.sql.*" %>
<%
String pos_name = request.getParameter("pos");
if(pos_name.equals("all")){
response.sendRedirect("admin.jsp");
}
else{
Class.forName("com.mysql.jdbc.Driver");
Connection con =
DriverManager.getConnection("jdbc:mysql://localhost:3306/recruit", "root",
"bb201751");
Statement smt = con.createStatement();
String sql = "select * from user where position_applied ='" + pos_name + "'";
ResultSet rs = smt.executeQuery(sql);}
%>
<table style="border : solid 1px yellow">
<font size="5">
<tr><th>User Id</th><th>User Name</th><th>Position applied</th><th>Status</th><th>Profile</th></tr>
<%
while(rs.next())
{
out.println("<tr><td>" + rs.getString(1) + "</td>");
out.println("<td>" + rs.getString(2) + "</td>");
out.println("<td>" + rs.getString(11) + "</td>");
out.println("<td>" + "<select name='status' onchange='update(this.value)'><option value = 'no signed'>no signed "+
"<option value = 'approve'>approve <option value = 'failed'>failed"+"</select></td>");
out.println("<td><input type=button value=Profile onClick=display_profile('" + rs.getString(1) + "') ></td></tr>");
}
con.close();
%>
</table>
</body>
</html>
老报错rs cannot be resolved，求大神指教 展开
1个回答
2015-12-02 · 做真实的自己 用良心做教育
千锋教育
千锋教育专注HTML5大前端、JavaEE、Python、人工智能、UI＆UE、云计算、全栈软件测试、大数据、物联网+嵌入式、Unity游戏开发、网络安全、互联网营销、Go语言等培训教育。
向TA提问
关注
![]()
展开全部
你的这个rs变量实在if/else语句块中，到你下面遍历rs的时候你的rs变量是不可见的，你可以把rs设置为全局变量
追问
怎么改。。。是开头加个ResultSet rs =null;吗？
追答
嗯，把rs的定义提出来放到开头就OK了
本回答被提问者采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
