void tableInitialise(JTable table) {

    JScrollPane scroll;
    TableColumn column = null;

    int colunms = table.getColumnCount();
    for (int y = 0; y < colunms; y++) {
      column = table.getColumnModel().getColumn(y);
      /*将每一列的默认宽度设置为100*/
      column.setPreferredWidth(100);
    }
    /*
     * 设置JTable自动调整列表的状态,此处设置为关闭
     */
    table.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);

    table.setFont(new Font("Menu.font", Font.PLAIN, 14));
    table.getTableHeader().setFont(new Font("Menu.font", Font.BOLD, 15));
    /*用JScrollPane装载JTable,这样超出范围的列就可以通过滚动条来查看*/

    scroll = new JScrollPane(table);
    TablePanel.removeAll();

    TablePanel.setLayout(new BoxLayout(TablePanel, BoxLayout.Y_AXIS));
    TablePanel.add(scroll);

    TablePanel.revalidate();

    table.setRowSelectionAllowed(true); // 设置JTable可被选择
    table.setSelectionMode(ListSelectionModel.SINGLE_SELECTION); // 设置JTable为单行选择
    table.getTableHeader().setBackground(new Color(206, 231, 255)); // 设置JTable表头颜色
    table.getTableHeader().setReorderingAllowed(false); // 设置JTable每个字段的顺序不可以改变
    table.getTableHeader().setResizingAllowed(false); // 设置JTable每个表头的大小不可以改变
    makeFace(table); // 设置JTable 颜色

    table.setVisible(true);
  }
  public RemoveTeacherTimetable() {
    frame = new JFrame("RemoveTeacherTimetable");
    frame.setContentPane(panel);
    frame.setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);
    frame.setVisible(true);
    tableView.setVisible(
        false); // hiding the unnecessary part before it is used, which makes the outlook more
                // pretty
    afterDeletion.setVisible(false);
    panelWidth = afterDeletion.getWidth() + 40;
    frame.pack();

    退出Button.addActionListener(
        new ActionListener() {
          @Override
          public void actionPerformed(ActionEvent e) {
            RemoveModule removeModule = new RemoveModule();
            frame.dispatchEvent(new WindowEvent(frame, WindowEvent.WINDOW_CLOSING));
          }
        });

    删除Button.addActionListener(
        new ActionListener() {
          @Override
          public void actionPerformed(ActionEvent e) {
            DefaultTableModel tableModel;
            tableModel = new DefaultTableModel();
            createTableModel(tableModel);
            tableView.setModel(tableModel);
            try {
              Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            } catch (Exception ex) {
              ex.printStackTrace();
              JOptionPane.showMessageDialog(
                  null, "failed to load the driver function", "ERROR", JOptionPane.ERROR_MESSAGE);
            }
            try {
              Connection con =
                  DriverManager.getConnection(
                      Administrator.URL, Administrator.USER, Administrator.PASSWORD);
              Statement st = con.createStatement();
              String Ayear = ayear.getText();
              String Semester = semester.getText();
              String T_id = t_id.getText();
              String C_id = c_id.getText();
              String query =
                  "DELETE FROM tc WHERE Ayear = '"
                      + Ayear
                      + "' AND Semester = '"
                      + Semester
                      + "' AND T_id = '"
                      + T_id
                      + "' AND C_id = '"
                      + C_id
                      + "'";
              if (!Ayear.isEmpty() && !Semester.isEmpty() && !T_id.isEmpty() && !C_id.isEmpty())
                st.executeUpdate(query);

              ResultSet rs = st.executeQuery("SELECT * FROM tc");
              while (rs.next()) {
                Vector<java.io.Serializable> vcRows = new Vector<>();
                vcRows.addElement(rs.getString(1));
                vcRows.addElement(rs.getInt(2));
                vcRows.addElement(rs.getString(3));
                vcRows.addElement(rs.getString(4));
                vcRows.addElement(rs.getString(5));
                tableModel.addRow(vcRows);
              }
              rs.close();
              st.close();
              con.close();
              tableView.setAutoResizeMode(
                  JTable
                      .AUTO_RESIZE_ALL_COLUMNS); // adjust the panel according to the table's
                                                 // current height, and set them visible
              panelHeight = tableView.getRowHeight() * tableView.getRowCount() + 50;
              afterDeletion.setPreferredSize(new Dimension(panelWidth, panelHeight));
              afterDeletion.setVisible(true);
              tableView.setVisible(true);
              frame.pack();

            } catch (Exception ex) {
              ex.printStackTrace();
              JOptionPane.showMessageDialog(
                  null,
                  "failed to excute the SQL statement\n" + ex.getMessage(),
                  "ERROR",
                  JOptionPane.ERROR_MESSAGE);
            }
          }

          private void createTableModel(DefaultTableModel tableModel) {
            tableModel.addColumn("Ayear");
            tableModel.addColumn("Semester");
            tableModel.addColumn("T_id");
            tableModel.addColumn("C_id");
            tableModel.addColumn("Rating");
          }
        });
  }
Example #3
0
  public QueryTeacher() {
    frame = new JFrame("QueryTeacher");
    frame.setContentPane(panel);
    frame.setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);
    frame.setVisible(true);
    tableView.setVisible(false);
    afterInsert.setVisible(false);
    panelWidth = afterInsert.getWidth();
    frame.pack();

    退出Button.addActionListener(
        new ActionListener() {
          @Override
          public void actionPerformed(ActionEvent e) {
            new QueryModule();
            frame.dispatchEvent(new WindowEvent(frame, WindowEvent.WINDOW_CLOSING));
          }
        });

    查询Button.addActionListener(
        new ActionListener() {
          @Override
          public void actionPerformed(ActionEvent e) {
            DefaultTableModel tableModel = new DefaultTableModel();
            createTableModel(tableModel);
            tableView.setModel(tableModel);
            try {
              Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            } catch (Exception ex) {
              ex.printStackTrace();
              JOptionPane.showMessageDialog(
                  null,
                  "failed to load the driver function/n" + ex.getMessage(),
                  "ERROR",
                  JOptionPane.ERROR_MESSAGE);
            }
            try {
              Connection con =
                  DriverManager.getConnection(
                      Administrator.URL, Administrator.USER, Administrator.PASSWORD);
              Statement st = con.createStatement();
              String T_id = t_id.getText();
              String T_name = t_name.getText();
              String T_sex = t_sex.getText();
              String T_birth = t_birth.getText();
              String T_prov = t_prov.getText();
              String T_region = t_region.getText();
              String Dept_id = dept_id.getText();
              String Col_id = col_id.getText();
              String Prof = prof.getText();
              String Sal = sal.getText();

              String query = "SELECT * FROM teacher where 1 = 1";
              if (!T_id.isEmpty() && T_id != "") query += "and T_id like '%" + T_id + "%'";
              if (!T_name.isEmpty() && T_name != "") query += "and T_name like '%" + T_name + "%'";
              if (!T_sex.isEmpty() && T_sex != "") query += "and T_sex like '%" + T_sex + "%'";
              if (!T_birth.isEmpty() && T_birth != "")
                query += "and T_birth like '%" + T_birth + "%'";
              if (!T_prov.isEmpty() && T_prov != "") query += "and T_prov like '%" + T_prov + "%'";
              if (!T_region.isEmpty() && T_region != "")
                query += "and T_region like '%" + T_region + "%'";
              if (!Dept_id.isEmpty() && Dept_id != "")
                query += "and Dept_id like '%" + Dept_id + "%'";
              if (!Col_id.isEmpty() && Col_id != "") query += "and Col_id like '%" + Col_id + "%'";
              if (!Prof.isEmpty() && Prof != "") query += "and Prof like '%" + Prof + "%'";
              if (!Sal.isEmpty() && Sal != "") query += "and Sal like '%" + Sal + "%'";

              ResultSet rs = st.executeQuery(query);
              while (rs.next()) {
                Vector<java.io.Serializable> vcRows = new Vector<>();
                vcRows.addElement(rs.getString(1));
                vcRows.addElement(rs.getString(2));
                vcRows.addElement(rs.getString(3));
                vcRows.addElement(rs.getDate(4));
                vcRows.addElement(rs.getString(5));
                vcRows.addElement(rs.getString(6));
                vcRows.addElement(rs.getString(7));
                vcRows.addElement(rs.getString(8));
                vcRows.addElement(rs.getString(9));
                vcRows.addElement(rs.getInt(10));
                tableModel.addRow(vcRows);
              }
              rs.close();
              st.close();
              con.close();
              tableView.setAutoResizeMode(
                  JTable
                      .AUTO_RESIZE_ALL_COLUMNS); // adjust the panel according to the table's
                                                 // current height, and set them visible
              panelHeight = tableView.getRowHeight() * tableView.getRowCount() + 50;
              afterInsert.setPreferredSize(new Dimension((int) (panelWidth * 1.4), panelHeight));
              afterInsert.setVisible(true);
              tableView.setVisible(true);
              frame.pack();

            } catch (Exception ex) {
              ex.printStackTrace();
              JOptionPane.showMessageDialog(
                  null,
                  "failed to excute the SQL statement\n" + ex.getMessage(),
                  "ERROR",
                  JOptionPane.ERROR_MESSAGE);
            }
          }

          private void createTableModel(DefaultTableModel tableModel) {
            tableModel.addColumn("T_id");
            tableModel.addColumn("T_name");
            tableModel.addColumn("T_sex");
            tableModel.addColumn("T_birth");
            tableModel.addColumn("T_prov");
            tableModel.addColumn("T_region");
            tableModel.addColumn("Dept_id");
            tableModel.addColumn("Col_id");
            tableModel.addColumn("Prof");
            tableModel.addColumn("Sal");
          }
        });
  }
Example #4
0
  private void updateTable() {
    dataExchange.transferString("updateTable");
    listProduct = new ArrayList<ProductEntity>();
    int size = dataExchange.acceptInt();

    for (int i = 0; i < size; i++) {
      listProduct.add(dataExchange.acceptProductEntity());
    }

    listGroup = new ArrayList<GroupEntity>();
    size = dataExchange.acceptInt();

    for (int i = 0; i < size; i++) {
      listGroup.add(dataExchange.acceptGroupEntity());
    }

    listSubGroup = new ArrayList<SubGroupEntity>();
    size = dataExchange.acceptInt();

    for (int i = 0; i < size; i++) {
      listSubGroup.add(dataExchange.acceptSubGroupEntity());
    }

    listProductTable = new ArrayList<ProductTableEntity>();

    for (int i = 0; i < listProduct.size(); i++) {
      ProductTableEntity entity = new ProductTableEntity();

      for (int j = 0; j < listGroup.size(); j++) {

        if (listProduct.get(i).getGroupId() == listGroup.get(j).getGroupId()) {
          entity.setGroupName(listGroup.get(j).getGroupName());
          break;
        }
      }

      for (int j = 0; j < listSubGroup.size(); j++) {

        if (listProduct.get(i).getSubGroupId() == listSubGroup.get(j).getSubGroupId()) {
          entity.setSubGroupName(listSubGroup.get(j).getSubGroupName());
          break;
        }
      }
      entity.setProductId(i + 1);
      entity.setProductName(listProduct.get(i).getProductName());
      entity.setAmount(listProduct.get(i).getAmount());
      entity.setPrice(listProduct.get(i).getPrice());
      listProductTable.add(entity);
    }
    productTableModel.removeIsAll();

    for (int i = 0; i < listProductTable.size(); i++) {
      String[] table = {
        String.valueOf(listProductTable.get(i).getProductId()),
        listProductTable.get(i).getProductName(),
        listProductTable.get(i).getGroupName(),
        listProductTable.get(i).getSubGroupName(),
        String.valueOf(listProductTable.get(i).getAmount()),
        String.valueOf(listProductTable.get(i).getPrice())
      };
      productTableModel.addDate(table);
    }
    table.setVisible(false);
    table.setVisible(true);
  }
  public UpdateUsercode() {
    frame = new JFrame("UpdateUsercode");
    frame.setContentPane(panel);
    frame.setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);
    frame.setVisible(true);
    tableView.setVisible(
        false); // hiding the unnecessary part before it is used, which makes the outlook more
                // pretty
    afterUpdate.setVisible(false);
    panelWidth = afterUpdate.getWidth() + 40;
    frame.pack();

    退出Button.addActionListener(
        new ActionListener() {
          @Override
          public void actionPerformed(ActionEvent e) {
            frame.dispatchEvent(new WindowEvent(frame, WindowEvent.WINDOW_CLOSING));
          }
        });
    更改Button.addActionListener(
        new ActionListener() {
          @Override
          public void actionPerformed(ActionEvent e) {
            DefaultTableModel tableModel = new DefaultTableModel();
            createTableModel(tableModel);
            tableView.setModel(tableModel);
            try {
              Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            } catch (Exception ex) {
              ex.printStackTrace();
              JOptionPane.showMessageDialog(
                  null, "failed to load the driver function", "ERROR", JOptionPane.ERROR_MESSAGE);
            }
            try {
              Connection con =
                  DriverManager.getConnection(
                      Administrator.URL, Administrator.USER, Administrator.PASSWORD);
              Statement st = con.createStatement();
              String old_U_id = old_u_id.getText();
              String U_id = u_id.getText();
              String U_name = u_name.getText();
              String Password = password.getText();
              String Privilege = privilege.getText();
              String query =
                  "UPDATE usercode SET U_id = '"
                      + U_id
                      + "', U_name = '"
                      + U_name
                      + "', Password = '******', Privilege = '"
                      + Privilege
                      + "' WHERE U_id = '"
                      + old_U_id
                      + "'";
              if (!old_U_id.isEmpty()
                  && !U_id.isEmpty()
                  && !U_name.isEmpty()
                  && !Password.isEmpty()
                  && !Privilege.isEmpty()) st.executeUpdate(query);

              ResultSet rs = st.executeQuery("SELECT * FROM usercode");
              while (rs.next()) {
                Vector<String> vcRows = new Vector<>();
                vcRows.addElement(rs.getString(1));
                vcRows.addElement(rs.getString(2));
                vcRows.addElement(rs.getString(3));
                vcRows.addElement(rs.getString(4));
                tableModel.addRow(vcRows);
              }
              rs.close();
              st.close();
              con.close();
              tableView.setAutoResizeMode(
                  JTable
                      .AUTO_RESIZE_ALL_COLUMNS); // adjust the panel according to the table's
                                                 // current height, and set them visible
              panelHeight = tableView.getRowHeight() * tableView.getRowCount() + 50;
              afterUpdate.setPreferredSize(new Dimension(panelWidth, panelHeight));
              afterUpdate.setVisible(true);
              tableView.setVisible(true);
              frame.pack();

            } catch (Exception ex) {
              ex.printStackTrace();
              JOptionPane.showMessageDialog(
                  null,
                  "failed to excute the SQL statement\n" + ex.getMessage(),
                  "ERROR",
                  JOptionPane.ERROR_MESSAGE);
            }
          }

          private void createTableModel(DefaultTableModel tableModel) {
            tableModel.addColumn("U_id");
            tableModel.addColumn("U_name");
            tableModel.addColumn("Password");
            tableModel.addColumn("Privilege");
          }
        });
  }