hqsampcF

1} else if (StorageManager.useMySQL) {
2String checkEntry = "SELECT bending FROM bending_language WHERE player ='"
3+ player.getName() + "'";
4ResultSet rs = this.MySql.select(checkEntry);
5try {
6if (rs.next()) {
7String updateEntry = "UPDATE bending_language SET language = "
8+ language
9+ " WHERE player ='"
10+ player.getName()
11+ "'";
12this.MySql.update(updateEntry);
13} else {
14String insertEntry = "INSERT INTO bending_language VALUES('"
15+ player.getName() + "','" + language + "')";
16this.MySql.insert(insertEntry);
17}
18} catch (SQLException e) {
19// TODO Auto-generated catch block
20e.printStackTrace();
21}
22}
23
24
25
26[...]
27public void initialize(File file)
28[...]
29	if (this.MySql.initialize()) {
30String createTable1 = "CREATE TABLE IF NOT EXISTS bending_element(player TEXT NOT NULL, bending TEXT NOT NULL)";
31String createTable2 = "CREATE TABLE IF NOT EXISTS bending_ability(player TEXT NOT NULL, setter TEXT NOT NULL, ability TEXT NOT NULL)";
32String createTable3 = "CREATE TABLE IF NOT EXISTS bending_language(player TEXT NOT NULL, language TEXT NOT NULL)";
33MySql.execute(createTable1);
34MySql.execute(createTable2);
35MySql.execute(createTable3);