public void select() throws RowNotFoundException {
try {
Connection conn = ConnectionManager.getConection();
Statement stmt = conn.createStatement();
ResultSet rs = null;
rs =
stmt.executeQuery(
"SELECT * FROM "
+ nombreTabla
+ " WHERE idGeneral ="
+ MysqlUtils.toMysqlString(telefono.getIdGeneral())
+ "AND descTelefono ="
+ MysqlUtils.toMysqlString(telefono.getDescTelefono()));
if (rs.next()) {
telefono.setIdGeneral(rs.getString("idGeneral"));
telefono.setDescTelefono(rs.getString("descTelefono"));
telefono.setTelefono(rs.getString("telefono"));
telefono.setTelefono2(rs.getString("telefono2"));
} else {
throw new RowNotFoundException();
}
} catch (Exception ex) {
System.out.println(ex);
}
}
public void insert() throws RowExistsException {
if (milog.isInfoEnabled()) {
milog.info("Telefono de: " + telefono.idGeneral);
}
try {
Connection conn = ConnectionManager.getConection();
Statement stmt = conn.createStatement();
ResultSet rs = null;
StringBuffer sqlString = new StringBuffer("INSERT INTO " + nombreTabla);
sqlString.append(" VALUES (" + MysqlUtils.toMysqlString(telefono.getIdGeneral()) + ", ");
sqlString.append(MysqlUtils.toMysqlString(telefono.getDescTelefono()) + ", ");
sqlString.append(MysqlUtils.toMysqlString(telefono.getTelefono()) + ", ");
sqlString.append(MysqlUtils.toMysqlString(telefono.getTelefono2()) + ")");
if (milog.isInfoEnabled()) {
milog.info("comando sql: " + sqlString);
}
stmt.execute(sqlString.toString());
} catch (Exception ex) {
if (milog.isInfoEnabled()) {
milog.info("error: " + ex.toString());
}
throw new RowExistsException();
}
}
public void delete() throws RowNotFoundException {
try {
Connection conn = ConnectionManager.getConection();
Statement stmt = conn.createStatement();
ResultSet rs = null;
StringBuffer sqlString = new StringBuffer("DELETE FROM " + nombreTabla);
sqlString.append(
" WHERE idGeneral="
+ MysqlUtils.toMysqlString(telefono.getIdGeneral())
+ "AND descTelefono="
+ MysqlUtils.toMysqlString(telefono.getDescTelefono()));
stmt.execute(sqlString.toString());
} catch (Exception ex) {
throw new RowNotFoundException();
}
}