package Bean;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;

public class BookQuery{

	public ArrayList bookquery(String strBookID)
	{
		String SQLString = "";
		String bookID = strBookID;
		
		java.sql.ResultSet sqlRst = null;
		java.sql.Statement Stmt = null;
//		Users user = new Users();                 //--------這句話寫在是錯誤的-----
		ArrayList<BookBean> arraylist = new ArrayList();
		
		Connection conn=new DBConn().getConn();
		try 
		{
	//		SQLString = "select * from UsersAccess where UsersTable = " + "'" + ID + "'";
			SQLString = "select * from book";
			Stmt = conn.createStatement(); //語句對象 
			sqlRst=Stmt.executeQuery ( SQLString); ; //結(jié)果集對象 
			
			while(sqlRst.next())
			{
				BookBean book = new BookBean();   //---這句話必須寫在這------
				book.setBookID(sqlRst.getString("bookID"));
				book.setBookName(sqlRst.getString("bookName"));
				book.setAuthor(sqlRst.getString("author"));
				book.setPrice(sqlRst.getDouble("price"));
				book.setDiscount(sqlRst.getDouble("discount"));
				book.setPress(sqlRst.getString("press"));
				book.setSum(sqlRst.getInt("sum"));
				book.setPicroot(sqlRst.getString("picroot"));
				
				arraylist.add(book);   //----把BookBean放入ArrayList中
			}
				Stmt.close (); 
				conn.close();
	
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		
		return arraylist;
	}
	
	
	public ArrayList booksearch(String strsql)
	{
		String SQLString = strsql;
		
		java.sql.ResultSet sqlRst = null;
		java.sql.Statement Stmt = null;
//		Users user = new Users();                 //--------這句話寫在是錯誤的-----
		ArrayList<BookBean> arraylist = new ArrayList();
		
		Connection conn=new DBConn().getConn();
		try 
		{
			Stmt = conn.createStatement(); //語句對象 
			sqlRst=Stmt.executeQuery ( SQLString); ; //結(jié)果集對象 
			
			while(sqlRst.next())
			{System.out.println("進入循環(huán)中！?。。。。。?quot;);
				BookBean book = new BookBean();   //---這句話必須寫在這------
				book.setBookID(sqlRst.getString("bookID"));
				book.setBookName(sqlRst.getString("bookName"));
				book.setAuthor(sqlRst.getString("author"));
				book.setPrice(sqlRst.getDouble("price"));
				book.setDiscount(sqlRst.getDouble("discount"));
				book.setPress(sqlRst.getString("press"));
				book.setSum(sqlRst.getInt("sum"));
				book.setPicroot(sqlRst.getString("picroot"));
				
				arraylist.add(book);   //----把BookBean放入ArrayList中
			}
				Stmt.close (); 
				conn.close();
	
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		
		return arraylist;
	}
	
	public Bean.BookBean bookQuery(String strBookID)
	{
		String SQLString = "";
		String bookID = strBookID;
		
		java.sql.ResultSet sqlRst = null;
		java.sql.Statement Stmt = null;
//		Users user = new Users();                 //--------這句話寫在是錯誤的-----
		BookBean book = new BookBean();
		
		Connection conn=new DBConn().getConn();
		try 
		{
	//		SQLString = "select * from UsersAccess where UsersTable = " + "'" + ID + "'";
			SQLString = "select * from book where bookID = '" + bookID + "'";
			Stmt = conn.createStatement(); //語句對象 
			sqlRst=Stmt.executeQuery ( SQLString); ; //結(jié)果集對象 
			
			if(sqlRst.next())
			{
				book.setBookID(sqlRst.getString("bookID"));
				book.setBookName(sqlRst.getString("bookName"));
				book.setAuthor(sqlRst.getString("author"));
				book.setPrice(sqlRst.getDouble("price"));
				book.setDiscount(sqlRst.getDouble("discount"));
				book.setPress(sqlRst.getString("press"));
				book.setSum(sqlRst.getInt("sum"));
				book.setPicroot(sqlRst.getString("picroot"));
				
			}
				Stmt.close (); 
				conn.close();
	
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		
		return book;
	}
}