public ArrayList<Value> getValue(int businessruleID){
        ArrayList<Value> v = new ArrayList<Value>();
        try {
            String sql = "select VALUE.VALUEID as VALUEID,\n" +
                    " VALUE.WAARDENAAM as WAARDENAAM,\n" +
                    " VALUE.VALUETYPE as VALUETYPE,\n" +
                    " VALUE.VALUE as VALUECONTENT,\n" +
                    " VALUE.BUSINESSRULE as BUSINESSRULE \n" +
                    " from VALUE VALUE \n" +
                    " where   VALUE.BUSINESSRULE = " + businessruleID;
            Statement stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery(sql);
            while (rs.next()) {
                int valueID = rs.getInt("VALUEID");
                String waardenaam = rs.getString("WAARDENAAM");
                String valuetype = rs.getString("VALUETYPE");
                String value = rs.getString("VALUECONTENT");
                Value val = new Value(waardenaam,valuetype,value);
                v.add(val);
            }
            stmt.close();
        } catch (Exception ex) {
            System.out.println("Kan geen values halen uit de database" + ex);
            ex.printStackTrace();
        }
        return v;
    }