public void updateGroup(Connection c, Group g) throws AdminException {
PreparedStatement statement = null;
String theQuery =
"update "
+ drvSettings.getGroupTableName()
+ " set "
+ drvSettings.getGroupNameColumnName()
+ " = ?,"
+ drvSettings.getGroupDescriptionColumnName()
+ " = ?"
+ " where "
+ drvSettings.getGroupSpecificIdColumnName()
+ " = ?";
try {
SilverTrace.debug("admin", "SQLGroupTable.updateGroup", "root.MSG_QUERY", theQuery);
statement = c.prepareStatement(theQuery);
statement.setString(1, drvSettings.trunc(g.getName(), 100));
statement.setString(2, drvSettings.trunc(g.getDescription(), 400));
statement.setInt(3, Integer.parseInt(g.getSpecificId()));
statement.executeUpdate();
} catch (Exception e) {
throw new AdminException(
"SQLGroupTable.updateGroup",
SilverpeasException.ERROR,
"root.EX_SQL_QUERY_FAILED",
"Query = " + theQuery,
e);
} finally {
DBUtil.close(statement);
}
}
/** Convert Group to GroupRow */
private GroupRow group2GroupRow(Group group) {
GroupRow gr = new GroupRow();
gr.id = idAsInt(group.getId());
gr.specificId = group.getSpecificId();
gr.domainId = idAsInt(group.getDomainId());
gr.superGroupId = idAsInt(group.getSuperGroupId());
gr.name = group.getName();
gr.description = group.getDescription();
gr.rule = group.getRule();
return gr;
}
/** Inserts in the database a new Group row. */
public int createGroup(Connection c, Group group) throws AdminException {
PreparedStatement statement = null;
int nextId = 0;
String theQuery =
"insert into "
+ drvSettings.getGroupTableName()
+ "("
+ getColumns()
+ ") values (?,?,?,?)";
try {
SilverTrace.debug("admin", "SQLGroupTable.createGroup", "root.MSG_QUERY", theQuery);
statement = c.prepareStatement(theQuery);
nextId =
DBUtil.getNextId(
drvSettings.getGroupTableName(), drvSettings.getGroupSpecificIdColumnName());
statement.setInt(1, nextId);
String gid = group.getSuperGroupId();
if ((gid == null) || (gid.length() <= 0) || (gid.equals("-1")))
statement.setNull(2, Types.INTEGER);
else statement.setInt(2, Integer.parseInt(gid));
statement.setString(3, drvSettings.trunc(group.getName(), 100));
statement.setString(4, drvSettings.trunc(group.getDescription(), 400));
statement.executeUpdate();
} catch (Exception e) {
throw new AdminException(
"SQLGroupTable.createGroup",
SilverpeasException.ERROR,
"root.EX_SQL_QUERY_FAILED",
"Query = " + theQuery,
e);
} finally {
DBUtil.close(statement);
}
return nextId;
}
