我要在jsp中调用存储过程,下面是我的代码为什么报错啊
  String url= "jdbc:oracle:thin:@192.168.3.152:1521:testdb";
   Class.forName("oracle.jdbc.driver.OracleDriver");
   Connection conn = DriverManager.getConnection(url,"system","system");
 //  Connection conn = confun.getConn();
    CallableStatement proc = conn.prepareCall("{call test(?)}");
    proc.registerOutParameter(1,java.sql.Types.INTEGER);
    proc.executeQuery();
    int sum = proc.getInt(1);
存储过程
create or replace procedure test(total out integer) is
begin
  select count(*) into total from d_sjpc_gt01;
end test;报的错误
org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 9 in the jsp file: /sjpc/tongji01_result.jsp
Generated servlet error:
D:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\sjpc\tongji01_005fresult_jsp.java:63: cannot resolve symbol
symbol  : class Connection 
location: class org.apache.jsp.sjpc.tongji01_005fresult_jsp
   Connection conn = DriverManager.getConnection(url,"system","system");
   ^
An error occurred at line: 9 in the jsp file: /sjpc/tongji01_result.jsp
Generated servlet error:
D:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\sjpc\tongji01_005fresult_jsp.java:63: cannot resolve symbol
symbol  : variable DriverManager 
location: class org.apache.jsp.sjpc.tongji01_005fresult_jsp
   Connection conn = DriverManager.getConnection(url,"system","system");
                     ^
An error occurred at line: 9 in the jsp file: /sjpc/tongji01_result.jsp
Generated servlet error:
D:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\sjpc\tongji01_005fresult_jsp.java:65: cannot resolve symbol
symbol  : class CallableStatement 
location: class org.apache.jsp.sjpc.tongji01_005fresult_jsp
    CallableStatement proc = conn.prepareCall("{call test(?)}");
    ^
3 errors
初学,不知道哪里的问题