package?kBMS.dao;

import?java.sql.*;
import?java.text.SimpleDateFormat;

import?kBMS.model.*;
import?kBMS.util.*;

public?class?booksDao?{
	/**
	?*?圖書添加
	?*/
	public?static?int?add（Connection?conbooks?book）throws?Exception{
		String?sql=“insert?into?books?values（????????）“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		pstmt.setString（1?book.getIBSN（））;
		pstmt.setString（2?book.getBookName（））;
		pstmt.setString（3?book.getBookType（））;
		pstmt.setString（4?book.getAuthor（））;
		pstmt.setString（5?book.getBookCompany（））;
		//轉(zhuǎn)換日期格式
		java.text.SimpleDateFormat??df??=?new?SimpleDateFormat（“yyyyMMdd“）;
	???	java.util.Date?ud?=?df.parse（book.getBookDate（））;
	????java.sql.Date?sd=new?java.sql.Date（ud.getTime（））;
	????
	????pstmt.setDate（6?sd）;?
		pstmt.setInt（7?Integer.valueOf（book.getBookNum（）））;
		pstmt.setString（8?book.getBookIntro（））;
		return?pstmt.executeUpdate（）;
	}
	/**
	?*?圖書修改
	?*/
	public?static?int?updatebook（Connection?conbooks?book）throws?Exception{
		String?sql=“update?books?set?book_name?=???book_type?=???book_author?=???book_company?=??“
				+?“?book_date?=???book_number?=???book_intro?=???where?isbn=“+book.getIBSN（）;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		pstmt.setString（1?book.getBookName（））;
		pstmt.setString（2?book.getBookType（））;
		pstmt.setString（3?book.getAuthor（））;
		pstmt.setString（4?book.getBookCompany（））;
		//轉(zhuǎn)換日期格式
		java.text.SimpleDateFormat??df??=?new?SimpleDateFormat（“yyyyMMdd“）;
	???	java.util.Date?ud?=?df.parse（book.getBookDate（））;
	????java.sql.Date?sd=new?java.sql.Date（ud.getTime（））;
	????
	????pstmt.setDate（5?sd）;?
		pstmt.setInt（6?Integer.valueOf（book.getBookNum（）））;
		pstmt.setString（7?book.getBookIntro（））;
		return?pstmt.executeUpdate（）;
	}
	/**
	?*?圖書刪除
	?*/
	public?static?int?deletebook（Connection?conString?ID）throws?Exception{
		System.out.println（ID）;
		String?sql?=?“delete?books?where?isbn?=“+ID+“?“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		return?pstmt.executeUpdate（）;
	}
	/**
	?*?圖書信息查詢
	?*/
	public?static?ResultSet?list（Connection?conbooks?book）throws?Exception{
		StringBuffer?sql=new?StringBuffer（“select?*?from?v_book?where?v_book.isbn?=?v_book.isbn“）;
		if（StringUtil.isNotEmpty（book.getBookName（）））{	//書名模糊查找
			sql.append（“?and?書名?like?‘%“+book.getBookName（）+“%‘“）;
		}
		if（StringUtil.isNotEmpty（book.getIBSN（）））{	//IBSN
			sql.append（“?and?v_book.isbn?=?“+book.getIBSN（））;
		}
		if（StringUtil.isNotEmpty（book.getAuthor（）））{	//作者模糊查找
			sql.append（“?and?作者?like?‘%“+book.getAuthor（）+“%‘“）;
		}
		if（StringUtil.isNotEmpty（book.getBookType（）））{	//圖書類型查找
			sql.append（“??and?圖書類型?like?‘%“+book.getBookType（）+“%‘“）;
		}
		PreparedStatement?pstmt=con.prepareStatement（sql.toString（））;
		return?pstmt.executeQuery（）;
	}
	/**
	?*?圖書類型添加
	?*/
	public?static?int?addtype（Connection?conbookType?booktype）throws?Exception{
		String?sql=“insert?into?booktype?values（???）“;