I want to save a highscore in a database, but if an sql-exeption is thrown I want to temporary save the data in a file. The game has diffent modes and for each there is a highscore. I would like to have a savefile like this:
2
Bob
4
Luca
6
Celina
9
Bob
Line 1 is the score for gamemode 1 and in line 2 there is the name of the player. Line 3 and 4 for gamemode 2 and so on.
I have this Java Code:
public static void saveHighscoreToDatabase(int spielModus, String nameHighscoretraeger, int score){
try {
Connection connection = DriverManager.getConnection(url, user, password);
String sql = null;
if (spielModus == 1){
sql = "INSERT INTO HighscoreLeicht (`Name`, `Score`) VALUES (?,?)";
}else if (spielModus == 2){
sql = "INSERT INTO HighscoreMittel (`Name`, `Score`) VALUES (?,?)";
}else if (spielModus == 3){
sql = "INSERT INTO HighscoreSchwer (`Name`, `Score`) VALUES (?,?)";
}else if (spielModus == 4){
sql = "INSERT INTO HighscoreModus (`Name`, `Score`) VALUES (?,?)";
}
PreparedStatement statement = connection.prepareStatement(sql);
statement.setString(1,nameHighscoretraeger);
statement.setInt(2, score);
statement.execute();
connection.close();
} catch (SQLException e) {
try {
BufferedWriter bw = new BufferedWriter(new FileWriter("....SaveFile.txt",true));
if (spielModus == 1){
bw.write(String.valueOf(score));
bw.newLine();
bw.write(nameHighscoretraeger);
bw.close();
}else if (spielModus == 2){
bw.newLine();
bw.newLine();
bw.write(String.valueOf(score));
bw.newLine();
bw.write(nameHighscoretraeger);
bw.close();
}else if (spielModus == 3){
}else if (spielModus == 4){
}
}catch (Exception e2){
System.out.println("Error");
}
}
The problem is, that the data of line 1 and 2 for example gets deleted if I want to save the data for line 3 and 4.
I tried using "newLine()" to skip the lines I'm already using, but then the data from those lines gets deleted. For example if I want to save the score 4 with the name Luca (line 3 and 4) the score of the gamemode 1 (2 and Bob, line 1 and 2) gets deletetd.
<blank>
<blank>
4
Luca