栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

Java+Swing+mysql5实现图书管理系统

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

Java+Swing+mysql5实现图书管理系统

Java+Swing+mysql5实现图书管理系统
  • 一、系统介绍
    • 1.系统功能
    • 2.环境配置
    • 3.数据库
    • 4.工程截图
  • 二、系统展示
    • 1.登录页
      • 1.1登录成功
    • 2.添加图书分类
    • 3.管理图书分类
    • 4.新增图书
    • 5.管理图书
    • 6.退出系统
    • 6.关于我们
  • 三、部分代码
    • DBConn.java
    • LoginFrm.java
    • Book.java
  • 四、其他
    • 获取源码


一、系统介绍 1.系统功能

1.登录系统
2.添加图书分类
3.管理图书分类
4.添加图书
5.管理图书
6.退出系统
7.关于我们

2.环境配置

JDK版本:1.8
Mysql:5.7

3.数据库


;

;

;
;
;
;
CREATE DATABASE `swing_book` ;

USE `swing_book`;



DROP TABLE IF EXISTS `book`;

CREATE TABLE `book` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT '',
  `author` varchar(255) DEFAULT '',
  `sex` varchar(255) DEFAULT '',
  `price` decimal(10,2) DEFAULT '0.00',
  `booktype_id` int(11) DEFAULT '0',
  `desc` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `FK_book` (`booktype_id`),
  CONSTRAINT `FK_book` FOREIGN KEY (`booktype_id`) REFERENCES `booktype` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;



insert  into `book`(`id`,`name`,`author`,`sex`,`price`,`booktype_id`,`desc`) values (1,'C语言','谭浩强','男','50.00',1,'C语言'),(2,'Java程序设计','詹姆斯·高斯林','男','100.00',1,'Java程序设计'),(3,'图形图像处理','何雄飞','男','40.00',2,'图形图像处理'),(4,'图形图像处理技术','张枝军','男','60.00',2,'图形图像处理技术'),(6,'汇编语言','王爽','女','90.00',1,'汇编语言');



DROP TABLE IF EXISTS `booktype`;

CREATE TABLE `booktype` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT '',
  `desc` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;



insert  into `booktype`(`id`,`name`,`desc`) values (1,'计算机类','计算机类'),(2,'图形图像类','图形图像类'),(3,'经济类','经济类');



DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) DEFAULT '',
  `userpass` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;



insert  into `user`(`id`,`username`,`userpass`) values (1,'admin','123456');

;
;
;
;

4.工程截图

二、系统展示 1.登录页

1.1登录成功

2.添加图书分类

3.管理图书分类

4.新增图书

5.管理图书

6.退出系统

6.关于我们

三、部分代码 DBConn.java
package cn.com.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;
 
public class DBConn {
    private static String driverName = "com.mysql.jdbc.Driver";
    private static String url = "jdbc:mysql://localhost:3306/swing_book?characterEncoding=utf8";
    private static String userName = "root";
    private static String password = "root";
    private Connection conn;
    private Statement stmt;
 
    public DBConn() {
        try {
            Class.forName(driverName);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
 
    
    public Connection getConnection() throws SQLException {
        return DriverManager.getConnection(url, userName, password);
    }
    
 
    
    public void close() {
        try {
            if (conn != null) {
                conn.close();
            }
            if (stmt != null) {
                stmt.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
 
}
LoginFrm.java
package cn.com.view;


import java.awt.EventQueue;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;

import javax.swing.GroupLayout;
import javax.swing.GroupLayout.Alignment;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;
import javax.swing.LayoutStyle.ComponentPlacement;
import javax.swing.border.EmptyBorder;

import cn.com.dao.UserDao;
import cn.com.model.User;
import cn.com.util.DBConn;
import cn.com.util.StringUtil;

public class LoginFrm extends JFrame {

	private JPanel contentPane;
	private JTextField username_txt;
	private JPasswordField password_txt;
	
	private DBConn db=new DBConn();
	
	private UserDao userDao=new UserDao();

	
	public static void main(String[] args) {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				try {
					LoginFrm frame = new LoginFrm();
					frame.setVisible(true);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		});
	}

	
	public LoginFrm() {
		setResizable(false);
		setTitle("u7BA1u7406u5458u767Bu5F55");
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(100, 100, 450, 300);
		contentPane = new JPanel();
		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
		setContentPane(contentPane);
		
		JLabel lblNewLabel = new JLabel("u56FEu4E66u7BA1u7406u7CFBu7EDF");
		lblNewLabel.setFont(new Font("微软雅黑", Font.PLAIN, 24));
		
		JLabel lblNewLabel_1 = new JLabel("u7528u6237u540D:");
		
		JLabel lblNewLabel_2 = new JLabel("u5BC6u7801:");
		
		username_txt = new JTextField();
		username_txt.setColumns(10);
		
		password_txt = new JPasswordField();
		
		JButton btnNewButton = new JButton("u767Bu5F55");
		btnNewButton.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				LoginActionPerformed(e);
			}
		});
		
		JButton btnNewButton_1 = new JButton("u91CDu7F6E");
		btnNewButton_1.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				ResetActionPerformed(e);
			}
			
		});
		GroupLayout gl_contentPane = new GroupLayout(contentPane);
		gl_contentPane.setHorizontalGroup(
			gl_contentPane.createParallelGroup(Alignment.TRAILING)
				.addGroup(gl_contentPane.createSequentialGroup()
					.addGap(114)
					.addGroup(gl_contentPane.createParallelGroup(Alignment.TRAILING)
						.addGroup(gl_contentPane.createSequentialGroup()
							.addComponent(lblNewLabel_2)
							.addPreferredGap(ComponentPlacement.UNRELATED)
							.addComponent(password_txt, 224, 224, 224)
							.addPreferredGap(ComponentPlacement.RELATED))
						.addGroup(gl_contentPane.createSequentialGroup()
							.addComponent(lblNewLabel_1)
							.addPreferredGap(ComponentPlacement.RELATED)
							.addGroup(gl_contentPane.createParallelGroup(Alignment.LEADING)
								.addComponent(lblNewLabel)
								.addComponent(username_txt, 226, 226, 226))))
					.addGap(48))
				.addGroup(Alignment.LEADING, gl_contentPane.createSequentialGroup()
					.addGap(153)
					.addComponent(btnNewButton)
					.addPreferredGap(ComponentPlacement.UNRELATED)
					.addComponent(btnNewButton_1)
					.addContainerGap(157, Short.MAX_VALUE))
		);
		gl_contentPane.setVerticalGroup(
			gl_contentPane.createParallelGroup(Alignment.LEADING)
				.addGroup(gl_contentPane.createSequentialGroup()
					.addGap(50)
					.addComponent(lblNewLabel)
					.addGap(18)
					.addGroup(gl_contentPane.createParallelGroup(Alignment.BASELINE)
						.addComponent(lblNewLabel_1)
						.addComponent(username_txt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
					.addGap(18)
					.addGroup(gl_contentPane.createParallelGroup(Alignment.BASELINE)
						.addComponent(lblNewLabel_2)
						.addComponent(password_txt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
					.addGap(18)
					.addGroup(gl_contentPane.createParallelGroup(Alignment.BASELINE)
						.addComponent(btnNewButton)
						.addComponent(btnNewButton_1))
					.addContainerGap(60, Short.MAX_VALUE))
		);
		contentPane.setLayout(gl_contentPane);
		
		this.setLocationRelativeTo(null);
	}

	protected void ResetActionPerformed(ActionEvent e) {
		// TODO Auto-generated method stub
		this.username_txt.setText("");
		this.password_txt.setText("");
		
		
	}

	protected void LoginActionPerformed(ActionEvent e) {
		// TODO Auto-generated method stub
		
		String username=this.username_txt.getText();
		String password=new String(this.password_txt.getPassword());
		
		if(StringUtil.isEmpty(username)) {
			JOptionPane.showMessageDialog(null, "用户名不能为空");
			return;
		}
		
		if(StringUtil.isEmpty(password)) {
			JOptionPane.showMessageDialog(null, "密码不能为空");
			return;
		}
		
		User user=new User(username,password);
		Connection conn=null;
		try {
			conn=db.getConnection();
			User current_user=userDao.login(conn,user);
			if(current_user!=null) {
				JOptionPane.showMessageDialog(null, "登录成功");
				dispose();
				new MainFrm().setVisible(true);
			}else {
				JOptionPane.showMessageDialog(null, "用户名或者密码错误");
			}
		} catch (Exception e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		
		
	}
}


Book.java
package cn.com.model;

public class Book {
	
	private int id;
	private String name;
	private String author;
	private String sex;
	private Float price;
	private Integer booktype_id;
	private String booktype_name;
	private String desc;
	
	public Book() {
		super();
		
	}
	
	
	
	public Book(String name, String author, String sex, Float price, Integer booktype_id, String desc) {
		super();
		this.name = name;
		this.author = author;
		this.sex = sex;
		this.price = price;
		this.booktype_id = booktype_id;
		this.desc = desc;
	}
	
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getAuthor() {
		return author;
	}
	public void setAuthor(String author) {
		this.author = author;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public Float getPrice() {
		return price;
	}
	public void setPrice(Float price) {
		this.price = price;
	}
	public Integer getBooktype_id() {
		return booktype_id;
	}
	public void setBooktype_id(Integer booktype_id) {
		this.booktype_id = booktype_id;
	}
	public String getBooktype_name() {
		return booktype_name;
	}
	public void setBooktype_name(String booktype_name) {
		this.booktype_name = booktype_name;
	}
	public String getDesc() {
		return desc;
	}
	public void setDesc(String desc) {
		this.desc = desc;
	}
	
	

}


四、其他 获取源码

点击以下链接获取源码,数据库文件在swing_book.sql文件里面。
Java+Swing+Mysql实现图书管理系统源码

Java+Swing+Mysql实现通讯录管理系统源码

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/975916.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号