Advertisement
Guest User

Untitled

a guest
May 26th, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.76 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()){
  13.             if(column.isNumber()){
  14.                 valueSet.add(rs.getFloat(1));
  15.                 }
  16.             else{
  17.                 valueSet.add(rs.getString(1));}
  18.             }
  19.        
  20.         rs.close();
  21.         statement.close();
  22.        
  23.         return valueSet;
  24.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement