예제 #1
0
  public ArrayList<Fabricante> getFabricantes(String material)
      throws ClassNotFoundException, SQLException {

    Connection con = null;

    try {

      con = ConexaoDAO.getConnection();
      ResultSet rs =
          con.createStatement()
              .executeQuery("SELECT nome FROM fabricante WHERE material='" + material + "'");
      ArrayList<Fabricante> tipos = new ArrayList<>();

      while (rs.next()) {
        Fabricante f = new Fabricante();
        f.setNome(rs.getString(1));
        tipos.add(f);
      }

      return tipos;

    } catch (Exception e) {

      con.close();
      return null;
    }
  }
예제 #2
0
  public boolean cadastrar(Fabricante fab) throws SQLException {

    Connection con = null;
    PreparedStatement st = null;

    try {

      con = ConexaoDAO.getConnection();
      st = con.prepareStatement("INSERT INTO fabricante (nome,material) VALUES(?,?)");
      st.setString(1, fab.getNome());
      st.setString(2, fab.getMaterial());
      ;
      return st.execute();

    } catch (Exception e) {

      // e.printStackTrace();
      st.close();
      con.close();
      return false;
    }
  }