初学者问jsp+servlet问题,谢谢了,急
AI牛 2004-01-08 11:12:43 我用JBuilder+tomcat ,我在一个工程里面写了一个jsp 和一个servlet,我想在Jsp 里做一个链接,来调用该servlet,
jsp程序如下:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page errorPage="index_error.jsp" %>
<%@ page import="java.*"%>
<html>
<head>
<title>
welcome !
</title>
</head>
<body bgcolor="#fffff0">
<center>
<h1>
welcome to here!
</h1>
</center>
<a href="DataServlet"> view the Orders-list</a>
</body>
</html>
Servlet 程序如下:
package testpro;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
import javax.sql.*;
public class DataServlet extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GBK";
//Initialize global variables
public void init() throws ServletException {
}
//Process the HTTP Get request
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://180.9.0.126:1433;DataBaseName=Northwind";
try{
Class.forName(driver);
Class.forName(driver);
Connection conn=DriverManager.getConnection(url,"sa","");
Statement stmt=conn.createStatement();
String query="select * from Orders";
ResultSet rs=stmt.executeQuery(query);
request.setAttribute("rs",rs);
getServletContext().getRequestDispatcher("/DataJsp.jsp").forward(request,response);
}
catch(Exception e){
System.out.println(e.getMessage());
}
}
//Clean up resources
public void destroy() {
}
}
当我点击连接时,报错为: URL: Unable to open location: Document not found on server
怎么办啊 ?
麻烦高手指点一下,小弟不胜感激!