Tomcat不稳定,求教高手!
javabean源代码如下:
package conn_go;
import java.sql.*;
public class conn_asa{
String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr="jdbc:odbc:court";
Connection conn=null;
ResultSet rs=null;
Statement stmt;
public conn_asa(){
try{
Class.forName(sDBDriver);
conn=DriverManager.getConnection(sConnStr,"DBA","sql");
stmt=conn.createStatement();
}
catch(java.lang.ClassNotFoundException e){
System.err.println("faq():"+e.getMessage());
}
catch(java.sql.SQLException e1){
System.err.println("faq():"+e1.getMessage());
}
}
public ResultSet executeQuery(String sql){
rs=null;
try{
conn=DriverManager.getConnection(sConnStr,"DBA","sql");
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
public static void closeConnection(Connection conn,Statement stmt,ResultSet rs) throws SQLException{
if(rs!=null)rs.close();
if(stmt!=null)stmt.close();
if(conn!=null)conn.close();
}
}
在jsp中调用:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="justDo" scope="page" class="conn_go.conn_asa"/>
<html>
<title>test</title>
<body>
<%
ResultSet Rs=justDo.executeQuery("select * from MSPT");
String strTemp;
//while(Rs.next()){
// strTemp=Rs.getString(1);
// out.print(strTemp);
//}
//Rs.close();
closeConnection;
%>
</body>
</html>
现在允许不稳定有时候正常,有时候刷新会提示错误:
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 7 in the jsp file: /index_index.jsp
Generated servlet error:
Syntax error, insert "AssignmentOperator ArrayInitializer" to complete Expression
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:328)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:397)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:288)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:267)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:255)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:556)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:293)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
为什么呢?
javabean已经编译并放置好了.
时好时坏.请大家帮忙看看
谢谢!