图书管理系统java版-eolink官网

图书管理系统java版

本文的目的就是通过图书管理系统掌握数据库编程技术，能正确连接数据库，能对数据库中信息进行查询、插入、删除、修改。

源码：

BookInfo.java

* 项目名称:图书管理系统

* 版本: 1.0

* 创建者: 张俊强

* 创建时间:2016/5/26

* */

package librarySystem;

import java.awt.*;

import javax.swing.*;

import java.awt.event.*;

import java.sql.*;

@SuppressWarnings("serial")

public class BookInfo extends JFrame implements ActionListener{

//主角面上的控件

private JLabel inputLabel;

private JTextField inputText;

private JButton searchBut;

private JTable bookTable;

private jscrollPane bookScroll;

private JButton addBut;

private JButton modifyBut;

private JButton deleteBut;

private JButton refreshBut;

private BookTableModel bookTableModel;

public static void main(String[] args) throws SQLException {

// TODO Auto-generated method stub

BookInfo bookInfo=new BookInfo();

bookInfo.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

bookInfo.setBounds(350, 150, 600, 400);

bookInfo.setVisible(true);

// bookInfo.importSQL();//导出数据

bookInfo.setMinWindowLayout();//设置数据

}

public BookInfo() throws SQLException{

//创建主界面上的控件

inputLabel=new JLabel("请输入书名:");

inputText=new JTextField(10);

searchBut=new JButton("查询");

bookTableModel=new BookTableModel();

bookTable=new JTable(bookTableModel);

bookScroll=new JScrollPane(bookTable);

addBut=new JButton("添加");

modifyBut=new JButton("修改");

deleteBut=new JButton("删除");

refreshBut=new JButton("刷新");

searchBut.addActionListener(this);

addBut.addActionListener(this);

refreshBut.addActionListener(this);

modifyBut.addActionListener(this);

deleteBut.addActionListener(this);

}

void setMinWindowLayout(){

//主界面布局

Container con1=new Container();

con1.setLayout(new FlowLayout());

con1.add(inputLabel);

con1.add(inputText);

con1.add(searchBut);

con1.add(refreshBut);

Container con2=new Container();

con2.setLayout(new FlowLayout());

con2.add(addBut);

con2.add(modifyBut);

con2.add(deleteBut);

this.setLayout(new BorderLayout());

this.add(con1,BorderLayout.NORTH);

this.add(bookScroll,BorderLayout.CENTER);

this.add(con2,BorderLayout.SOUTH);

this.validate();

}

@Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

if(e.getSource()==searchBut){

if(!this.inputText.getText().equals("")){

String bookName=this.inputText.getText();

String sql="SELECT * FROM book_info WHERE book_name ='"+bookName+"'";

try {

bookTableModel=new BookTableModel(sql);

bookTable.setModel(bookTableModel);

} catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

}else{

JOptionPane.showMessageDialog(this,"输入不能为空", "提示",JOptionPane.PLAIN_MESSAGE);

}

else if(e.getSource()==addBut){

@SuppressWarnings("unused")

AddBookDialog addWin=new AddBookDialog(this,"添加图书",true);

this.refreshTable();

}

else if(e.getSource()==refreshBut){

this.refreshTable();

}

else if(e.getSource()==deleteBut){

int rowNum=bookTable.getSelectedRow();

if(rowNum<0||rowNum>bookTable.getRowCount()){

JOptionPane.showMessageDialog(this,"未选中", "提示",JOptionPane.PLAIN_MESSAGE);

}

else{

//System.out.print(bookName);

int n = JOptionPane.showConfirmDialog(null, "确认删除吗?", "确认删除框", JOptionPane.YES_NO_OPTION);

if (n == JOptionPane.YES_OPTION) {

String bookNum=(String) bookTable.getValueAt(rowNum, 0);

String sql="DELETE FROM book_info WHERE book_num= '"+bookNum+"'";

bookTableModel.deleteBook(sql);

this.refreshTable();

JOptionPane.showMessageDialog(this,"删除成功", "提示",JOptionPane.PLAIN_MESSAGE);

} else if (n == JOptionPane.NO_OPTION) {

return;

}

else if(e.getSource()==modifyBut){

bookTable.setModel(bookTableModel);

int rowNum=bookTable.getSelectedRow();

if(rowNum<0||rowNum>bookTable.getRowCount()){

JOptionPane.showMessageDialog(this,"未选中", "提示",JOptionPane.PLAIN_MESSAGE);

}

else{

@SuppressWarnings("unused")

ModifyBook modifyWin=new ModifyBook(this,"修改信息",true,bookTableModel,rowNum);

this.refreshTable();

}

public void refreshTable(){

BookTableModel searchBook;

try {

searchBook = new BookTableModel("SELECT * FROM book_info");

bookTable.setModel(searchBook);

bookTableModel=searchBook;

} catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

BookTableModel.java

package librarySystem;

import java.sql.*;

import java.util.*;

* 图书表模型

* */

import javax.swing.table.*;

@SuppressWarnings("serial")

public class BookTableModel extends AbstractTableModel{

//表的元素

private Vector> rowData;

private Vector colName;

// 数据库

private PreparedStatement stmt;

private ResultSet result;

public BookTableModel(String sql) throws SQLException{

this.initData(sql);

}

public BookTableModel() throws SQLException{

this.initData("SELECT * FROM book_info");

}

public void initData(String sql) throws SQLException{

setRowData(new Vector>());

setColName(new Vector());

getColName().add("书号");

getColName().add("书名");

getColName().add("出版社");

getColName().add("出版时间");

getColName().add("价格");

* 数据库的导入

* */

try {

Class.forName("com.mysql.jdbc.Driver");

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

String url= "jdbc:mysql://localhost:3306/device";

String user="root";

String password="zjq1314520";

Connection con=DriverManager.getConnection(url,user,passwobAdvurd);

stmt = con.prepareStatement(sql);

result=stmt.executeQuery();

importSQL();

}

void importSQL() throws SQLException{

// TODO Auto-generated method stub

@SuppressWarnings("unused")

boolean signNull=true;

while(result.next()){

Vector item=new Vector();

for(int i=1;i<7;i++){

item.add(result.getString(i));

}

getRowData().add(item);

signNull=false;

}

result.close();

}

@Override

public int getColumnCount() {//得到列数

// TODO Auto-generated method stub

return this.colName.size();

}

@Override

public int getRowCount() {//得到行数

// TODO Auto-generated method stub

return this.rowData.size();

}

@Override

public Object getValueAt(int row, int col) {//得到某行某列的数据

// TODO Auto-generated method stub

return (this.rowData.get(row)).get(col);

}

@Override

public String getColumnName(int column) {

// TODO Auto-generated method stub

return this.colName.get(column);

}

public Vector> getRowData() {

return rowData;

}

public void setRowData(Vector> rowData) {

this.rowData = rowData;

}

public Vector getColName() {

return colName;

}

public void setColName(Vector colName) {

this.colName = colName;

}

public void addBook(String sql){

try {

stmt.executeUpdate(sql);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

// initData("SELECT * FROM book_info");

}

public void deleteBook(String sql){

try {

stmt.executeUpdate(sql);

} catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

AddBookDialog.java

package librarySystem;

import java.awt.*;

import java.awt.event.*;

import java.sql.SQLException;

import javax.swing.*;

@SuppressWarnings("serial")

public class AddBookDialog extends JDialog implements ActionListener{

private JLabel bookNumLabel;

private JLabel bookNameLabel;

private JLabel bookWriterLabel;

private JLabel bookPublishLabel;

private JLabel bookPriceLabel;

private JLabel bookTimeLabel;

private JTextField bookNumText;

private JTextField bookNameText;

private JTextField bookWriterText;

private JTextField bookPublishText;

private JTextField bookPriceText;

private JTextField bookTimeText;

private JButton submitBut;

private JButton cancelBut;

public AddBookDialog(Frame owner,String title,boolean model){

//父窗口,窗口名,是否是模式窗口

super(owner,title,model);

bookNumLabel=new JLabel("书号:");

bookNameLabel=new JLabel("书名:");

bookWriterLabel=new JLabel("作者:");

bookPublishLabel=new JLabel("出版社:");

bookPriceLabel=new JLabel("价格:");

bookTimeLabel=new JLabel("出版时间:");

bookNumText=new JTextField(10);

bookNameText=new JTextField(10);

bookWriterText=new JTextField(10);

bookPublishText=new JTextField(10);

bookPriceText=new JTextField(10);

bookTimeText=new JTextField(9);

submitBut=new JButton("确认");

cancelBut=new JButton("取消");

submitBut.addActionListener(this);

cancelBut.addActionListener(this);

this.setBounds(350,150,400,260);

this.setResizable(false);

this.setLayout(new BorderLayout());

initLayout();

}

public void initLayout(){

Container[] con1=new Container[6];

for(int i=0;i<6;i++) con1[i]=new Container();

con1[0].setLayout(new FlowLayout());

con1[0].add(bookNumLabel);

con1[0].add(bookNumText);

con1[1].setLayout(new FlowLayout());

con1[1].add(bookNameLabel);

con1[1].add(bookNameText);

con1[2].setLayout(new FlowLayout());

con1[2].add(bookWriterLabel);

con1[2].add(bookWriterText);

con1[3].setLayout(new FlowLayout());

con1[3].add(bookPublishLabel);

con1[3].add(bookPublishText);

con1[4].setLayout(new FlowLayout());

con1[4].add(bookPriceLabel);

con1[4].add(bookPriceText);

con1[5].setLayout(new FlowLayout());

con1[5].add(bookTimeLabel);

con1[5].add(bookTimeText);

Container con2=new Container();

con2.setLayout(new BorderLayout());

con2.add(con1[0],BorderLayout.NORTH);

con2.add(con1[1],BorderLayout.CENTER);

con2.add(con1[2],BorderLayout.SOUTH);

Container con3=new Container();

con3.setLayout(new BorderLayout());

con3.add(con1[3],BorderLayout.NORTH);

con3.add(con1[4],BorderLayout.CENTER);

con3.add(con1[5],BorderLayout.SOUTH);

Container con4=new Container();

con4.setLayout(new FlowLayout());

con4.add(submitBut);

con4.add(cancelBut);

Container con5=new Container();

con5.setLayout(new BorderLayout());

con5.add(con2,BorderLayout.NORTH);

con5.add(con3,BorderLayout.CENTER);

con5.add(con4,BorderLayout.SOUTH);

this.add(con5,BorderLayout.CENTER);

this.validate();

this.setVisible(true);

}

@Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

if(e.getSource()==submitBut){

if(bookNumText.getText().equals("")||bookNameText.getText().equals("")||

bookWriterText.getText().equals("")||bookPublishText.getText().equals("")||

bookPriceText.getText().equals("")||bookTimeText.getText().equals("")){

//System.out.println("输入失败");

JOptionPane.showMessageDialog(this,"输入不能有空", "提示",JOptionPane.PLAIN_MESSAGE);

}

else{

//System.out.println("输入成功");

String sql="insert into "

+ "book_info(book_num,book_name,book_writer,publish_house,book_price,publish_time)"

+ "values('"+bookNumText.getText()+"','"+bookNameText.getText()+"','"+bookWriterText.getText()+"','"+bookPublishText.getText()+"','"+bookPriceText.getText()+"','"+bookTimeText.getText()+"')";

try {

BookTableModel book=new BookTableModel();

book.addBook(sql);

} catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

JOptionPane.showMessageDialog(this,"添加成功", "提示",JOptionPane.PLAIN_MESSAGE);

this.setVisible(false);

}

if(e.getSource()==cancelBut){

this.setVisible(false);

}

ModifyBook.java

package librarySystem;

import java.awt.*;

import java.awt.event.*;

import java.sql.SQLException;

import javax.swing.*;

@SuppressWarnings("serial")

public class ModifyBook extends JDialog implements ActionListener{

private JLabel bookNumLabel;

private JLabel bookNameLabel;

private JLabel bookWriterLabel;

private JLabel bookPublishLabel;

private JLabel bookPriceLabel;

private JLabel bookTimeLabel;

private JTextField bookNumText;

private JTextField bookNameText;

private JTextField bookWriterText;

private JTextField bookPublishText;

private JTextField bookPriceText;

private JTextField bookTimeText;

private JButton submitBut;

private JButton cancelBut;

private BookTableModel bookModel;

private int rowNum;

public ModifyBook(Frame owner,String thttp://itle,boolean type,BookTableModel model,int row){

super(owner,title,type);

bookModel=model;

rowNum=row;

bookNumLabel=new JLabel("书号:");

bookNameLabel=new JLabel("书名:");

bookWriterLabel=new JLabel("作者:");

bookPublishLabel=new JLabel("出版社:");

bookPriceLabel=new JLabel("价格:");

bookTimeLabel=new JLabel("出版时间:");

bookNumText=new JTextField(10);

bookNameText=new JTextField(10);

bookWriterText=new JTextField(10);

bookPublishText=new JTextField(10);

bookPriceText=new JTextField(10);

bookTimeText=new JTextField(9);

submitBut=new JButton("确认修改");

cancelBut=new JButton("取消");

submitBut.addActionListener(this);

cancelBut.addActionListener(this);

this.setBounds(350,150,400,260);

this.setResizable(false);

this.setLayout(new BorderLayout());

this.setValue();

this.initLayout();

}

public void initLayout(){

Container[] con1=new Container[6];

for(int i=0;i<6;i++) con1[i]=new Container();

con1[0].setLayout(new FlowLayout());

con1[0].add(bookNumLabel);

con1[0].add(bookNumText);

con1[1].setLayout(new FlowLayout());

con1[1].add(bookNameLabel);

con1[1].add(bookNameText);

con1[2].setLayout(new FlowLayout());

con1[2].add(bookWriterLabel);

con1[2].add(bookWriterText);

con1[3].setLayout(new FlowLayout());

con1[3].add(bookPublishLabel);

con1[3].add(bookPublishText);

con1[4].setLayout(new FlowLayout());

con1[4].add(bookPriceLabel);

con1[4].add(bookPriceText);

con1[5].setLayout(new FlowLayout());

con1[5].add(bookTimeLabel);

con1[5].add(bookTimeText);

Container con2=new Container();

con2.setLayout(new BorderLayout());

con2.add(con1[0],BorderLayout.NORTH);

con2.add(con1[1],BorderLayout.CENTER);

con2.add(con1[2],BorderLayout.SOUTH);

Container con3=new Container();

con3.setLayout(new BorderLayout());

con3.add(con1[3],BorderLayout.NORTH);

con3.add(con1[4],BorderLayout.CENTER);

con3.add(con1[5],BorderLayout.SOUTH);

Container con4=new Container();

con4.setLayout(new FlowLayout());

con4.add(submitBut);

con4.add(cancelBut);

Container con5=new Container();

con5.setLayout(new BorderLayout());

con5.add(con2,BorderLayout.NORTH);

con5.add(con3,BorderLayout.CENTER);

con5.add(con4,BorderLayout.SOUTH);

this.add(con5,BorderLayout.CENTER);

this.validate();

this.setVisible(true);

}

public void setValue(){

this.bookNumText.setText((String) bookModel.getValueAt(rowNum, 0));

this.bookNumText.setEditable(false);

this.bookNameText.setText((String) bookModel.getValueAt(rowNum, 1));

this.bookWriterText.setText((String) bookModel.getValueAt(rowNum, 2));

this.bookPublishText.setText((String) bookModel.getValueAt(rowNum, 3));

this.bookTimeText.setText((String) bookModel.getValueAt(rowNum, 4));

this.bookPriceText.setText((String) bookModel.getValueAt(rowNum, 5));

this.validate();

}

@Override

public void actionPerformed(ActionEvent e) {

// System.out.println(bookPriceText.getText());

// TODO Auto-generated method stub

if(e.getSource()==submitBut){

if(bookNumText.getText().equals("")||bookNameText.getText().equals("")||

bookWriterText.getText().equals("")||bookPublishText.getText().equals("")||

bookPriceText.getText().equals("")||bookTimeText.getText().equals("")){

//System.out.println("输入失败");

JOptionPane.showMessageDialog(this,"修改不能有空", "提示",JOptionPane.PLAIN_MESSAGE);

}

else{

int n = JOptionPane.showConfirmDialog(null, "确认修改吗?", "确认修改框", JOptionPane.YES_NO_OPTION);

if (n == JOptionPane.YES_OPTION) {

String sql="UPDATE book_info SET book_name ='"+bookNameText.getText()+"', book_writer= '"+bookWriterText.getText()+"',publish_house='"+bookPublishText.getText()+"',book_price='"+bookPriceText.getText()+"',publish_time='"+bookTimeText.getText()+"' WHERE book_num = '"+bookNumText.getText()+"' ";

try {

BookTableModel book=new BookTableModel();

book.addBook(sql);

} catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

JOptionPane.showMessageDialog(this,"修改成功", "提示",JOptionPane.PLAIN_MESSAGE);

this.setVisible(false);

} else if (n == JOptionPane.NO_OPTION) {

return;

}

if(e.getSource()==cancelBut){

this.setVisible(false);

}

程序运行结果：

主界面：

查询界面：

添加图书界面：

修改界面：

删除操作：

数据库界面：

关于管理系统的更多内容请点击《管理系统专题》进行学习

c#自定义Attribute获取接口实现示例代码

175 2023-07-14

图书管理系统java版

多平台统一管理软件接口，如何实现多平台统一管理软件接口

vue项目接口域名动态的获取方法

c#自定义Attribute获取接口实现示例代码

推荐文章

接口调用是什么意思？几种常用接口调用方式

接口设计原则

8款在线 API 接口文档管理工具

api管理系统是什么？

什么是接口调试？接口调试的步骤有哪些？

api 接口管理系统有哪些？

接口测试有几种测试方法

API文档生成工具有哪些？

微服务和api网关区别

交换机配置步骤

最近发表

热评文章

在线接口文档管理工具推荐，支持在线测试，HTTP接口

开源的在线接口文档wiki工具Mindoc的介绍与使

如何优雅的进行接口设计？接口设计的六大原则是什么？

什么是API测试,api检测公司

软件接口设计怎么做？前后端分离软件接口设计思路

接口管理平台推荐，几大接口管理平台总有一款适合你！