用JSP连接ORACLE的时候,页面显示类找不到SQL异常,我不知道该怎么配置,需要把CLASSES12.JAR放在什么位置,怎么设置。代码如下:
Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("Oracle.jdbc.driver.OracleDriver");
}
catch(ClassNotFoundException e)
{
out.print("类找不到");
}
Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("Oracle.jdbc.driver.OracleDriver");
}
catch(ClassNotFoundException e)
{
out.print("类找不到");
}
2、把classes12.jar文件拷到[tomcat_home]下面的common\lib\下
Class.forName("oracle.jdbc.driver.OracleDriver");Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:mysid","system","manager");//mysid数据库
//system,manager 用户名,密码
2、把classes12.jar(或classes12.zip)文件拷到[tomcat_home]下面的common\lib\下然后:
Class.forName("oracle.jdbc.driver.OracleDriver");
注意你的串为:"Oracle.jdbc.driver.OracleDriver" 大小写有错误!
oracle -> Oracle