package?action;

import?java.util.List;

import?javax.servlet.http.Cookie;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

import?vo.Book;
import?base.baseAction;
import?dao.BookDao;

public?class?BookAction?extends?baseAction?{

	//?UserDao?userDao?=?null;
	public?BookAction（）?{
		//?userDao?=?new?UserDao（con）;
	}

	public?String?queryBookList（HttpServletRequest?req?HttpServletResponse?resp）?{
		String?cid?=?req.getParameter（“cid“）;
		try?{
			openCon（）;
			BookDao?bookDao?=?new?BookDao（con）;
			//設置自動提交為false
			//con.setAutoCommit（false）;
			List?list?=?bookDao.queryByCategory（Integer.parseInt（cid））;
			//手動提交事務
			//con.commit（）;
			req.setAttribute（“list“?list）;
			return?“book/bookList.jsp“;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			return?“error.jsp“;
		}?finally?{
			//關閉連接
			closeCon（）;
		}
	}
	
	
	public?String?orderGood（HttpServletRequest?req?HttpServletResponse?resp）?{
//		Map?map?=?new?HashMap（）;
		List?list=null;
		Book?book?=?new?Book（）;
		try{
		openCon（）;
		BookDao?bookDao?=?new?BookDao（con）;
		Cookie?[]?cookie?=?req.getCookies（）;
		
		for（int?i=0;i			
			if（!cookie[i].getName（）.equals（“JSESSIONID“））{
				
				book?=?bookDao.queryBook（Integer.parseInt（cookie[i].getName（）））;
				//if（book!=null）{
					//map.put（book?cookie[i].getValue（））;
					String?isbn=book.getIsbn（）;
					String?picture=book.getImageFile（）;
					String?title=book.gettitle（）;
					String?price=book.getPrice（）;
					String?num=cookie[i].getValue（）;
					System.out.print（“數量是：“+cookie[i].getValue（））;
					bookDao.orderGood（isbnpicture?price?titlenum）;
					
					System.out.print（“ddddddddddddddddddddddddddddddddddd“）;
				//}
				
				????
				
			}
			System.out.print（“gggggggggggggggggggggg“）;
		}
		list=bookDao.selectOrder（）;
		System.out.print（“yyyyyyyyyyyyyyyyyyyyy“）;
		req.setAttribute（“list“list）;
		System.out.print（“aaaaaaaaaaaaaabbbbbbbbbbbbbbbbbbbccccccccccccc“）;
		
		
		
		}catch（Exception?e）{
			e.printStackTrace（）;
			System.out.print（“chucuola“）;
			return?“error.jsp“;
		}finally{
			closeCon（）;
		}
		
		return?“book/orderBook.jsp“;
	}
	
public?void?delgood（String?isbn）
{
	try{
??openCon（）;
??BookDao?bookDao=new?BookDao（con）;
??bookDao.delgood（isbn）;
}?catch?（Exception?e）?{
	e.printStackTrace（）;
	
}?finally?{
	//關閉連接
	closeCon（）;
}

}



	public?String?queryBookDetail（HttpServletRequest?req?HttpServletResponse?resp）?{
		String?isbn?=?req.getParameter（“isbn“）;
		try?{
			openCon（）;
			BookDao?bookDao?=?new?BookDao（con）;
			//設置自動提交為false
			//con.setAutoCommit（false）;
			Book?book?=?bookDao.queryByIsbn（isbn）;
			//手動提交事務
			//con.commit（）;
			if（book==null）
				return?“error.jsp“;
			else{
				req.setAttribute（“book“?book）;
				return?“book/bookdetail.jsp“;
			}
		}?catch?（Exception?e）?{
			e.printSta

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-06-18?11:49??Login\
?????文件?????????456??2013-03-08?10:48??Login\.classpath
?????目錄???????????0??2013-03-29?12:02??Login\.myeclipse\
?????文件?????????298??2013-04-21?17:34??Login\.mymetadata
?????文件????????1414??2013-04-19?16:50??Login\.project
?????目錄???????????0??2013-06-18?11:49??Login\.settings\
?????文件?????????500??2013-03-07?09:29??Login\.settings\.jsdtscope
?????文件????????1040??2013-04-19?16:57??Login\.settings\com.genuitec.eclipse.j2eedt.core.prefs
?????文件?????????330??2013-03-07?09:29??Login\.settings\org.eclipse.jdt.core.prefs
?????文件??????????49??2013-03-07?09:29??Login\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2013-03-07?09:29??Login\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2013-06-18?11:49??Login\src\
?????目錄???????????0??2013-06-18?11:49??Login\src\action\
?????文件????????3132??2013-04-21?16:20??Login\src\action\BookAction.java
?????文件????????1958??2013-04-20?22:17??Login\src\action\CookieCartAction.java
?????文件????????2061??2013-04-20?22:13??Login\src\action\DelCookieCartAction.java
?????文件?????????509??2013-03-28?09:19??Login\src\action\ICartAction.java
?????文件????????2097??2013-03-29?11:03??Login\src\action\SessionCartAction.java
?????文件????????1975??2013-04-21?17:15??Login\src\action\UserAction.java
?????目錄???????????0??2013-06-18?11:49??Login\src\base\
?????文件?????????267??2012-09-24?19:50??Login\src\base\baseAction.java
?????文件?????????594??2013-03-15?10:54??Login\src\base\baseDao.java
?????目錄???????????0??2013-06-18?11:49??Login\src\dao\
?????文件????????4030??2013-04-21?16:22??Login\src\dao\BookDao.java
?????文件????????1358??2013-03-15?10:55??Login\src\dao\UserDao.java
?????文件??????????98??2013-04-12?20:48??Login\src\db.properties
?????目錄???????????0??2013-06-18?11:49??Login\src\servlet\
?????文件????????2953??2013-04-21?16:20??Login\src\servlet\BanzhangServlet.java
?????目錄???????????0??2013-06-18?11:49??Login\src\util\
?????文件?????????457??2013-03-15?11:03??Login\src\util\ConfigUtils.java
?????文件????????1927??2013-03-15?11:08??Login\src\util\DbUtil.java
............此處省略175個文件信息