基于Eclipse+Java+Swing+Mysql实现旅游管理信息系统(高分课设)

package View; import java.awt.*; import javax.swing.JFrame; 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.ScrollPaneConstants; import javax.swing.Timer; import javax.swing.table.DefaultTableCellRenderer; import javax.swing.table.DefaultTableModel; import Controller.Select; import Controller.Updata; import Picture.Background; import Utils.ValidateUtils; import javax.swing.DefaultComboBoxModel; import javax.swing.ImageIcon; import javax.swing.JButton; import javax.swing.JComboBox; import java.awt.event.ActionListener; import java.awt.event.WindowAdapter; import java.awt.event.WindowEvent; import java.sql.Date; import java.text.SimpleDateFormat; import java.util.regex.Matcher; import java.util.regex.Pattern; import java.awt.Color; import java.awt.Font; import java.awt.event.ActionEvent; public class MainJframe extends JFrame { private JTextField textField_name;//姓名 private JTextField textField_age;//年龄 private JTextField textField_IDcard;//身份证号码 private JTextField textField_address;//地址 private JTextField textField_phone;//电话 private JTextField textField_pt;//陪同 private JTextField textField_ss;//食宿 private JTextField textField_line;//线路号 String name,sex,age,Idcard,address,phone,th,pt,ss,line; Select select = new Select(); Updata updata = new Updata(); Object[] header= {"线路号","起点","终点","天数","主要景点","团号"}; Object[][] data=select.getLineInfo(); public MainJframe() { super("旅游管理信息系统"); this.setBounds(0, 0, 1200, 700); this.setLocationRelativeTo(null);//让窗口在屏幕中间显示 this.setResizable(false);//让窗口大小不可改变 getContentPane().setLayout(null); this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);//用户单击窗口的关闭按钮时程序执行的操作 JLabel lblNewLabel_name= new JLabel("姓名："); lblNewLabel_name.setBounds(100, 300, 72, 18); getContentPane().add(lblNewLabel_name); textField_name = new JTextField(); textField_name.setBounds(150, 295, 180, 24); getContentPane().add(textField_name); textField_name.setColumns(10); JLabel lblNewLabel_sex= new JLabel("性别："); lblNewLabel_sex.setBounds(100, 350, 72, 18); getContentPane().add(lblNewLabel_sex); JComboBox comboBox_sez = new JComboBox(); comboBox_sez.setModel(new DefaultComboBoxModel(new String[] {"男", "女"})); comboBox_sez.setBounds(150, 345, 180, 24); getContentPane().add(comboBox_sez); JLabel lblNewLabel_age= new JLabel("年龄："); lblNewLabel_age.setBounds(100, 400, 72, 18); getContentPane().add(lblNewLabel_age); textField_age = new JTextField(); textField_age.setBounds(150,395 , 180, 24); getContentPane().add(textField_age); textField_age.setColumns(10); JLabel lblNewLabel_IDcard= new JLabel("身份证号码:"); lblNewLabel_IDcard.setBounds(65, 450, 72, 18); getContentPane().add(lblNewLabel_IDcard); textField_IDcard = new JTextField(); textField_IDcard.setBounds(150, 445, 180, 24); getContentPane().add(textField_IDcard); textField_IDcard.setColumns(10); JLabel lblNewLabel_address= new JLabel("住址："); lblNewLabel_address.setBounds(100, 500, 72, 18); getContentPane().add(lblNewLabel_address); textField_address = new JTextField(); textField_address.setBounds(150, 495, 180, 24); getContentPane().add(textField_address); textField_address.setColumns(10); JLabel lblNewLabel_phone= new JLabel("电话："); lblNewLabel_phone.setBounds(100, 550, 72, 18); getContentPane().add(lblNewLabel_phone); textField_phone = new JTextField(); textField_phone.setBounds(150, 545, 180, 24); getContentPane().add(textField_phone); textField_phone.setColumns(10); JLabel lblNewLabel_th= new JLabel("团名："); lblNewLabel_th.setBounds(500, 300, 72, 18); getContentPane().add(lblNewLabel_th); JComboBox comboBox_th = new JComboBox(); comboBox_th.setModel(new DefaultComboBoxModel(new String[] {"夕阳红旅行团", "随心所欲旅行团"})); comboBox_th.setBounds(550, 295, 180, 24); getContentPane().add(comboBox_th); ImageIcon i0 = new ImageIcon("img/Icon0.png"); JButton lvt = new JButton("查看旅游团信息",i0); lvt.setBounds(780, 290, 158, 27); lvt.setFocusPainted(false);//去掉按钮周围的焦点框 lvt.setContentAreaFilled(true);//设置按钮bu透明背景 getContentPane().add(lvt); lvt.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent arg0) { String sql = "SELECT COUNT(*) FROM `user` WHERE user_state='已登录'"; int reselt = select.getCount(sql); if (reselt>0) { //判断当前登录的用户身份 Enquiry e = new Enquiry(); e.setVisible(true); //dispose(); } else { JOptionPane.showMessageDialog(null, "请先登录！"); Login l = new Login(); l.setVisible(true); dispose(); } } }); JLabel lblNewLabel_line= new JLabel("线路号："); lblNewLabel_line.setBounds(500, 450, 72, 18); getContentPane().add(lblNewLabel_line); textField_line = new JTextField(); textField_line.setBounds(550, 445, 180, 24); getContentPane().add(textField_line); textField_line.setColumns(10); JLabel lblNewLabel_pt= new JLabel("陪同："); lblNewLabel_pt.setBounds(500, 350, 72, 18); getContentPane().add(lblNewLabel_pt); textField_pt = new JTextField(); textField_pt.setText("是否选择导游陪同？"); textField_pt.setToolTipText(""); textField_pt.setBounds(550, 345, 180, 24); getContentPane().add(textField_pt); textField_pt.setColumns(10); JLabel lblNewLabel_ss= new JLabel("食宿："); lblNewLabel_ss.setBounds(500, 400, 72, 18); getContentPane().add(lblNewLabel_ss); textField_ss = new JTextField(); textField_ss.setText("是否选择宾馆住宿？"); textField_ss.setBounds(550, 395, 180, 24); getContentPane().add(textField_ss); textField_ss.setColumns(10); JButton button_3 = new JButton("是"); button_3.setBounds(780, 340, 50, 27); button_3.setFocusPainted(false);//去掉按钮周围的焦点框 button_3.setContentAreaFilled(true);//设置按钮透明背景 getContentPane().add(button_3); button_3.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { textField_pt.setText("是"); } }); JButton button_4 = new JButton("否"); button_4.setBounds(850, 340, 50, 27); button_4.setFocusPainted(false);//去掉按钮周围的焦点框 button_4.setContentAreaFilled(true);//设置按钮不透明背景 getContentPane().add(button_4); button_4.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { textField_pt.setText("无"); } }); JButton button_6 = new JButton("是"); button_6.setBounds(780, 390, 50, 27); button_6.setFocusPainted(false);//去掉按钮周围的焦点框 button_6.setContentAreaFilled(true);//设置按钮透明背景 getContentPane().add(button_6); button_6.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { textField_ss.setText("是"); } }); JButton button_7 = new JButton("否"); button_7.setBounds(850, 390, 50, 27); button_7.setFocusPainted(false);//去掉按钮周围的焦点框 button_7.setContentAreaFilled(true);//设置按钮透明背景 getContentPane().add(button_7); button_7.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { textField_ss.setText("无"); } }); JButton btnNewButton = new JButton("报名"); btnNewButton.setFont(new Font("微软雅黑", Font.PLAIN, 18)); btnNewButton.setBounds(700, 516, 124, 33); btnNewButton.setFocusPainted(false);//去掉按钮周围的焦点框 btnNewButton.setContentAreaFilled(true);//设置按钮不透明背景 getContentPane().add(btnNewButton); btnNewButton.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { name = textField_name.getText(); sex = com