Connection conn = ds.getConnection();
Statement st = conn.createStatement();
String sqlStr = "select * from cat";
ResultSet rs = st.executeQuery(sqlStr);
while ( rs.next() ) {
out.println(rs.getString("categoryName")+"<br>");
}
rs.close();
st.close();
conn.close();
%>
5.3、servlet的配置测试
5.3.1编写并编译如下的简单servlet
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class HelloWorld extends HttpServlet {
public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("");
out.println("Hello World");
}
}
5.3.2在test.war文件夹下建立一个WEB-INF目录，里面再建立一个classes目录和web.xml文件目录结构如下：
[test.war]
[WEB-INF]
[classes]
web.xml
将编译成功的HelloWorld.class放置到classes目录下，web.xml内容如下：
<?xml version="1.0"?>
<!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
<servlet>
<servlet-name>HelloWorld</servlet-name>
<servlet-class>HelloWorld</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>HelloWorld</servlet-name>
<url-pattern>/HelloWorld</url-pattern>
</servlet-mapping>
</web-app>
通过调用http://localhost:8080/test/HelloWorld 就可以看到hello world的输出
共2页 1 2
