public static ArrayList<String> getDrugNames(){
        Statement stmt = null;
        ResultSet rs = null;
        String sql= "SELECT * FROM DRUGS";
        ArrayList<String> count=null;
      try {
        stmt =  conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);	
        rs = stmt.executeQuery(sql);
		count= new ArrayList<String>();
		int i=0;
		while(rs.next()){		
			count.add(i,rs.getString("drugname").toLowerCase());
			
			i++;
		}  
		System.out.println(count);
      } catch (SQLException ex) {
        Logger.getLogger(DatabaseProcess.class.getName()).log(Level.SEVERE, null, ex);
      }	finally{
          try {
            if(rs!=null) rs.close();
            if(stmt!=null) stmt.close();
          } catch (SQLException ex) {
            Logger.getLogger(DatabaseProcess.class.getName()).log(Level.SEVERE, null, ex);
          }
      }
		return count;		
	}