如何解决?The requested resource () is not availab servlet连接数据库就会出现
出现如下故障如何解决?
文件:
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.