Advertisement
Guest User

Untitled

a guest
May 17th, 2016
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.36 KB | None | 0 0
  1. public synchronized String pobierzStatystyki(){
  2. Connection c = null;
  3. Statement stat = null;
  4. String wynik = "";
  5.  
  6. try {
  7. Class.forName("org.sqlite.JDBC");
  8.  
  9. c = DriverManager.getConnection("jdbc:sqlite:statystyki.db");
  10.  
  11. stat = c.createStatement();
  12.  
  13. String comenda = "SELECT * FROM STATYSTYKI";
  14.  
  15. ResultSet result = stat.executeQuery(comenda);
  16.  
  17. while(result.next()){
  18. wynik += result.getString("UZYTKOWNIK");
  19. wynik += "\n";
  20. wynik += result.getInt("PUNKTY");
  21. wynik += "\n";
  22. }
  23. stat.close();
  24. c.close();
  25.  
  26. } catch (ClassNotFoundException ex) {
  27. ex.printStackTrace();
  28. } catch (SQLException ex) {
  29. ex.printStackTrace();
  30. }
  31.  
  32. return wynik;
  33. }
  34.  
  35. public synchronized void dodajStatystyke(String nazwa,int punkty){
  36. Connection c = null;
  37. Statement stat = null;
  38.  
  39. try {
  40. Class.forName("org.sqlite.JDBC");
  41.  
  42. c = DriverManager.getConnection("jdbc:sqlite:statystyki.db");
  43.  
  44. stat = c.createStatement();
  45.  
  46. String comenda;
  47. /*comenda = "DROP TABLE STATYSTYKI";
  48. try{
  49. stat.executeUpdate(comenda);
  50. }catch(Exception ex){
  51.  
  52. }*/
  53. try{
  54. comenda = "CREATE TABLE STATYSTYKI("
  55. + "UZYTKOWNIK TEXT,"
  56. + "PUNKTY INTEGER"
  57. + ");";
  58.  
  59. stat.executeUpdate(comenda);
  60. }catch(Exception ex){
  61. //ex.printStackTrace();
  62. }
  63.  
  64. comenda = "INSERT INTO STATYSTYKI VALUES ("
  65. + "'"+ nazwa + "',"
  66. + punkty
  67. + ");";
  68.  
  69. stat.executeUpdate(comenda);
  70.  
  71.  
  72. stat.close();
  73. c.close();
  74.  
  75. } catch (ClassNotFoundException ex) {
  76. ex.printStackTrace();
  77. } catch (SQLException ex) {
  78. ex.printStackTrace();
  79. }
  80. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement