public JSONArray ObtenerMateriales() { JSONArray Materiales = new JSONArray(); JSONObject material = new JSONObject(); try { this.cn = getConnection(); this.st = this.cn.createStatement(); String sql; sql = "SELECT * FROM material"; this.rs = this.st.executeQuery(sql); while (this.rs.next()) { Material mat = new Material(rs.getString("codigo"), rs.getString("material")); material = mat.getJSONObject(); System.out.printf(material.toString()); Materiales.add(material); } this.desconectar(); } catch (Exception e) { e.printStackTrace(); } return (Materiales); }
public JSONObject DatosMaterial(String Codigo) { JSONObject mater = new JSONObject(); try { this.cn = getConnection(); this.st = this.cn.createStatement(); String sql = "SELECT * FROM material WHERE codigo = '" + Codigo + "';"; this.rs = this.st.executeQuery(sql); this.rs.first(); Material use = new Material(rs.getString("codigo"), rs.getString("material")); mater = use.getJSONObject(); this.desconectar(); } catch (Exception e) { e.printStackTrace(); } return (mater); }
public boolean AdicionarMaterial(JSONObject datos) { try { this.cn = getConnection(); this.st = cn.createStatement(); Material use = new Material("", String.valueOf(datos.get("material"))); String tsql; tsql = "INSERT INTO material VALUES(DEFAULT, '"; tsql += use.getNombre_material() + "')"; this.st.execute(tsql); this.desconectar(); } catch (Exception e) { e.printStackTrace(); return false; } return true; }
public boolean ModificarMaterial(JSONObject datos, String Codigo) { try { this.cn = getConnection(); this.st = cn.createStatement(); Material use = new Material("", String.valueOf(datos.get("material"))); String tsql; tsql = "UPDATE material SET material='" + use.getNombre_material() + "' WHERE codigo = " + Codigo + ";"; this.st.execute(tsql); this.desconectar(); } catch (Exception e) { e.printStackTrace(); return false; } return true; }