如何使用java实现简单的图书借阅系统

这篇文章将为大家详细讲解有关如何使用java实现简单的图书借阅系统，小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。

具体内容如下

直接看代码：

package ttt;import java.awt.BorderLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.jscrollPane;import javax.swing.JTable;import javax.swing.border.TitledBorder;import javax.swing.table.DefaultTableModel;public class Labmsys extends JFrame{        JTable booktable=null;        static DefaultTableModel bookmodel=null;        JTable borrowtable=null;        static DefaultTableModel bmodel=null;        JPanel j1=new JPanel();        JPanel j2=new JPanel();        JPanel j3=new JPanel();        JButton button1=new JButton("借书");        JButton button2=new JButton("还书");    public Labmsys()    {        this.setLayout(new BorderLayout());        this.add(j1,BorderLayout.WEST);        this.add(j2,BorderLayout.EAST);        this.add(j3,BorderLayout.CENTER);        j1.setBorder(new TitledBorder("图书借书表"));        j2.setBorder(new TitledBorder("图书库存表"));        this.booktable=bookIn();        this.borrowtable=borrowIn();        JScrollPane  jsp1=new JScrollPane(borrowtable);        JScrollPane  jsp2=new JScrollPane(booktable);        j1.add(jsp1);        j2.add(jsp2);        j3.add(button1);        j3.add(button2);        //添加借书监听器        button1.addActionListener(new ActionListener()        {            @Override            public void actionPerfORMed(ActionEvent e) {                // TODO Auto-generated method stub                int rowNum=booktable.getSelectedRow();                System.out.println(rowNum);                if(rowNum>=0)                {                    String isbn=booktable.getValueAt(rowNum, 0).toString();                    System.out.println(isbn);                    int count=Integer.parseInt((String) booktable.getValueAt(rowNum, 2));                    String s=JOptionPane.showInputDialog("请输入学号");                    if(count<=0)                        JOptionPane.showMessageDialog(null,"图书库存不足");                    else if (null==s)                        JOptionPane.showMessageDialog(null,"请输入学号");                    else{                        if(borrowBook(isbn,s))                        {                            System.out.println("yes");                            JOptionPane.showMessageDialog(null,"successful!");                        }                        else JOptionPane.showMessageDialog(null,"Wrong!");                    }                }else JOptionPane.showMessageDialog(null,"Choose book!");            }      });        //添加还书监听器        button2.addActionListener(new ActionListener()        {            @Override            public void actionPerformed(ActionEvent e) {                // TODO Auto-generated method stub                int rowNum=borrowtable.getSelectedRow();                System.out.println(rowNum);                if(rowNum>=0)                {                    String isbn=borrowtable.getValueAt(rowNum, 2).toString();                    String tablexh = borrowtable.getValueAt(rowNum, 1).toString();                    System.out.println(isbn);                    String xh=JOptionPane.showInputDialog("请输入学号");                    if (!xh.equals(tablexh))                        JOptionPane.showMessageDialog(null,"学号不正确");                    else{                        if(returnBook(isbn))                        {                            JOptionPane.showMessageDialog(null,"successful!");                        }                        else JOptionPane.showMessageDialog(null,"Wrong!");                    }                }else JOptionPane.showMessageDialog(null,"Choose book!");                }            });    }    public boolean borrowBook(String isbn, String s) {                int xh = Integer.parseInt(s);                int isbn2 =Integer.parseInt(isbn);                System.out.println("学号："+xh);        boolean b=false;        String driver="com.mysql.jdbc.Driver";        String url="jdbc:Mysql://localhost:3306/test";        String user="root";        String passWord="123456";        Connection conn=null;        Statement stmt=null;        try {                 Class.forName(driver);                conn = DriverManager.getConnection(url, user, password);                 stmt = conn.createStatement();                 System.out.println("isbn:"+isbn);               conn.setAutoCommit(false);               String sql1 = "update book set count=count-1 where isbn='"+isbn2+"'";               String sql2 = "insert into borrow(xh,isbn) values('"+xh+"','"+isbn2+"')";               stmt.executeUpdate(sql1);               stmt.executeUpdate(sql2);               System.out.println("isbn2:"+isbn2);               //stmt = (PreparedStatement) conn.prepareStatement("update book set count=count-1 where isbn=?");               conn.commit();               stmt.close();               conn.close();               b=true;        }        catch (Exception e) {                 try{                   conn.rollback();               }catch(Exception e1){e1.printStackTrace();}              }                return b;            }    private boolean returnBook(String isbn) {        int isbn2 =Integer.parseInt(isbn);           boolean b=false;           String driver="com.mysql.jdbc.Driver";           String url="jdbc:mysql://localhost:3306/test";           String user="root";           String password="123456";           Connection conn=null;           Statement stmt=null;           try {               Class.forName(driver);              conn = DriverManager.getConnection(url, user, password);               stmt = conn.createStatement();               conn.setAutoCommit(false);             stmt.executeUpdate("delete from borrow where isbn='"+isbn2+"'");             stmt.executeUpdate("update book set count=count+1 where isbn='"+isbn2+"'");             System.out.println("还书isbn2:"+isbn2);             conn.commit();             stmt.close();             conn.close();             b=true;             }           catch (Exception e) {                 try{                   conn.rollback();                   }catch(Exception e1){e1.printStackTrace();}}             return b;    }    private JTable borrowIn() {        // TODO Auto-generated method stub        String []head={"id","xh","ISBN"};        String [][]data=null;        bookmodel=new DefaultTableModel(data,head);        JTable t=new JTable(bookmodel);        String driver="com.mysql.jdbc.Driver";        String url="jdbc:mysql://localhost:3306/test";        String user="root";        String password="123456";        Connection conn=null;        Statement stmt=null;        ResultSet rs=null;        try {                 Class.forName(driver);                conn = DriverManager.getConnection(url, user, password);                 stmt = conn.createStatement();                 rs=stmt.executeQuery("select * from borrow");                String[] row=new String[3];               while(rs.next()){               row[0]=rs.getString(1);               row[1]=rs.getString(2);               row[2]=rs.getString(3);               bookmodel.addRow(row);               bookmodel.fireTableDataChanged(); }               rs.close();               stmt.close();               conn.close();}        catch (Exception e) {                 // TODO Auto-generated catch block                    System.out.println(e);                }                return t;    }    public  JTable bookIn() {        // TODO Auto-generated method stub        String []head={"ISBN","name","count"};        String [][]data=null;        bmodel=new DefaultTableModel(data,head);        JTable t=new JTable(bmodel);        String driver="com.mysql.jdbc.Driver";        String url="jdbc:mysql://localhost:3306/test";        String user="root";        String password="123456";        Connection conn=null;        Statement stmt=null;        ResultSet rs=null;        try {                 Class.forName(driver);                conn = DriverManager.getConnection(url, user, password);                 stmt = conn.createStatement();                 rs=stmt.executeQuery("select * from book");                String[] row=new String[3];               while(rs.next()){               row[0]=rs.getString(1);               row[1]=rs.getString(2);               row[2]=rs.getString(3);               bmodel.addRow(row);               bmodel.fireTableDataChanged(); }               rs.close();               stmt.close();               conn.close();}        catch (Exception e) {                 // TODO Auto-generated catch block                    System.out.println(e);                }        return t;      }    public static void main(String[] args) {        // TODO Auto-generated method stub        Labmsys n=new Labmsys();         n.setTitle("图书借阅管理系统");        n.setSize(1000,500);        n.setLocationRelativeTo(null);        n.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);        n.setVisible(true);    }}

数据库：

---- Table structure for table `book`--DROP TABLE IF EXISTS `book`;CREATE TABLE `book` (  `ISBN` int(11) NOT NULL,  `name` varchar(50) NOT NULL,  `count` int(11) default NULL,  PRIMARY KEY  (`ISBN`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;---- Dumping data for table `book`--LOCK TABLES `book` WRITE;;INSERT INTO `book` VALUES (662530,'C#',9),(662545,'python',12),(663520,'c++',6),(663548,'java',8);;UNLOCK TABLES;---- Table structure for table `borrow`--DROP TABLE IF EXISTS `borrow`;CREATE TABLE `borrow` (  `id` int(11) NOT NULL auto_increment,  `xh` int(11) NOT NULL,  `isbn` int(11) NOT NULL,  PRIMARY KEY  (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;---- Dumping data for table `borrow`--LOCK TABLES `borrow` WRITE;;INSERT INTO `borrow` VALUES (1006,123456,662545),(1007,456789,663520),(1009,789456,662530),(1010,741852,662530);

运行结果显示：

关于“如何使用java实现简单的图书借阅系统”这篇文章就分享到这里了，希望以上内容可以对大家有一定的帮助，使各位可以学到更多知识，如果觉得文章不错，请把它分享出去让更多的人看到。