租车管理系统【GUI/Swing+MySQL】（Java课设）

package User; import Main.Login; import javax.swing.*; import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.*; public class UserClient extends JFrame implements ActionListener { //用户界面 JTable table; JLabel label1; Object data[][]; //存储表格数据的二维数组 Object column[] = {"编号", "车型", "车牌", "价格", "是否被租", "租用天数"}; //显示表格对应条目名称 JButton buttonOfUndo, buttonOfChange, buttonOfAble, buttonOfBrowse, buttonOfRent, buttonOfLogout, buttonOfRentCount, buttonOfMine; Box boxLeft, boxRight; JTextField fieldOfRent, fieldOfChange, fieldOfUndo; JPanel jPanelLeft, jPanelRight; Connection con = null; Statement state = null; ResultSet rs = null; //执行JDBC相关操作 String userName; public UserClient(String userName) { init(); setVisible(true); setBounds(350, 200, 600, 510); setTitle("欢迎使用汽车租赁系统"); this.userName = userName; } void init() { label1 = new JLabel(""); //空出一行让界面不那么紧凑 buttonOfAble = new JButton("可租车辆"); buttonOfAble.addActionListener(this); buttonOfBrowse = new JButton("全部车辆"); buttonOfBrowse.addActionListener(this); buttonOfRent = new JButton(" 租 车 "); buttonOfRent.addActionListener(this); buttonOfChange = new JButton(" 换 车 "); buttonOfChange.addActionListener(this); buttonOfUndo = new JButton(" 退 租 "); buttonOfUndo.addActionListener(this); buttonOfMine = new JButton(" 我租的车 "); buttonOfMine.addActionListener(this); buttonOfRentCount = new JButton(" 总租金 "); buttonOfRentCount.addActionListener(this); buttonOfLogout = new JButton(" 退出登录 "); buttonOfLogout.addActionListener(this); fieldOfRent = new JTextField(9); fieldOfChange = new JTextField(9); fieldOfUndo = new JTextField(9); fieldOfRent.setHorizontalAlignment(JTextField.CENTER); fieldOfChange.setHorizontalAlignment(JTextField.CENTER); fieldOfUndo.setHorizontalAlignment(JTextField.CENTER); //设置输入框对齐方式为居中 data = new Object[50][6]; table = new JTable(data, column);//组件的创建 table.setEnabled(false); JScrollPane scrollPane = new JScrollPane(table); buttonOfBrowse.setPreferredSize(new Dimension(36, 27)); buttonOfRentCount.setPreferredSize(new Dimension(36, 27)); buttonOfMine.setPreferredSize(new Dimension(36, 27)); buttonOfRent.setPreferredSize(new Dimension(36, 27)); buttonOfAble.setPreferredSize(new Dimension(40, 27)); buttonOfLogout.setPreferredSize(new Dimension(36, 27)); buttonOfChange.setPreferredSize(new Dimension(36, 27)); buttonOfUndo.setPreferredSize(new Dimension(36, 27)); //统一按钮样式 boxLeft = Box.createVerticalBox(); boxLeft.add(Box.createVerticalStrut(25)); boxLeft.add(buttonOfAble); boxLeft.add(Box.createVerticalStrut(10)); boxLeft.add(buttonOfBrowse); boxLeft.add(Box.createVerticalStrut(28)); boxLeft.add(fieldOfRent); boxLeft.add(Box.createVerticalStrut(5)); boxLeft.add(buttonOfRent); boxLeft.add(Box.createVerticalStrut(15)); boxLeft.add(fieldOfChange); boxLeft.add(Box.createVerticalStrut(5)); boxLeft.add(buttonOfChange); boxLeft.add(Box.createVerticalStrut(15)); boxLeft.add(fieldOfUndo); boxLeft.add(Box.createVerticalStrut(5)); boxLeft.add(buttonOfUndo); boxLeft.add(Box.createVerticalStrut(27)); boxLeft.add(buttonOfMine); boxLeft.add(Box.createVerticalStrut(12)); boxLeft.add(buttonOfRentCount); boxLeft.add(Box.createVerticalStrut(12)); boxLeft.add(buttonOfLogout); boxRight = Box.createHorizontalBox(); boxRight.add(Box.createHorizontalStrut(5)); boxRight.add(boxLeft); //左边的按钮部分用 box布局 jPanelLeft = new JPanel(); jPanelRight = new JPanel(); jPanelLeft.setLayout(new BorderLayout()); jPanelLeft.add(boxRight, BorderLayout.NORTH);//把左边的按钮部分放到jPanelLeft中。 jPanelRight.setLayout(new BorderLayout()); jPanelRight.add(label1, BorderLayout.NORTH); jPanelRight.add(scrollPane, BorderLayout.CENTER);//把表格 放JPanelRight里 this.setLayout(new BorderLayout()); add(jPanelRight, BorderLayout.EAST); add(jPanelLeft, BorderLayout.WEST);//把两个大的Panel放到窗口里面 } public void browseInfo() { int i = 0; while (i < 50) { data[i][0] = " "; data[i][1] = " "; data[i][2] = " "; data[i][3] = " "; data[i][4] = " "; data[i][5] = " "; i++; } i = 0; this.connectDB(); try { state = con.createStatement(); String sql = "select * from car_info"; rs = state.executeQuery(sql); while (rs.next()) { String ID = rs.getString("ID"); String carType = rs.getString("carType"); String license = rs.getString("license"); String price = rs.getString("price"); String days = rs.getString("days"); String isHire = rs.getString("isHire"); data[i][0] = ID; data[i][1] = carType; data[i][2] = license; data[i][3] = price; data[i][4] = days; data[i][5] = isHire; i++; } this.closeDB(); repaint(); } catch (SQLException e1) { e1.printStackTrace(); } this.closeDB(); } @Override public void actionPerformed(ActionEvent e) { Object source = e.getSource(); if (source == buttonOfAble) //可租用车辆按钮 { int flag = 0; //用来判断有没有没被租用的车辆，如果能返回 “否” 值（未被租用车辆）的集，则赋值为 1 int i = 0; while (i < 50) { data[i][0] = " "; data[i][1] = " "; data[i][2] = " "; data[i][3] = " "; data[i][4] = " "; data[i][5] = " "; i++; } i = 0; //i 赋值为0, 为下面的循环做准备 this.connectDB(); try { state = con.createStatement(); String sql = "select * from car_info where isHire= '否';";//查询表里面 没被租用的车辆 rs = state.executeQuery(sql); while (rs.next()) //把查询到的信息写入右边的表格中 { String ID = rs.getString("ID"); String carType = rs.getString("carType"); String license = rs.getString("license"); String price = rs.getString("price"); String days = rs.getString("days"); String isHire = rs.getString("isHire"); data[i][0] = ID; data[i][1] = carType; data[i][2] = license; data[i][3] = price; data[i][4] = isHire; data[i][5] = days; i++; flag = 1; } this.closeDB(); repaint();//刷新一下 } catch (SQLException e1) { e1.printStackTrace(); } if (flag == 0) { JOptionPane.showMessageDialog(null, "车辆都已被租用！"); } } el