public static ManufacturerPOJO getManufacturerById(int id) throws Exception {
    ManufacturerPOJO m = null;
    Connection connect = null;
    try {
      connect = MySqlDataAccessHelper.getConnection();
      CallableStatement statement = connect.prepareCall("{Call sp_getManufacturerById(?)}");
      statement.setInt(1, id);
      ResultSet rs = statement.executeQuery();

      if (rs.next()) {
        m = new ManufacturerPOJO();
        m.setManufacturerId(rs.getInt("manufacturerId"));
        m.setManufacturerName(rs.getString("manufacturerName"));
        m.setCountry(rs.getString("country"));
      }
      connect.close();
      statement.close();
    } catch (Exception ex) {
      throw ex;
    }
    return m;
  }
  public static ArrayList<ManufacturerPOJO> getManufacturerAll() throws Exception {
    ArrayList<ManufacturerPOJO> result = new ArrayList<ManufacturerPOJO>();
    Connection connect = null;
    try {
      connect = MySqlDataAccessHelper.getConnection();
      CallableStatement statement = connect.prepareCall("{Call sp_getManufacturerAll()}");
      ResultSet rs = statement.executeQuery();

      while (rs.next()) {
        ManufacturerPOJO m = new ManufacturerPOJO();
        m.setManufacturerId(rs.getInt("manufacturerId"));
        m.setManufacturerName(rs.getString("manufacturerName"));
        m.setCountry(rs.getString("country"));
        result.add(m);
      }
      connect.close();
      statement.close();
    } catch (Exception ex) {
      throw ex;
    }
    return result;
  }