public Cuota getCuota(long id) {
ResultSet resu = null;
Statement stmte = null;
Connection conne = null;
try {
conne = super.getConection();
stmte = conne.createStatement();
resu =
stmte.executeQuery(
"SELECT cuotas_id, periodo, alumnos_id, inscripciones_id, monto, pagado, facturas_serie, facturas_numero, cuota FROM cuotas "
+ "where cuotas_id = '"
+ id
+ "'");
} catch (SQLException ex) {
while (ex != null) {
ex.printStackTrace();
ex = ex.getNextException();
}
}
Cuota c = new Cuota();
try {
while (resu.next()) {
c.setId(resu.getLong(1));
c.setPeriodo(resu.getTimestamp(2));
c.setIdAlumno(resu.getLong(3));
c.setInscripcion(resu.getLong(4));
c.setMonto(resu.getDouble(5));
c.setPagado(resu.getBoolean(6));
c.setSerieFactura(resu.getInt(7));
c.setNumeroFactura(resu.getLong(8));
c.setCuota(resu.getBoolean(9));
c.setPago(this.getPago(c.getId()));
c.setProducto(this.getProducto(resu.getInt(10)));
}
} catch (SQLException ex) {
while (ex != null) {
ex.printStackTrace();
ex = ex.getNextException();
}
}
try {
resu.close();
stmte.close();
conne.close();
} catch (SQLException e) {
while (e != null) {
e.printStackTrace();
e = e.getNextException();
}
}
return c;
}
public int modificarCuota(Cuota cuota) {
Statement stmt = null;
Connection conn = null;
int registrosInsertados = 0;
try {
conn = super.getConection();
stmt = conn.createStatement();
System.out.println(
"UPDATE cuotas "
+ "SET monto = '"
+ cuota.getMonto()
+ "' , pagado = '"
+ cuota.isPagado()
+ "', facturas_serie = '"
+ cuota.getSerieFactura()
+ "', facturas_numero = '"
+ cuota.getNumeroFactura()
+ "' "
+ ", productos_id = '"
+ cuota.getProducto().getIdproducto()
+ "' "
+ "WHERE cuotas_id = "
+ cuota.getId());
registrosInsertados =
stmt.executeUpdate(
"UPDATE cuotas "
+ "SET monto = '"
+ cuota.getMonto()
+ "' , pagado = '"
+ cuota.isPagado()
+ "', facturas_serie = '"
+ cuota.getSerieFactura()
+ "', facturas_numero = '"
+ cuota.getNumeroFactura()
+ "' "
+ ", productos_id = '"
+ cuota.getProducto().getIdproducto()
+ "' "
+ "WHERE cuotas_id = "
+ cuota.getId());
} catch (SQLException ex) {
while (ex != null) {
ex.printStackTrace();
ex = ex.getNextException();
}
try {
stmt.close();
conn.close();
} catch (SQLException e) {
while (e != null) {
e.printStackTrace();
e = e.getNextException();
}
}
}
return registrosInsertados;
}