package?js4129.action;

import?java.io.File;
import?java.io.FileInputStream;
import?java.sql.ResultSet;
import?java.util.Map;

import?javax.servlet.ServletOutputStream;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletResponse;

import?js4129.db.JdbcUtils;
import?js4129.model.Book;
import?js4129.model.User;

import?org.apache.struts2.ServletActionContext;

import?com.opensymphony.xwork2.ActionContext;
import?com.opensymphony.xwork2.ActionSupport;

public?class?BookAction?extends?ActionSupport?{
	
	private?User?user;
	
	public?User?getUser（）?{
		return?user;
	}

	public?void?setUser（User?user）?{
		this.user?=?user;
	}
	
	private?void?get（）?{
		Map?session=ActionContext.getContext（）.getSession（）;
		user?=?（User）session.get（“login“）;
	}
	
	@Override
	public?String?execute（）?throws?Exception?{
		
		get（）;
		return?SUCCESS;
	}
//--------------------------------------------------	
	private?Book?book;
	private?File?photo;
	
	public?Book?getBook（）?{
		return?book;
	}

	public?void?setBook（Book?book）?{
		this.book?=?book;
	}

	public?File?getPhoto（）?{
		return?photo;
	}

	public?void?setPhoto（File?photo）?{
		this.photo?=?photo;
	}

	public?String?insert（）?{
		
		get（）;
		try?{
			String?sql?=?“select?*?from?book?where?‘isbn‘=?“;
			ResultSet?rs?=?JdbcUtils.executeQuery（sql?book.getIsbn（））;
			if（rs.next（））?{
				this.addFieldError（“msg“?“ISBN已經存在！“）;
			}else{
				if（this.getPhoto（）!=null）?{
					FileInputStream?fis?=?new?FileInputStream（this.getPhoto（））;
					byte[]buffer?=?new?byte[fis.available（）];
					fis.read（buffer）;
					book.setPhoto（buffer）;
				}
				sql?=?“insert?into?book（‘isbn‘‘name‘‘auth‘‘pub‘‘pric‘‘num‘‘sum‘‘img‘）?values（????????）“;
				JdbcUtils.executeUpdate（sqlbook.getIsbn（）book.getBookName（）book.getAuthor（）book.getPublisher（）book.getPrice（）book.getCnum（）book.getSummary（）book.getPhoto（））;
				this.addFieldError（“msg“?“添加成功！“）;
			}
		}?catch?（Exception?e）?{
			//?TODO:?handle?exception
		}
		return?SUCCESS;
	}
	//--------------------------------------------------
	public?String?delete（）?{
		
		get（）;
		try?{
			String?sql?=?“select?*?from?book?where?‘isbn‘=?“;
			ResultSet?rs?=?JdbcUtils.executeQuery（sql?book.getIsbn（））;
			if（!rs.next（））?{
				this.addFieldError（“msg“?“要刪除的圖書不存在！“）;
			}else{
				sql?=?“select?*?from?lend?where?‘bid‘=?“;
				rs?=?JdbcUtils.executeQuery（sql?rs.getInt（“id“））;
				if（rs.next（））?{
					this.addFieldError（“msg“?“該圖書已被借出，故不能刪除！“）;
				}else?{
					sql?=?“delete?from?book?where?‘isbn‘=?“;
					JdbcUtils.executeUpdate（sql?book.getIsbn（））;
					this.addFieldError（“msg“?“刪除成功！“）;
				}
			}
		}?catch?（Exception?e）?{
			//?TODO:?handle?exception
		}
		return?SUCCESS;
	}
//--------------------------------------------------
	public?String?select（）?{
		
		get（）;
		try?{
			Book?onebook?=?new?Book（）;
			String?sql?=?“select?*?from?book?where?‘i

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1093??2015-11-27?10:22??8\.classpath

?????文件???????1406??2015-12-23?10:12??8\.project

?????文件????????522??2015-11-27?10:22??8\.settings\.jsdtscope

?????文件???????1040??2015-12-23?10:12??8\.settings\com.genuitec.eclipse.j2eedt.core.prefs

?????文件????????336??2015-12-21?19:11??8\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2015-11-27?10:22??8\.settings\org.eclipse.jdt.core.prefs

?????文件????????479??2015-12-23?10:12??8\.settings\org.eclipse.wst.common.component

?????文件????????414??2015-11-27?10:22??8\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2015-11-27?10:22??8\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2015-11-27?10:22??8\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件?????294780??2015-12-22?12:05??8\book.sql

?????文件???????5991??2015-12-23?15:03??8\src\.struts.mex

?????文件???????5548??2015-12-23?14:21??8\src\js4129\action\BookAction.java

?????文件????????557??2015-12-23?14:21??8\src\js4129\action\DownAction.java

?????文件????????724??2015-12-23?14:21??8\src\js4129\action\Index.java

?????文件???????2190??2015-12-23?14:22??8\src\js4129\action\LendAction.java

?????文件???????1432??2015-12-23?14:23??8\src\js4129\action\LoginAction.java

?????文件????????370??2015-12-23?14:24??8\src\js4129\action\Logon.java

?????文件???????1154??2015-12-23?14:25??8\src\js4129\action\Reader.java

?????文件???????1609??2015-12-23?14:52??8\src\js4129\action\ReaderAction.java

?????文件???????1715??2015-12-23?14:26??8\src\js4129\action\ReturnAction.java

?????文件???????2527??2015-12-23?14:26??8\src\js4129\action\SearchAction.java

?????文件???????2381??2015-12-23?14:27??8\src\js4129\action\StartAction.java

?????文件???????1357??2015-12-23?14:27??8\src\js4129\action\UploadAction.java

?????文件???????2058??2015-12-23?14:28??8\src\js4129\action\UserAction.java

?????文件???????2516??2015-12-23?14:28??8\src\js4129\action\ZhuCeAction.java

?????文件???????2847??2015-12-23?14:29??8\src\js4129\db\JdbcUtils.java

?????文件???????1457??2015-12-23?14:29??8\src\js4129\model\Book.java

?????文件???????1168??2015-12-23?14:30??8\src\js4129\model\Lend.java

?????文件???????1612??2015-12-23?14:30??8\src\js4129\model\User.java

............此處省略114個文件信息