Advertisement
pawlas91

Untitled

Jun 25th, 2019
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.67 KB | None | 0 0
  1.  @Override
  2.     public void initialize(URL location, ResourceBundle resources) {
  3.         try {
  4.             Class.forName("com.mysql.cj.jdbc.Driver");
  5.             con = DriverManager.getConnection("jdbc:mysql://192.168.31" +
  6.                     ".128:3303/arduino?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false" +
  7.                     "&serverTimezone=UTC", "java", "java");
  8.             st = con.createStatement();
  9.             ResultSet rs = con.createStatement().executeQuery("select * from czujniki");
  10.             while (rs.next()) {
  11.                 oblist.add(new ModelTabeli(rs.getString("ID"), rs.getString("DATA"), rs.getString("TEMP_ZEW"),
  12.                         rs.getString("WILG_ZEW"),
  13.                         rs.getString("TEMP_WEW"), rs.getString("WILG_WEW"), rs.getString("CISNIENIE"), rs.getString(
  14.                         "WYSOKOSC"), rs.getString("CO_PPM")));
  15.             }
  16.  
  17.         } catch (Exception ex) {
  18.             System.out.println(ex);
  19.         }
  20.  
  21.         id1.setCellValueFactory(new PropertyValueFactory<>("ID"));
  22.         data1.setCellValueFactory(new PropertyValueFactory<>("DATA"));
  23.         t1.setCellValueFactory(new PropertyValueFactory<>("TEMP_ZEW"));
  24.         w1.setCellValueFactory(new PropertyValueFactory<>("WILG_ZEW"));
  25.         t2.setCellValueFactory(new PropertyValueFactory<>("TEMP_WEW"));
  26.         w2.setCellValueFactory(new PropertyValueFactory<>("WILG_WEW"));
  27.         c1.setCellValueFactory(new PropertyValueFactory<>("CISNIENIE"));
  28.         w3.setCellValueFactory(new PropertyValueFactory<>("WYSOKOSC"));
  29.         p1.setCellValueFactory(new PropertyValueFactory<>("CO_PPM"));
  30.  
  31.         tabela.setItems(oblist);
  32.  
  33.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement