基于java+jdbc+mysql的图书管理系统代码

╰+攻爆jí腚メ 2023-10-11 20:02 28阅读 0赞

源码编号：F-A17

项目类型：java SE项目（awt+swing）开源免费

项目名称：图书管理系统代码

用户类型：只有管理员和普通用户，双角色，

主要技术：java、awt、swing、jdbc数据库等技术

运行工具：Eclipse/MyEclipse/IDEA都可以，Eclipse最兼容

数 据 库：MySQL5.7以上

数据库表数量：3张表

视图数量：10个左右

项目简介：本系统主要有登录、注册、图书信息管理、用户管理、借阅图书、还书，查看借阅历史、修改密码等相关操作功能模块，

**项目骨架**

![29e363504f5b6d082bd0b85e464845be.png][]

**注册界面**

![623607f2fc051e471d10e504ebe896b1.png][]

**项目骨架**

![0bd39b6da430b35a23fa56f2154a182f.png][]

**注册界面**

![789fbf73b2c55dc769f6c737bcac72a3.png][]

登录界面

![2e935a2446889c8d3b625eeb623dd35f.png][]

**图书管理**

![2f9c597b02ec6d77e39bfdd7ee738a66.png][]

**用户管理**

![d0ca967a6205550cd51a189082b23bf6.png][]

**修改信息**

![5f24fefba512132cb827f0d2ebba295b.png][]

**修改信息**

![7a51982f04ece28ea16df56e325007d5.png][]

相关代码展示：

package menu;
    
    import java.awt.Color;
    import java.awt.Dimension;
    import java.awt.Font;
    import java.awt.Image;
    import java.awt.Toolkit;
    import java.awt.event.ActionEvent;
    import java.awt.event.ActionListener;
    
    import javax.swing.Icon;
    import javax.swing.ImageIcon;
    import javax.swing.JButton;
    import javax.swing.JFrame;
    import javax.swing.JLabel;
    import javax.swing.JOptionPane;
    import javax.swing.JPanel;
    import javax.swing.JTextField;
    import javax.swing.table.DefaultTableModel;
    
    import database.BookData;
    import database.ManageBook;
    
    public class FixBook {
    
    	public FixBook(DefaultTableModel model,int id) {
    		JFrame f = new JFrame();
    		f.setSize(500, 500);
    		f.setLocationRelativeTo(null);
    		f.setLayout(null);
    		f.setTitle("修改图书");
    		
    		//改变窗口图标
    		Toolkit tool = Toolkit.getDefaultToolkit();
    		Image img = tool.getImage("picture\\sign.jpg");
    		f.setIconImage(img);
    		
    		/*设置窗口背景图案*/
    		Icon i = new ImageIcon("picture\\admin_background.jpg");
    		JLabel label = new JLabel(i);
    		label.setBounds(0, 0, 500, 500);
    		
    		
    		
    		JPanel panel1 = new JPanel();
    		JPanel panel2 = new JPanel();
    		JPanel panel3 = new JPanel();
    		JPanel panel4 = new JPanel();
    		JPanel panel5 = new JPanel();
    		
    		Font font = new Font("宋体",Font.BOLD,30);
    		Font font1 = new Font("宋体",Font.PLAIN,20);
    		Dimension dimension = new Dimension(300,40);
    		Dimension dimension1 = new Dimension(200,40);
    		
    		/*书名标签*/
    		JLabel labbook = new JLabel("书名：");
    		labbook.setFont(font);
    		panel1.add(labbook);
    		panel1.setBounds(50, 30, 200, 60);
    		
    		/*书名输入文本框*/
    		JTextField textbook = new JTextField(12);
    		panel2.setLayout(null);
    		textbook.setSize(dimension);
    		textbook.setFont(font1);
    		panel2.add(textbook);
    		panel2.setBounds(100, 90, 500, 50);
    		
    		/*作者标签*/
    		JLabel labauthor = new JLabel("作者：");
    		labauthor.setFont(font);
    		panel3.add(labauthor);
    		panel3.setBounds(50, 160, 200, 60);
    		
    		/*作者输入文本框*/
    		JTextField textauthor = new JTextField(12);
    		panel4.setLayout(null);
    		textauthor.setSize(dimension);
    		textauthor.setFont(font1);
    		panel4.add(textauthor);
    		panel4.setBounds(100, 220, 500, 50);
    		
    		
    		/*添加按钮*/
    		JButton button = new JButton("确定修改");
    		button.setPreferredSize(dimension1);
    		button.setBackground(Color.PINK);
    		button.setFont(new Font("宋体",Font.BOLD,25));
    		panel5.add(button);
    		panel5.setBounds(150, 300, 200, 100);
    		
    		button.addActionListener(new ActionListener() {
    			
    			@Override
    			public void actionPerformed(ActionEvent e) {
    				String book = textbook.getText().trim();
    				String author = textauthor.getText().trim();
    				ManageBook mb = new ManageBook();
    				try {
    					mb.changeBook(id, book);
    					mb.changeAuthor(id, author);
    					JOptionPane.showMessageDialog(null, "修改成功", "修改", JOptionPane.PLAIN_MESSAGE);
    					BookData bd = new BookData();
    					try {
    						model.setRowCount(0);
    						bd.selectAll(model);
    					} catch (Exception e1) {
    						// TODO Auto-generated catch block
    						e1.printStackTrace();
    					}
    				} catch (Exception e2) {
    					// TODO Auto-generated catch block
    					e2.printStackTrace();
    				}
    			}
    		});
    		
    		
    		f.add(panel1);
    		f.add(panel2);
    		f.add(panel3);
    		f.add(panel4);
    		f.add(panel5);
    		f.add(label);
    		
    		textbook.setOpaque(false);
    		textauthor.setOpaque(false);
    		panel1.setOpaque(false);
    		panel2.setOpaque(false);
    		panel3.setOpaque(false);
    		panel4.setOpaque(false);
    		panel5.setOpaque(false);
    		
    		f.setVisible(true);
    	}
    }

[29e363504f5b6d082bd0b85e464845be.png]: https://img-blog.csdnimg.cn/img_convert/29e363504f5b6d082bd0b85e464845be.png
[623607f2fc051e471d10e504ebe896b1.png]: https://img-blog.csdnimg.cn/img_convert/623607f2fc051e471d10e504ebe896b1.png
[0bd39b6da430b35a23fa56f2154a182f.png]: https://img-blog.csdnimg.cn/img_convert/0bd39b6da430b35a23fa56f2154a182f.png
[789fbf73b2c55dc769f6c737bcac72a3.png]: https://img-blog.csdnimg.cn/img_convert/789fbf73b2c55dc769f6c737bcac72a3.png
[2e935a2446889c8d3b625eeb623dd35f.png]: https://img-blog.csdnimg.cn/img_convert/2e935a2446889c8d3b625eeb623dd35f.png
[2f9c597b02ec6d77e39bfdd7ee738a66.png]: https://img-blog.csdnimg.cn/img_convert/2f9c597b02ec6d77e39bfdd7ee738a66.png
[d0ca967a6205550cd51a189082b23bf6.png]: https://img-blog.csdnimg.cn/img_convert/d0ca967a6205550cd51a189082b23bf6.png
[5f24fefba512132cb827f0d2ebba295b.png]: https://img-blog.csdnimg.cn/img_convert/5f24fefba512132cb827f0d2ebba295b.png
[7a51982f04ece28ea16df56e325007d5.png]: https://img-blog.csdnimg.cn/img_convert/7a51982f04ece28ea16df56e325007d5.png