图书管理系统的删除和修改操作代码
时间: 2024-03-23 10:40:10 浏览: 48
删除操作代码:
```java
public void deleteBook(String bookId) {
try {
Statement stmt = conn.createStatement();
String sql = "DELETE FROM books WHERE book_id='" + bookId + "'";
stmt.executeUpdate(sql);
System.out.println("图书删除成功!");
} catch (SQLException e) {
e.printStackTrace();
}
}
```
修改操作代码:
```java
public void updateBook(String bookId, String title, String author, String category, double price) {
try {
Statement stmt = conn.createStatement();
String sql = "UPDATE books SET title='" + title + "', author='" + author + "', category='" + category + "', price=" + price + " WHERE book_id='" + bookId + "'";
stmt.executeUpdate(sql);
System.out.println("图书修改成功!");
} catch (SQLException e) {
e.printStackTrace();
}
}
```
注意:以上代码仅作参考,实际应用中需要根据具体需求进行修改。另外,为了防止 SQL 注入攻击,建议使用 PreparedStatement 来代替 Statement,具体实现请参考相关文档。