?? bookupdate.java
字號:
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("數據庫成功修改!");
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -