用java+sqlservser2005写的旅行社信息管理系统

package frame; import java.awt.BorderLayout; import java.awt.FlowLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.WindowAdapter; import java.awt.event.WindowEvent; import java.io.File; import java.util.Calendar; import javax.swing.ImageIcon; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JMenu; import javax.swing.JMenuBar; import javax.swing.JMenuItem; import javax.swing.JOptionPane; import javax.swing.JPanel; import frame.Input.JoinTravelGroupInputFrame; import frame.Input.QuitTravelGroupInputFrame; import frame.Input.StatisticsTravelInputFrame; import frame.Input.TravelGroupInputFrame; import frame.Input.TravelerInputFrame; import frame.Input.TravelsInputFrame; import frame.Query.All.JoinTravelGroupQueryAllFrame; import frame.Query.All.QuitTravelGroupQueryAllFrame; import frame.Query.All.StatisticsTravelQueryAllFrame; import frame.Query.All.TravelGroupQueryAllFrame; import frame.Query.All.TravelerQueryAllFrame; import frame.Query.All.TravelsQueryAllFrame; import frame.Query.ById.JoinTravelGroupQueryByIdFrame; import frame.Query.ById.QuitTravelGroupQueryByIdFrame; import frame.Query.ById.StatisticsTravelQueryByIdFrame; import frame.Query.ById.TravelGroupQueryByIdFrame; import frame.Query.ById.TravelerQueryByIdFrame; import frame.Query.ById.TravelsQueryByIdFrame; import frame.Remove.JoinTravelGroupRemoveFrame; import frame.Remove.QuitTravelGroupRemoveFrame; import frame.Remove.StatisticsTravelRemoveFrame; import frame.Remove.TravelGroupRemoveFrame; import frame.Remove.TravelerRemoveFrame; import frame.Remove.TravelsRemoveFrame; import frame.Update.JoinTravelGroupUpdateFrame; import frame.Update.QuitTravelGroupUpdateFrame; import frame.Update.StatisticsTravelUpdateFrame; import frame.Update.TravelGroupUpdateFrame; import frame.Update.TravelerUpdateFrame; import frame.Update.TravelsUpdateFrame; public class MainFrame extends JFrame implements Runnable,ActionListener { //主菜单 private JMenuBar mainMenu = new JMenuBar(); //菜单项 private JMenu menuFile = new JMenu("系统(F)"); private JMenu menuTravels = new JMenu("旅行社管理(M)"); private JMenu menuQuery = new JMenu("查询(Q)"); private JMenu memuRemove = new JMenu("删除(R)"); private JMenu memuUpdate = new JMenu("修改(U)"); private JMenu menuHelp = new JMenu("帮助(H)"); //子菜单项 private JMenuItem menuFileExit = new JMenuItem("退出(X)"); private JMenuItem menuRegister = new JMenuItem("注册(R)"); private JMenuItem menuCancel = new JMenuItem("注销(C)"); private JMenuItem menuTravelsInput = new JMenuItem("旅行资料输入"); private JMenuItem menuTravelGroupInput = new JMenuItem("旅行团资料输入"); private JMenuItem menuTravelerInput = new JMenuItem("旅客资料输入"); private JMenuItem menuJoinTravelGroupInput = new JMenuItem("加入旅行团输入"); private JMenuItem menuQuitTravelGroupInput = new JMenuItem("退出旅行团输入"); private JMenuItem menuStatisticsTravelInput = new JMenuItem("统计旅行团人数输入"); private JMenuItem menuTravelsQueryById = new JMenuItem("编号查询旅行资料"); private JMenuItem menuTravelGroupQueryById = new JMenuItem("编号查询旅行团资料"); private JMenuItem menuTravelerQueryById = new JMenuItem("编号查询旅客资料"); private JMenuItem menuJoinTravelGroupQueryById = new JMenuItem("编号查询加入旅行团"); private JMenuItem menuQuitTravelGroupQueryById = new JMenuItem("编号查询退出旅行团"); private JMenuItem menuStatisticsTravelQueryById = new JMenuItem("编号查询统计旅行团人数"); private JMenuItem menuTravelsQueryAll = new JMenuItem("查询全部旅行资料"); private JMenuItem menuTravelGroupQueryAll = new JMenuItem("查询全部旅行团资料"); private JMenuItem menuTravelerQueryAll = new JMenuItem("查询全部旅客资料"); private JMenuItem menuJoinTravelGroupQueryAll = new JMenuItem("查询全部加入旅行团"); private JMenuItem menuQuitTravelGroupQueryAll = new JMenuItem("查询全部退出旅行团"); private JMenuItem menuStatisticsTravelQueryAll = new JMenuItem("查询全部统计旅行团人数"); private JMenuItem menuTravelsRemove = new JMenuItem("旅行资料"); private JMenuItem menuTravelGroupRemove = new JMenuItem("旅行团资料"); private JMenuItem menuTravelerRemove = new JMenuItem("旅客资料"); private JMenuItem menuJoinTravelGroupRemove = new JMenuItem("加入旅行团"); private JMenuItem menuQuitTravelGroupRemove = new JMenuItem("退出旅行团"); private JMenuItem menuStatisticsTravelRemove = new JMenuItem("统计旅行团人数"); private JMenuItem menuTravelsUpdate = new JMenuItem("旅行资料"); private JMenuItem menuTravelGroupUpdate = new JMenuItem("旅行团资料"); private JMenuItem menuTravelerUpdate = new JMenuItem("旅客资料"); private JMenuItem menuJoinTravelGroupUpdate = new JMenuItem("加入旅行团"); private JMenuItem menuQuitTravelGroupUpdate = new JMenuItem("退出旅行团"); private JMenuItem menuStatisticsTravelUpdate = new JMenuItem("统计旅行团人数"); private JMenuItem menuHelpAbout = new JMenuItem("关于(A)"); private ImageIcon icon = new ImageIcon("images" + File.separator + "1.jpg"); private JLabel label = new JLabel(icon,JLabel.LEFT); private JLabel lblTime = new JLabel(); private Thread thread = new Thread(this); public MainFrame() { thread.start();//开始线程 menuFile.setMnemonic('F'); menuTravels.setMnemonic('M'); menuQuery.setMnemonic('Q'); memuRemove.setMnemonic('R'); memuUpdate.setMnemonic('U'); menuHelp.setMnemonic('H'); menuFileExit.setMnemonic('X'); menuRegister.setMnemonic('R'); menuCancel.setMnemonic('C'); menuHelpAbout.setMnemonic('A'); mainMenu.add(menuFile); mainMenu.add(menuTravels); mainMenu.add(menuQuery); mainMenu.add(memuRemove); mainMenu.add(memuUpdate); mainMenu.add(menuHelp); menuFile.add(menuFileExit); menuFile.add(menuRegister); menuFile.add(menuCancel); menuTravels.add(menuTravelsInput); menuTravels.add(menuTravelGroupInput); menuTravels.add(menuTravelerInput); menuTravels.add(menuJoinTravelGroupInput); menuTravels.add(menuQuitTravelGroupInput); menuTravels.add(menuStatisticsTravelInput); menuQuery.add(menuTravelsQueryById); menuQuery.add(menuTravelsQueryAll); menuQuery.add(menuTravelGroupQueryById); menuQuery.add(menuTravelGroupQueryAll); menuQuery.add(menuTravelerQueryById); menuQuery.add(menuTravelerQueryAll); menuQuery.add(menuJoinTravelGroupQueryById); menuQuery.add(menuJoinTravelGroupQueryAll); menuQuery.add(menuQuitTravelGroupQueryById); menuQuery.add(menuQuitTravelGroupQueryAll); menuQuery.add(menuStatisticsTravelQueryById); menuQuery.add(menuStatisticsTravelQueryAll); memuRemove.add(menuTravelsRemove); memuRemove.add(menuTravelGroupRemove); memuRemove.add(menuTravelerRemove); memuRemove.add(menuJoinTravelGroupRemove); memuRemove.add(menuQuitTravelGroupRemove); memuRemove.add(menuStatisticsTravelRemove); memuUpdate.add(menuTravelsUpdate); memuUpdate.add(menuTravelGroupUpdate); memuUpdate.add(menuTravelerUpdate); memuUpdate.add(menuJoinTravelGroupUpdate); memuUpdate.add(menuQuitTravelGroupUpdate); memuUpdate.add(menuStatisticsTravelUpdate); menuHelp.add(menuHelpAbout); menuFileExit.addActionListener(this); menuRegister.addActionListener(this); menuCancel.addActionListener(this); menuTravelsInput.addActionListener(this); menuTravelGroupInput.addActionListener(this); menuTravelerInput.addActionListener(this); menuJoinTravelGroupInput.addActionListener(this); menuQuitTravelGroupInput.addActionListener(this); menuStatisticsTravelInput.addActionListener(this); menuTravelsQueryById.addActionListener(this); menuTravelGroupQueryById.addActionListener(this); menuTravelerQueryById.addActionListener(this); menuJoinTravelGroupQueryById.addActionListener(this); menuQuitTravelGroupQueryById.addActionListener(this); menuStatisticsT