错误信息：org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 47 in the jsp file: /check.jsp
rs cannot be resolved
44:
45: finally{
46: try{
47: rs.close() ;
48: pstmt.close() ;
49: conn.close() ;
50: }catch(Exception e){}
An error occurred at line: 150 in the generated java file
Syntax error, insert "}" to complete BlockAn error occurred at line: 160 in the generated java file
Syntax error on token "}", delete this tokenAn error occurred at line: 161 in the generated java file
Syntax error, insert "}" to complete ClassBody代码：<%@ page contentType="text/html" pageEncoding="GBK"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%><html>
<head><title>注册检测</title></head><jsp:useBean id="reg" scope="request" class="gg.Register"/>
<jsp:setProperty name="reg" property="*"/>
<body>
<%! // 定义若干个数据库的连接常量
public static final String DBDRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver" ;
public static final String DBURL = "jdbc:sqlserver://localhost:1433;database=login" ;
public static final String DBUSER = "sa" ;
public static final String DBPASS = "tan111000" ;
Connection conn = null ; // 数据库连接
PreparedStatement pstmt = null ; // 数据库预处理操作
%>
request.setCharacterEncoding("gbk") ;
<%
String username = request.getParameter("name");
String name = request.getParameter("age");
String password = request.getParameter("password");
%>
<%
try{
%>
<%
Class.forName(DBDRIVER) ;
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS) ;
String sql = "insert into login(username,name,password) values('"+username+"','"+name+"','"+password+"')";
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
%>
}
<%
}catch(Exception e){}
finally{
try{
rs.close() ;
pstmt.close() ;
conn.close() ;
}catch(Exception e){}
if(reg.isValidate()){
%>
<jsp:forward page="success.jsp"/>
<%
} else {
%>
<jsp:forward page="zhuce.jsp"/>
<%
}
%>
</body>
</html>
rs cannot be resolved
44:
45: finally{
46: try{
47: rs.close() ;
48: pstmt.close() ;
49: conn.close() ;
50: }catch(Exception e){}
An error occurred at line: 150 in the generated java file
Syntax error, insert "}" to complete BlockAn error occurred at line: 160 in the generated java file
Syntax error on token "}", delete this tokenAn error occurred at line: 161 in the generated java file
Syntax error, insert "}" to complete ClassBody代码：<%@ page contentType="text/html" pageEncoding="GBK"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%><html>
<head><title>注册检测</title></head><jsp:useBean id="reg" scope="request" class="gg.Register"/>
<jsp:setProperty name="reg" property="*"/>
<body>
<%! // 定义若干个数据库的连接常量
public static final String DBDRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver" ;
public static final String DBURL = "jdbc:sqlserver://localhost:1433;database=login" ;
public static final String DBUSER = "sa" ;
public static final String DBPASS = "tan111000" ;
Connection conn = null ; // 数据库连接
PreparedStatement pstmt = null ; // 数据库预处理操作
%>
request.setCharacterEncoding("gbk") ;
<%
String username = request.getParameter("name");
String name = request.getParameter("age");
String password = request.getParameter("password");
%>
<%
try{
%>
<%
Class.forName(DBDRIVER) ;
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS) ;
String sql = "insert into login(username,name,password) values('"+username+"','"+name+"','"+password+"')";
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
%>
}
<%
}catch(Exception e){}
finally{
try{
rs.close() ;
pstmt.close() ;
conn.close() ;
}catch(Exception e){}
if(reg.isValidate()){
%>
<jsp:forward page="success.jsp"/>
<%
} else {
%>
<jsp:forward page="zhuce.jsp"/>
<%
}
%>
</body>
</html>
解决方案 »
- Spring security 问题 所有的访问页面都被拦截了！不管有没有权限！
- 取得ServletContext
- JS 赋给TD 属性问题 来高手帮忙~~
- javaMail中文API文档（谁有，给一个中文的）
- javascript使叶面后退到前一个页面，请问大家怎样写？
- 在ORACLE数据库中，建了一张视图，如何向这张视图里面插入值？
- 怎么用java的正则表达式排除网页中的<head></head>之间的内容？
- 哪位高手帮忙解决这样的问题？
- classpath具体怎么设置呢？谢谢！
- Spring+Mybatis 事务管理不回滚的问题
- 大神求帮忙
- 急需解决，ArcGIS Server JavaScript的问题
Syntax error, insert "}"
try{
rs.close() ;
pstmt.close() ;
conn.close() ;
}catch(Exception e){}
if(reg.isValidate()){
%>
<jsp:forward page="success.jsp"/><%
} else {
%>
<jsp:forward page="zhuce.jsp"/>
<%
}
这一段的finally少了结束的"}".
插入操作也不用ResultSet，既然没有定义更不用提关闭了，所以出错呗
try{
rs.close() ; 《-----------------this，删
pstmt.close() ;
conn.close() ;
}catch(Exception e){}