基于javaweb+Swing+MySQL火车票售票管理系统

基于javaweb+Swing+MySQL火车票售票管理系统

开发工具：eclipse/idea/myeclipse/sts等均可配置运行

适用

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

                    return;
                String nVal = table.getValueAt(e.getLastRow(), e.getColumn())
                        .toString();
                // 如果旧的值 和新的值一样，直接 返回
                if (nVal.equals(oldValue)) {
                    return;
                }
                // 判断当前编辑的单元格是否是主键列
                if (e.getColumn() == 0) {
                    // 还原旧的值
                    table.setValueAt(oldValue, e.getLastRow(), e.getColumn());
                    return;
                }
                // 更新数据

                int ticketid = Integer.valueOf(table.getValueAt(e.getLastRow(), 0).toString());
                String station_arrival = table.getValueAt(e.getLastRow(), 1).toString();
                String station_depart = table.getValueAt(e.getLastRow(), 2).toString();
                String depart_date = table.getValueAt(e.getLastRow(), 3).toString();
                String depart_time = table.getValueAt(e.getLastRow(), 4).toString();
                int ticket_number = Integer.valueOf(table.getValueAt(e.getLastRow(), 5).toString());
                String seattype = table.getValueAt(e.getLastRow(), 6).toString();
                String tickettype = table.getValueAt(e.getLastRow(), 7).toString();

                int tickets_left = Integer.valueOf(table.getValueAt(e.getLastRow(), 8).toString());

import java.util.List;

import dao.UserDao;
import entity.AcPs;
import entity.User;
import util.*;

public class UserDaoImpl implements UserDao {

    public boolean add(String name, String identity_number, String account, String password) throws Exception {
        Connection con = Util.getConnection();
        String sqladd = "insert into user(name,identity_number,account,password) values(?,?,?,?)";
        PreparedStatement stmt = con.prepareStatement(sqladd);
        stmt.setString(1, name);
        stmt.setString(2, identity_number);
        stmt.setString(3, account);
        stmt.setString(4, password);

        add(label_6);

        cmbseattype = new JComboBox(list1.toArray());
        cmbseattype.setBounds(350, 292, 146, 23);
        add(cmbseattype);

        JLabel label_7 = new JLabel("车票价格：");
        label_7.setBounds(280, 325, 146, 23);
        add(label_7);

        txtfares = new JTextField();
        txtfares.setBounds(350, 325, 146, 23);
        add(txtfares);
        txtfares.setColumns(10);

        JLabel label_8 = new JLabel("发售站：");
        label_8.setBounds(280, 357, 146, 23);
        add(label_8);

        txtticket_office = new JTextField();
        txtticket_office.setBounds(350, 357, 146, 23);
        add(txtticket_office);
        txttickets_left.setColumns(10);

        int result = JOptionPane.showConfirmDialog(null, "是否确定要购买该车票");
        // 判断用户是否点击
        if (result == JOptionPane.OK_OPTION) {
            int ticketidd = Integer.valueOf(table.getValueAt(
                    table.getSelectedRow(), 0).toString());

            Userlogin_db dg = new Userlogin_db();
            int usd = dg.getUseridDl();
            System.out.println(usd + "");
            System.out.println(ticketidd + "()()()()(" + usd);
            userticketdao = new UserTicketImpl();
            userdao = new UserDaoImpl();
            ticketim = new TicketImpl();
            int blance = userdao.selectbl(usd);
            int yuan = ticketim.fares(ticketidd);
            System.out.println(blance + "***" + yuan);
            if (blance >= yuan) {
                boolean falll = userdao.reduBlance(usd, yuan);

        return true;
    }

    @Override
    public boolean fundTicket(int userticketid, int userticketticketid) throws SQLException, Exception {
        Connection con = Util.getConnection();
        String sqlll = "update ticket set tickets_left=tickets_left+1 where ticketid = ?";
        PreparedStatement stmttt = con.prepareStatement(sqlll);
        stmttt.setInt(1, userticketticketid);
        stmttt.executeUpdate();
        String sql = "delete from userticket where userticketid=?";
        PreparedStatement stmt = con.prepareStatement(sql);
        stmt.setInt(1, userticketid);
        stmt.executeUpdate();
        return true;
    }

    private SeattypeImpl seattypeDao;

    
    public UpdataTicket(Ticket ticket) throws SQLException {
        setLayout(null);

        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        setBounds(500, 100, 800, 800);
        contentPane = new JPanel();

    public void setUserticketidentity_number(String userticketidentity_number) {
        this.userticketidentity_number = userticketidentity_number;
    }

    public void setUserticketname(String userticketname) {
        this.userticketname = userticketname;
    }

    public String getUserticketstation_arrival() {
        return userticketstation_arrival;
    }

    public void setUserticketstation_arrival(String userticketstation_arrival) {
        this.userticketstation_arrival = userticketstation_arrival;
    }

    public String getUserticketstation_depart() {
        return userticketstation_depart;
    }

public class UpdataSelf extends JFrame {

    JPanel contentPane;
    private JTextField txtname;
    private JTextField txtidentity_number;
    private JTextField txtaccout;
    private JTextField txtPassword;
    private UserDaoImpl userDao;

    public UpdataSelf(int id, String name, String iden, String acc, String pass) {
        setLayout(null);

        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        setBounds(500, 100, 800, 800);
        contentPane = new JPanel();

        JLabel label = new JLabel("用户姓名：");
        label.setBounds(250, 100, 70, 23);
        add(label);

        txtname = new JTextField();
        txtname.setBounds(350, 100, 180, 23);
        add(txtname);
        txtname.setColumns(10);
        txtname.setText(name);

        while (rs.next()) {
            int userticketid = rs.getInt(1);
            int userticketuserid = rs.getInt(2);
            int userticketticketid0 = rs.getInt(3);
            String userticketname = rs.getString(4);
            String userticketidentity_number = rs.getString(5);
            String userticketstation_arrival = rs.getString(6);
            String userticketstation_depart = rs.getString(7);
            String userticketdepart_date = rs.getString(8);
            String userticketdepart_time = rs.getString(9);
            int userticketticket_number = rs.getInt(10);
            String userticketseattype = rs.getString(11);
            String usertickettickettype = rs.getString(12);
            String userticketfares = rs.getString(13);
            String userticketticket_office = rs.getString(14);

            UserTicket userticket0 = new UserTicket(userticketid, userticketuserid, userticketticketid0,
                    userticketname, userticketidentity_number, userticketstation_arrival,

    int userticketticketid;
    String userticketname;
    String userticketidentity_number;
    String userticketstation_arrival;
    String userticketstation_depart;
    String userticketdepart_date;
    String userticketdepart_time;
    int userticketticket_number;
    String userticketseattype;
    String usertickettickettype;
    String userticketfares;
    String userticketticket_office;

    public int getUserticketid() {
        return userticketid;
    }

        if (result == JOptionPane.OK_OPTION) {
            int ticketidd = Integer.valueOf(table.getValueAt(
                    table.getSelectedRow(), 0).toString());

            Userlogin_db dg = new Userlogin_db();
            int usd = dg.getUseridDl();
            System.out.println(usd + "");
            System.out.println(ticketidd + "()()()()(" + usd);
            userticketdao = new UserTicketImpl();
            userdao = new UserDaoImpl();
            ticketim = new TicketImpl();
            int blance = userdao.selectbl(usd);
            int yuan = ticketim.fares(ticketidd);
            System.out.println(blance + "***" + yuan);
            if (blance >= yuan) {
                boolean falll = userdao.reduBlance(usd, yuan);
                boolean fal = userticketdao.SelectUidTid(ticketidd, usd);
                boolean fall = userticketdao.Left(ticketidd);
                System.out.println(fal + "23421434234" + fall);
                if (falll) {
                    if (fall) {
                        if (fal) {
                            boolean falg = userticketdao.buyTicket(ticketidd, usd);
                            boolean flag1 = userticketdao.buyTicketb(ticketidd, usd);
                            JOptionPane.showMessageDialog(null, "购买成功！");
                            System.out.println(falg + "1" + flag1);

运行环境

Java≥6、MySQL≥5.5

开发工具

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

技术框架

Java Swing

适用

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

功能说明

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