JAVA-最简单的图书管理系统-增删改查-MYSQL-GUI

package com.java.view; import java.awt.EventQueue; import javax.swing.JInternalFrame; import java.awt.Color; import javax.swing.GroupLayout; import javax.swing.GroupLayout.Alignment; import javax.swing.JScrollPane; import java.awt.SystemColor; import java.util.ArrayList; import java.util.Vector; import javax.swing.JTable; import javax.swing.table.DefaultTableModel; import com.cn.dao.BookDao; import com.cn.model.Book; import javax.swing.ScrollPaneConstants; import javax.swing.JLabel; import javax.swing.JTextField; import javax.swing.LayoutStyle.ComponentPlacement; import javax.swing.JButton; import java.awt.event.ActionListener; import java.awt.event.ActionEvent; import javax.swing.JPanel; import javax.swing.border.TitledBorder; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; public class UpdateBook extends JInternalFrame { private JTable booktable; private JTextField findbookname; private JTextField upbookid; private JTextField upbookname; private JTextField upauthor; private JTextField upprice; private JTextField upother; /** * Launch the application. */ public static void main(String[] args) { EventQueue.invokeLater(new Runnable() { public void run() { try { UpdateBook frame = new UpdateBook(); frame.setVisible(true); } catch (Exception e) { e.printStackTrace(); } } }); } /** * Create the frame. */ public UpdateBook() { setIconifiable(true); setClosable(true); setBackground(new Color(0, 139, 139)); setForeground(SystemColor.control); setTitle("\u56FE\u4E66\u7EF4\u62A4"); setBounds(100, 100, 589, 489); JScrollPane scrollPane = new JScrollPane(); scrollPane.setVerticalScrollBarPolicy(ScrollPaneConstants.VERTICAL_SCROLLBAR_NEVER); scrollPane.setHorizontalScrollBarPolicy(ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER); scrollPane.setEnabled(false); JLabel label = new JLabel("\u4E66\u540D\uFF1A"); findbookname = new JTextField(); findbookname.setColumns(10); JButton btnNewButton = new JButton("\u67E5\u627E"); btnNewButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { listbook(); } }); JPanel panel = new JPanel(); panel.setBorder(new TitledBorder(null, "\u56FE\u4E66\u7EF4\u62A4\u64CD\u4F5C", TitledBorder.LEADING, TitledBorder.TOP, null, null)); GroupLayout groupLayout = new GroupLayout(getContentPane()); groupLayout.setHorizontalGroup( groupLayout.createParallelGroup(Alignment.LEADING) .addGroup(groupLayout.createSequentialGroup() .addGap(55) .addGroup(groupLayout.createParallelGroup(Alignment.LEADING) .addComponent(panel, GroupLayout.PREFERRED_SIZE, 462, GroupLayout.PREFERRED_SIZE) .addComponent(scrollPane, GroupLayout.PREFERRED_SIZE, 461, GroupLayout.PREFERRED_SIZE) .addGroup(groupLayout.createSequentialGroup() .addComponent(label) .addPreferredGap(ComponentPlacement.RELATED) .addComponent(findbookname, GroupLayout.PREFERRED_SIZE, 198, GroupLayout.PREFERRED_SIZE) .addGap(35) .addComponent(btnNewButton))) .addContainerGap(56, Short.MAX_VALUE)) ); groupLayout.setVerticalGroup( groupLayout.createParallelGroup(Alignment.LEADING) .addGroup(groupLayout.createSequentialGroup() .addGap(38) .addGroup(groupLayout.createParallelGroup(Alignment.BASELINE) .addComponent(label) .addComponent(findbookname, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE) .addComponent(btnNewButton)) .addGap(18) .addComponent(scrollPane, GroupLayout.PREFERRED_SIZE, 124, GroupLayout.PREFERRED_SIZE) .addGap(39) .addComponent(panel, GroupLayout.PREFERRED_SIZE, 152, GroupLayout.PREFERRED_SIZE) .addContainerGap(65, Short.MAX_VALUE)) ); JLabel lblNewLabel = new JLabel("\u56FE\u4E66\u7F16\u53F7\uFF1A"); upbookid = new JTextField(); upbookid.setEditable(false); upbookid.setColumns(10); JLabel lblNewLabel_1 = new JLabel("\u4E66 \u540D\uFF1A"); upbookname = new JTextField(); upbookname.setColumns(10); JLabel lblNewLabel_2 = new JLabel("\u4F5C \u8005\uFF1A"); upauthor = new JTextField(); upauthor.setColumns(10); JLabel lblNewLabel_3 = new JLabel("\u4EF7 \u683C\uFF1A"); upprice = new JTextField(); upprice.setColumns(10); JLabel lblNewLabel_4 = new JLabel("\u5176 \u4ED6\uFF1A"); upother = new JTextField(); upother.setColumns(10); JButton button = new JButton("\u4FEE\u6539"); JButton button_1 = new JButton("\u5220\u9664"); GroupLayout gl_panel = new GroupLayout(panel); gl_panel.setHorizontalGroup( gl_panel.createParallelGroup(Alignment.LEADING) .addGroup(gl_panel.createSequentialGroup() .addGap(30) .addGroup(gl_panel.createParallelGroup(Alignment.LEADING) .addGroup(gl_panel.createSequentialGroup() .addComponent(lblNewLabel_2) .addPreferredGap(ComponentPlacement.RELATED) .addComponent(upauthor, GroupLayout.PREFERRED_SIZE, 96, GroupLayout.PREFERRED_SIZE)) .addGroup(gl_panel.createSequentialGroup() .addComponent(lblNewLabel_1) .addPreferredGap(ComponentPlacement.RELATED) .addComponent(upbookname, GroupLayout.PREFERRED_SIZE, 104, GroupLayout.PREFERRED_SIZE)) .addGroup(gl_panel.createSequentialGroup() .addComponent(lblNewLabel) .addPreferredGap(ComponentPlacement.RELATED) .addComponent(upbookid, GroupLayout.PREFERRED_SIZE, 106, GroupLayout.PREFERRED_SIZE))) .addGap(31) .addGroup(gl_panel.createParallelGroup(Alignment.LEADING) .addGroup(gl_panel.createSequentialGroup() .addComponent(button) .addGap(26) .addComponent(button_1)) .addGroup(gl_panel.createSequentialGroup() .addComponent(lblNewLabel_4) .addGap(4) .addComponent(upother, GroupLayout.PREFERRED_SIZE, 96, GroupLayout.PREFERRED_SIZE)) .addGroup(gl_panel.createSequentialGroup() .addComponent(lblNewLabel_3) .addGap(4) .addComponent(upprice, GroupLayout.PREFERRED_SIZE, 96, GroupLayout.PREFERRED_SIZE)))) ); gl_panel.setVerticalGroup( gl_panel.createParallelGroup(Alignment.LEADING) .addGroup(gl_panel.createSequentialGroup() .addContainerGap() .addGroup(gl_panel.createParallelGroup(Alignment.LEADING) .addGroup(gl_panel.createSequentialGroup() .addGroup(gl_panel.createParallelGroup(Alignment.BASELINE) .addComponent(lblNewLabel) .addComponent(upbookid, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)) .addGap(20) .addGroup(gl_panel.createParallelGroup(Alignment.BASELINE) .addComponent(lblNewLabel_1) .addComponent(upbookname, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)) .addGap(24) .addGroup(gl_panel.createParallelGroup(Alignment.BASELINE) .addComponent(lblNewLabel_2) .addComponent(upauthor, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))) .addGroup(gl_panel.createSequentialGroup() .addGroup(gl_panel.createParallelGroup(Alignment.LEADING) .addGroup(gl_panel.createSequentialGroup() .addGap(3) .addComponent(lblNewLabel_3)) .addComponent(upprice, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)) .addGap(18) .addGroup(gl_panel.createParallelGroup(Alignment.LEADING) .addGroup(gl_panel.createSequentialGroup() .addGap(3) .addComponent(lblNewLabel_4)) .addComponent(upother, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)) .addGap(18) .addG