基于信息管理的教材管理系统与排行榜设计与实现

CREATE TABLE Textbook (

id INT AUTO_INCREMENT PRIMARY KEY,

title VARCHAR(255) NOT NULL,

author VARCHAR(255),

year INT,

quantity INT DEFAULT 0

);

SELECT title, COUNT(*) AS usage_count

FROM Textbook

JOIN BorrowRecord ON Textbook.id = BorrowRecord.textbook_id

GROUP BY title

ORDER BY usage_count DESC

LIMIT 10;

public List getTextbooks() {

String query = "SELECT * FROM Textbook";

try (Connection conn = Database.getConnection();

Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery(query)) {

List textbooks = new ArrayList<>();

while (rs.next()) {

Textbook textbook = new Textbook();

排课管理软件

textbook.setId(rs.getInt("id"));

textbook.setTitle(rs.getString("title"));

textbook.setAuthor(rs.getString("author"));

textbooks.add(textbook);

}

return textbooks;

} catch (SQLException e) {

e.printStackTrace();

return Collections.emptyList();

}

}