servlet连接数据库

inti 2003-07-16 03:19:05

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

oracledriver 已在classpath里设置了

...全文

71 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

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)