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（???）“;

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-06-13?09:14??oracle+Java-圖書管理系統(tǒng)\
?????文件????????6641??2019-06-13?09:14??oracle+Java-圖書管理系統(tǒng)\..txt
?????目錄???????????0??2018-05-06?15:35??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\
?????文件?????????468??2018-05-06?15:28??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\.classpath
?????文件?????????393??2018-04-23?12:57??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\.project
?????目錄???????????0??2018-04-23?12:57??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\.settings\
?????文件?????????598??2018-04-23?12:58??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2018-05-06?15:28??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\
?????目錄???????????0??2018-05-06?15:28??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\images\
?????文件?????????664??2015-08-13?07:59??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\images\about.png
?????文件?????????805??2015-08-13?07:59??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\images\add.png
?????文件?????????852??2015-08-13?07:59??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\images\base.png
?????文件?????????646??2015-08-13?07:59??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\images\bookManager.png
?????文件?????????618??2015-08-13?07:59??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\images\bookTypeManager.png
?????文件?????????666??2015-08-13?07:59??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\images\delete.png
?????文件?????????516??2015-08-13?07:59??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\images\edit.png
?????文件???????17744??2018-04-24?10:26??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\images\erweima.PNG
?????文件?????????755??2015-08-13?07:59??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\images\exit.png
?????文件???????12026??2015-08-13?07:59??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\images\java1234.png
?????文件?????????644??2015-08-13?07:59??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\images\login.png
?????文件????????5261??2015-08-13?07:59??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\images\logo.png
?????文件?????????676??2015-08-13?07:59??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\images\me.png
?????文件?????????611??2015-08-13?07:59??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\images\modify.png
?????文件?????????481??2015-08-13?07:59??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\images\password.png
?????文件?????????725??2015-08-13?07:59??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\images\reset.png
?????文件?????????628??2015-08-13?07:59??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\images\search.png
?????文件?????????575??2015-08-13?07:59??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\images\userName.png
?????目錄???????????0??2018-05-06?15:28??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\kBMS\
?????目錄???????????0??2018-05-06?15:28??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\kBMS\dao\
?????文件????????4575??2018-05-06?15:28??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\kBMS\dao\booksDao.class
?????文件????????2425??2018-05-06?15:28??oracle+Java-圖書管理系統(tǒng)\BookManagerSystem\bin\kBMS\dao\borrowedDao.class
............此處省略141個(gè)文件信息