loadcart.java

用最近的dojo1.2.1制作前端的ajax购书网站

package server.servlet;

import java.io.*;
import javax.servlet.ServletException;
import server.servlet.OperateCookie.OperateCookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import server.consumer.*;
import java.util.*;
import javax.servlet.http.Cookie;
import server.database.*;
import java.sql.*;
import server.books.MyBookClass;
import changeToJson.ToJson;

/**
 * @version 	1.0
 * @author
 */
public class LoadCart extends HttpServlet{

	/**
	* @see javax.servlet.http.HttpServlet#void (javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	*/
	private HashMap[] Cartbook;
	public void doGet(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException {
			resp.setHeader("Cache-Control","no-cache");
			PrintWriter out=resp.getWriter();
			Operation op = new Operation();
			//StringBuffer str=returndata(req);
			//out.print(str);
			resp.setContentType("text/html");
			String wCart = req.getParameter("op");
			System.out.println(wCart);
			if(wCart.equals("loadCart")){
				String userID = req.getParameter("userID");
				Vector ids = new Vector();
				String sql = "select id from Cart where userID='"+userID+"'";
				try{
					System.out.println("1");
					ResultSet CartBookid = op.select(sql);
					System.out.println("2");
					int count = 0;
					while(CartBookid.next()){
						count = count+1;
						ids.add(CartBookid.getString("id"));
						System.out.println("2.5");
						System.out.println(count+":"+CartBookid.getString("id"));
						
					}
					Object[] Id = ids.toArray();
					//System.out.println("count:"+count);
					Cartbook = new HashMap[count];
					CartBookid.first();//返回到第一项
					CartBookid.previous();
					//System.out.println(CartBookid.getString("id"));
					//int i = 0;
					ResultSet info;
					String sql_Bookinfo;
					for(int i = 0; i < Id.length; ++i){
						//String id = CartBookid.getString("id");
						sql_Bookinfo = "select * from Book where id='"+Id[i]+"'";
						System.out.println(Id[i]);
						//Operation newOP = new Operation();
						System.out.println("3");
						info = op.select(sql_Bookinfo);
						System.out.println("4");
						info.next();//id唯一，故应该只有一条信息
						HashMap temp = new HashMap();
						for(int j = 0; j<MyBookClass.getPropertySize(); ++j){
							temp.put(MyBookClass.property[j],info.getString(MyBookClass.property[j]));
						}
						Cartbook[i] = temp;
						//newOP.closeResultSet();
						//newOP.closeConnection();
					}
				}
				catch(ClassNotFoundException e){}
				catch(SQLException e){}
				catch(InstantiationException e){}
				catch(IllegalAccessException e){}
				String Json = ToJson.toJson(Cartbook);
				out.print(Json);
				System.out.println(Json);
			}	

	}

	/**
	* @see javax.servlet.http.HttpServlet#void (javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	*/
	public void doPost(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException {
			doGet(req,resp);
	}

}