📄 booklistservlet.java
字号:
package sample;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.Iterator;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
public class BookListServlet extends HttpServlet
{
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
//parse request 处理请求
//String tableName=request.getParameter("tableName");
//send reponse !!!! 返回响应
request.setCharacterEncoding("gb2312");
String bidName=null; //which kind of icecream
HttpSession session=null;
ShoppingCart1 cart=null;
response.setContentType("text/html;charset=gb2312");
BookListDB cd=new BookListDB();
cd.ConnectionDB();
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>数据库中的数据</TITLE></HEAD>");
out.println(" <BODY>");
out.println("<div align=\"center\">");
out.println("<h3><b>请您选择您想购买的书:</b></h3>");
bidName=request.getParameter("toBuy");//get book id
//session is retrieved, if not exist, create a new one
session=request.getSession(true);
cart=(ShoppingCart1) session.getAttribute("cart");
if( cart==null){ //not order product, and orderlist is empty
cart=new ShoppingCart1();
session.setAttribute("cart", cart);
}
if ((bidName == null) && cart.isEmpty()) { //
out.println("<h4> <font color='red'> 您 尚 未 选 购 任 何 书 </font> </h4>");
}
if (bidName != null) { // already have order list, add the current order to the existed order list
cart.addOneProduct(new BidName(bidName));
System.out.println("bidName is" + bidName);
if(bidName.equals("101"))
{
cart.addBid101CounterCounter();
}
if(bidName.equals("102"))
{
cart.addBid102CounterCounter();
}
if(bidName.equals("103"))
{
cart.addBid103CounterCounter();
}
if(bidName.equals("104"))
{
cart.addBid104CounterCounter();
}
if(bidName.equals("105"))
{
cart.addBid105CounterCounter();
}
if(bidName.equals("106"))
{
cart.addBid106CounterCounter();
}
if(bidName.equals("107"))
{
cart.addBid107CounterCounter();
}
if(bidName.equals("108"))
{
cart.addBid108CounterCounter();
}
}
out.println(" <table width=\"600\" border='6'>");
out.println(" <tr>");
String[] columnNames=cd.getColumnNames();
for (int i=0; i <columnNames.length; i++)
{
System.out.print(columnNames[i] + "\t");
out.println(" <td>"+columnNames[i]+"</td>");
}
out.println(" </tr>");
System.out.println();
ArrayList cellList =cd.getAllData();
Iterator itall = cellList.iterator();
//String bkName=null;
String bid=null;
while(itall.hasNext())
{
out.println(" <tr>");
ArrayList row =(ArrayList)itall.next();
for (int i = 0; i < row.size(); i++) {
System.out.print(row.get(i)+ "\t");
out.println(" <td>"+row.get(i).toString()+"</td>");
// bkName=row.get(1).toString();
bid=row.get(0).toString();
//System.out.println(bid);
}
System.out.println();
out.print("<td>");
out.print("<form action='bookList' method='get' title='book form' >");
out.println("<input type='hidden' name='toBuy' value='"+bid+"'>");
out.println(" <input type='submit' value='放入购物车'> ") ;
//out.print(" 您已选购了"+bkName+": <font color='red'>" + " </font> 本");
out.println("</form> ");
out.print("</td>");
out.println(" </tr>");
}
out.println(" </table>");
out.println("</div>");
out.print(" 您已选购了Java Web编程: <font color='red'>" +cart.getBid101CounterCounter()+ " </font> 本 ");
out.print(" 您已选购了计算机网络技术: <font color='red'>" +cart.getBid102CounterCounter()+ " </font> 本 ");
out.print(" 您已选购了Java 2基础: <font color='red'>" + cart.getBid103CounterCounter()+" </font> 本 ");
out.print(" 您已选购了Java 22基础: <font color='red'>" + cart.getBid104CounterCounter()+" </font> 本 ");
out.print(" 您已选购了Java 222基础: <font color='red'>" +cart.getBid105CounterCounter()+ " </font> 本 ");
out.print(" 您已选购了Java a2基础: <font color='red'>" + cart.getBid106CounterCounter()+" </font> 本 ");
out.print(" 您已选购了Java a22基础: <font color='red'>" + cart.getBid107CounterCounter()+" </font> 本 ");
out.print(" 您已选购了Java a222基础: <font color='red'>" + cart.getBid108CounterCounter()+" </font> 本 ");
if ( !cart.isEmpty()) { //if cart is not empty, send them to client
out.println(" <font color='blue'> <h3> 您 总 共 选 了 "+ cart.total()+" 本 书</h3> ");
out.println("</font> <br>");
System.out.println( cart.total());
}
out.println ("<form action='notbuy' method='GET' title='notBuy form'> <br>");
out.println("<input type=submit value='取消购物!'> ");
out.println("</form> <br>");
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
doPost(request,response);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -