public int update(BookForm bookForm) {
String sql =
"Update titles set typeid="
+ bookForm.getTypeId()
+ ", title='"
+ bookForm.getTitle()
+ "'"
+ ",author='"
+ bookForm.getAuthor()
+ "',translator='"
+ bookForm.getTranslator()
+ "',price="
+ bookForm.getPrice()
+ ",page="
+ bookForm.getPage()
+ " where isbn='"
+ bookForm.getIsbn()
+ "'";
int falg = conn.executeUpdate(sql);
conn.close();
return falg;
}
// add book info
public int insert(BookForm bookForm) {
String sql = "";
int falg = findTitle(bookForm.getIsbn());
try {
if (falg != 2 && falg != 0) {
sql =
"Insert into titles (isbn,title,typeid,author,translator,price,page,inTime,operator) values('"
+ bookForm.getIsbn()
+ "','"
+ bookForm.getTitle()
+ "',"
+ bookForm.getTypeId()
+ ",'"
+ bookForm.getAuthor()
+ "','"
+ bookForm.getTranslator()
+ "','"
+ bookForm.getPrice()
+ "','"
+ bookForm.getPage()
+ "','"
+ bookForm.getInTime()
+ "','"
+ bookForm.getOperator()
+ "')";
falg = conn.executeUpdate(sql);
}
} catch (Exception ex) {
falg = 0;
} finally {
conn.close();
}
System.out.println("falg:" + falg);
return falg;
}
public int delete(BookForm bookForm) {
String sql = "Delete from titles where isbn='" + bookForm.getIsbn() + "'";
int falg = conn.executeUpdate(sql);
return falg;
}