Advertisement
Guest User

Untitled

a guest
May 26th, 2017
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.73 KB | None | 0 0
  1. public  List<Object>getColumnValues(String table,Column column, QUERY_TYPE modality) throws SQLException{
  2.         LinkedList<Object> valueSet = new LinkedList<Object>();
  3.         String query="";
  4.         if(modality.equals(QUERY_TYPE.DISTINCT)){
  5.             query="SELECT DISTINCT"+column.getColumnName()+"FROM"+table;}
  6.         else{
  7.             query="SELECT"+column.getColumnName()+"FROM"+table+"ORDER BY"+column.getColumnName();}
  8.  
  9.         Statement statement = DbAccess.getConnection().createStatement();//connessione al Database
  10.         ResultSet rs = statement.executeQuery(query);//eseguo la query
  11.        
  12.         while(rs.next()){//ciclo sulle tuple
  13.             if(column.isNumber()){
  14.                 valueSet.add(rs.getFloat(1));
  15.                 }
  16.             else{
  17.                 valueSet.add(rs.getString(1));}
  18.             }
  19.         return valueSet;
  20.  
  21.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement