public void actualizar(partners pa) throws Exception {
try {
this.Conectar();
System.out.println("Aqui vamos");
String query =
"update partner set name=?, lastname=?, street=?, noExt=?, noInt=?, colony=?, zip=?, locality=?, phone=?, mobile=?, email=?, customer=? ,supplier=?, image=?,city_id=?,state_id=?,country_id=?,active=? where id=?";
PreparedStatement st = this.getCon().prepareStatement(query);
st.setString(1, pa.getName());
st.setString(2, pa.getLastName());
st.setString(3, pa.getStreet());
st.setString(4, pa.getNoExt());
st.setString(5, pa.getNoInt());
st.setString(6, pa.getColony());
st.setString(7, pa.getZip());
st.setString(8, pa.getLocality());
st.setString(9, pa.getPhone());
st.setString(10, pa.getMobile());
st.setString(11, pa.getEmail());
st.setBoolean(12, pa.getCustomer());
st.setBoolean(13, pa.isSupplier());
st.setBytes(14, pa.getImage());
st.setInt(15, pa.getCity_id());
st.setInt(16, pa.getState_id());
st.setInt(17, pa.getCity_id());
st.setInt(18, pa.getActive());
st.setInt(19, pa.getIdPartner());
st.executeUpdate();
} catch (Exception e) {
throw e;
} finally {
this.Cerrar();
}
}
public void registrar(partners pa) throws Exception {
try {
this.Conectar();
String query =
"insert into partner (name,lastname,street,noExt,noInt,colony,zip,locality,phone,mobile,email,customer,supplier,image,city_id,state_id,country_id,active)"
+ "values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); ";
PreparedStatement st = this.getCon().prepareStatement(query);
st.setString(1, pa.getName());
st.setString(2, pa.getLastName());
st.setString(3, pa.getStreet());
st.setString(4, pa.getNoExt());
st.setString(5, pa.getNoInt());
st.setString(6, pa.getColony());
st.setString(7, pa.getZip());
st.setString(8, pa.getLocality());
st.setString(9, pa.getPhone());
st.setString(10, pa.getMobile());
st.setString(11, pa.getEmail());
st.setBoolean(12, pa.getCustomer());
st.setBoolean(13, pa.isSupplier());
st.setBytes(14, pa.getImage());
st.setInt(15, pa.getCity_id());
st.setInt(16, pa.getState_id());
st.setInt(17, pa.getCity_id());
st.setInt(18, pa.getActive());
st.executeUpdate();
} catch (Exception e) {
throw e;
} finally {
this.Cerrar();
}
}
public List<partners> Mostrar(partners pa) throws Exception {
List<partners> lista;
ResultSet rs;
try {
this.Conectar();
PreparedStatement st = this.getCon().prepareCall("select * from partner where id=?");
rs = st.executeQuery();
lista = new ArrayList();
while (rs.next()) {
partners part = new partners();
part.setIdPartner(rs.getInt("id"));
part.setName(rs.getString("name"));
part.setLastName(rs.getString("lastname"));
part.setStreet(rs.getString("street"));
part.setNoExt(rs.getString("noExt"));
part.setNoInt(rs.getString("noInt"));
part.setColony(rs.getString("Colony"));
part.setZip(rs.getString("Zip"));
part.setLocality(rs.getString("Locality"));
part.setPhone(rs.getString("Phone"));
part.setMobile(rs.getString("Mobile"));
part.setCustomer(rs.getBoolean("Customer"));
part.setSupplier(rs.getBoolean("Supplier"));
part.setImage(rs.getBytes("image"));
part.setCity_id(rs.getInt("City_id"));
part.setState_id(rs.getInt("State_id"));
part.setCountry_id(rs.getInt("Country_id"));
lista.add(part);
}
} catch (Exception e) {
throw e;
} finally {
this.Cerrar();
}
return lista;
}
public partners LeerID_Actualizar(int pa) throws Exception {
partners part = null;
ResultSet rs;
try {
this.Conectar();
PreparedStatement st =
this.getCon().prepareStatement("" + "select * from partner where id= ? ");
st.setInt(1, pa);
rs = st.executeQuery();
while (rs.next()) {
part = new partners();
part.setIdPartner(rs.getInt("id"));
part.setName(rs.getString("name"));
part.setLastName(rs.getString("lastname"));
part.setStreet(rs.getString("street"));
part.setNoExt(rs.getString("noExt"));
part.setNoInt(rs.getString("noInt"));
part.setColony(rs.getString("Colony"));
part.setZip(rs.getString("Zip"));
part.setLocality(rs.getString("Locality"));
part.setPhone(rs.getString("Phone"));
part.setMobile(rs.getString("Mobile"));
part.setCustomer(rs.getBoolean("Customer"));
part.setSupplier(rs.getBoolean("Supplier"));
part.setImage(rs.getBytes("image"));
part.setCity_id(rs.getInt("City_id"));
part.setState_id(rs.getInt("State_id"));
part.setCountry_id(rs.getInt("Country_id"));
}
} catch (Exception e) {
throw e;
} finally {
this.Cerrar();
}
return part;
}