航空订票管理系统 JAVA+MySQL

package Main; import java.awt.BorderLayout; import java.awt.Color; import java.awt.Container; import java.awt.Font; import java.awt.GridLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.WindowAdapter; import java.awt.event.WindowEvent; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javax.swing.BorderFactory; import javax.swing.ButtonGroup; import javax.swing.ImageIcon; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JRadioButton; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.JTextField; import javax.swing.SwingConstants; import javax.swing.table.DefaultTableModel; import javax.swing.table.TableColumn; import javax.swing.table.TableColumnModel; public class UserSearchPanel extends JPanel { public static final String DBDRIVER = "com.mysql.jdbc.Driver"; public static final String DBURL = "jdbc:mysql://localhost:3306/Aviation"; public static final String DBUSER = "root"; public static final String DBPASS = "admin"; protected static final int DISPOSE_ON_CLOSE = 0; private JTable table = null; private DefaultTableModel tableModel = null; private String[] titles = {"航班编号","起飞地点","到达地点","起飞时间","到达时间","价格","座位数量","是否已预订"}; private String[][] userList = new String[100][8]; Object[][] userList1 = new Object[100][8]; private JButton bianliUser = new JButton("遍历航班"); private JButton searchUser = new JButton("搜索航班"); private JButton reviseUser = new JButton("预订航班"); private JRadioButton jrb1 = new JRadioButton("按航班编号查询"); private JRadioButton jrb2 = new JRadioButton("按起落地点查询"); private ButtonGroup group = new ButtonGroup(); private JPanel searchPanel = new JPanel(); private String ID = ""; private String startSta = ""; private String arriveSta = ""; private String startTime = ""; private String endTime =""; private String price = ""; private String seatNum = ""; private String isOrder = ""; private String receiveQi = ""; private String receiveMu = ""; private int rowCount; public UserSearchPanel(){ } public UserSearchPanel(String UserName,String Name,String ID,String gender) throws Exception{ setLayout(null); this.setBackground(Color.CYAN); searchPanel.setLayout(new GridLayout(2,1)); searchPanel.add(jrb1); searchPanel.add(jrb2); group.add(jrb1); group.add(jrb2); searchPanel.setBorder(BorderFactory.createTitledBorder("请选择查询方式：")); this.tableModel = new DefaultTableModel(this.userList,this.titles); this.table = new JTable(this.tableModel); JScrollPane scr = new JScrollPane(this.table); try { bianli(); } catch (Exception e2) { e2.printStackTrace(); } tableModel.setDataVector(userList, titles); bianliUser.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ try { bianli(); } catch (Exception e2) { e2.printStackTrace(); } tableModel.setDataVector(userList, titles); } }); searchUser.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ if(!jrb1.isSelected()&&!jrb2.isSelected()) JOptionPane.showMessageDialog(null, "请选择查询方式","没有选择查询方式",JOptionPane.ERROR_MESSAGE); if(jrb1.isSelected()){ String userName1 = JOptionPane.showInputDialog("请输入要检索的航班编号："); try { search(userName1); } catch (Exception e1) { e1.printStackTrace(); } if(!userName1.equals("")) tableModel.setDataVector(userList, titles); } if(jrb2.isSelected()){ JFrame frame = new JFrame("按起落地查询"); JPanel panel = new JPanel(); JButton JBt = new JButton("查询"); JLabel jlbqi = new JLabel("起飞地:"); JTextField jtfqi = new JTextField(); JLabel jlbmu = new JLabel("目的地:"); JTextField jtfmu = new JTextField(); panel.setLayout(null); panel.setBackground(Color.WHITE); frame.setResizable(false); jlbqi.setFont(new Font("宋体",Font.PLAIN,18)); jlbqi.setSize(100,30); jlbqi.setLocation(10, 10); jtfqi.setFont(new Font("宋体",Font.PLAIN,18)); jtfqi.setSize(200,30); jtfqi.setLocation(90, 10); jlbmu.setFont(new Font("宋体",Font.PLAIN,18)); jlbmu.setSize(100,30); jlbmu.setLocation(10, 50); jtfmu.setFont(new Font("宋体",Font.PLAIN,18)); jtfmu.setSize(200,30); jtfmu.setLocation(90, 50); JBt.setFont(new Font("宋体",Font.PLAIN,18)); JBt.setSize(70,30); JBt.setLocation(285, 90); panel.add(jlbqi); panel.add(jtfqi); panel.add(jlbmu); panel.add(jtfmu); panel.add(JBt); frame.add(panel); frame.setDefaultCloseOperation(frame.DISPOSE_ON_CLOSE); frame.setVisible(true); frame.setLocationRelativeTo(null); frame.setSize(400, 170); JBt.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ receiveQi = jtfqi.getText(); receiveMu = jtfmu.getText(); frame.dispose(); try { search2(receiveQi,receiveMu); } catch (Exception e1) { e1.printStackTrace(); } tableModel.setDataVector(userList, titles); } }); } }}); reviseUser.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ int xuanzhong = -1; String xuanzhongID = ""; try { hangshu(); } catch (Exception e1) { // TODO Auto-generated catch block e1.printStackTrace(); } xuanzhong = table.getSelectedRow(); if (xuanzhong<0)JOptionPane.showMessageDialog(null, "请选中要更改的航班行","没有选中航班",JOptionPane.ERROR_MESSAGE); else if(xuanzhong<rowCount) { xuanzhongID = userList[xuanzhong][0]; String jtfAID = userList[xuanzhong][0]; String jtfSS = userList[xuanzhong][1]; String jtfAS = userList[xuanzhong][2]; String jtfST = userList[xuanzhong][3]; String jtfAT = userList[xuanzhong][4]; String jtfPrice = userList[xuanzhong][5]; String jtfSeatNum = userList[xuanzhong][6]; YudingPanel xiugaiPanel = new YudingPanel(jtfAID,jtfSS,jtfAS,jtfST,jtfAT,jtfPrice,jtfSeatNum, UserName, Name, ID, gender); xiugaiPanel.setBackground(Color.WHITE); JFrame frame = new JFrame(); frame.add(xiugaiPanel); frame.setTitle("预订航班界面"); frame.setSize(700,663); frame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE); frame.setLocationRelativeTo(null); frame.setVisible(true); frame.addWindowListener(new WindowAdapter(){ public void windowClosing(WindowEvent e) { try { bianli(); } catch (Exception e2) {