火车售票系统完整代码.docx

1、火车售票系统完整代码package com.yue;import java.awt.Color;import java.awt.GridBagConstraints;import java.awt.GridBagLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.CallableStatement;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet

2、;import java.sql.SQLException;import java.sql.Statement;import javax.swing.BorderFactory;import javax.swing.JButton;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JPasswordField;import javax.swing.JTextArea;import javax.swing.JTextField;public c

3、lass BuyPanel extends JPanel StringBuffer sb = new StringBuffer(); private boolean flag = false; JTextArea jtArea = new JTextArea(10, 78); JLabel buyLabel = new JLabel(订票); JTextField fId = new JTextField(7); JTextField ftid = new JTextField(7); JTextField fche = new JTextField(7); JTextField fzhang

4、shu = new JTextField(7); JTextField fbodyId = new JTextField(7); JPasswordField jpField = new JPasswordField(7); public JPanel getBuypn() JPanel pan = new JPanel(); GridBagLayout layout = new GridBagLayout(); pan.setLayout(layout); GridBagConstraints con = getGridBagConstraints(0, 0, 1, 1, 100, 100,

5、 GridBagConstraints.NONE, GridBagConstraints.WEST); pan.add(buyLabel, con); con = getGridBagConstraints(0, 2, 1, 1, 100, 100, GridBagConstraints.NONE, GridBagConstraints.WEST); pan.add(new pan3(), con); con = getGridBagConstraints(0, 3, 1, 1, 100, 100, GridBagConstraints.NONE, GridBagConstraints.WES

6、T); pan.add(new pan4(), con); con = getGridBagConstraints(0, 4, 1, 1, 100, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); pan.add(new pan5(), con); this.setLocation(270, 150); this.add(pan); return pan; /* * 定义下面购票操作区面板pan3 * * author Administrator * */ class pan3 extends JPanel JLabel lId

7、= new JLabel( 车票号码 ); JLabel ltid = new JLabel( 车票号码 ); JLabel che = new JLabel( 车 次 ); JLabel lbodyId = new JLabel( 身份证号 ); JLabel password = new JLabel( 密码 ); JLabel lzhangshu = new JLabel( 所需张数 ); JLabel la1 = new JLabel( ); JLabel la2 = new JLabel( ); JButton sureButton = new JButton(查询确认); JBut

8、ton buyButton = new JButton(确认购票); public pan3() buyButton.addActionListener(new ActionListener() Override public void actionPerformed(ActionEvent e) UpdateUser(); if (flag=true) UpdateTrain(); System.out.println(hjkasfhjkaf); ); sureButton.addActionListener(new ActionListener() Override public void

9、 actionPerformed(ActionEvent e) select(); ); GridBagLayout layout = new GridBagLayout(); this.setLayout(layout); GridBagConstraints con = getGridBagConstraints(0, 0, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(lId, con); con = getGridBagConstraints(1, 0, 1, 1, 0, 100, G

10、ridBagConstraints.NONE, GridBagConstraints.EAST); this.add(fId, con); con = getGridBagConstraints(8, 0, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(la2, con); con = getGridBagConstraints(9, 0, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(sur

11、eButton, con); con = getGridBagConstraints(0, 1, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(ltid, con); con = getGridBagConstraints(1, 1, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(ftid, con); con = getGridBagConstraints(2, 1, 1, 1, 0, 10

12、0, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(che, con); con = getGridBagConstraints(3, 1, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(fche, con); con = getGridBagConstraints(4, 1, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.ad

13、d(lbodyId, con); con = getGridBagConstraints(5, 1, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(fbodyId, con); con = getGridBagConstraints(0, 2, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(password, con); con = getGridBagConstraints(1, 2, 1,

14、 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(jpField, con); con = getGridBagConstraints(2, 2, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(lzhangshu, con); con = getGridBagConstraints(3, 2, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstrai

15、nts.EAST); this.add(fzhangshu, con); con = getGridBagConstraints(8, 2, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(la1, con); con = getGridBagConstraints(9, 2, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(buyButton, con); this.setBorder(Bord

16、erFactory.createTitledBorder(订票操作区); /* * 定义下面一个JList用于显示车票的所有信息面板pan4 * * author Administrator * */ class pan4 extends JPanel JButton btId = new JButton(车票号码); JButton bt1 = new JButton(起 点 站); JButton bt2 = new JButton(终 点 站); JButton bt3 = new JButton(车 次); JButton bt4 = new JButton(发车时间); JButto

17、n bt5 = new JButton(到达时间); JButton bt6 = new JButton(座位类型); JButton bt7 = new JButton(发车日期); JButton bt8 = new JButton(剩余票数); JButton bt9 = new JButton(车票价格); public pan4() this.setLayout(new GridBagLayout(); GridBagConstraints con = getGridBagConstraints(0, 0, 1, 1, 0, 100, GridBagConstraints.NONE,

18、 GridBagConstraints.EAST); this.add(btId, con); con = getGridBagConstraints(1, 0, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(bt1, con); con = getGridBagConstraints(2, 0, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(bt2, con); con = getGridB

19、agConstraints(3, 0, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(bt3, con); con = getGridBagConstraints(4, 0, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(bt4, con); con = getGridBagConstraints(5, 0, 1, 1, 0, 100, GridBagConstraints.NONE, Gri

20、dBagConstraints.EAST); this.add(bt5, con); con = getGridBagConstraints(6, 0, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(bt6, con); con = getGridBagConstraints(7, 0, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(bt7, con); con = getGridBagCon

21、straints(8, 0, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(bt8, con); con = getGridBagConstraints(9, 0, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(bt9, con); con = getGridBagConstraints(0, 1, 11, 1, 0, 100, GridBagConstraints.NONE, GridBag

22、Constraints.EAST); this.add(jtArea, con); jtArea.setBackground(Color.GREEN); /* * 定义最下面的按钮面板pan5 * * author Administrator * */ class pan5 extends JPanel JButton bt1 = new JButton(退出登录); JLabel lab1 = new JLabel( ); public pan5() GridBagLayout layout = new GridBagLayout(); this.setLayout(layout); Gri

23、dBagConstraints con = getGridBagConstraints(0, 0, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(bt1, con); con = getGridBagConstraints(1, 0, 1, 1, 0, 100, GridBagConstraints.NONE, GridBagConstraints.EAST); this.add(lab1, con); bt1.addActionListener(new ActionListener() Ov

24、erride public void actionPerformed(ActionEvent e) System.exit(0); ); /* * 放回一个网格包约束 * * param x * param y * param width * param heigh * param weighx * param weighy * param fill * param anchor * return */ private GridBagConstraints getGridBagConstraints(int x, int y, int width, int heigh, int weighx,

25、 int weighy, int fill, int anchor) GridBagConstraints con = new GridBagConstraints(); con.gridx = x; con.gridy = y; con.gridwidth = width; con.gridheight = heigh; con.weightx = weighx; con.weighty = weighy; con.fill = fill; con.anchor = anchor; return con; /* * 按车票号码搜索所有的车票信息 * * throws SQLException

26、 */ private void select() Connection conn = null; Statement stmt = null; ResultSet ticket = null; try conn = DriverManager.getConnection( jdbc:oracle:thin:127.0.0.1:1521:ORCL, store, store); catch (SQLException e1) e1.printStackTrace(); try stmt = conn.createStatement(); String text = select * from

27、train_table + where tid= + + fId.getText() + ; ticket = stmt.executeQuery(text); while (ticket.next() String starter = ticket.getString(starter); String reacher = ticket.getString(reacher); String ticketNumber = ticket.getString(ticketNumber); String startTime = ticket.getString(startTime); String e

28、ndTime = ticket.getString(endTime); String seatIdNumber = ticket.getString(seatIdNumber); String busDate = ticket.getString(busDate); int ticketNum = ticket.getInt(ticketNum); double price = ticket.getDouble(price); sb.append( + fId.getText() + t+ + starter + t+ + reacher + t+ + ticketNumber + t + startTime + t + endTime + t + seatIdNumber + t + busDate + t + ticketNum + t + price + + n); jtArea.setText(sb.toString(); if (sb.length() 0) sb.delete(1, sb.length(); else JOptionPane.showMessageDialog(new TestFrame(), 无此车！); catch (SQLException e) finally if (ticket != null)