Advertisement
Guest User

Untitled

a guest
Feb 27th, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.66 KB | None | 0 0
  1. try {
  2. Connection con = DriverManager.getConnection("jdbc:mysql://172.18.2.70:3306/mysql?verifyServerCertificate=false&useSSL=true",
  3. "userek" , "$ala_ma!kota%");
  4. Statement st = con.createStatement();
  5.  
  6. ResultSet rs = st.executeQuery("Select * from userek.tabelka");
  7. show (rs);
  8. st.close();
  9.  
  10. st = con.createStatement();
  11. int update_count = st.executeUpdate("INSERT INTO USEREK.TABELKA Values (0,'xD','xDDDDDD', 0)");
  12. System.out.println(update_count + "wypisane wiersze z USEREK.TABELKA");
  13. st.close();
  14.  
  15. con.close();
  16. }catch(Exception e){
  17. e.printStackTrace();
  18. }
  19.  
  20. }
  21. public static void show(ResultSet rs) throws SQLException{
  22.  
  23. Vector<Vector<String>> wiersze = new Vector<Vector<String>>();
  24.  
  25. while (rs.next()){
  26.  
  27. Vector<String> wiersz = new Vector<>();
  28. wiersz.addElement(rs.getString("id"));
  29. wiersz.addElement(rs.getString("imie"));
  30. wiersz.addElement(rs.getString("nazwisko"));
  31. wiersz.addElement(rs.getString("pensja"));
  32. wiersz.addElement(rs.getString("imie") + " " + rs.getString("nazwisko"));
  33. wiersze.add(wiersz);
  34.  
  35. }
  36. System.out.println("Begin--------");
  37. for (Vector<String>wiersz : wiersze){
  38. System.out.println("Wiersz: " + wiersz);
  39. }
  40. System.out.println("End--------");
  41. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement