try {
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, username);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
Log log = new Log();
log.setUsername(rs.getString(1));
log.setDate(rs.getString(2).substring(0, 19));
log.setAction(rs.getString(3));
log.setFilename(rs.getString(4));
log.setPathname(rs.getString(5));
logList.add(log);
}
return logList;
} catch (SQLException e) {
e.printStackTrace();