用java和mysql写一个图书管理系统
时间: 2024-05-12 16:13:36 浏览: 5
好的,以下是一个简单的图书管理系统的Java代码,使用MySQL数据库。我假设你已经安装了Java和MySQL,并且已经创建了一个名为"library"的数据库,其中包含一个名为"books"的表,该表包含以下列:id(int)、title(varchar)、author(varchar)、publisher(varchar)、year(int)、isbn(varchar)。
```java
import java.sql.*;
public class BookManager {
private static final String DB_URL = "jdbc:mysql://localhost/library";
private static final String DB_USER = "root";
private static final String DB_PASSWORD = "password";
public static void main(String[] args) {
try {
Connection conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);
Statement stmt = conn.createStatement();
// Create table if not exists
String createTable = "CREATE TABLE IF NOT EXISTS books (id INT PRIMARY KEY AUTO_INCREMENT, title VARCHAR(255), author VARCHAR(255), publisher VARCHAR(255), year INT, isbn VARCHAR(255))";
stmt.executeUpdate(createTable);
// Insert sample data
String insertData = "INSERT INTO books (title, author, publisher, year, isbn) VALUES ('The Great Gatsby', 'F. Scott Fitzgerald', 'Scribner', 1925, '978-0743273565')";
stmt.executeUpdate(insertData);
// Query data
String query = "SELECT * FROM books";
ResultSet rs = stmt.executeQuery(query);
// Print results
while (rs.next()) {
int id = rs.getInt("id");
String title = rs.getString("title");
String author = rs.getString("author");
String publisher = rs.getString("publisher");
int year = rs.getInt("year");
String isbn = rs.getString("isbn");
System.out.println("ID: " + id);
System.out.println("Title: " + title);
System.out.println("Author: " + author);
System.out.println("Publisher: " + publisher);
System.out.println("Year: " + year);
System.out.println("ISBN: " + isbn);
}
// Close connection
rs.close();
stmt.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
```
这个程序将创建一个名为"books"的表,插入一个样本数据,然后查询并打印出所有图书的信息。你可以根据自己的需要修改此代码,例如添加删除书籍或按标题或作者搜索的功能。