java图书管理系统实现增删改查项目源码
时间: 2023-12-28 12:05:26 浏览: 43
以下是一个简单的Java图书管理系统的增删改查项目源码,其中使用了MySQL数据库。该系统实现了管理员和读者的登录、注销、修改密码等功能,管理员可以对图书信息进行增删改查、查看读者、查看借阅记录,读者可以对图书信息进行查看查询、修改个人信息、查看借阅记录。
```java
// 连接数据库
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/library", "root", "password");
// 添加图书信息
String sql = "INSERT INTO book (book_name, author, price, publish_date) VALUES (?, ?, ?, ?)";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "Java编程思想");
pstmt.setString(2, "Bruce Eckel");
pstmt.setDouble(3, 99.0);
pstmt.setDate(4, new java.sql.Date(new Date().getTime()));
pstmt.executeUpdate();
// 修改图书信息
String sql = "UPDATE book SET price = ? WHERE book_name = ?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setDouble(1, 88.0);
pstmt.setString(2, "Java编程思想");
pstmt.executeUpdate();
// 删除图书信息
String sql = "DELETE FROM book WHERE book_name = ?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "Java编程思想");
pstmt.executeUpdate();
// 查询图书信息
String sql = "SELECT * FROM book WHERE book_name = ?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "Java编程思想");
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
System.out.println(rs.getString("book_name") + " " + rs.getString("author") + " " + rs.getDouble("price") + " " + rs.getDate("publish_date"));
}
```