基于java+mysql的Swing+MySQL火车票售票管理系统

基于java+mysql的Swing+MySQL火车票售票管理系统

运行环境

Java≥8、MySQL≥5.7

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

管理员管理车票和用户、用户购买车票等

技术框架

Java Swing MySQL

---

        JLabel label = new JLabel("到达站：");
        label.setBounds(280, 65, 146, 23);
        add(label);

        txtstation_arrival = new JTextField();
        txtstation_arrival.setBounds(350, 65, 146, 23);
        add(txtstation_arrival);
        txtstation_arrival.setColumns(10);

        JLabel label1 = new JLabel("乘车站：");
        label1.setBounds(280, 97, 146, 23);
        add(label1);

        txtstation_depart = new JTextField();
        txtstation_depart.setBounds(350, 97, 146, 23);
        add(txtstation_depart);
        txtstation_arrival.setColumns(10);

        JLabel label_20 = new JLabel("发车日期：");
        label_20.setBounds(280, 130, 146, 23);
        add(label_20);

        txtdepart_date = new JTextField();
        txtdepart_date.setBounds(350, 130, 146, 23);
        add(txtdepart_date);
        txtdepart_date.setColumns(10);

        return flag;
    }

    @Override
    public boolean addBlance(int userid, int yuan) throws SQLException {
   
        System.out.println(userid + "----" + yuan);
        boolean flag = false;
        String sql = "update user set balance=balance+? where userid = ?";
        Connection con = Util.getConnection();
        PreparedStatement stmt = con.prepareStatement(sql);
        stmt.setInt(1, yuan);
        stmt.setInt(2, userid);
        int result = stmt.executeUpdate();
        ResultSet rr = null;
        System.out.println(sql);
        if (result >= 1) {
   
            flag = true;
        }

                        , seattype, tickettype, tickets_left, fares, ticket_office);
                try {
   
                    ticketimpl.update(ticket);
                } catch (SQLException e1) {
   
                    // TODO Auto-generated catch block
                    e1.printStackTrace();
                }
                try {
   
                    loadData();
                } catch (SQLException e1) {
   
                    // TODO Auto-generated catch block
                    e1.printStackTrace();
                }
            }
        });
    }

        List