这是我的程序
package test;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class CounterServlet extends HttpServlet
{
private static final String CONTENT_TYPE = "text/html; charset=GBK";
private String indata;
private String s, t, f;
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
/*接受客户端信息*/
response.setContentType (CONTENT_TYPE);
PrintWriter out = response.getWriter();
indata = request.getParameter("DATA");
/*与数据库连接查询*/
String url = url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=chfjava";
Connection con;
Statement stmt;
String query = "select * from shop";
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
try {
out.println("<html>");
out.println("<body>");
out.println("<head><title>商品搜索结果</title></head>");
out.println("<h2 align='center'>" + "搜索结果" + "</h2>");
out.println("<P>klfjkljkljkljkl</P>");
out.println("<P>fsjdkljfklsdjfklsd</P>");
out.println(query);
//out.println(indata);
out.println("<P>"+ indata + "</P>");
con = DriverManager.getConnection(url, "sa", "");
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
s = rs.getString("id");
t = rs.getString("name");
f = rs.getString("price");
out.println(s);
out.println(t);
out.println(f);
}
out.println("sjdklfjklsdjfkljsdklfjkljskl");
stmt.close();
con.close();
//out.println(indata);
out.println("</body>");
out.println("</html>");
out.close();
}
catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
}
}为什么我输入5sdfsdf
输出结果为
搜索结果
klfjkljkljkljkl fsjdkljfklsdjfklsd select * from shop
5sdfsdf
为什么这几句不输出啊 out.println("sjdklfjklsdjfkljsdklfjkljskl");
数据库查询后面的都没有结果,数据库查询的结果也不输出??
为什么我输入5sdfsdf
输出结果为
搜索结果
klfjkljkljkljkl fsjdkljfklsdjfklsd select * from shop
5sdfsdf
为什么这几句不输出啊 out.println("sjdklfjklsdjfkljsdklfjkljskl");
数据库查询后面的都没有结果,数据库查询的结果也不输出??
我的数据库内容为
id name price
1 chf 12
2 chfjf 15
楼主【cschf】截止到2008-06-24 14:51:39的历史汇总数据(不包括此帖):
发帖数:4 发帖分:230
结贴数:3 结贴分:190
未结数:1 未结分:40
结贴率:75.00 % 结分率:82.61 %
楼主加油
System.err.println("Exception: " + ex.getMessage());
out.println(("Exception: " + ex.getMessage() + "</html>");
out.close();
} 我觉得应该有异常
你这样写试试。看看页面上有什么?
LZ捕捉的就是SQL异常,不是没捕捉到么。
所以我让他直接捕捉基类异常不就什么都OK了么?