Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package DB;
- import javafx.collections.FXCollections;
- import javafx.collections.ObservableList;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.Statement;
- public class GestoreQueryCerca<T> {
- public ObservableList cerca(String tabella) {
- // Connect to database
- //non ho capito com si fa xD
- try {
- connection c = DriverManager.getConnection();
- // Create tutti i risultati in una tabella
- String selectSql = "SELECT * " +
- "FROM " + tabella;
- try (Statement statement = c.createStatement();
- ResultSet rS = statement.executeQuery(selectSql)) {
- ObservableList products = FXCollections.observableArrayList();
- // inserisco i risultati nella lista preferisco un set
- while (rS.next())//scorro gli elementi del risultato
- {
- String a = rS.getString(1);
- String b = rS.getString(2);
- String c = rS.getString(3);
- products.add( a,b,c,"[]" );
- }
- connection.close();
- }
- }
- catch (Exception e) {
- e.printStackTrace();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement