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;
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;Da2tabaseName=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("<h2 align='center'>" + "搜索结果" + "</h2>");
out.println("<html>");
out.println("<head><title>商品搜索结果</title></head>");
out.println("<body>");
con = DriverManager.getConnection(url, "sa", "");
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
String s = rs.getString("id");
String t = rs.getString("name");
String f = rs.getString("price");
out.println(s + " " + t + " " + f);
}
stmt.close();
con.close();
//out.println("<P>"+ indata + "</P>");
out.println("</body></html>");
out.close();
}
catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
}
}
