private String mapName;
private int[] mapArraySieg;
private int[] mapArrayNiederlage;
private int mapMaxWin;
private int mapMaxLoss;
private String mapMaxWinName;
private String mapMAxLossName;
public SpielerStatsMap(String mapName) throws IOException{
this.mapName = mapName;
loadMapStats();
}
private void loadMapStats(){
try{
String db_file_name_prefix = "c:\\Users\\Hades 2\\Desktop\\database\\mydb";
Connection con = null;
Class.forName("org.hsqldb.jdbcDriver");
con = DriverManager.getConnection("jdbc:hsqldb:file:" + db_file_name_prefix,"SA",""); //SA Username : kein Passwort
Statement statement = con.createStatement();
mapArraySieg = new int[10];
mapArrayNiederlage = new int[10];
PreparedStatement ps = con.prepareStatement("SELECT * FROM \"Karten_Siege\" ORDER BY ? DESC LIMIT 5");
ps.setString(1, this.mapName);
System.out.println(ps.toString());
ResultSet table_01 = ps.executeQuery();
//ResultSet table_01 = statement.executeQuery("SELECT TOP 10 * FROM \"Karten_Siege\" ORDER BY '"+this.mapName+"' DESC");
int i=0;
while(table_01.next()){
mapArraySieg[i] = table_01.getInt(this.mapName);
i++;
}
table_01 = statement.executeQuery("SELECT TOP 10 * FROM \"Karten_Niederlage\"");
i=0;
while(table_01.next()){
mapArrayNiederlage[i] = table_01.getInt(this.mapName);
i++;
}
String mapname = this.mapName;
mapname.toUpperCase();
table_01 = statement.executeQuery("SELECT MAX '(\"Akropolis\")' AS \"Akropolis\" FROM \"Karten_Siege\"");
i=0;
while(table_01.next()){
mapMaxWin = table_01.getInt(this.mapName);
//mapMaxWinName = table_01.getString("Spieler");
System.out.println("Höchster Sieg "+mapMaxWin+" Name: ");
i++;
}
statement.close();
con.close();
}
catch (SQLException ex){
Logger.getLogger(SpielerStatsMap.class.getName()).log(Level.SEVERE, null, ex);
ex.printStackTrace();
}
catch (ClassNotFoundException ex){
Logger.getLogger(SpielerStatsMap.class.getName()).log(Level.SEVERE, null, ex);
}
}
public int[] getMapArraySieg() {
return mapArraySieg;
}
public int[] getMapArrayNiederlage() {
return mapArrayNiederlage;
}
}
das Setzen der order by Clause OHNE String-Geraffel beherrscht.
