我要在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
初学,不知道哪里的问题
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
初学,不知道哪里的问题
import java.sql.*;
import javax.naming.*;
import javax.sql.*;找不到DriverManager 等
<%@ page import="javax.naming.*"%>
<%@ page import="javax.sql.*"%>