AI 助理
备案控制台
开发者社区 云计算 文章 正文

Eclipse+Java+Swing实现图书管理系统（下）

2022-05-25 223
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介： Eclipse+Java+Swing实现图书管理系统

BookInfoFrm.java

package com.sjsq.view;
import java.sql.Connection;
import java.sql.ResultSet;
import java.util.Vector;
import javax.swing.GroupLayout;
import javax.swing.JButton;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.LayoutStyle;
import javax.swing.table.DefaultTableModel;
import com.sjsq.dao.BookDao;
import com.sjsq.dao.BorrowDetailDao;
import com.sjsq.model.Book;
import com.sjsq.model.BorrowDetail;
import com.sjsq.util.DbUtil;
import com.sjsq.util.StringUtil;
import com.sjsq.util.TimeUtil;
public class BookInfoFrm extends JInternalFrame {
  private JTextField bookIdText;
  private JTextField bookName;
  private JTextField bookNameText;
  private JTable bookTable;
  private JButton jB_borrow;
  private JButton jButton1;
  private JLabel jLabel1;
  private JLabel jLabel2;
  private JLabel jLabel3;
  private JPanel jPanel1;
  private JScrollPane jScrollPane1;
  DbUtil dbUtil = new DbUtil();
  BookDao bookDao = new BookDao();
  BorrowDetailDao borrowDetailDao = new BorrowDetailDao();
  public BookInfoFrm() {
    initComponents();
    fillTable(new Book());
    setTitle("书籍信息");
    this.setLocation(200, 50);
  }
  private void fillTable(Book book) {
    DefaultTableModel model = (DefaultTableModel) bookTable.getModel();
    model.setRowCount(0);
    Connection con = null;
    try {
      con = dbUtil.getCon();
      book.setStatus(1);
      ResultSet list = bookDao.list(con, book);
      while (list.next()) {
        Vector rowData = new Vector();
        rowData.add(list.getInt("id"));
        rowData.add(list.getString("book_name"));
        rowData.add(list.getString("type_name"));
        rowData.add(list.getString("author"));
        rowData.add(list.getString("remark"));
        model.addRow(rowData);
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      try {
        dbUtil.closeCon(con);
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
  private void initComponents() {
    jScrollPane1 = new JScrollPane();
    bookTable = new JTable();
    jPanel1 = new JPanel();
    jLabel1 = new JLabel();
    bookNameText = new JTextField();
    jButton1 = new JButton();
    jB_borrow = new JButton();
    jLabel2 = new JLabel();
    bookIdText = new JTextField();
    jLabel3 = new JLabel();
    bookName = new JTextField();
    setClosable(true);
    bookTable.setModel(new DefaultTableModel(new Object[][] {
    }, new String[] { "编号", "书名", "类型", "作者", "描述" }) {
      boolean[] canEdit = new boolean[] { false, false, false, false, false };
      public boolean isCellEditable(int rowIndex, int columnIndex) {
        return canEdit[columnIndex];
      }
    });
    bookTable.addMouseListener(new java.awt.event.MouseAdapter() {
      public void mousePressed(java.awt.event.MouseEvent evt) {
        bookTableMousePressed(evt);
      }
    });
    jScrollPane1.setViewportView(bookTable);
    jLabel1.setText("书籍名称：");
    bookNameText.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        bookNameTextActionPerformed(evt);
      }
    });
    jButton1.setText("查询");
    jButton1.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jButton1ActionPerformed(evt);
      }
    });
    GroupLayout jPanel1Layout = new GroupLayout(jPanel1);
    jPanel1.setLayout(jPanel1Layout);
    jPanel1Layout.setHorizontalGroup(jPanel1Layout.createParallelGroup(GroupLayout.Alignment.LEADING)
        .addGroup(GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
            .addGap(42, 42, 42).addComponent(jLabel1).addGap(36, 36, 36)
            .addComponent(bookNameText, GroupLayout.PREFERRED_SIZE, 130,
                GroupLayout.PREFERRED_SIZE)
            .addPreferredGap(LayoutStyle.ComponentPlacement.RELATED, 149, Short.MAX_VALUE)
            .addComponent(jButton1).addGap(45, 45, 45)));
    jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup(GroupLayout.Alignment.LEADING)
        .addGroup(jPanel1Layout.createSequentialGroup().addGap(23, 23, 23)
            .addGroup(jPanel1Layout.createParallelGroup(GroupLayout.Alignment.BASELINE)
                .addComponent(jButton1).addComponent(jLabel1).addComponent(bookNameText,
                    GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE,
                    GroupLayout.PREFERRED_SIZE))
            .addContainerGap(30, Short.MAX_VALUE)));
    jB_borrow.setText("借书");
    jB_borrow.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jB_borrowActionPerformed(evt);
      }
    });
    jLabel2.setText("编号：");
    bookIdText.setEditable(false);
    jLabel3.setText("书名：");
    bookName.setEditable(false);
    GroupLayout layout = new GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING).addGroup(layout
        .createSequentialGroup().addGap(22, 22, 22)
        .addGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING).addGroup(layout
            .createSequentialGroup().addComponent(jLabel2)
            .addPreferredGap(LayoutStyle.ComponentPlacement.RELATED)
            .addComponent(bookIdText, GroupLayout.PREFERRED_SIZE, 95,
                GroupLayout.PREFERRED_SIZE)
            .addPreferredGap(LayoutStyle.ComponentPlacement.RELATED).addComponent(jLabel3)
            .addGap(18, 18, 18)
            .addComponent(bookName, GroupLayout.PREFERRED_SIZE, 127,
                GroupLayout.PREFERRED_SIZE)
            .addPreferredGap(LayoutStyle.ComponentPlacement.RELATED, 102, Short.MAX_VALUE)
            .addComponent(jB_borrow).addGap(88, 88, 88))
            .addGroup(layout.createSequentialGroup()
                .addGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING, false)
                    .addComponent(jPanel1, GroupLayout.Alignment.TRAILING,
                        GroupLayout.DEFAULT_SIZE,
                        GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jScrollPane1, GroupLayout.Alignment.TRAILING,
                        GroupLayout.DEFAULT_SIZE, 507, Short.MAX_VALUE))
                .addContainerGap(38, Short.MAX_VALUE)))));
    layout.setVerticalGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING)
        .addGroup(layout.createSequentialGroup()
            .addComponent(jPanel1, GroupLayout.PREFERRED_SIZE,
                GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
            .addPreferredGap(LayoutStyle.ComponentPlacement.RELATED)
            .addComponent(jScrollPane1, GroupLayout.PREFERRED_SIZE, 225,
                GroupLayout.PREFERRED_SIZE)
            .addPreferredGap(LayoutStyle.ComponentPlacement.RELATED, 35, Short.MAX_VALUE)
            .addGroup(layout.createParallelGroup(GroupLayout.Alignment.BASELINE)
                .addComponent(jLabel2).addComponent(jLabel3)
                .addComponent(bookIdText, GroupLayout.PREFERRED_SIZE,
                    GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
                .addComponent(bookName, GroupLayout.PREFERRED_SIZE,
                    GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
                .addComponent(jB_borrow))
            .addGap(27, 27, 27)));
    pack();
  }
  private void jB_borrowActionPerformed(java.awt.event.ActionEvent evt) {
    String bookId = this.bookIdText.getText();
    String bookName = this.bookName.getText();
    if (StringUtil.isEmpty(bookId) || StringUtil.isEmpty(bookName)) {
      JOptionPane.showMessageDialog(null, "请选择相关书籍");
      return;
    }
    BorrowDetail borrowDetail = new BorrowDetail();
    borrowDetail.setUserId(LoginFrm.currentUser.getUserId());
    borrowDetail.setBookId(Integer.parseInt(bookId));
    borrowDetail.setStatus(1);
    borrowDetail.setBorrowTime(TimeUtil.getTime());
    Connection con = null;
    try {
      con = dbUtil.getCon();
      // 先查询是否有该书在借
      ResultSet list = borrowDetailDao.list(con, borrowDetail);
      while (list.next()) {
        JOptionPane.showMessageDialog(null, "该书已在借,请先还再借");
        return;
      }
      int i = borrowDetailDao.add(con, borrowDetail);
      if (i == 1) {
        JOptionPane.showMessageDialog(null, "借书成功");
      } else {
        JOptionPane.showMessageDialog(null, "借书失败");
      }
    } catch (Exception e) {
      e.printStackTrace();
      JOptionPane.showMessageDialog(null, "借书异常");
    } finally {
      try {
        dbUtil.closeCon(con);
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
  private void bookTableMousePressed(java.awt.event.MouseEvent evt) {
    int row = this.bookTable.getSelectedRow();
    Object bookId = this.bookTable.getValueAt(row, 0);
    Object bookName = this.bookTable.getValueAt(row, 1);
    this.bookIdText.setText(bookId.toString());
    this.bookName.setText(bookName.toString());
  }
  private void bookNameTextActionPerformed(java.awt.event.ActionEvent evt) {
  }
  private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
    String bookName = this.bookNameText.getText();
    Book book = new Book();
    book.setBookName(bookName);
    fillTable(book);
  }
}

BookTypeAddFrm.java

package com.sjsq.view;
import java.sql.Connection;
import javax.swing.GroupLayout;
import javax.swing.JButton;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import com.sjsq.dao.BookTypeDao;
import com.sjsq.model.BookType;
import com.sjsq.util.DbUtil;
import com.sjsq.util.StringUtil;
public class BookTypeAddFrm extends JInternalFrame {
  private JButton jButton1;
  private JButton jButton2;
  private JLabel jLabel1;
  private JLabel jLabel2;
  private JScrollPane jScrollPane1;
  private JTextField typeNameText;
  private JTextArea typeRemarkTtext;
  DbUtil dbUtil = new DbUtil();
  BookTypeDao bookTypeDao = new BookTypeDao();
  public BookTypeAddFrm() {
    initComponents();
    setTitle("图书类别添加");
    this.setLocation(200, 50);
  }
  private void initComponents() {
    jLabel1 = new JLabel();
    jLabel2 = new JLabel();
    jButton1 = new JButton();
    typeNameText = new JTextField();
    jScrollPane1 = new JScrollPane();
    typeRemarkTtext = new JTextArea();
    jButton2 = new JButton();
    setClosable(true);
    jLabel1.setText("图书类别名称：");
    jLabel2.setText("类别说明：");
    jButton1.setText("添加");
    jButton1.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jButton1ActionPerformed(evt);
      }
    });
    typeRemarkTtext.setColumns(20);
    typeRemarkTtext.setRows(5);
    jScrollPane1.setViewportView(typeRemarkTtext);
    jButton2.setText("重置");
    jButton2.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jButton2ActionPerformed(evt);
      }
    });
    GroupLayout layout = new GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING)
        .addGroup(layout.createSequentialGroup().addGap(49, 49, 49)
            .addGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING, false)
                .addGroup(layout.createSequentialGroup().addComponent(jLabel2).addGap(18, 18, 18)
                    .addComponent(jScrollPane1))
                .addGroup(layout.createSequentialGroup().addComponent(jLabel1).addGap(18, 18, 18)
                    .addComponent(typeNameText, GroupLayout.PREFERRED_SIZE, 241,
                        GroupLayout.PREFERRED_SIZE))
                .addGroup(layout.createSequentialGroup().addComponent(jButton1).addGap(53, 53, 53)
                    .addComponent(jButton2)))
            .addGap(179, 179, 179)));
    layout.setVerticalGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING).addGroup(layout
        .createSequentialGroup().addGap(35, 35, 35)
        .addGroup(layout.createParallelGroup(GroupLayout.Alignment.BASELINE).addComponent(jLabel1)
            .addComponent(typeNameText, GroupLayout.PREFERRED_SIZE,
                GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
        .addGap(43, 43, 43)
        .addGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING).addComponent(jLabel2)
            .addComponent(jScrollPane1, GroupLayout.PREFERRED_SIZE, 134,
                GroupLayout.PREFERRED_SIZE))
        .addGap(41, 41, 41).addGroup(layout.createParallelGroup(GroupLayout.Alignment.BASELINE)
            .addComponent(jButton1).addComponent(jButton2))
        .addContainerGap(62, Short.MAX_VALUE)));
    pack();
  }
  private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
    String typeName = this.typeNameText.getText();
    String typeRemark = this.typeRemarkTtext.getText();
    if (StringUtil.isEmpty(typeName) || StringUtil.isEmpty(typeRemark)) {
      JOptionPane.showMessageDialog(null, "请输入相关信息");
      return;
    }
    BookType bookType = new BookType();
    bookType.setTypeName(typeName);
    bookType.setRemark(typeRemark);
    Connection con = null;
    try {
      con = dbUtil.getCon();
      int i = bookTypeDao.add(con, bookType);
      if (i == 1) {
        JOptionPane.showMessageDialog(null, "添加成功");
        reset();
      } else if (i == 2) {
        JOptionPane.showMessageDialog(null, "添加失败,类别已存在");
      } else {
        JOptionPane.showMessageDialog(null, "添加失败");
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      try {
        dbUtil.closeCon(con);
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
  private void reset() {
    this.typeNameText.setText("");
    this.typeRemarkTtext.setText("");
  }
  private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
    reset();
  }
}

BookTypeManagerFrm.java

package com.sjsq.view;
import java.sql.Connection;
import java.sql.ResultSet;
import java.util.Vector;
import javax.swing.BorderFactory;
import javax.swing.GroupLayout;
import javax.swing.JButton;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.LayoutStyle;
import javax.swing.table.DefaultTableModel;
import com.sjsq.dao.BookTypeDao;
import com.sjsq.model.BookType;
import com.sjsq.util.DbUtil;
import com.sjsq.util.StringUtil;
public class BookTypeManagerFrm extends JInternalFrame {
  private JButton jButton1;
  private JButton jButton2;
  private JLabel jLabel1;
  private JLabel jLabel2;
  private JLabel jLabel3;
  private JPanel jPanel1;
  private JScrollPane jScrollPane1;
  private JTextField typeIdText;
  private JTextField typeNameText;
  private JTextField typeRemarkText;
  private JTable typeTable;
  DbUtil dbUtil = new DbUtil();
  BookTypeDao bookTypeDao = new BookTypeDao();
  public BookTypeManagerFrm() {
    initComponents();
    fillTable();
    setTitle("图书类别修改");
    this.setLocation(200, 30);
  }
  private void fillTable() {
    DefaultTableModel model = (DefaultTableModel) typeTable.getModel();
    model.setRowCount(0);
    Connection con = null;
    try {
      con = dbUtil.getCon();
      ResultSet list = bookTypeDao.list(con, new BookType());
      while (list.next()) {
        Vector rowData = new Vector();
        rowData.add(list.getInt("id"));
        rowData.add(list.getString("type_name"));
        rowData.add(list.getString("remark"));
        model.addRow(rowData);
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      try {
        dbUtil.closeCon(con);
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
  private void initComponents() {
    jScrollPane1 = new JScrollPane();
    typeTable = new JTable();
    jPanel1 = new JPanel();
    jLabel1 = new JLabel();
    jLabel2 = new JLabel();
    jLabel3 = new JLabel();
    typeIdText = new JTextField();
    typeNameText = new JTextField();
    typeRemarkText = new JTextField();
    jButton1 = new JButton();
    jButton2 = new JButton();
    setClosable(true);
    typeTable.setModel(new DefaultTableModel(new Object[][] {
    }, new String[] { "编号", "类别名称", "类别描述" }) {
      boolean[] canEdit = new boolean[] { false, false, false };
      public boolean isCellEditable(int rowIndex, int columnIndex) {
        return canEdit[columnIndex];
      }
    });
    typeTable.addMouseListener(new java.awt.event.MouseAdapter() {
      public void mousePressed(java.awt.event.MouseEvent evt) {
        typeTableMousePressed(evt);
      }
    });
    jScrollPane1.setViewportView(typeTable);
    jPanel1.setBorder(BorderFactory.createTitledBorder("表单操作"));
    jPanel1.setToolTipText("");
    jLabel1.setText("编号：");
    jLabel2.setText("类别名称：");
    jLabel3.setText("描述：");
    typeIdText.setEditable(false);
    jButton1.setText("修改");
    jButton1.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jButton1ActionPerformed(evt);
      }
    });
    jButton2.setText("删除");
    jButton2.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jButton2ActionPerformed(evt);
      }
    });
    GroupLayout jPanel1Layout = new GroupLayout(jPanel1);
    jPanel1.setLayout(jPanel1Layout);
    jPanel1Layout.setHorizontalGroup(jPanel1Layout.createParallelGroup(GroupLayout.Alignment.LEADING)
        .addGroup(jPanel1Layout.createSequentialGroup().addGroup(jPanel1Layout
            .createParallelGroup(GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup().addGap(22, 22, 22).addGroup(jPanel1Layout
                .createParallelGroup(GroupLayout.Alignment.LEADING, false)
                .addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel3).addGap(18, 18, 18)
                    .addComponent(typeRemarkText))
                .addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel1).addGap(18, 18, 18)
                    .addComponent(typeIdText, GroupLayout.PREFERRED_SIZE, 123,
                        GroupLayout.PREFERRED_SIZE)
                    .addGap(18, 18, 18)
                    .addGroup(jPanel1Layout
                        .createParallelGroup(GroupLayout.Alignment.LEADING)
                        .addComponent(jButton2)
                        .addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel2)
                            .addGap(18, 18, 18).addComponent(typeNameText,
                                GroupLayout.PREFERRED_SIZE, 133,
                                GroupLayout.PREFERRED_SIZE))))))
            .addGroup(jPanel1Layout.createSequentialGroup().addGap(41, 41, 41).addComponent(jButton1)))
            .addContainerGap(43, Short.MAX_VALUE)));
    jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup(GroupLayout.Alignment.LEADING)
        .addGroup(jPanel1Layout.createSequentialGroup().addGroup(jPanel1Layout
            .createParallelGroup(GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createParallelGroup(GroupLayout.Alignment.BASELINE)
                .addComponent(jLabel1).addComponent(jLabel2).addComponent(typeNameText,
                    GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE,
                    GroupLayout.PREFERRED_SIZE))
            .addComponent(typeIdText, GroupLayout.PREFERRED_SIZE,
                GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
            .addGap(27, 27, 27)
            .addGroup(jPanel1Layout.createParallelGroup(GroupLayout.Alignment.BASELINE)
                .addComponent(jLabel3).addComponent(typeRemarkText,
                    GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE,
                    GroupLayout.PREFERRED_SIZE))
            .addPreferredGap(LayoutStyle.ComponentPlacement.RELATED, 41, Short.MAX_VALUE)
            .addGroup(jPanel1Layout.createParallelGroup(GroupLayout.Alignment.BASELINE)
                .addComponent(jButton1).addComponent(jButton2))
            .addContainerGap()));
    GroupLayout layout = new GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING).addGroup(layout
        .createSequentialGroup().addGap(42, 42, 42)
        .addGroup(layout.createParallelGroup(GroupLayout.Alignment.TRAILING)
            .addComponent(jPanel1, GroupLayout.Alignment.LEADING,
                GroupLayout.DEFAULT_SIZE, GroupLayout.DEFAULT_SIZE,
                Short.MAX_VALUE)
            .addComponent(jScrollPane1, GroupLayout.Alignment.LEADING,
                GroupLayout.PREFERRED_SIZE, 452, GroupLayout.PREFERRED_SIZE))
        .addContainerGap(49, Short.MAX_VALUE)));
    layout.setVerticalGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING)
        .addGroup(layout.createSequentialGroup().addContainerGap()
            .addComponent(jScrollPane1, GroupLayout.PREFERRED_SIZE, 137,
                GroupLayout.PREFERRED_SIZE)
            .addGap(51, 51, 51)
            .addComponent(jPanel1, GroupLayout.PREFERRED_SIZE,
                GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
            .addContainerGap(30, Short.MAX_VALUE)));
    pack();
  }
  private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
    String typeId = this.typeIdText.getText();
    if (StringUtil.isEmpty(typeId)) {
      JOptionPane.showMessageDialog(null, "请选择相关信息");
      return;
    }
    Connection con = null;
    try {
      con = dbUtil.getCon();
      int i = bookTypeDao.delete(con, typeId);
      if (i == 1) {
        JOptionPane.showMessageDialog(null, "删除成功");
        fillTable();
      } else if (i == 2) {
        JOptionPane.showMessageDialog(null, "删除失败-类别最少保留一个");
      } else if (i == 3) {
        JOptionPane.showMessageDialog(null, "删除失败-该类别下有书籍");
      } else {
        JOptionPane.showMessageDialog(null, "删除失败");
      }
    } catch (Exception e) {
      e.printStackTrace();
      JOptionPane.showMessageDialog(null, "删除异常");
    } finally {
      try {
        dbUtil.closeCon(con);
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
  private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
    String typeId = this.typeIdText.getText();
    String typeName = this.typeNameText.getText();
    String typeRemark = this.typeRemarkText.getText();
    if (StringUtil.isEmpty(typeName) || StringUtil.isEmpty(typeRemark)) {
      JOptionPane.showMessageDialog(null, "请输入相关信息");
      return;
    }
    BookType bookType = new BookType();
    bookType.setTypeId(Integer.parseInt(typeId));
    bookType.setTypeName(typeName);
    bookType.setRemark(typeRemark);
    Connection con = null;
    try {
      con = dbUtil.getCon();
      int i = bookTypeDao.update(con, bookType);
      if (i == 1) {
        JOptionPane.showMessageDialog(null, "修改成功");
        fillTable();
      } else {
        JOptionPane.showMessageDialog(null, "修改失败");
      }
    } catch (Exception e) {
      e.printStackTrace();
      JOptionPane.showMessageDialog(null, "修改异常");
    } finally {
      try {
        dbUtil.closeCon(con);
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
  private void typeTableMousePressed(java.awt.event.MouseEvent evt) {
    int row = this.typeTable.getSelectedRow();
    this.typeIdText.setText(typeTable.getValueAt(row, 0).toString());
    this.typeNameText.setText(typeTable.getValueAt(row, 1).toString());
    this.typeRemarkText.setText(typeTable.getValueAt(row, 2).toString());
  }
}

BorrowDetailFrm.java

package com.sjsq.view;
import java.sql.Connection;
import java.sql.ResultSet;
import java.util.Vector;
import javax.swing.GroupLayout;
import javax.swing.JInternalFrame;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
import com.sjsq.dao.BorrowDetailDao;
import com.sjsq.model.BorrowDetail;
import com.sjsq.util.DbUtil;
import com.sjsq.util.TimeUtil;
public class BorrowDetailFrm extends JInternalFrame {
  private JTable detailTable;
  private JScrollPane jScrollPane1;
  DbUtil dbUtil = new DbUtil();
  BorrowDetailDao borrowDetailDao = new BorrowDetailDao();
  public BorrowDetailFrm() {
    initComponents();
    fillTable(new BorrowDetail());
    setTitle("借还信息");
    this.setLocation(200, 50);
  }
  private void fillTable(BorrowDetail borrowDetail) {
    DefaultTableModel model = (DefaultTableModel) detailTable.getModel();
    model.setRowCount(0);
    Connection con = null;
    try {
      con = dbUtil.getCon();
      ResultSet list = borrowDetailDao.list(con, borrowDetail);
      while (list.next()) {
        Vector rowData = new Vector();
        rowData.add(list.getString("username"));
        rowData.add(list.getString("book_name"));
        int status = list.getInt("status");
        if (status == 1) {
          rowData.add("在借");
        } else {
          rowData.add("已还");
        }
        rowData.add(TimeUtil.getDateByTime(list.getLong("borrow_time")));
        if (status == 2) {
          rowData.add(TimeUtil.getDateByTime(list.getLong("return_time")));
        }
        model.addRow(rowData);
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      try {
        dbUtil.closeCon(con);
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
  private void initComponents() {
    jScrollPane1 = new JScrollPane();
    detailTable = new JTable();
    setClosable(true);
    detailTable.setModel(new DefaultTableModel(new Object[][] {
    }, new String[] { "借书人", "书名", "状态", "借书时间", "还书时间" }) {
      boolean[] canEdit = new boolean[] { false, false, false, false, false };
      public boolean isCellEditable(int rowIndex, int columnIndex) {
        return canEdit[columnIndex];
      }
    });
    jScrollPane1.setViewportView(detailTable);
    GroupLayout layout = new GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING)
        .addGroup(layout.createSequentialGroup().addContainerGap()
            .addComponent(jScrollPane1, GroupLayout.DEFAULT_SIZE, 700, Short.MAX_VALUE)
            .addContainerGap()));
    layout.setVerticalGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING)
        .addGroup(layout
            .createSequentialGroup().addContainerGap().addComponent(jScrollPane1,
                GroupLayout.PREFERRED_SIZE, 366, GroupLayout.PREFERRED_SIZE)
            .addContainerGap(25, Short.MAX_VALUE)));
    pack();
  }
}

LoginFrm.java

package com.sjsq.view;
import java.sql.Connection;
import javax.swing.GroupLayout;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.LayoutStyle;
import javax.swing.WindowConstants;
import com.sjsq.dao.UserDao;
import com.sjsq.model.User;
import com.sjsq.util.DbUtil;
import com.sjsq.util.StringUtil;
public class LoginFrm extends JFrame {
  public static User currentUser;
  private JButton jB_login;
  private JButton jB_reset;
  private JLabel jLabel1;
  private JLabel jLabel2;
  private JLabel jLabel3;
  private JTextField passwordText;
  private JComboBox role;
  private JTextField userNameText;
  UserDao userDao = new UserDao();
  DbUtil dbUtil = new DbUtil();
  public LoginFrm() {
    initComponents();
    this.role.addItem("学生");
    this.role.addItem("管理员");
    this.setLocationRelativeTo(null);
  }
  private void initComponents() {
    jLabel1 = new JLabel();
    jLabel2 = new JLabel();
    jLabel3 = new JLabel();
    jB_login = new JButton();
    jB_reset = new JButton();
    userNameText = new JTextField();
    passwordText = new JTextField();
    role = new JComboBox();
    setTitle("用户登录");
    setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);
    setResizable(false);
    jLabel1.setText("账号：");
    jLabel2.setText("密码：");
    jLabel3.setText("角色：");
    jB_login.setText("登录");
    jB_login.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jB_loginActionPerformed(evt);
      }
    });
    jB_reset.setText("重置");
    jB_reset.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jB_resetActionPerformed(evt);
      }
    });
    GroupLayout layout = new GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING).addGroup(layout
        .createSequentialGroup().addGap(59, 59, 59)
        .addGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup().addComponent(jB_login).addGap(87, 87, 87)
                .addComponent(jB_reset))
            .addGroup(layout.createSequentialGroup()
                .addGroup(layout.createParallelGroup(GroupLayout.Alignment.TRAILING)
                    .addComponent(jLabel3).addComponent(jLabel2).addComponent(jLabel1))
                .addGap(18, 18, 18)
                .addGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING, false)
                    .addComponent(userNameText, GroupLayout.DEFAULT_SIZE, 150,
                        Short.MAX_VALUE)
                    .addComponent(passwordText)
                    .addComponent(role, 0, GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))))
        .addContainerGap(137, Short.MAX_VALUE)));
    layout.setVerticalGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING).addGroup(layout
        .createSequentialGroup().addGap(49, 49, 49)
        .addGroup(layout.createParallelGroup(GroupLayout.Alignment.BASELINE).addComponent(jLabel1)
            .addComponent(userNameText, GroupLayout.PREFERRED_SIZE,
                GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
        .addGap(45, 45, 45)
        .addGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING).addComponent(jLabel2)
            .addComponent(passwordText, GroupLayout.PREFERRED_SIZE,
                GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
        .addGap(33, 33, 33)
        .addGroup(layout.createParallelGroup(GroupLayout.Alignment.BASELINE).addComponent(jLabel3)
            .addComponent(role, GroupLayout.PREFERRED_SIZE,
                GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
        .addPreferredGap(LayoutStyle.ComponentPlacement.RELATED, 42, Short.MAX_VALUE)
        .addGroup(layout.createParallelGroup(GroupLayout.Alignment.BASELINE).addComponent(jB_login)
            .addComponent(jB_reset))
        .addGap(37, 37, 37)));
    pack();
  }
  private void jB_loginActionPerformed(java.awt.event.ActionEvent evt) {
    String userName = this.userNameText.getText();
    String password = this.passwordText.getText();
    int index = this.role.getSelectedIndex();
    if (StringUtil.isEmpty(userName) || StringUtil.isEmpty(password)) {
      JOptionPane.showMessageDialog(null, "请输入相关信息");
      return;
    }
    User user = new User();
    user.setUserName(userName);
    user.setPassword(password);
    if (index == 0) {
      user.setRole(1);
    } else {
      user.setRole(2);
    }
    Connection con = null;
    try {
      con = dbUtil.getCon();
      User login = userDao.login(con, user);
      currentUser = login;
      if (login == null) {
        JOptionPane.showMessageDialog(null, "登录失败");
      } else {
        // 角色 1普通 2管理员
        if (index == 0) {
          // 学生
          this.dispose();
          new UserMainFrm().setVisible(true);
        } else {
          // 管理员
          this.dispose();
          new AdminMainFrm().setVisible(true);
        }
      }
    } catch (Exception e) {
      e.printStackTrace();
      JOptionPane.showMessageDialog(null, "登录异常");
    } finally {
      try {
        dbUtil.closeCon(con);
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
  private void reset() {
    this.userNameText.setText("");
    this.passwordText.setText("");
  }
  private void jB_resetActionPerformed(java.awt.event.ActionEvent evt) {
    reset();
  }
  public static void main(String args[]) {
    java.awt.EventQueue.invokeLater(new Runnable() {
      public void run() {
        new LoginFrm().setVisible(true);
      }
    });
  }
}

RegisterFrm.java

package com.sjsq.view;
import java.sql.Connection;
import javax.swing.GroupLayout;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.LayoutStyle;
import javax.swing.WindowConstants;
import com.sjsq.dao.UserDao;
import com.sjsq.model.User;
import com.sjsq.util.DbUtil;
import com.sjsq.util.StringUtil;
public class RegisterFrm extends JFrame {
  private JButton jButton1;
  private JButton jButton2;
  private JLabel jLabel1;
  private JLabel jLabel2;
  private JTextField passwordText;
  private JTextField userNameText;
  DbUtil dbUtil = new DbUtil();
  UserDao userDao = new UserDao();
  public RegisterFrm() {
    initComponents();
    this.setLocationRelativeTo(null);
  }
  private void initComponents() {
    jLabel1 = new JLabel();
    jLabel2 = new JLabel();
    jButton1 = new JButton();
    jButton2 = new JButton();
    userNameText = new JTextField();
    passwordText = new JTextField();
    setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);
    setTitle("用户注册");
    setResizable(false);
    jLabel1.setText("账号：");
    jLabel2.setText("密码：");
    jButton1.setText("注册");
    jButton1.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jButton1ActionPerformed(evt);
      }
    });
    jButton2.setText("重置");
    jButton2.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jButton2ActionPerformed(evt);
      }
    });
    GroupLayout layout = new GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING).addGroup(layout
        .createSequentialGroup().addGap(60, 60, 60)
        .addGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup().addComponent(jButton1).addGap(77, 77, 77)
                .addComponent(jButton2))
            .addGroup(layout.createSequentialGroup()
                .addGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel1).addComponent(jLabel2))
                .addGap(37, 37, 37)
                .addGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING, false)
                    .addComponent(passwordText).addComponent(userNameText,
                        GroupLayout.DEFAULT_SIZE, 144, Short.MAX_VALUE))))
        .addContainerGap(123, Short.MAX_VALUE)));
    layout.setVerticalGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING).addGroup(layout
        .createSequentialGroup().addGap(49, 49, 49)
        .addGroup(layout.createParallelGroup(GroupLayout.Alignment.BASELINE).addComponent(jLabel1)
            .addComponent(userNameText, GroupLayout.PREFERRED_SIZE,
                GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
        .addGap(48, 48, 48)
        .addGroup(layout.createParallelGroup(GroupLayout.Alignment.BASELINE).addComponent(jLabel2)
            .addComponent(passwordText, GroupLayout.PREFERRED_SIZE,
                GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
        .addPreferredGap(LayoutStyle.ComponentPlacement.RELATED, 68, Short.MAX_VALUE)
        .addGroup(layout.createParallelGroup(GroupLayout.Alignment.BASELINE).addComponent(jButton1)
            .addComponent(jButton2))
        .addGap(64, 64, 64)));
    pack();
  }
  private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
    String userName = this.userNameText.getText();
    String password = this.passwordText.getText();
    if (StringUtil.isEmpty(userName) || StringUtil.isEmpty(password)) {
      JOptionPane.showMessageDialog(null, "请输入相关信息");
      return;
    }
    User user = new User();
    user.setUserName(userName);
    user.setPassword(password);
    user.setRole(1);
    Connection con = null;
    try {
      con = dbUtil.getCon();
      int i = userDao.addUser(con, user);
      if (i == 2) {
        JOptionPane.showMessageDialog(null, "该用户名已存在,请重新注册");
      } else if (i == 0) {
        JOptionPane.showMessageDialog(null, "注册失败");
      } else {
        JOptionPane.showMessageDialog(null, "注册成功");
        this.dispose();
        new LoginFrm().setVisible(true);
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      try {
        dbUtil.closeCon(con);
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
  private void reset() {
    this.userNameText.setText("");
    this.passwordText.setText("");
  }
  private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
    reset();
  }
  public static void main(String args[]) {
    java.awt.EventQueue.invokeLater(new Runnable() {
      public void run() {
        new RegisterFrm().setVisible(true);
      }
    });
  }
}

UserBorrowDetail.java

package com.sjsq.view;
import java.sql.Connection;
import java.sql.ResultSet;
import java.util.Vector;
import javax.swing.GroupLayout;
import javax.swing.JButton;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.LayoutStyle;
import javax.swing.table.DefaultTableModel;
import com.sjsq.dao.BorrowDetailDao;
import com.sjsq.model.BorrowDetail;
import com.sjsq.util.DbUtil;
import com.sjsq.util.StringUtil;
import com.sjsq.util.TimeUtil;
public class UserBorrowDetail extends JInternalFrame {
  private JTextField borrowIdText;
  private JTable borrowTbale;
  private JButton jB_return;
  private JLabel jLabel1;
  private JScrollPane jScrollPane1;
  DbUtil dbUtil = new DbUtil();
  BorrowDetailDao borrowDetailDao = new BorrowDetailDao();
  public UserBorrowDetail() {
    initComponents();
    fillTable(new BorrowDetail());
    this.jB_return.setVisible(false);
    setTitle("借还信息");
    this.setLocation(200, 50);
  }
  private void fillTable(BorrowDetail borrowDetail) {
    DefaultTableModel model = (DefaultTableModel) borrowTbale.getModel();
    model.setRowCount(0);
    Integer userId = LoginFrm.currentUser.getUserId();
    Connection con = null;
    try {
      con = dbUtil.getCon();
      borrowDetail.setUserId(userId);
      ResultSet list = borrowDetailDao.list(con, borrowDetail);
      while (list.next()) {
        Vector rowData = new Vector();
        rowData.add(list.getInt("id"));
        rowData.add(list.getString("book_name"));
        int status = list.getInt("status");
        if (status == 1) {
          rowData.add("在借");
        }
        if (status == 2) {
          rowData.add("已还");
        }
        rowData.add(TimeUtil.getDateByTime(list.getLong("borrow_time")));
        if (status == 2) {
          rowData.add(TimeUtil.getDateByTime(list.getLong("return_time")));
        }
        model.addRow(rowData);
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      try {
        dbUtil.closeCon(con);
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
  private void initComponents() {
    jScrollPane1 = new JScrollPane();
    borrowTbale = new JTable();
    jLabel1 = new JLabel();
    borrowIdText = new JTextField();
    jB_return = new JButton();
    setClosable(true);
    borrowTbale.setModel(new DefaultTableModel(new Object[][] {
    }, new String[] { "编号", "书名", "状态", "借书时间", "还书时间" }) {
      boolean[] canEdit = new boolean[] { false, false, false, false, false };
      public boolean isCellEditable(int rowIndex, int columnIndex) {
        return canEdit[columnIndex];
      }
    });
    borrowTbale.addMouseListener(new java.awt.event.MouseAdapter() {
      public void mousePressed(java.awt.event.MouseEvent evt) {
        borrowTbaleMousePressed(evt);
      }
    });
    jScrollPane1.setViewportView(borrowTbale);
    jLabel1.setText("编号：");
    borrowIdText.setEditable(false);
    jB_return.setText("还书");
    jB_return.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jB_returnActionPerformed(evt);
      }
    });
    GroupLayout layout = new GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING)
        .addGroup(layout.createSequentialGroup().addGap(35, 35, 35).addComponent(jLabel1).addGap(38, 38, 38)
            .addComponent(borrowIdText, GroupLayout.PREFERRED_SIZE, 114,
                GroupLayout.PREFERRED_SIZE)
            .addPreferredGap(LayoutStyle.ComponentPlacement.RELATED, 282, Short.MAX_VALUE)
            .addComponent(jB_return).addGap(44, 44, 44))
        .addGroup(layout.createSequentialGroup().addContainerGap()
            .addComponent(jScrollPane1, GroupLayout.DEFAULT_SIZE, 700, Short.MAX_VALUE)
            .addContainerGap()));
    layout.setVerticalGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING).addGroup(layout
        .createSequentialGroup()
        .addComponent(jScrollPane1, GroupLayout.PREFERRED_SIZE, 239,
            GroupLayout.PREFERRED_SIZE)
        .addGap(18, 18, 18)
        .addGroup(layout.createParallelGroup(GroupLayout.Alignment.BASELINE).addComponent(jLabel1)
            .addComponent(borrowIdText, GroupLayout.PREFERRED_SIZE,
                GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
            .addComponent(jB_return))
        .addContainerGap(26, Short.MAX_VALUE)));
    pack();
  }
  private void jB_returnActionPerformed(java.awt.event.ActionEvent evt) {
    String BorrowStr = this.borrowIdText.getText();
    if (StringUtil.isEmpty(BorrowStr)) {
      JOptionPane.showMessageDialog(null, "请选择未还的书籍");
      return;
    }
    BorrowDetail detail = new BorrowDetail();
    detail.setBorrowId(Integer.parseInt(BorrowStr));
    detail.setStatus(2);
    detail.setReturnTime(TimeUtil.getTime());
    Connection con = null;
    try {
      con = dbUtil.getCon();
      int i = borrowDetailDao.returnBook(con, detail);
      if (i == 1) {
        JOptionPane.showMessageDialog(null, "还书成功");
      } else {
        JOptionPane.showMessageDialog(null, "还书失败");
      }
    } catch (Exception e) {
      e.printStackTrace();
      JOptionPane.showMessageDialog(null, "还书异常");
    } finally {
      try {
        dbUtil.closeCon(con);
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
    fillTable(new BorrowDetail());
  }
  private void borrowTbaleMousePressed(java.awt.event.MouseEvent evt) {
    int row = borrowTbale.getSelectedRow();
    Integer borrowId = (Integer) borrowTbale.getValueAt(row, 0);
    String status = (String) borrowTbale.getValueAt(row, 2);
    this.borrowIdText.setText(borrowId.toString());
    if (status.equals("在借")) {
      this.jB_return.setVisible(true);
    } else {
      this.jB_return.setVisible(false);
    }
  }
}

UserInfoFrm.java

package com.sjsq.view;
import java.sql.Connection;
import java.sql.ResultSet;
import java.util.Vector;
import javax.swing.BorderFactory;
import javax.swing.GroupLayout;
import javax.swing.JButton;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.LayoutStyle;
import javax.swing.table.DefaultTableModel;
import com.sjsq.dao.UserDao;
import com.sjsq.model.User;
import com.sjsq.util.DbUtil;
import com.sjsq.util.StringUtil;
public class UserInfoFrm extends JInternalFrame {
  private JButton jButton1;
  private JButton jButton2;
  private JLabel jLabel1;
  private JLabel jLabel2;
  private JLabel jLabel3;
  private JLabel jLabel4;
  private JLabel jLabel5;
  private JPanel jPanel1;
  private JPanel jPanel2;
  private JScrollPane jScrollPane1;
  private JTextField passwordText;
  private JTextField userIdText;
  private JTextField userNameText;
  private JTextField userNaneSelectText;
  private JTable userTable;
  DbUtil dbUtil = new DbUtil();
  UserDao userDao = new UserDao();
  public UserInfoFrm() {
    initComponents();
    fillTable(new User());
    setTitle("用户信息");
    this.setLocation(200, 50);
  }
  private void fillTable(User user) {
    DefaultTableModel model = (DefaultTableModel) userTable.getModel();
    model.setRowCount(0);
    Connection con = null;
    try {
      con = dbUtil.getCon();
      ResultSet list = userDao.list(con, user);
      while (list.next()) {
        Vector rowData = new Vector();
        rowData.add(list.getInt("id"));
        rowData.add(list.getString("username"));
        rowData.add(list.getString("password"));
        model.addRow(rowData);
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      try {
        dbUtil.closeCon(con);
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
  private void initComponents() {
    jLabel2 = new JLabel();
    jScrollPane1 = new JScrollPane();
    userTable = new JTable();
    jPanel1 = new JPanel();
    jLabel1 = new JLabel();
    jButton1 = new JButton();
    userNaneSelectText = new JTextField();
    jPanel2 = new JPanel();
    jLabel3 = new JLabel();
    userIdText = new JTextField();
    jLabel4 = new JLabel();
    userNameText = new JTextField();
    jLabel5 = new JLabel();
    passwordText = new JTextField();
    jButton2 = new JButton();
    jLabel2.setText("jLabel2");
    setClosable(true);
    userTable.setModel(new DefaultTableModel(new Object[][] {
    }, new String[] { "编号", "账号", "密码" }) {
      boolean[] canEdit = new boolean[] { false, false, false };
      public boolean isCellEditable(int rowIndex, int columnIndex) {
        return canEdit[columnIndex];
      }
    });
    userTable.addMouseListener(new java.awt.event.MouseAdapter() {
      public void mousePressed(java.awt.event.MouseEvent evt) {
        userTableMousePressed(evt);
      }
    });
    jScrollPane1.setViewportView(userTable);
    jPanel1.setBorder(BorderFactory.createTitledBorder("表单操作"));
    jLabel1.setText("账号：");
    jButton1.setText("查询");
    jButton1.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jButton1ActionPerformed(evt);
      }
    });
    GroupLayout jPanel1Layout = new GroupLayout(jPanel1);
    jPanel1.setLayout(jPanel1Layout);
    jPanel1Layout.setHorizontalGroup(jPanel1Layout.createParallelGroup(GroupLayout.Alignment.LEADING)
        .addGroup(jPanel1Layout.createSequentialGroup().addContainerGap().addComponent(jLabel1)
            .addGap(18, 18, 18)
            .addComponent(userNaneSelectText, GroupLayout.DEFAULT_SIZE, 184, Short.MAX_VALUE)
            .addGap(18, 18, 18).addComponent(jButton1).addContainerGap()));
    jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup(GroupLayout.Alignment.LEADING)
        .addGroup(jPanel1Layout.createSequentialGroup().addGroup(jPanel1Layout
            .createParallelGroup(GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createParallelGroup(GroupLayout.Alignment.BASELINE)
                .addComponent(jLabel1).addComponent(userNaneSelectText,
                    GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE,
                    GroupLayout.PREFERRED_SIZE))
            .addComponent(jButton1))
            .addContainerGap(GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)));
    jPanel2.setBorder(BorderFactory.createTitledBorder("用户操作"));
    jLabel3.setText("编号：");
    userIdText.setEditable(false);
    jLabel4.setText("账号：");
    jLabel5.setText("密码：");
    jButton2.setText("修改");
    jButton2.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jButton2ActionPerformed(evt);
      }
    });
    GroupLayout jPanel2Layout = new GroupLayout(jPanel2);
    jPanel2.setLayout(jPanel2Layout);
    jPanel2Layout.setHorizontalGroup(jPanel2Layout.createParallelGroup(GroupLayout.Alignment.LEADING)
        .addGroup(jPanel2Layout.createSequentialGroup().addContainerGap()
            .addGroup(jPanel2Layout.createParallelGroup(GroupLayout.Alignment.LEADING)
                .addGroup(jPanel2Layout.createSequentialGroup().addComponent(jLabel3)
                    .addPreferredGap(LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(userIdText, GroupLayout.PREFERRED_SIZE, 85,
                        GroupLayout.PREFERRED_SIZE)
                    .addGap(18, 18, 18).addComponent(jLabel4))
                .addGroup(jPanel2Layout.createSequentialGroup().addComponent(jLabel5)
                    .addPreferredGap(LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(passwordText, GroupLayout.PREFERRED_SIZE, 88,
                        GroupLayout.PREFERRED_SIZE)))
            .addGroup(jPanel2Layout.createParallelGroup(GroupLayout.Alignment.LEADING)
                .addGroup(jPanel2Layout.createSequentialGroup().addGap(37, 37, 37).addComponent(
                    userNameText, GroupLayout.PREFERRED_SIZE, 94,
                    GroupLayout.PREFERRED_SIZE))
                .addGroup(jPanel2Layout.createSequentialGroup().addGap(8, 8, 8).addComponent(jButton2)))
            .addContainerGap(26, Short.MAX_VALUE)));
    jPanel2Layout.setVerticalGroup(jPanel2Layout.createParallelGroup(GroupLayout.Alignment.LEADING)
        .addGroup(jPanel2Layout.createSequentialGroup()
            .addGroup(jPanel2Layout.createParallelGroup(GroupLayout.Alignment.BASELINE)
                .addComponent(jLabel3).addComponent(jLabel4)
                .addComponent(userIdText, GroupLayout.PREFERRED_SIZE,
                    GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
                .addComponent(userNameText, GroupLayout.PREFERRED_SIZE,
                    GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
            .addGap(29, 29, 29)
            .addGroup(jPanel2Layout.createParallelGroup(GroupLayout.Alignment.BASELINE)
                .addComponent(jLabel5)
                .addComponent(passwordText, GroupLayout.PREFERRED_SIZE,
                    GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
                .addComponent(jButton2))
            .addContainerGap(37, Short.MAX_VALUE)));
    GroupLayout layout = new GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING).addGroup(layout
        .createSequentialGroup().addGap(24, 24, 24)
        .addGroup(layout.createParallelGroup(GroupLayout.Alignment.TRAILING)
            .addComponent(jPanel2, GroupLayout.Alignment.LEADING,
                GroupLayout.DEFAULT_SIZE, GroupLayout.DEFAULT_SIZE,
                Short.MAX_VALUE)
            .addComponent(jScrollPane1, GroupLayout.Alignment.LEADING, 0, 0, Short.MAX_VALUE)
            .addComponent(jPanel1, GroupLayout.Alignment.LEADING,
                GroupLayout.DEFAULT_SIZE, GroupLayout.DEFAULT_SIZE,
                Short.MAX_VALUE))
        .addGap(226, 226, 226)));
    layout.setVerticalGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING)
        .addGroup(layout.createSequentialGroup()
            .addComponent(jPanel1, GroupLayout.PREFERRED_SIZE,
                GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
            .addGap(28, 28, 28)
            .addComponent(jScrollPane1, GroupLayout.PREFERRED_SIZE, 136,
                GroupLayout.PREFERRED_SIZE)
            .addPreferredGap(LayoutStyle.ComponentPlacement.UNRELATED)
            .addComponent(jPanel2, GroupLayout.PREFERRED_SIZE,
                GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
            .addContainerGap(16, Short.MAX_VALUE)));
    pack();
  }
  private void userTableMousePressed(java.awt.event.MouseEvent evt) {
    int row = this.userTable.getSelectedRow();
    this.userIdText.setText(userTable.getValueAt(row, 0).toString());
    this.userNameText.setText(userTable.getValueAt(row, 1).toString());
    this.passwordText.setText(userTable.getValueAt(row, 2).toString());
  }
  private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
    String userId = this.userIdText.getText();
    String userName = this.userNameText.getText();
    String password = this.passwordText.getText();
    if (StringUtil.isEmpty(userName) || StringUtil.isEmpty(password)) {
      JOptionPane.showMessageDialog(null, "请输入相关信息");
      return;
    }
    User user = new User();
    user.setUserId(Integer.parseInt(userId));
    user.setUserName(userName);
    user.setPassword(password);
    Connection con = null;
    try {
      con = dbUtil.getCon();
      int i = userDao.update(con, user);
      if (i == 1) {
        JOptionPane.showMessageDialog(null, "修改成功");
        fillTable(new User());
      } else {
        JOptionPane.showMessageDialog(null, "修改失败");
      }
    } catch (Exception e) {
      e.printStackTrace();
      JOptionPane.showMessageDialog(null, "修改异常");
    } finally {
      try {
        dbUtil.closeCon(con);
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
  private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
    String userName = this.userNaneSelectText.getText();
    User user = new User();
    user.setUserName(userName);
    fillTable(user);
  }
}

UserMainFrm.java

package com.sjsq.view;
import javax.swing.GroupLayout;
import javax.swing.JDesktopPane;
import javax.swing.JFrame;
import javax.swing.JMenu;
import javax.swing.JMenuBar;
import javax.swing.JMenuItem;
import javax.swing.JOptionPane;
import javax.swing.WindowConstants;
public class UserMainFrm extends JFrame {
  private JMenu jMenu1;
  private JMenuBar jMenuBar1;
  private JMenuItem jMenuItem1;
  private JMenuItem jMenuItem2;
  private JMenuItem jMenuItem3;
  private JDesktopPane userMainjdp;
  public UserMainFrm() {
    initComponents();
    // 设置位置
    setBounds(100, 200, 1050, 650);
    // 居中显示
    this.setLocationRelativeTo(null);
  }
  private void initComponents() {
    userMainjdp = new JDesktopPane();
    jMenuBar1 = new JMenuBar();
    jMenu1 = new JMenu();
    jMenuItem1 = new JMenuItem();
    jMenuItem2 = new JMenuItem();
    jMenuItem3 = new JMenuItem();
    setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);
    setTitle("图书者主界面");
    jMenu1.setText("基本信息");
    jMenuItem1.setText("书籍信息");
    jMenuItem1.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jMenuItem1ActionPerformed(evt);
      }
    });
    jMenu1.add(jMenuItem1);
    jMenuItem2.setText("借书记录");
    jMenuItem2.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jMenuItem2ActionPerformed(evt);
      }
    });
    jMenu1.add(jMenuItem2);
    jMenuItem3.setText("退出系统");
    jMenuItem3.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jMenuItem3ActionPerformed(evt);
      }
    });
    jMenu1.add(jMenuItem3);
    jMenuBar1.add(jMenu1);
    setJMenuBar(jMenuBar1);
    GroupLayout layout = new GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING).addComponent(userMainjdp,
        GroupLayout.DEFAULT_SIZE, 400, Short.MAX_VALUE));
    layout.setVerticalGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING).addComponent(userMainjdp,
        GroupLayout.DEFAULT_SIZE, 279, Short.MAX_VALUE));
    pack();
  }
  private void jMenuItem3ActionPerformed(java.awt.event.ActionEvent evt) {
    int i = JOptionPane.showConfirmDialog(null, "确认退出系统");
    if (i == 0) {
      this.dispose();
    }
  }
  private void jMenuItem2ActionPerformed(java.awt.event.ActionEvent evt) {
    UserBorrowDetail userBorrowDetail = new UserBorrowDetail();
    userBorrowDetail.setVisible(true);
    this.userMainjdp.add(userBorrowDetail);
  }
  private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {
    BookInfoFrm infoFrm = new BookInfoFrm();
    infoFrm.setVisible(true);
    this.userMainjdp.add(infoFrm);
  }
  public static void main(String args[]) {
    java.awt.EventQueue.invokeLater(new Runnable() {
      public void run() {
        new UserMainFrm().setVisible(true);
      }
    });
  }
}

UserManagerFrm.java

package com.sjsq.view;
import javax.swing.GroupLayout;
import javax.swing.JInternalFrame;
public class UserManagerFrm extends JInternalFrame {
  public UserManagerFrm() {
    initComponents();
  }
  private void initComponents() {
    setClosable(true);
    GroupLayout layout = new GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(
        layout.createParallelGroup(GroupLayout.Alignment.LEADING).addGap(0, 394, Short.MAX_VALUE));
    layout.setVerticalGroup(
        layout.createParallelGroup(GroupLayout.Alignment.LEADING).addGap(0, 278, Short.MAX_VALUE));
    pack();
  }
}


四、其他

1.其他系统实现


JavaWeb系统系列实现

Java+JSP实现学生图书管理系统

Java+JSP实现学生信息管理系统

Java+JSP实现用户信息管理系统

Java+Servlet+JSP实现航空订票系统

Java+Servlet+JSP实现房屋租赁管理系统

Java+Servlet+JSP实现学生选课管理系统

Java+Servlet+JSP实现学生成绩管理系统

Java+Servlet+JSP实现宠物诊所管理系统

Java+SSM+Easyui实现网上考试系统

Java+Springboot+H-ui实现营销管理系统

Java+Springboot+Mybatis+Bootstrap实现网上商城系统


JavaSwing系统系列实现

Java+Swing实现斗地主游戏

Java+Swing实现图书管理系统

Java+Swing实现医院管理系统

Java+Swing实现仓库管理系统

Java+Swing实现考试管理系统

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

Java+Swing实现停车场管理系统

Java+Swing实现学生信息管理系统

Java+Swing实现学生宿舍管理系统

Java+Swing实现学生选课管理系统

Java+Swing实现学生成绩管理系统

Java+Swing实现学校教材管理系统

Java+Swing实现学校教务管理系统

Java+Swing实现企业人事管理系统

Java+Swing实现电子相册管理系统

Java+Swing实现自助取款机(ATM)系统

Java+Swing实现超市管理系统-TXT存储信息

Java+Swing实现宠物商店管理系统-TXT存储信息


文章标签：
存储
关键词：
Java swing
Eclipse java
Java图书管理系统
Java eclipse
Eclipse swing
水坚石青
目录
相关文章
栈江湖
|
7天前
|
存储 IDE Java
漂亮不是梦！Java Swing美化攻略
Java Swing 是一个为 Java 设计的 GUI 工具包，提供文本框、按钮等组件。尽管其外观可定制，通过 Look and Feel（LAF）机制改变应用风格，如 Darcula 和 FlatLaf，但现已淡出主流视野，主要应用于 IDE 领域，如 IntelliJ IDEA 和 Eclipse。相比其他 GUI 框架，Swing 的发展前景有限。
栈江湖
18 1
听白
|
1月前
|
Java Android开发
Eclipse Java 构建路径
Eclipse Java 构建路径
听白
39 3
听白
|
1月前
|
Java Android开发
Eclipse 创建 Java 项目
Eclipse 创建 Java 项目
听白
48 4
听白
|
1月前
|
Java Android开发
Eclipse 创建 Java 接口
Eclipse 创建 Java 接口
听白
33 1
听白
|
1月前
|
Java Android开发
Eclipse 创建 Java 包
Eclipse 创建 Java 包
听白
33 1
2的n次方_
|
3月前
|
存储 Java
Java——图书管理系统
该文档详细介绍了一个图书管理系统的设计与实现。系统包含普通用户和管理员两种角色，通过书架操作图书，如添加、查找、借阅、归还及删除图书等功能。文档展示了各个功能的具体代码实现，并使用继承和接口等方式优化了系统结构。通过多态技术实现了不同用户角色调用相应功能。整体设计清晰，逻辑严谨，便于理解和实现。
2的n次方_
198 17
Java——图书管理系统
听白
|
1月前
|
Java Android开发
Eclipse 创建 Java 类
Eclipse 创建 Java 类
听白
29 0
wljslmz
|
4月前
|
安全 Java API
“Java中哪种Swing API方法是线程安全的？
【8月更文挑战第23天】
wljslmz
61 2
Jay17
|
4月前
|
Java 网络安全 开发工具
新手入门Java。如何下载Eclipse、写出最基本的“Hello word”以及如何连接github并且上传项目。
新手入门Java。如何下载Eclipse、写出最基本的“Hello word”以及如何连接github并且上传项目。
Jay17
64 0
米码收割机
|
4月前
|
SQL Java 数据库连接
【Java】Java Swing 图书管借阅管理系统（源码+论文）【独一无二】
【Java】Java Swing 图书管借阅管理系统（源码+论文）【独一无二】
米码收割机
284 0

热门文章

最新文章

  • 1
    C语言调试是开发中的重要技能，涵盖基本技巧如打印输出、断点调试和单步执行，以及使用GCC、GDB、Visual Studio和Eclipse CDT等工具。
  • 2
    Eclipse 快捷键
  • 3
    Eclipse 内置浏览器
  • 4
    Eclipse 代码模板
  • 5
    Eclipse 重启选项
  • 6
    Java volatile关键字：你真的懂了吗？
  • 7
    java小工具util系列2：字符串工具
  • 8
    Java爬虫：数据采集的强大工具
  • 9
    Java多线程并发编程：同步机制与实践应用
  • 10
    Java中的异常处理：从基础到高级
  • 1
    【Java开发指南 | 第三十一篇】Java 包(package)
    84
  • 2
    【Java开发指南 | 第二十九篇】Java接口
    50
  • 3
    【Java开发指南 | 第二十八篇】Java封装
    60
  • 4
    【Java开发指南 | 第二十六篇】Java多态
    41
  • 5
    【Java开发指南 | 第二十四篇】Java继承
    61
  • 6
    【Java开发指南 | 第九篇】访问实例变量和方法、继承、接口
    59
  • 7
    【Java开发指南 | 第八篇】Java变量、构造方法、创建对象
    93
  • 8
    Java Stream API详解与使用
    99
  • 9
    Java医院绩效考核系统源码B/S+avue+MySQL助力医院实现精细化管理
    82
  • 10
    《手把手教你》系列技巧篇（四十三）-java+ selenium自动化测试-处理https 安全问题或者非信任站点-上篇（详解教程）
    134

    • 相关课程

    更多
  • Java面试疑难点解析 - 面试技巧及语言基础
  • Java面试疑难点解析 - Java Web开发
  • Java面试疑难点解析 - 系统架构及项目设计
  • Java编程入门
  • Java面向对象编程
  • Java高级编程

    • 相关电子书

    更多
  • Spring Cloud Alibaba - 重新定义 Java Cloud-Native
  • The Reactive Cloud Native Arch
  • JAVA开发手册1.5.0

    • 相关实验场景

    更多
  • 阿里云平台上进行Java程序的编译与运行
  • 使用Java面向对象编写网络通信程序应用
  • 手动部署Java Web环境（Alibaba Cloud Linux 2）
  • 搭建Java Web开发环境（Anolis OS）
  • RocketMQ中使用Java客户端发送消息和消费的应用
  • 部署基于Dragonwell的Java运行环境

    • 推荐镜像

    更多
  • eclipse
  • maven
  • nodejs-release
    • 下一篇
    手把手教你白嫖阿里云服务器(免费领服务器)