javaweb图书管理系统增删
时间: 2023-11-30 16:43:11 浏览: 39
以下是JavaWeb图书管理系统中增加和删除图书的代码示例:
1. 添加图书
```java
public boolean add(Book book) {
Connection conn = null;
PreparedStatement pstmt = null;
boolean flag = false;
try {
conn = DBUtil.getConnection();
String sql = "insert into book(name, author, price) values(?, ?, ?)";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, book.getName());
pstmt.setString(2, book.getAuthor());
pstmt.setDouble(3, book.getPrice());
int count = pstmt.executeUpdate();
if (count > 0) {
flag = true;
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.close(conn, pstmt, null);
}
return flag;
}
```
2. 删除图书
```java
public boolean delete(String name) {
Connection conn = null;
PreparedStatement pstmt = null;
boolean flag = false;
try {
conn = DBUtil.getConnection();
String sql = "delete from book where name=?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, name);
int count = pstmt.executeUpdate();
if (count > 0) {
flag = true;
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.close(conn, pstmt, null);
}
return flag;
}
```