servlet连接数据库

2003-07-16 03:19:05 109 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

我在servlet连接oracle数据库,连不上,错误是找不到驱动
但在javabean里连没问题,然后servlet调用bean连数据库
还是报找不到驱动
如何解决?

oracledriver 已在classpath里设置了

...全文

Truncated SVD for faster dection Truncated SVD方法最先被提出在《Fast R-CNN》论文中，用于降低全连接层的运算量，提升模型的速度。在卷积神经网络的分类任务中，FC层的运算速度远远大于CONV层，而在Fast R-CNN的目标检测任务中，大多数的运算时间发生在FC 的运算中，是因为针对每张输入图片，只进行一次卷积操作，而要对生成的Region Proposal，大致两千个，进行全连接操作进行分类与Bounding... 阅读详情

inti

Web 开发 81,108 成员 341,721 内容

+ 关注 + 加入社区

切换为时间正序

inti 2003-07-17

打赏
举报

自己up

inti 2003-07-16

打赏
举报

不好意思上面的错了
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class test2 extends HttpServlet {

private Connection c;
public void doPost(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException{

response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<title>Example</title>" +
"<body bgcolor=FFFFFF>");

out.println("<h2>Button Clicked</h2>");

String text = request.getParameter("data");

if(text != null){
out.println("<STRONG>Text from :</STRONG>");
out.println(text);
} else {
out.println("No text entered.");
}

try{
Class.forName("oracle.jdbc.driver.OracleDriver");
c=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:oradb","scott","tiger");
} catch (java.sql.SQLException e) {
out.println("connect error "+e);

}catch (java.lang.ClassNotFoundException e) {
out.println("driver not found");
System.out.println("driver "+e);
}

try{
Statement stmt = c.createStatement();
String updateString = "insert into test values('"+ text +"')";
int count = stmt.executeUpdate(updateString);

ResultSet rs = stmt.executeQuery( "select text from test");
while(rs.next()){
String s = rs.getString("t");
out.println("<BR> <STRONG>Text from database:</STRONG>");
out.println(s);
}
rs.close();
stmt.close();
c.close();

}catch(java.sql.SQLException e){
System.out.println(e.toString());
}

out.println("<P>Return to <A HREF=../servlet/simple.html>Form</A>");
out.close();
}
}

inti 2003-07-16

打赏
举报

快晕死了
代码:

import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class test2 extends HttpServlet {

public void doPost(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException{

response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<title>Example</title>" +
"<body bgcolor=FFFFFF>");

out.println("<h2>Button Clicked</h2>");

String text = request.getParameter("data");

if(text != null){
out.println("<STRONG>Text from :</STRONG>");
out.println(text);
} else {
out.println("No text entered.");
}

try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection c=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:oradb","scott","tiger");
} catch (java.sql.SQLException e) {
out.println("connect error "+e);

}catch (java.lang.ClassNotFoundException e) {
out.println("driver not found");
System.out.println("driver "+e);
}

try{
Statement stmt = c.createStatement();
String updateString = "insert into test values('"+ text +"')";
int count = stmt.executeUpdate(updateString);

ResultSet results = stmt.executeQuery( "select t from test");
while(results.next()){
String s = results.getString("t");
out.println("<BR> <STRONG>Text from database:</STRONG>");
out.println(s);
}
rs.close();
stmt.close();
c.close();

}catch(java.sql.SQLException e){
System.out.println(e.toString());
}

out.println("<P>Return to <A HREF=../servlet/simple.html>Form</A>");
out.close();
}
}

classpath已设置了,试了几种方法都是出找不到驱动的错误

WAPQQ 2003-07-16

打赏
举报

设置CLASSPATH

cyicecream 2003-07-16

打赏
举报

给出你的代码，代码有错误的地方

inti 2003-07-16

打赏
举报

to 楼上: 不行
启动tomcat时报了一堆错
WebappClassLoader: Additional JARs have been added
Apache Tomcat/4.0.1
java.util.zip.ZipException: error in opening zip file
at java.util.zip.ZipFile.open(Native Method)
at java.util.zip.ZipFile.<init>(ZipFile.java:112)
at java.util.jar.JarFile.<init>(JarFile.java:117)
at java.util.jar.JarFile.<init>(JarFile.java:82)

mingjob 2003-07-16

打赏
举报

把你的oracle jdbc driver的zip包后缀改成jar，放到你的WEB-INF\lib下去试试

warwolf 2003-07-16

打赏
举报

把代码写出来看看才知道究竟哪里问题啊

servlet连接数据库

相关推荐