package Bean;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class BookUpdate {

	public void Update(BookBean bookbean)
	{
		Bean.BookBean book = bookbean;
		Connection conn = null;
			conn = new DBConn().getConn();
			String sql = null;
			sql = "update book set bookName = ?,author = ?,press = ?,price = ?,sum = ?,discount = ?,picroot = ? where bookID = ?";
			try {
				System.out.println(sql);
				PreparedStatement ps = conn.prepareStatement(sql);
				
				ps.setString(1, book.getBookName());
				ps.setString(2, book.getAuthor());
				ps.setString(3, book.getPress());
				ps.setDouble(4, book.getPrice());
				ps.setInt(5, book.getSum());
				ps.setDouble(6, book.getDiscount());
				ps.setString(7, book.getPicroot());
				ps.setString(8, book.getBookID());
				System.out.println("這是BOOKID號：");
				System.out.println(book.getBookName());
				System.out.println(book.getBookID());
				ps.executeUpdate();
				System.out.println("修改數據庫！");
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
			System.out.println("數據庫成功修改！");
	}
}