public static Plan selectPlan(int planID) throws TextFormatException, SQLException {
DBUtil du = DBUtil.getDBUtil();
String SQLCommand = null;
ResultSet rs;
if (planID < 0) throw new TextFormatException("userID is null");
SQLCommand = " select * from " + tableName + " where planID = " + planID;
rs = du.executeQuery(SQLCommand);
rs.next();
return new Plan(
rs.getInt("planID"),
rs.getString("title"),
rs.getString("siteIDs"),
rs.getDate("startTime"),
rs.getDate("endTime"),
rs.getInt("organizer"),
rs.getString("participants"),
rs.getInt("budget"),
rs.getInt("groupNum"),
rs.getInt("groupNumMax"),
rs.getInt("talkStreamID"),
rs.getBoolean("isDone"),
rs.getTimestamp("timestamp"),
rs.getString("information"));
}
public static Vector<Plan> selectPlan(Plan plan) throws TextFormatException, SQLException {
assert plan.getTitle().length() < 80;
DBUtil du = DBUtil.getDBUtil();
String SQLCommand = null;
ResultSet rs;
Plan result_plan;
boolean isAnd = false;
if (plan == null) throw new TextFormatException();
String siteIDs = plan.getSiteIDs();
Date startTime = plan.getStartTime();
Date endTime = plan.getEndTime();
int organizer = plan.getOrganizer();
String participants = plan.getParticipants();
int budget = plan.getBudget();
int groupNum = plan.getGroupNum();
int groupNumMax = plan.getGroupNumMax();
int talkStreamID = plan.getTalkStreamID();
SQLCommand = " select * from " + tableName + " where ";
if (budget >= 0) {
SQLCommand += " budget = '" + budget + "'";
isAnd = true;
}
if (groupNum >= 0) {
if (isAnd) SQLCommand += " and ";
SQLCommand += " groupNum = " + groupNum;
isAnd = true;
}
if (groupNumMax >= 0) {
if (isAnd) SQLCommand += " and ";
SQLCommand += " groupNumMax = " + groupNumMax;
isAnd = true;
}
if (talkStreamID >= 0) {
if (isAnd) SQLCommand += " and ";
SQLCommand += " talkStreamID = " + talkStreamID;
isAnd = true;
}
if (organizer >= 0) {
if (isAnd) SQLCommand += " and ";
SQLCommand += " organizer = " + organizer;
isAnd = true;
}
if (startTime != null) {
if (isAnd) SQLCommand += " and ";
SQLCommand += " startTime >= '" + startTime + "'";
isAnd = true;
}
if (endTime != null) {
if (isAnd) SQLCommand += " and ";
SQLCommand += " endTime <= '" + endTime + "'";
isAnd = true;
}
rs = du.executeQuery(SQLCommand);
Vector<Plan> vector = new Vector<Plan>();
while (rs.next()) {
result_plan =
new Plan(
rs.getInt("planID"),
rs.getString("title"),
rs.getString("siteIDs"),
rs.getDate("startTime"),
rs.getDate("endTime"),
rs.getInt("organizer"),
rs.getString("participants"),
rs.getInt("budget"),
rs.getInt("groupNum"),
rs.getInt("groupNumMax"),
rs.getInt("talkStreamID"),
rs.getBoolean("isDOne"),
rs.getTimestamp("timestamp"),
rs.getString("information"));
vector.add(result_plan);
}
return vector;
}
