int rows;
String timestamp;
String[] timestamp_ = new String[6];
String datum;
String zeit;
ResultSet rs;
public List getForum_ansicht() {
int i = 0;
try{
Class.forName(db_driver);
try{
Connection db = DriverManager.getConnection(db_url, db_username, db_password);
if(req.getParameter("forumID") == null && req.getParameter("threadID") == null) {
String rowStatement = "SELECT id FROM forum_foren";
PreparedStatement row_prepStmt = db.prepareStatement(rowStatement);
ResultSet row_rs = row_prepStmt.executeQuery();
row_rs.next();
row_rs.last();
rows = row_rs.getRow();
String selectStatement = "SELECT id, titel FROM forum_foren";
PreparedStatement select_prepStmt = db.prepareStatement(selectStatement);
rs = select_prepStmt.executeQuery();
while(rs.next()) {
array.add(i, new forum_ansicht_spalten(rs.getInt("id"), rs.getString("titel")));
i++;
}
} else if(req.getParameter("forumID") != null && Integer.parseInt(req.getParameter("forumID")) > 0 && req.getParameter("threadID") == null) {
String rowStatement = "SELECT id, forenid FROM forum_threads WHERE forenid = ?";
PreparedStatement row_prepStmt = db.prepareStatement(rowStatement);
row_prepStmt.setString(1, req.getParameter("forumID"));
ResultSet row_rs = row_prepStmt.executeQuery();
row_rs.next();
row_rs.last();
rows = row_rs.getRow();
String selectStatement = "SELECT id, titel, forenid FROM forum_threads WHERE forenid = ? ORDER BY timestamp_edit DESC";
PreparedStatement select_prepStmt = db.prepareStatement(selectStatement);
select_prepStmt.setString(1, req.getParameter("forumID"));
rs = select_prepStmt.executeQuery();
while(rs.next()) {
array.add(i, new forum_ansicht_spalten(rs.getInt("id"), rs.getString("titel"), rs.getInt("forenid")));
i++;
}
} else if(req.getParameter("forumID") != null && Integer.parseInt(req.getParameter("forumID")) > 0 && req.getParameter("threadID") != null && Integer.parseInt(req.getParameter("threadID")) > 0) {
String rowStatement = "SELECT id, forenid, threadid FROM forum_messages WHERE forenid = ? AND threadid = ?";
PreparedStatement row_prepStmt = db.prepareStatement(rowStatement);
row_prepStmt.setString(1, req.getParameter("forumID"));
row_prepStmt.setString(2, req.getParameter("threadID"));
ResultSet row_rs = row_prepStmt.executeQuery();
row_rs.next();
row_rs.last();
rows = row_rs.getRow();
String selectStatement = "SELECT forum_messages.id AS forum_messages_id, forum_messages.titel, forum_messages.forenid, forum_messages.threadid, forum_messages.message, forum_messages.userid, forum_messages.userid_edit, forum_messages.timestamp_create, forum_messages.timestamp_edit, users.id AS forum_users_id, users.username, users.profil_image FROM forum_messages, users WHERE forum_messages.forenid = ? AND forum_messages.threadid = ? AND forum_messages.userid = users.id ORDER BY forum_messages.timestamp_create ASC";
PreparedStatement select_prepStmt = db.prepareStatement(selectStatement);
select_prepStmt.setString(1, req.getParameter("forumID"));
select_prepStmt.setString(2, req.getParameter("threadID"));
rs = select_prepStmt.executeQuery();
while(rs.next()) {
timestamp = new Date(rs.getLong("timestamp_create")*1000).toString();
timestamp_ = timestamp.split(" ");
if(timestamp_[0].equals("Sun")) {
timestamp_[0] = "Sonntag";
} else if(timestamp_[0].equals("Mon")) {
timestamp_[0] = "Montag";
} else if(timestamp_[0].equals("Thu")) {
timestamp_[0] = "Dienstag";
} else if(timestamp_[0].equals("Wed")) {
timestamp_[0] = "Mittwoch";
} else if(timestamp_[0].equals("Thur")) {
timestamp_[0] = "Donnerstag";
} else if (timestamp_[0].equals("Fri")) {
timestamp_[0] = "Freitag";
} else if(timestamp_[0].equals("Sat")) {
timestamp_[0] = "Samstag";
}
if(timestamp_[1].equals("Jan")) {
timestamp_[1] = "01";
} else if(timestamp_[1].equals("Feb")) {
timestamp_[1] = "02";
} else if(timestamp_[1].equals("Mar")) {
timestamp_[1] = "03";
} else if(timestamp_[1].equals("Apr")) {
timestamp_[1] = "04";
} else if(timestamp_[1].equals("May")) {
timestamp_[1] = "05";
} else if (timestamp_[1].equals("Jun")) {
timestamp_[1] = "06";
} else if(timestamp_[1].equals("July")) {
timestamp_[1] = "07";
} else if(timestamp_[1].equals("Aug")) {
timestamp_[1] = "08";
} else if(timestamp_[1].equals("Sept")) {
timestamp_[1] = "09";
} else if(timestamp_[1].equals("Oct")) {
timestamp_[1] = "10";
} else if(timestamp_[1].equals("Nov")) {
timestamp_[1] = "11";
} else if(timestamp_[1].equals("Dec")) {
timestamp_[1] = "12";
}
datum = timestamp_[0] + ", " + timestamp_[2] + "." + timestamp_[1] + "." + timestamp_[5];
zeit = timestamp_[3];
array.add(i, new forum_ansicht_spalten(rs.getInt("forum_messages_id"), datum, zeit, rs.getString("forum_messages.titel"), rs.getString("forum_messages.message"), rs.getString("users.username"), rs.getString("users.profil_image")));
i++;
}
}
rs.close();
db.close();
} catch(Exception db_error) {
System.out.println(db_error);
}
} catch(Exception db_driver_error) {
System.out.println(db_driver_error);
}
return array;
}