Operate 类
package org.wdj.bean;import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;import javax.naming.InitialContext;
import javax.sql.DataSource;public class Operate {
private Connection con=null;
private Statement stmt=null;
public Operate(){
try {
javax.naming.Context initCtx=new InitialContext();
con=((DataSource)initCtx.lookup("java:comp/env/jdbc/test")).getConnection();
} catch (Exception e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
public ResultSet getRS(String sql)throws Exception{
stmt=con.createStatement();
return stmt.executeQuery(sql);
}
public boolean close()throws Exception{
boolean flag=true;
try{
con.close();
stmt.close();
}
catch(Exception e){
flag=false;
}
return flag;
}
}
MyJsp.jsp页
<%
Operate op=new Operate();
java.sql.ResultSet rs=op.getRS("select * from test");
while(rs.next()){
out.println(rs.getString("username"));
out.println("<br>");
}
if(op.close()){
out.println("true");
%>出现错误提示是:
description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSP:
package org.wdj.bean;import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;import javax.naming.InitialContext;
import javax.sql.DataSource;public class Operate {
private Connection con=null;
private Statement stmt=null;
public Operate(){
try {
javax.naming.Context initCtx=new InitialContext();
con=((DataSource)initCtx.lookup("java:comp/env/jdbc/test")).getConnection();
} catch (Exception e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
public ResultSet getRS(String sql)throws Exception{
stmt=con.createStatement();
return stmt.executeQuery(sql);
}
public boolean close()throws Exception{
boolean flag=true;
try{
con.close();
stmt.close();
}
catch(Exception e){
flag=false;
}
return flag;
}
}
MyJsp.jsp页
<%
Operate op=new Operate();
java.sql.ResultSet rs=op.getRS("select * from test");
while(rs.next()){
out.println(rs.getString("username"));
out.println("<br>");
}
if(op.close()){
out.println("true");
%>出现错误提示是:
description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSP:
<jsp:useBean id="xxx" scope="page" class="class文件的路径" />