public void determineBMI(User user) {
PreparedStatement ps;
try {
ps =
getConnection()
.prepareStatement(
" SELECT w.weight, u.length, w.user_IDuser "
+ " FROM uber.user u, uber.weight w "
+ " WHERE w.user_IDuser = ? "
+ " AND w.weightdate = ( SELECT MAX(w.weightdate) FROM uber.weight w WHERE w.user_IDuser = ? )"
+ " AND u.iduser = ? ");
this.user = user;
ps.setInt(1, user.getIdUser());
ps.setInt(2, user.getIdUser());
ps.setInt(3, user.getIdUser());
ResultSet rs = ps.executeQuery();
while (rs.next()) {
height = rs.getDouble(2);
weight = rs.getDouble(1);
}
} catch (SQLException e) {
error("determineBMI()");
e.printStackTrace();
}
BMICalculate();
}
public void execute(Session bot, String channel, User user, String message)
throws SessionException {
SimpleStringTokenizer tokens = new SimpleStringTokenizer(message);
List<SessionCommand> commandList = new LinkedList<SessionCommand>();
SessionCommandManager manager = bot.getCommandManager();
while (tokens.hasMoreTokens()) {
SessionCommand command = manager.getCommand(tokens.nextToken());
if (command != null) {
commandList.add(command);
}
}
if (commandList.size() < 1) {
commandList = manager.getCommands();
}
String target = channel;
if (commandList.size() > 1) {
target = user.getNick();
}
for (SessionCommand t : commandList) {
String msg;
if (t.getUsage() == null) {
msg = manager.getPrefix() + t.getName();
} else {
msg = manager.getPrefix() + t.getName() + " " + t.getUsage();
}
bot.msg(target, msg);
}
}
public void insertBMI(double bmiArg) {
PreparedStatement ps;
try {
ps =
getConnection()
.prepareStatement("INSERT INTO uber.bmi (bmi, user_iduser) " + " VALUES (?, ?)");
ps.setDouble(1, bmiArg);
ps.setInt(2, user.getIdUser());
ps.execute();
} catch (SQLException e) {
error("insertBMI()");
e.printStackTrace();
}
}
public String getUsernameTitleToString() {
return user.getUserName() + ": " + title;
}
@Override
public String toString() {
return user.getUserName() + ": " + text;
}