存储过程调用报错

[baibinbin]

我要在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 JSP

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 : 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
初学，不知道哪里的问题

[huataixiang19810225]

在你的jsp中加入
import java.sql.*;
import javax.naming.*;
import javax.sql.*;

找不到DriverManager 等

[huataixiang19810225]

<%@ page import="java.sql.*" %>
<%@ page import="javax.naming.*"%>
<%@ page import="javax.sql.*"%>

[rongdajian]

同意楼上的兄弟的说法！