前言
✨Java Swing开发~✨
🎯项目介绍：
这是一款基于Java Swing开发的图书管理系统，极其适合作为Java课设设计以及学习技术使用，其中使用MySQL 8.x作为数据库。
👀功能特色：
1️⃣基础功能（管理员权限）
（1）系统登录功能：用户可以通过用户名和密码登录系统。
（2）图书分类管理功能：增、删、改、查操作不在话下！
（3）图书信息管理功能：增、删、改图书，修改图书名称、类别、价格等信息，畅所欲言。
（4）图书借阅管理功能：借、还，妥妥的轻松搞定！考虑到逾期情况的判别和处理，早就事无巨细了！
2️⃣可选加分功能（用户权限）
（1）借阅记录查询功能：学生只需查看自己在某时间段内的借阅记录，管理员可按照学号查询学生的借阅记录。
一、项目展示
二、部分代码
1.Book
package entity;
/**
* BookManagementSystem
* 图书
*
* @author PlutoCtx
* @version 2024/5/26 1:07
* @email ctx195467@163.com
* @since JDK17
*/
public class Book {
/**
* 图书id
*/
private int id;
/**
* 书名
*/
private String bookName;
/**
* 作者
*/
private String author;
/**
* 图书数量
*/
private int number;
/**
* 价格
*/
private Float price;
/**
* 图书类别
*/
private Integer bookTypeId;
/**
* 图书类别
*/
private String bookTypeName;
/**
* 描述
*/
private String bookDesc;
public Book(String bookName, String author, Integer number, Float price, Integer bookTypeId, String bookDesc) {
super();
this.bookName = bookName;
this.author = author;
this.number = number;
this.price = price;
this.bookTypeId = bookTypeId;
this.bookDesc = bookDesc;
}
public Book(int id, String bookName, String author, Integer number, Float price, Integer bookTypeId, String bookDesc) {
super();
this.id = id;
this.bookName = bookName;
this.author = author;
this.number = number;
this.price = price;
this.bookTypeId = bookTypeId;
this.bookDesc = bookDesc;
}
public Book(String bookName, String author, Integer bookTypeId) {
super();
this.bookName = bookName;
this.author = author;
this.bookTypeId = bookTypeId;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getBookName() {
return bookName;
}
public void setBookName(String bookName) {
this.bookName = bookName;
}
public String getAuthor() {
return author;
}
public void setAuthor(String author) {
this.author = author;
}
public int getNumber() {
return number;
}
public void setNumber(int number) {
this.number = number;
}
public Float getPrice() {
return price;
}
public void setPrice(Float price) {
this.price = price;
}
public Integer getBookTypeId() {
return bookTypeId;
}
public void setBookTypeId(Integer bookTypeId) {
this.bookTypeId = bookTypeId;
}
public String getBookTypeName() {
return bookTypeName;
}
public void setBookTypeName(String bookTypeName) {
this.bookTypeName = bookTypeName;
}
public String getBookDesc() {
return bookDesc;
}
public void setBookDesc(String bookDesc) {
this.bookDesc = bookDesc;
}
public Book() {
}
public Book(int id,
String bookName,
String author,
Integer number,
Float price,
Integer bookTypeId,
String bookTypeName,
String bookDesc) {
this.id = id;
this.bookName = bookName;
this.author = author;
this.number = number;
this.price = price;
this.bookTypeId = bookTypeId;
this.bookTypeName = bookTypeName;
this.bookDesc = bookDesc;
}
}
2.BookDao
package dao;
import entity.Book;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
/**
* BookManagementSystem
*
* @author PlutoCtx
* @version 2024/5/26 9:27
* @email ctx195467@163.com
* @since JDK17
*/
public class BookDao {
/**
* 添加图书
* @param connection 连接数据库
* @param book 书籍
* @return preparedStatement.executeUpdate(),int
* @throws Exception how do I know
*/
public int add(Connection connection, Book book)throws Exception{
String sql = "INSERT INTO book VALUES (null, ?, ?, ?, ?, ?, ?)";
PreparedStatement preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1, book.getBookName());
preparedStatement.setString(2, book.getAuthor());
preparedStatement.setInt(3, book.getNumber());
preparedStatement.setFloat(4, book.getPrice());
preparedStatement.setInt(5, book.getBookTypeId());
preparedStatement.setString(6, book.getBookDesc());
return preparedStatement.executeUpdate();
}
/**
* 查找书籍
* @param connection 连接数据库
* @param book 书籍
* @return preparedStatement.executeUpdate(), int
* @throws Exception how do I know
*/
public ResultSet list(Connection connection, Book book)throws Exception{
StringBuilder stringBuffer = new StringBuilder("SELECT * FROM book b,bookType bt WHERE b.bookTypeId = bt.id");
if(book.getBookName() != null &&
!book.getBookName().equals("")){
stringBuffer.append(" and b.bookName like '%").append(book.getBookName()).append("%'");
}
if(book.getAuthor() != null &&
!book.getAuthor().equals("")){
stringBuffer.append(" and b.author like '%").append(book.getAuthor()).append("%'");
}
if(book.getBookTypeId() != null && book.getBookTypeId()!=-1){
stringBuffer.append(" and b.bookTypeId=").append(book.getBookTypeId());
}
PreparedStatement preparedStatement = connection.prepareStatement(stringBuffer.toString());
return preparedStatement.executeQuery();
}
/**
* 删除书籍
* @param connection 连接数据库
* @param id 书籍id号
* @return preparedStatement.executeUpdate(), int
* @throws Exception how do I know
*/
public int delete(Connection connection,String id)throws Exception{
String sql = "DELETE FROM book " +
"WHERE id = ?";
PreparedStatement preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1, id);
return preparedStatement.executeUpdate();
}
/**
* 更新书籍
* @param connection 连接数据库
* @param book 书籍
* @return preparedStatement.executeUpdate(),int
* @throws Exception how do I know
*/
public int update(Connection connection,Book book) throws Exception{
String sql = "UPDATE book " +
"SET bookName = ?, author = ?, number = ?, price = ?, bookDesc = ?, bookTypeId = ? " +
"WHERE id = ?";
PreparedStatement preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1, book.getBookName());
preparedStatement.setString(2, book.getAuthor());
preparedStatement.setInt(3, book.getNumber());
preparedStatement.setFloat(4, book.getPrice());
preparedStatement.setString(5, book.getBookDesc());
preparedStatement.setInt(6, book.getBookTypeId());
preparedStatement.setInt(7, book.getId());
return preparedStatement.executeUpdate();
}
/**
* 判断书籍是否存在
* @param connection 数据库连接
* @param bookTypeId 书类号
* @return 存在与否
* @throws Exception 异常多了什么都有可能
*/
public boolean existBookByBookTypeId(Connection connection,String bookTypeId)throws Exception{
String sql = "SELECT * FROM book WHERE bookTypeId = ?";
PreparedStatement preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1, bookTypeId);
ResultSet rs = preparedStatement.executeQuery();
return rs.next();
}
}
3.DBUtil
package utils;
import java.sql.Connection;
import java.sql.DriverManager;
/**
* BookManagementSystem
* 数据库连接
*
* @author PlutoCtx
* @version 2024/5/26 8:06
* @email ctx195467@163.com
* @since JDK17
*/
public class DBUtil {
/**
数据库
*/
private String url = "jdbc:mysql://localhost:3306/BookBorrowingManagementSystem";
/**
* 用户名
*/
private String username = "root";
/**
* 密码
*/
private String password = "Shangxiao111";
/**
* 驱动名称
*/
private String jdbcName = "com.mysql.cj.jdbc.Driver";
/**
* 获取数据库连接
* @return 返回连接
* @throws Exception 没连上
*/
public Connection getConnection() throws Exception{
Class.forName(jdbcName);
Connection connection = DriverManager.getConnection(url, username, password);
return connection;
}
/**
* 关闭数据库连接
* @param connection 数据库连接
* @throws Exception 异常
*/
public void closeConnection(Connection connection) throws Exception{
if (connection != null){
connection.close();
}
}
}
4.BookAddInternalFrame
package view.adminOperation;
import dao.BookDao;
import dao.BookTypeDao;
import entity.Book;
import entity.BookType;
import utils.DBUtil;
import javax.swing.*;
import javax.swing.border.LineBorder;
import java.awt.event.ActionEvent;
import java.sql.Connection;
import java.sql.ResultSet;
import java.util.Objects;
import java.util.logging.Logger;
/**
* BookManagementSystem
* 图书添加界面
*
* @author PlutoCtx
* @version 2024/5/26 9:08
* @email ctx195467@163.com
* @since JDK17
*/
public class BookAddInternalFrame extends JInternalFrame {
private final JTextField bookNameTxt;
private final JTextField authorTxt;
private final JTextField bookNumberTxt;
private final ButtonGroup buttonGroup = new ButtonGroup();
private final JTextField priceTxt;
private final JComboBox bookTypeJcb;
private final JTextArea bookDescTxt;
private final DBUtil dbUtil = new DBUtil();
private final BookTypeDao bookTypeDao = new BookTypeDao();
private final BookDao bookDao = new BookDao();
/**
* Create the frame.
*/
public BookAddInternalFrame() {
setClosable(true);
setIconifiable(true);
setTitle("图书添加");
setBounds(100, 100, 450, 467);
JLabel label = new JLabel("图书名称：");
bookNameTxt = new JTextField();
bookNameTxt.setColumns(10);
JLabel label1 = new JLabel("图书作者：");
authorTxt = new JTextField();
authorTxt.setColumns(10);
JLabel label2 = new JLabel("图书数量：");
bookNumberTxt = new JTextField();
bookNumberTxt.setColumns(10);
JLabel label3 = new JLabel("图书价格：");
priceTxt = new JTextField();
priceTxt.setColumns(10);
JLabel label4 = new JLabel("图书描述：");
bookDescTxt = new JTextArea();
JLabel label5 = new JLabel("图书类别：");
bookTypeJcb = new JComboBox();
JButton button = new JButton("添加");
button.addActionListener(this::bookAddActionPerformed);
button.setIcon(new ImageIcon(Objects.requireNonNull(BookAddInternalFrame.class.getResource("/add.png"))));
JButton button1 = new JButton("重置");
button1.addActionListener(this::resetValueActionPerformed);
button1.setIcon(new ImageIcon(Objects.requireNonNull(BookAddInternalFrame.class.getResource("/reset.png"))));
GroupLayout groupLayout = new GroupLayout(getContentPane());
groupLayout.setHorizontalGroup(
groupLayout.createParallelGroup(GroupLayout.Alignment.LEADING)
.addGroup(groupLayout.createSequentialGroup()
.addGap(42)
.addGroup(groupLayout.createParallelGroup(GroupLayout.Alignment.LEADING)
.addGroup(groupLayout.createSequentialGroup()
.addComponent(button)
.addPreferredGap(LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(button1)
.addGap(232))
.addGroup(groupLayout.createParallelGroup(GroupLayout.Alignment.LEADING)
.addComponent(label5)
.addGroup(groupLayout.createSequentialGroup()
.addGroup(groupLayout.createParallelGroup(GroupLayout.Alignment.TRAILING)
.addComponent(label4)
.addComponent(label2)
.addComponent(label))
.addPreferredGap(LayoutStyle.ComponentPlacement.RELATED)
.addGroup(groupLayout.createParallelGroup(GroupLayout.Alignment.LEADING)
.addGroup(groupLayout.createSequentialGroup()
.addGroup(groupLayout.createParallelGroup(GroupLayout.Alignment.LEADING, false)
.addComponent(bookNameTxt, GroupLayout.PREFERRED_SIZE, 88, GroupLayout.PREFERRED_SIZE)
.addComponent(bookNumberTxt, GroupLayout.PREFERRED_SIZE, 88, GroupLayout.PREFERRED_SIZE)
.addComponent(bookTypeJcb, 0, GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGap(35)
.addGroup(groupLayout.createParallelGroup(GroupLayout.Alignment.LEADING, false)
.addGroup(groupLayout.createSequentialGroup()
.addComponent(label1)
.addPreferredGap(LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(authorTxt, GroupLayout.PREFERRED_SIZE, 91, GroupLayout.PREFERRED_SIZE))
.addGroup(groupLayout.createSequentialGroup()
.addComponent(label3)
.addPreferredGap(LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(priceTxt))))
.addComponent(bookDescTxt))
.addContainerGap(44, Short.MAX_VALUE)))))
);
groupLayout.setVerticalGroup(
groupLayout.createParallelGroup(GroupLayout.Alignment.LEADING)
.addGroup(groupLayout.createSequentialGroup()
.addGap(42)
.addGroup(groupLayout.createParallelGroup(GroupLayout.Alignment.BASELINE)
.addComponent(label)
.addComponent(bookNameTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
.addComponent(label1)
.addComponent(authorTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
.addGap(29)
.addGroup(groupLayout.createParallelGroup(GroupLayout.Alignment.BASELINE)
.addComponent(label2)
.addComponent(bookNumberTxt)
.addComponent(label3)
.addComponent(priceTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
.addGap(33)
.addGroup(groupLayout.createParallelGroup(GroupLayout.Alignment.BASELINE)
.addComponent(label5)
.addComponent(bookTypeJcb, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
.addGap(30)
.addGroup(groupLayout.createParallelGroup(GroupLayout.Alignment.LEADING)
.addComponent(label4)
.addComponent(bookDescTxt, GroupLayout.PREFERRED_SIZE, 137, GroupLayout.PREFERRED_SIZE))
.addPreferredGap(LayoutStyle.ComponentPlacement.RELATED, 37, Short.MAX_VALUE)
.addGroup(groupLayout.createParallelGroup(GroupLayout.Alignment.BASELINE)
.addComponent(button)
.addComponent(button1))
.addGap(42))
);
getContentPane().setLayout(groupLayout);
/*
* 设置文本域边框
*/
bookDescTxt.setBorder(new LineBorder(new java.awt.Color(127,157,185), 1, false));
fillBookType();
}
/**
* 重置事件处理
* @param e event
*/
private void resetValueActionPerformed(ActionEvent e) {
this.resetValue();
}
/**
* 图书添加事件处理
* @param event event
*/
private void bookAddActionPerformed(ActionEvent event) {
String bookName = this.bookNameTxt.getText();
String author = this.authorTxt.getText();
String price = this.priceTxt.getText();
String bookDesc = this.bookDescTxt.getText();
if(bookName == null || "".equals(bookName.trim())){
JOptionPane.showMessageDialog(null, "图书名称不能为空");
return;
}
if(author == null || "".equals(author.trim())){
JOptionPane.showMessageDialog(null, "图书作者不能为空");
return;
}
if(price == null || "".equals(price.trim())){
JOptionPane.showMessageDialog(null, "图书价格不能为空");
return;
}
String bookNumber = bookNumberTxt.getText();
int numberOfBook = bookNumber.isEmpty() ? 0 : Integer.parseInt(bookNumber);
BookType bookType = (BookType) bookTypeJcb.getSelectedItem();
int bookTypeId = bookType.getId();
Book book = new Book(bookName,author, numberOfBook, Float.parseFloat(price) , bookTypeId, bookDesc);
Connection con = null;
try{
con = dbUtil.getConnection();
int addNum = bookDao.add(con, book);
if(addNum == 1){
JOptionPane.showMessageDialog(null, "图书添加成功");
resetValue();
}else{
JOptionPane.showMessageDialog(null, "图书添加失败");
}
}catch(Exception e){
e.printStackTrace();
JOptionPane.showMessageDialog(null, "图书添加失败");
}finally{
try {
dbUtil.closeConnection(con);
} catch (Exception e) {
e.printStackTrace();
}
}
}
/**
* 重置表单
*/
private void resetValue(){
this.bookNameTxt.setText("");
this.authorTxt.setText("");
this.priceTxt.setText("");
this.bookNumberTxt.setText("");
this.bookDescTxt.setText("");
if(this.bookTypeJcb.getItemCount()>0){
this.bookTypeJcb.setSelectedIndex(0);
}
}
/**
* 初始化图书类别下拉框
*/
private void fillBookType(){
Connection con = null;
BookType bookType = null;
try{
con = dbUtil.getConnection();
ResultSet rs = bookTypeDao.list(con, new BookType());
while(rs.next()){
bookType = new BookType();
bookType.setId(rs.getInt("id"));
bookType.setBookTypeName(rs.getString("bookTypeName"));
this.bookTypeJcb.addItem(bookType);
}
}catch(Exception e){
e.printStackTrace();
}finally{
Logger.getGlobal().info("finished!");
}
}
}
5.Login
package view;
import dao.UserDao;
import entity.User;
import utils.DBUtil;
import javax.swing.*;
import javax.swing.border.EmptyBorder;
import javax.swing.plaf.FontUIResource;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.sql.Connection;
import java.util.Enumeration;
import java.util.Objects;
/**
* BookManagementSystem
* 登录界面
*
* @author PlutoCtx
* @version 2024/5/26 8:17
* @email ctx195467@163.com
* @since JDK17
*/
public class Login extends JFrame {
private JPanel contentPane;
private final JTextField userNameText;
private final JPasswordField passwordText;
private final DBUtil dbUtil = new DBUtil();
private final UserDao userDao = new UserDao();
/**
* Create the frame
*/
public Login(){
//改变系统默认字体
Font font = new Font("Dialog", Font.PLAIN, 12);
Enumeration<Object> keys = UIManager.getDefaults().keys();
while (keys.hasMoreElements()){
Object key = keys.nextElement();
Object value = UIManager.get(key);
if (value instanceof FontUIResource){
UIManager.put(key, font);
}
}
setResizable(false);
// 用户登录
setTitle("用户登录");
setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);
setBounds(500,250,450,343);
contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5,5,5,5));
setContentPane(contentPane);
JLabel lblNewLabel = new JLabel("图书管理系统");
lblNewLabel.setFont(new Font("宋体", Font.BOLD, 23));
lblNewLabel.setIcon(new ImageIcon(Objects.requireNonNull(getClass().getResource("/logo.png"))));
JLabel lblNewLabel1 = new JLabel("用户名：");
lblNewLabel1.setIcon(new ImageIcon(Objects.requireNonNull(getClass().getResource("/userName.png"))));
JLabel lblNewLabel2 = new JLabel("密 码：");
lblNewLabel2.setIcon(new ImageIcon(Objects.requireNonNull(getClass().getResource("/password.png"))));
userNameText = new JTextField();
userNameText.setColumns(10);
passwordText = new JPasswordField();
JButton btnNewButton1 = new JButton("登录");
btnNewButton1.addActionListener(this::loginActionPerformed);
btnNewButton1.setIcon(new ImageIcon(Objects.requireNonNull(getClass().getResource("/login.png"))));
JButton btnNewButton2 = new JButton("重置");
btnNewButton2.addActionListener(this::resetValueActionPerformed);
btnNewButton2.setIcon(new ImageIcon(Objects.requireNonNull(getClass().getResource("/reset.png"))));
GroupLayout groupLayoutContentPane = new GroupLayout(contentPane);
groupLayoutContentPane.setHorizontalGroup(
groupLayoutContentPane.createParallelGroup(GroupLayout.Alignment.LEADING)
.addGroup(groupLayoutContentPane.createSequentialGroup()
.addGroup(groupLayoutContentPane.createParallelGroup(GroupLayout.Alignment.LEADING)
.addGroup(groupLayoutContentPane.createSequentialGroup()
.addGap(111)
.addComponent(lblNewLabel))
.addGroup(groupLayoutContentPane.createSequentialGroup()
.addGap(101)
.addGroup(groupLayoutContentPane.createParallelGroup(GroupLayout.Alignment.LEADING)
.addComponent(lblNewLabel1)
.addComponent(lblNewLabel2)
.addComponent(btnNewButton1))
.addGap(32)
.addGroup(groupLayoutContentPane.createParallelGroup(GroupLayout.Alignment.LEADING)
.addComponent(btnNewButton2)
.addGroup(groupLayoutContentPane.createParallelGroup(GroupLayout.Alignment.LEADING, false)
.addComponent(passwordText)
.addComponent(userNameText, GroupLayout.DEFAULT_SIZE, 128, Short.MAX_VALUE)))))
.addContainerGap(111, Short.MAX_VALUE))
);
groupLayoutContentPane.setVerticalGroup(
groupLayoutContentPane.createParallelGroup(GroupLayout.Alignment.LEADING)
.addGroup(groupLayoutContentPane.createSequentialGroup()
.addGap(30)
.addComponent(lblNewLabel)
.addGap(26)
.addGroup(groupLayoutContentPane.createParallelGroup(GroupLayout.Alignment.LEADING)
.addGroup(groupLayoutContentPane.createSequentialGroup()
.addComponent(lblNewLabel1)
.addGap(29)
.addGroup(groupLayoutContentPane.createParallelGroup(GroupLayout.Alignment.BASELINE)
.addComponent(lblNewLabel2)
.addComponent(passwordText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)))
.addComponent(userNameText, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
.addGap(36)
.addGroup(groupLayoutContentPane.createParallelGroup(GroupLayout.Alignment.BASELINE)
.addComponent(btnNewButton1)
.addComponent(btnNewButton2))
.addContainerGap(60, Short.MAX_VALUE))
);
contentPane.setLayout(groupLayoutContentPane);
// 居中
this.setLocationRelativeTo(null);
}
/**
* 登录事件处理
* @param evt action
*/
private void loginActionPerformed(ActionEvent evt) {
String userName = this.userNameText.getText();
String password = new String(this.passwordText.getPassword());
if (userName == null || userName.equals("")){
JOptionPane.showMessageDialog(null, "用户名不能为空");
return;
}
if (password == null || password.equals("")){
JOptionPane.showMessageDialog(null, "密码不能为空");
return;
}
// 调用dao层方法
User user = new User(userName, password);
Connection con = null;
try {
con = dbUtil.getConnection();
User currentUser = userDao.login(con, user);
if (currentUser != null){
dispose();
if (currentUser.getStatus() == 1) {
new AdminMainFrame(currentUser).setVisible(true);
JOptionPane.showMessageDialog(null, "登录成功");
} else {
new UserMainFrame(currentUser).setVisible(true);
JOptionPane.showMessageDialog(null, "登录成功");
}
}else {
JOptionPane.showMessageDialog(null, "用户名或密码错误");
}
} catch (Exception e) {
e.printStackTrace();
}finally {
try {
dbUtil.closeConnection(con);
}catch (Exception e){
e.printStackTrace();
}
}
}
/**
* 重置事件处理
* @param evt action
*/
private void resetValueActionPerformed(ActionEvent evt){
this.userNameText.setText("");
this.passwordText.setText("");
}
}
三、配置
1️⃣ 想把文件夹直接导入到你的 idea 中吗？看这里哦！
2️⃣ 你需要打开 navicat 等数据库可视化软件，并且执行 sql 文件夹里的数据库文件。赶快试试吧！
3️⃣ 如果必要的话，记得要修改 DBUtil.java 中的用户名、连接、密码哦。
4️⃣ 最后就是运行 Main 了，期待你的成果！#database #java #idea #navicat #coding #程序猿