如何解决？The requested resource () is not availab servlet连接数据库就会出现

pro_yy 2010-01-07 08:23:47

出现如下故障如何解决？
文件：
package servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class ConnSql extends HttpServlet {

public ConnSql() {
super();
}

public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}

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

response.setCharacterEncoding("GBK");

response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.print("所有用户的信息为<br />");

Connection conn = null;
Statement stm = null;
ResultSet rs = null;
String connStr = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=siaswushu";

try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

}catch(ClassNotFoundException e){
e.printStackTrace();
}

try {
conn = DriverManager.getConnection(connStr,"sa","sa");
stm = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stm.executeQuery("select * from userinfo");

while(rs.next()){
out.print("用户名: " + rs.getString("name") + "------密码: " + rs.getString("pwd") + "<br />");
}

rs.close();
stm.close();
conn.close();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}

out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doGet(request, response);
}

public void init() throws ServletException {
// Put your code here
}

}

运行servlet文件时：
Status 404

type Status report

message /ProjectABC/servlet/servlet.LoginServlet

description The requested resource (/ProjectABC/servlet/servlet.LoginServlet) is not available.

...全文

970 11 打赏收藏转发到动态举报

写回复

用AI写文章

11 条回复

切换为时间正序

请发表友善的回复…

发表回复

LaughingDi 2011-06-19

打赏
举报

debug出现情况：
在public class ConnSql extends HttpServlet 设置断点出现
calss<T>.getDeclaredConstructor0(boolean) line:not available
**********************
calss<T>.getDeclaredConstructor0(boolean) line:not available
请教，这个是由于什么原因引起的啊？
我的程序也出现这个

pro_yy 2010-01-11

打赏
举报

以解决，谢谢

hongjn 2010-01-09

打赏
举报

为什么要在servlet写HTML呢

没耐心看

帮顶

pro_yy 2010-01-09

打赏
举报

进入servlet 是用doget 还是dopost？

crazylaa 2010-01-08

打赏
举报

404路径错误，你看看到底有没有进入这个servlet的doGet方法啊？

pro_yy 2010-01-07

打赏
举报

debug出现情况：
在public class ConnSql extends HttpServlet 设置断点出现
calss<T>.getDeclaredConstructor0(boolean) line:not available

阿_布 2010-01-07

打赏
举报

图片没显示

pro_yy 2010-01-07

打赏
举报

debug出现以上情况，请各位帮帮忙解答，谢谢

阿_布 2010-01-07

打赏
举报

404
你的访问路径错误。

pro_yy 2010-01-07

打赏
举报

没法连接，不知道是不是少了什么东西？用单独的jsp文件能直接访问数据库，但是这个servlet就不行

阿_布 2010-01-07

打赏
举报

response.setContentType("text/html;charset=gbk");
打印一下看能不能取到数据
while(rs.next()){
System.out.println("用户名: " + rs.getString("name") + "------密码: " + rs.getString("pwd") + " <br />");
}