public void beolvas() {
try { // adatok beolvasása
jatekoslista.clear();
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://195.199.32.121:3306/pisti";
String user = "pisti";
String pass = "jelszo";
Connection conn = DriverManager.getConnection(url, user, pass);
Statement st = conn.createStatement();
String sql = "Select * FROM `adatok`;";
ResultSet rs = st.executeQuery(sql);
while (rs.next()) {
int id = rs.getInt("id");
String nev = rs.getString("felhasznalonev");
int x = rs.getInt("x");
int y = rs.getInt("y");
int iranyx = rs.getInt("iranyx");
int iranyy = rs.getInt("iranyy");
int el = rs.getInt("el");
// int time = rs.getInt("time");
Ember ad = new Ember(nev);
jatekoslista.add(ad);
}
conn.close();
st.close();
rs.close();
} catch (Exception e) {
System.out.println("Error: " + e.getMessage());
}
}
Az utolsó módosítás: 2023 September 19 13:49:18.