Application: gvSIG desktop

			logger.error("SQL for labeling exists but is not valid: " + sql_str);

import java.util.HashMap;

import java.util.Iterator;

import org.gvsig.tools.evaluator.sqljep.SQLJEPEvaluator;

 * 

 * TODO Perhaps create a manager in Tools to perform this operation

 * 

 * @author jldominguez

 *

	private static Map<String, EvaluatorWithDescriptions> evCache =

			new HashMap<String, EvaluatorWithDescriptions>();

    	EvaluatorWithDescriptions resp = evCache.get(expr);

    		resp = new SQLJEPEvaluator(expr);

    		if (evCache.size() > 100) {

    			removeOne(evCache);

    		}

    		evCache.put(expr, resp);

	private static void removeOne(

			Map<String, EvaluatorWithDescriptions> themap) {

		Iterator<String> iter = themap.keySet().iterator();

		int count = 50;

		String k = null;

		while (iter.hasNext() && count > 0) {

			k = iter.next();

			count--;

		}

		themap.remove(k);

	}

			logger.error("While getting dummy feature in labeling expression.", e1);

package org.gvsig.labeling.gui.layerproperties;

import java.awt.Component;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.Insets;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.MouseEvent;

import java.awt.event.MouseListener;

import javax.swing.BorderFactory;

import javax.swing.JButton;

import javax.swing.JList;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTextArea;

import javax.swing.ScrollPaneConstants;

import org.gvsig.andami.ui.mdiManager.IWindow;

import org.gvsig.andami.ui.mdiManager.WindowInfo;

import org.gvsig.app.ApplicationLocator;

import org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor;

import org.gvsig.i18n.Messages;

public class LabelExpressionEditorPanel extends JPanel implements

IWindow, ActionListener, MouseListener {

	private static final String CANCEL_ACTION = "CANCEL";

	private static final String ACCEPT_ACTION = "ACCEPT";

	private static final String ADDFIELD_ACTION = "ADD_FIELD";

	private String originalValue;

	private String value;

	private WindowInfo wInfo = null;

	private String[] fieldNames;

	private int[] fieldTypes;

	private JButton botCancel;

	private JButton botAccept;

	private JButton botAddField;

	private JScrollPane spExpression;

	private JTextArea txtExpression;

	private JScrollPane spFieldList;

	private JList lstFields;

	public LabelExpressionEditorPanel(FeatureAttributeDescriptor[] atts) {

		super();

		int n = atts.length;

		this.fieldNames = new String[n];

		this.fieldTypes = new int[n];

		for (int i=0; i<n; i++) {

			this.fieldNames[i] = atts[i].getName();

			this.fieldTypes[i] = atts[i].getType();

		}

		initialize();

	}

	private void initialize() {

		this.setLayout(new GridBagLayout());

		GridBagConstraints baseConst = new GridBagConstraints();

		baseConst.ipadx = 2;

		baseConst.ipady = 2;

		baseConst.anchor = baseConst.CENTER;

		baseConst.insets = new Insets(2,2,2,2);

		GridBagConstraints con;

		con = (GridBagConstraints) baseConst.clone();

		con.gridx = 0;

		con.gridy = 0;

		con.gridheight = 3;

		con.gridwidth = 2;

		con.fill = con.BOTH;

		con.weightx = 1;

		con.weighty = 1;

		this.add(getFieldListComposition(), con);

		con = (GridBagConstraints) baseConst.clone();

		con.gridx = 2;

		con.gridy = 2;

		con.fill = con.NONE;

		this.add(getBotAddField(), con);

		con.gridx = 0;

		con.gridy = 3;

		con.gridheight = 4;

		con.gridwidth = 5;

		con.fill = con.BOTH;

		con.weightx = 1;

		con.weighty = 1;

		this.add(getExpressionComposition(), con);

		con = (GridBagConstraints) baseConst.clone();

		con.gridx = 3;

		con.gridy = 8;

		con.fill = con.NONE;

		this.add(getBotAccept(), con);

		con = (GridBagConstraints) baseConst.clone();

		con.gridx = 4;

		con.gridy = 8;

		con.fill = con.NONE;

		this.add(getBotCancel(), con);

	}

	private JButton getBotCancel() {

		if (botCancel == null) {

			botCancel = new JButton(Messages.getText("cancel"));

			botCancel.setActionCommand(CANCEL_ACTION);

			botCancel.addActionListener(this);

		}

		return botCancel;

	}

	private JButton getBotAccept() {

		if (botAccept == null) {

			botAccept = new JButton(Messages.getText("accept"));

			botAccept.setActionCommand(ACCEPT_ACTION);

			botAccept.addActionListener(this);

		}

		return botAccept;

	}

	private Component getExpressionComposition() {

		if (spExpression == null) {

			spExpression = new JScrollPane();

			spExpression.setViewportView(getTxtExpression());

			spExpression.setVerticalScrollBarPolicy(ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS);

			spExpression.setHorizontalScrollBarPolicy(ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED);

			spExpression

					.setBorder(BorderFactory.createTitledBorder(

							Messages.getText("expression")));

		}

		return spExpression;

	}

	private JTextArea getTxtExpression() {

		if (txtExpression == null){

			txtExpression = new JTextArea();

		}

		return txtExpression;

	}

	public void setExpression(String expr){

		this.getTxtExpression().setText(expr);

	}

	public String getExpression(){

		return this.getTxtExpression().getText();

	}

	private JButton getBotAddField() {

		if (botAddField == null) {

			botAddField = new JButton(Messages.getText("add_field"));

			botAddField.setActionCommand(ADDFIELD_ACTION);

			botAddField.addActionListener(this);

		}

		return botAddField;

	}

	private Component getFieldListComposition() {

		if (spFieldList == null){

			spFieldList = new JScrollPane();

			spFieldList.setViewportView(getLstFields());

			spFieldList.setVerticalScrollBarPolicy(ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS);

			spFieldList.setHorizontalScrollBarPolicy(ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED);

			spFieldList

					.setBorder(BorderFactory.createTitledBorder(

							Messages.getText("fields")));

		}

		return spFieldList;

	}

	private JList getLstFields() {

		if (lstFields == null){

			lstFields = new JList(this.fieldNames);

			lstFields.addMouseListener(this);

		}

		return lstFields;

	}

	public WindowInfo getWindowInfo() {

		if (wInfo == null) {

			wInfo = new WindowInfo(WindowInfo.RESIZABLE

					+ WindowInfo.MODALDIALOG);

			wInfo.setWidth(500);

			wInfo.setHeight(400);

			wInfo.setTitle(Messages.getText("expression"));

		}

		return wInfo;

	}

	public Object getWindowProfile() {

		return WindowInfo.EDITOR_PROFILE;

	}

	public void setValue(String value) {

		this.originalValue = value;

		this.value = value;

		this.setExpression(value);

	}

	public String getValue() {

		return this.value;

	}

	public void actionPerformed(ActionEvent e) {

		doAction(e.getActionCommand());

	}

	private void doAction(String action){

		if (action.equals(ADDFIELD_ACTION)){

			JTextArea txt = getTxtExpression();

			StringBuffer strb = new StringBuffer();

			String str = txt.getText();

			int sini = txt.getSelectionStart();

			int send = txt.getSelectionEnd();

			if (sini > 0){

				strb.append(str.substring(0, sini));

				str = str.substring(sini);

			}

			// strb.append('[');

			strb.append((String)getLstFields().getSelectedValue());

			// strb.append(']');

			send = send -sini;

			if (send > 0){

				str = str.substring(send);

			}

			strb.append(str);

			getTxtExpression().setText(strb.toString());

		} else {

			// Accept or cancel

			if (action.equals(ACCEPT_ACTION)){

				this.value = getExpression();

			} else {

				this.value = this.originalValue;

			}

			ApplicationLocator.getManager().getUIManager().closeWindow(this);

		}

	}

	public void mouseClicked(MouseEvent e) {

		if (e.getSource() == getLstFields()){

			if (e.getButton() == MouseEvent.BUTTON1 && e.getClickCount() > 1){

				doAction(ADDFIELD_ACTION);

			}

		}

	}

	public void mouseEntered(MouseEvent e) {

		// Do nothing

	}

	public void mouseExited(MouseEvent e) {

		// Do nothing

	}

	public void mousePressed(MouseEvent e) {

		// Do nothing

	}

	public void mouseReleased(MouseEvent e) {

		// Do nothing

	}

}

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 * Copyright (C) 2005 IVER T.I. and Generalitat Valenciana.

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 * For more information, contact:

 *

 *  Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *      +34 963862235

 *   gvsig@gva.es

 *      www.gvsig.gva.es

 *

 *    or

 *

 *   IVER T.I. S.A

 *   Salamanca 50

 *   46005 Valencia

 *   Spain

 *

 *   +34 963163400

 *   dac@iver.es

import java.util.logging.Level;

import org.jfree.chart.block.EmptyBlock;

		rdBtnFilteredFeatures = new JRadioButton(Messages.getText("filtered_features").concat(" (SQL GDBMS)"));

		sqlPnl.add(new JLabel("   SQL: SELECT * FROM "));

		sqlPnl.add(new JLabel("<" + Messages.getText("layer_name")

				+ ">"));

		sqlPnl.add(new JLabel(" WHERE  "));

		sqlPnl.add(txtSQL = new JTextField(30));

		sqlPnl.add(new JLabel(";"));

	private class DefaultEditor extends AbstractCellEditor implements

			TableCellEditor, ActionListener {

		JPanel editor;

		LabelExpressionEditorPanel dialog;

		private JTextField text;

		private JButton button;

		protected static final String EDIT = "edit";

//			cons.anchor = GridBagConstraints.FIRST_LINE_START;

			cons.fill = cons.BOTH;

//			cons.anchor = GridBagConstraints.FIRST_LINE_END;

			cons1.fill = cons1.VERTICAL;

//			cons.gridheight = GridBagConstraints.REMAINDER;

			button.setActionCommand(DefaultEditor.EDIT);

			button.addActionListener(this);

			// Set up the dialog that the button brings up.

			dialog = new LabelExpressionEditorPanel(atts);

		public void actionPerformed(ActionEvent e) {

			if (EDIT.equals(e.getActionCommand())) {

				dialog.setValue(text.getText());

				ApplicationLocator.getManager().getUIManager().addWindow(dialog);

				//fireEditingStopped(); // Make the renderer reappear.

				text.setText(dialog.getValue());

			}

		}