servlet查询代码如下
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
ServletOutputStream out=response.getOutputStream();
String stnm=request.getParameter("stnm");
try {
Statement stat = conn.createStatement();
ResultSet rs = stat.executeQuery("select * from qstation where stnm ='"+stnm+"'");
while (rs.next()) {
ResultSetMetaData rsmd1 = rs.getMetaData();
int count = rsmd1.getColumnCount();
String all="";
for (int i =1; i < count+1; i++) {
all=all+rs.getString(i)+",";
}
System.out.println(all);
out.println(all);
}
} catch (Exception e) {
// TODO: handle exception
}
}
system.out.println打印的消息是：
58238,320101,null,060602,南京,11880.0,3200.0,1,125.0,null,苏,南京市,南京市辖区,长江流域,中下游区,长江下游,101190101,华东电网,江苏,1,01,01,2,2,1,220101,
但是前台页面只显示：58238,320101,null,060602,
请问这是什么问题？
package com.rss.web;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class TestServlet extends HttpServlet{
/**
*
*/
private static final long serialVersionUID = 1L;
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
resp.setContentType("text/html");
String all="58238,320101,null,060602,南京,11880.0,3200.0,1,125.0,null,苏,南京市,南京市辖区,长江流域,中下游区,长江下游,101190101,华东电网,江苏,1,01,01,2,2,1,220101,";
System.out.println(all);
req.setAttribute("testServlet", all);
req.getRequestDispatcher("/testServlet.jsp").forward(req, resp);
}
}
web.xml
testServlet
com.rss.web.TestServlet
testServlet
/test.do
test.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
页面结果
哎，，这网站居然把XML和HTML标签屏蔽了 你把servlet按上边的写 页面输出下'${testServlet }'就有结果，绝对没问题，
<servlet>
<servlet-name>testServlet</servlet-name>
<servlet-class>com.rss.web.TestServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>testServlet</servlet-name>
<url-pattern>/test.do</url-pattern>
</servlet-mapping>
```<%@ page language="java" contentType="text/html; charset=UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'testServlet.jsp' starting page</title>
</head>
<script src="js/jquery-1.7.1.js"></script>
<body>
'${testServlet }'
</body>
</html>