Java+Swing+mysql的会议预约管理系统源码+数据库.zip

package com.lys.meeting.view.admin; import com.lys.meeting.utils.DataUtils; import javax.swing.*; import javax.swing.event.AncestorEvent; import javax.swing.event.AncestorListener; import javax.swing.event.ListSelectionEvent; import javax.swing.event.ListSelectionListener; import javax.swing.table.DefaultTableModel; import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.io.BufferedWriter; import java.io.FileWriter; import java.io.IOException; import java.sql.ResultSet; import java.sql.SQLException; public class MeetingTableApp extends JFrame { private JTable table; String sql = "select * from record"; String[] columnName = {"序号","主键","开始时间", "结束时间", "会议室名称", "地址", "人数", "主讲人", "主题", "培训内容", "记录人"}; private JTextField startTimeField, endTimeField, roomNameField, addressField, attendeeField, speakerField, topicField, trainingContentField, recorderField; private int selected = 0; private String sql_del="delete from record where id = ? "; String sql_add = "insert into record(id,start_time,end_time,room_name,address,attendees,speaker,topic,training_content,recorder) values(0,?,?,?,?,?,?,?,?,?)"; private String sql_update = "update record set start_time=?,end_time=?,room_name=?,address=?,attendees=?, speaker=?,topic=?,training_content=?,recorder=? where id = ? "; public MeetingTableApp() { setTitle("会议信息管理"); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setSize(1200, 400); setLayout(new BorderLayout()); // 获取初始化数据 try { ResultSet set = DataUtils.query(sql, new Object[]{}); table = new JTable(DataUtils.getSetArrays(set), columnName); } catch (SQLException e) { throw new RuntimeException(e); } JScrollPane scrollPane = new JScrollPane(table); add(scrollPane, BorderLayout.CENTER); JPanel formPanel = new JPanel(); formPanel.setLayout(new GridBagLayout()); GridBagConstraints constraints = new GridBagConstraints(); constraints.fill = GridBagConstraints.HORIZONTAL; constraints.insets = new Insets(5, 5, 5, 5); JLabel startTimeLabel = new JLabel("开始时间:"); startTimeField = new JTextField(20); constraints.gridx = 0; constraints.gridy = 0; formPanel.add(startTimeLabel, constraints); constraints.gridx = 1; constraints.gridy = 0; formPanel.add(startTimeField, constraints); JLabel endTimeLabel = new JLabel("结束时间:"); endTimeField = new JTextField(20); constraints.gridx = 0; constraints.gridy = 1; formPanel.add(endTimeLabel, constraints); constraints.gridx = 1; constraints.gridy = 1; formPanel.add(endTimeField, constraints); JLabel roomNameLabel = new JLabel("会议室名称:"); roomNameField = new JTextField(20); constraints.gridx = 0; constraints.gridy = 2; formPanel.add(roomNameLabel, constraints); constraints.gridx = 1; constraints.gridy = 2; formPanel.add(roomNameField, constraints); JLabel addressLabel = new JLabel("地址:"); addressField = new JTextField(20); constraints.gridx = 0; constraints.gridy = 3; formPanel.add(addressLabel, constraints); constraints.gridx = 1; constraints.gridy = 3; formPanel.add(addressField, constraints); JLabel attendeeLabel = new JLabel("人数:"); attendeeField = new JTextField(20); constraints.gridx = 0; constraints.gridy = 4; formPanel.add(attendeeLabel, constraints); constraints.gridx = 1; constraints.gridy = 4; formPanel.add(attendeeField, constraints); JLabel speakerLabel = new JLabel("主讲人:"); speakerField = new JTextField(20); constraints.gridx = 0; constraints.gridy = 5; formPanel.add(speakerLabel, constraints); constraints.gridx = 1; constraints.gridy = 5; formPanel.add(speakerField, constraints); JLabel topicLabel = new JLabel("主题:"); topicField = new JTextField(20); constraints.gridx = 0; constraints.gridy = 6; formPanel.add(topicLabel, constraints); constraints.gridx = 1; constraints.gridy = 6; formPanel.add(topicField, constraints); JLabel trainingContentLabel = new JLabel("培训内容:"); trainingContentField = new JTextField(20); constraints.gridx = 0; constraints.gridy = 7; formPanel.add(trainingContentLabel, constraints); constraints.gridx = 1; constraints.gridy = 7; formPanel.add(trainingContentField, constraints); JLabel recorderLabel = new JLabel("记录人:"); recorderField = new JTextField(20); constraints.gridx = 0; constraints.gridy = 8; formPanel.add(recorderLabel, constraints); constraints.gridx = 1; constraints.gridy = 8; formPanel.add(recorderField, constraints); JPanel buttonPanel = new JPanel(); JButton addButton = new JButton("添加"); addButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { addMeeting(); } }); buttonPanel.add(addButton); JButton updateButton = new JButton("更新"); updateButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { updateMeeting(); } }); buttonPanel.add(updateButton); JButton deleteButton = new JButton("删除"); deleteButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { deleteMeeting(); } }); buttonPanel.add(deleteButton); JButton resetButton = new JButton("重置"); resetButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { startTimeField.setText(""); endTimeField.setText(""); roomNameField.setText(""); addressField.setText(""); attendeeField.setText(""); speakerField.setText(""); topicField.setText(""); trainingContentField.setText(""); recorderField.setText(""); } }); buttonPanel.add(resetButton); JButton exportButton = new JButton("导出数据"); exportButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { exportTableData(); } }); buttonPanel.add(exportButton); JButton closeButton = new JButton("关闭"); closeButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { dispose(); } }); buttonPanel.add(closeButton); add(formPanel, BorderLayout.EAST); add(buttonPanel, BorderLayout.SOUTH); table.getSelectionModel().addListSelectionListener(new ListSelectionListener() { @Override public void valueChanged(ListSelectionEvent e) { if (!e.getValueIsAdjusting()) { // 确保事件不会被重复触发 int row = table.getSelectedRow(); if (row != -1) { // 获取选中行的数据 selected = (int) table.getValueAt(row, 1); startTimeField.setText((String) table.getValueAt(row, 2)); endTimeField.setText((String) table.getValueAt(row, 3)); roomNameField.setText((String) table.getValueAt(row, 4)); addressFiel