Esempio n. 1
0
  public static Vector<Integer> getValuesInVector(String query) throws SQLException {
    Vector<Integer> vc = new Vector<Integer>();

    ResultSet rs = Utilfunctions.executeQuery(query);
    while (rs.next()) vc.add(rs.getInt(1));

    return vc;
  }
Esempio n. 2
0
 public static int getClassCode(String classString) throws SQLException {
   ResultSet rs =
       Utilfunctions.executeQuery(
           "SELECT classCode FROM class WHERE CONCAT(course,' ',dept,' ',year,' - ',section) = '"
               + classString
               + "'");
   rs.next();
   return rs.getInt(1);
 }
Esempio n. 3
0
 public static void populateComboBoxwithQuery(JComboBox ComboBox, String Query)
     throws SQLException {
   ComboBox.removeAllItems();
   ResultSet result = Utilfunctions.executeQuery(Query);
   try {
     while (result.next() != false) {
       ComboBox.addItem(result.getString(1));
     }
   } catch (Exception e) {
     // Logger.getLogger(DayWisePeriodConfigChooseForm.class.getName()).log(Level.SEVERE, null, e);
     JOptionPane.showMessageDialog(null, e);
   }
 }
Esempio n. 4
0
  public static int executeUpdate(String query) {
    int rowsAffected = 0;
    try {
      Class.forName("com.mysql.jdbc.Driver");
      String dbpwd = Utilfunctions.getDbConfig("password");
      if (con == null)
        con = DriverManager.getConnection("jdbc:mysql://localhost:3306/schedulepro", "root", dbpwd);
      PreparedStatement statement;
      statement = con.prepareStatement(query);

      rowsAffected = statement.executeUpdate();
    } catch (Exception e) {
      JOptionPane.showMessageDialog(null, e);
    }
    return rowsAffected;
  }
Esempio n. 5
0
  public static int insertWithGeneratedKey(String query) {
    int lastInsertId = 0;
    try {
      Class.forName("com.mysql.jdbc.Driver");
      String dbpwd = Utilfunctions.getDbConfig("password");
      if (con == null)
        con = DriverManager.getConnection("jdbc:mysql://localhost:3306/schedulepro", "root", dbpwd);

      PreparedStatement statement = con.prepareStatement(query, Statement.RETURN_GENERATED_KEYS);
      statement.executeUpdate();

      ResultSet keys = statement.getGeneratedKeys();
      keys.next();
      lastInsertId = keys.getInt(1);

      return lastInsertId;
    } catch (Exception e) {
      JOptionPane.showMessageDialog(null, e);
    }
    return lastInsertId;
  }
Esempio n. 6
0
  public static ResultSet executeQuery(String query) {

    try {
      try {
        Class.forName("com.mysql.jdbc.Driver");
      } catch (ClassNotFoundException ex) {
        JOptionPane.showMessageDialog(null, ex.getMessage());
      }
      String dbpwd = Utilfunctions.getDbConfig("password");
      if (con == null)
        con = DriverManager.getConnection("jdbc:mysql://localhost:3306/schedulepro", "root", dbpwd);

      PreparedStatement statement = con.prepareStatement(query);
      result = statement.executeQuery();

    } catch (SQLException e) {
      // JOptionPane.showMessageDialog(null, e.getMessage());
      Logger.getLogger(DayWisePeriodConfigChooseForm.class.getName()).log(Level.SEVERE, null, e);
    }

    return result;
  }