public ArrayList obtenerCriterioxCompetencia(int xId) {
try {
Statement stmt = null;
ResultSet rs = null;
ConexionBD connect = new ConexionBD();
Connection con = connect.getConnect();
ArrayList cc = new ArrayList();
// SQL query command
String SQL = "SELECT * FROM tr_criterio_competencia where competencia_id = " + xId;
stmt = con.createStatement();
rs = stmt.executeQuery(SQL);
while (rs.next()) {
cc.add(
new CriterioCompetencia(
rs.getInt("CRITERIO_COMPETENCIA_ID"),
rs.getInt("CRITERIO_ID"),
rs.getInt("COMPETENCIA_ID")));
}
return cc;
} catch (SQLException ex) {
System.out.println("SQL Exception: " + ex.toString());
}
return null;
}
public int crearCriterioCompetencia(int idCompetencia, int idCriterio) {
ConexionBD connect = new ConexionBD();
Connection con = connect.getConnect();
if (con != null) {
try {
PreparedStatement stmt1 =
(PreparedStatement)
con.prepareStatement(
"Insert into tr_criterio_competencia(competencia_id,criterio_id)"
+ "VALUES(?,?)");
stmt1.setInt(1, idCompetencia);
stmt1.setInt(2, idCriterio);
int rows_updated = stmt1.executeUpdate();
con.close();
return rows_updated;
} catch (SQLException ex) {
System.out.println("SQL Exception: " + ex.toString());
}
}
return 0;
}
public int eliminarCriterio(int xIdCriterio, int xIdCompetencia) {
ConexionBD connect = new ConexionBD();
Connection con = connect.getConnect();
if (con != null) {
try {
PreparedStatement stmt1 =
(PreparedStatement)
con.prepareStatement(
"DELETE FROM tr_criterio_competencia WHERE CRITERIO_ID=? AND COMPETENCIA_ID = ?");
stmt1.setInt(1, xIdCriterio);
stmt1.setInt(2, xIdCompetencia);
int rows_updated = stmt1.executeUpdate();
con.close();
return rows_updated;
} catch (SQLException ex) {
System.out.println("SQL Exception: " + ex.toString());
}
}
return 0;
}