课程设计基于java swing的火车购票系统源码.zip

package 课程设计; import java.awt.Color; import java.awt.Container; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; import javax.swing.ImageIcon; import javax.swing.JButton; import javax.swing.JComboBox; 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 javax.swing.JTextField; import javax.swing.SwingUtilities; import javax.swing.UIManager; public class achpage extends JFrame implements ActionListener{ private static final long serialVersionUID = 1L; //菜单栏 JMenuBar menubar; JMenu menu,submenu,settings,jfstyle; JMenuItem sub1,sub2,jfstyle1,jfstyle2,jfstyle3; //标签背景 private JPanel imagePanel; private ImageIcon background; //主页组件 JLabel jl; JFrame jf; Container con; JComboBox<String> ccp; String[] ccp0 = new String[]{"车辆（Coach）","站点（City）","发车时间（Ctime）","车票（Ticket）","乘客（Passenger）","退票（Refund）","售票员（Conductor）","———— 请选择 ————"}; JButton ccrefresh,cchome,ccback,ccexit; //车辆 JLabel jl0,jl01,jl02,jl03,jl011,jl022,jl033; JButton coacreate,coareset,coareset1,coareset2,coareset3; JTextField coacno,coaseat,coaholder,coacno1,coaseat1,coaholder1; //站点 JLabel jl1,jl11,jl12,jl13,jl14,jl15,jl111,jl112,jl113,jl114,jl115; JButton citcreate,citreset,citreset1,citreset2,citreset3,citreset4,citreset5; JTextField citcname,citcno,citmileage,citstart,cittarget,citcname1,citcno1,citmileage1,citstart1,cittarget1; //发车时间 JLabel jl2,jl21,jl22,jl23,jl221,jl222,jl223; JButton timcreate,timreset,timreset1,timreset2,timreset3; JTextField timtime,timcname,timcno,timtime1,timcname1,timcno1; //车票 JLabel jl3,jl31,jl32,jl33,jl34,jl35,jl36,jl331,jl332,jl333,jl334,jl335,jl336; JButton ticcreate,ticreset,ticreset1,ticreset2,ticreset3,ticreset4,ticreset5,ticreset6; JTextField tictno,ticcname,ticcno,tictime,ticprice,ticlast,tictno1,ticcname1,ticcno1,tictime1,ticprice1,ticlast1; //乘客 JLabel jl4,jl41,jl42,jl43,jl44,jl45,jl46,jl441,jl442,jl443,jl444,jl445,jl446; JButton pascreate,pasreset,pasreset1,pasreset2,pasreset3,pasreset4,pasreset6; JTextField pastno,pasname,pasid,pasnum,passeat,pastno1,pasname1,pasid1,pasnum1,passeat1; JComboBox<String> pasrorb,pasrorb1; String[] rorb = new String[]{"预定","购买"}; //退票 JLabel jl5,jl51,jl52,jl53,jl54,jl55,jl56,jl551,jl552,jl553,jl554,jl555,jl556; JButton refcreate,refreset,refreset1,refreset2,refreset3,refreset4,refreset5,refreset6; JTextField reftno,refname,refid,refnum,reftprice,refdate,reftno1,refname1,refid1,refnum1,reftprice1,refdate1; //售票员 JLabel jl6,jl61,jl62,jl63,jl661,jl662,jl663; JButton concreate,conreset,conreset1,conreset2,conreset3; JTextField concon,conname,consex,concon1,conname1,consex1; public achpage() { background = new ImageIcon("D:\\eclipse\\课程设计\\bin\\img\\管理员修改数据.png"); // 背景图片 JLabel label = new JLabel(background); //把背景图片显示在一个标签里面 label.setBounds(0, 0, background.getIconWidth(), background.getIconHeight()); // 把标签的大小位置设置为图片刚好填充整个面板 // 把内容窗格转化为JPanel，否则不能用方法setOpaque()来使内容窗格透明 imagePanel = (JPanel) this.getContentPane(); imagePanel.setOpaque(false); this.getLayeredPane().setLayout(null); // 把背景图片添加到分层窗格的最底层作为背景 this.getLayeredPane().add(label, new Integer(Integer.MIN_VALUE)); this.setSize(background.getIconWidth(), background.getIconHeight()); // 窗口组件初始化 this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); // 设置布局方式为绝对定位 this.setLayout(null); // 窗口大小改变 this.setResizable(true); this.setTitle("小生的车站售票系统"); //函数设立标题 // 居中显示 this.setLocationRelativeTo(null); // 可见 this.setVisible(true); // 创建一个容器 jf = this; con = jf.getContentPane(); //调用函数 init(); achpage1(); coach0(); jl0.setVisible(false); city0(); jl1.setVisible(false); time0(); jl2.setVisible(false); ticket0(); jl3.setVisible(false); passenger0(); jl4.setVisible(false); refund0(); jl5.setVisible(false); conductor0(); jl6.setVisible(false); } void init() { //首栏 menubar = new JMenuBar(); //菜单 menu = new JMenu("菜单"); submenu = new JMenu("菜单项目"); menu.add(submenu); submenu.add(sub1 = new JMenuItem("车站售票管理系统")); sub1.addActionListener(this); submenu.addSeparator(); submenu.add(sub2 = new JMenuItem("宾馆管理系统")); sub2.addActionListener(this); //设置 settings = new JMenu("设置"); jfstyle = new JMenu("风格"); jfstyle.add(jfstyle1 = new JMenuItem("Windows 窗口")); jfstyle.addSeparator(); jfstyle1.addActionListener(this); jfstyle.add(jfstyle2 = new JMenuItem("Unix 窗口")); jfstyle.addSeparator(); jfstyle2.addActionListener(this); jfstyle.add(jfstyle3 = new JMenuItem("Java 窗口")); jfstyle3.addActionListener(this); settings.add(jfstyle); //添加 menubar.add(menu); menubar.add(settings); setJMenuBar(menubar); } void achpage1() { //创建下拉列表框 ccp = new JComboBox<String>(ccp0); //下拉列表进行选择添加 jl = new JLabel(); jl.setBounds(0, 0, 576, 500); ccp.setBounds(188, 68, 200, 30); ccp.setMaximumRowCount(4); ccp.setSelectedItem(ccp0[7]); ccp.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { if(ccp.getSelectedItem() == ccp0[0]) { jl0.setVisible(true); jl1.setVisible(false); jl2.setVisible(false); jl3.setVisible(false); jl4.setVisible(false); jl5.setVisible(false); jl6.setVisible(false); } else if(ccp.getSelectedItem() == ccp0[1]){ jl0.setVisible(false); jl1.setVisible(true); jl2.setVisible(false); jl3.setVisible(false); jl4.setVisible(false); jl5.setVisible(false); jl6.setVisible(false); } else if(ccp.getSelectedItem() == ccp0[2]){ jl0.setVisible(false); jl1.setVisible(false); jl2.setVisible(true); jl3.setVisible(false); jl4.setVisible(false); jl5.setVisible(false); jl6.setVisible(false); } else if(ccp.getSelectedItem() == ccp0[3]){ jl0.setVisible(false); jl1.setVisible(false); jl2.setVisible(false); jl3.setVisible(true); jl4.setVisible(false); jl5.setVisible(false); jl6.setVisible(false); } else if(ccp.getSelectedItem() == ccp0[4]){ jl0.setVisible(false); jl1.setVisible(false); jl2.setVisible(false); jl3.setVisible(false); jl4.setVisible(true); jl5.setVisible(false); jl6.setVisible(false); } else if(ccp.getSelectedItem() == ccp0[5]){ jl0.setVisible(false); jl1.setVisible(false); jl2.setVisible(false); jl3.setVisible(false); jl4.setVisible(false); jl5.setVisible(true); jl6.setVisible(false); } else if(ccp.getSelectedItem() == ccp0[6]){ jl0.setVisible(false); jl1.setVisible(false); jl2.setVisible(false); jl3.setVisible(false); jl4.setVisible(false); jl5.setVisible(false); jl6.setVisible(true); } else{ ccp.removeItemAt(7); } } }); //刷新按钮 ccrefresh = new JButton("刷新"); ccrefresh.setBounds(94, 68, 85, 30); ccrefresh.addActionListener(this); //返回上一页按钮 ccback = new JButton("返回"); ccback.setBounds(397, 68, 85, 30); ccback.addActionListener(this); //返回�