showsort.java

网上商城

package store;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class ShowSort extends HttpServlet {
  public void doGet(HttpServletRequest request,
                     HttpServletResponse response)
       throws IOException, ServletException
   {
     response.setContentType("text/html;charset=gbk");
     PrintWriter out = response.getWriter();
     try{
       DBConn conn =new DBConn();
       String sql="SELECT * FROM sorts";
       ResultSet rs=conn.query(sql);
       out.print("<SELECT name='sort'>");
       out.print("<option value='1'>请选择商品分类");
       while(rs.next()){
        out.print("<option value='"+rs.getInt("id")+"'>"+rs.getString("sortname"));
       }
       out.print("</SELECT>");
       rs.close();
       conn.DBclose();
     }
     catch(Exception e){
      out.print("无任何分类");
     }
   }
      public void doPost(HttpServletRequest request,
                        HttpServletResponse response)
          throws IOException, ServletException
      {
        doGet(request,response);
      }
     public void destroy()
      {
      }
}