Statistics
| Revision:

root / trunk / extensions / extCAD / src / com / iver / cit / gvsig / gui / cad / panels / JPanelFieldDefinition.java @ 9009

History | View | Annotate | Download (9.94 KB)

1
package com.iver.cit.gvsig.gui.cad.panels;
2

    
3
import java.awt.BorderLayout;
4
import java.awt.Component;
5
import java.sql.Types;
6
import java.util.ArrayList;
7

    
8
import javax.swing.DefaultCellEditor;
9
import javax.swing.JButton;
10
import javax.swing.JComboBox;
11
import javax.swing.JLabel;
12
import javax.swing.JOptionPane;
13
import javax.swing.JPanel;
14
import javax.swing.JScrollPane;
15
import javax.swing.JTable;
16
import javax.swing.ListSelectionModel;
17
import javax.swing.event.ListSelectionEvent;
18
import javax.swing.event.ListSelectionListener;
19
import javax.swing.table.DefaultTableModel;
20
import javax.swing.table.TableColumn;
21

    
22
import jwizardcomponent.JWizardComponents;
23
import jwizardcomponent.JWizardPanel;
24

    
25
import com.iver.andami.PluginServices;
26
import com.iver.cit.gvsig.fmap.drivers.FieldDescription;
27

    
28
/**
29
 * @author fjp
30
 *
31
 * Panel para que el usuario seleccione el driver que va a utilizar para
32
 * crear un tema desde cero.
33
 *
34
 */
35
public class JPanelFieldDefinition extends JWizardPanel {
36

    
37

    
38
        private JLabel jLabel = null;
39
        private JScrollPane jScrollPane = null;
40
        private JTable jTable = null;
41
        private JPanel jPanelEast = null;
42
        private JButton jButtonAddField = null;
43
        private JButton jButtonDeleteField = null;
44
        private int MAX_FIELD_LENGTH = 254;
45

    
46

    
47
        public JPanelFieldDefinition(JWizardComponents wizardComponents) {
48
                super(wizardComponents, null);
49
                initialize();
50
                // TODO Auto-generated constructor stub
51
        }
52

    
53

    
54
        /* (non-Javadoc)
55
         * @see jwizardcomponent.JWizardPanel#next()
56
         */
57
        public void next() {
58
                DefaultTableModel tm=(DefaultTableModel) jTable.getModel();
59
                boolean valid=true;
60
                for (int i = 0;i<tm.getRowCount();i++) {
61
                                String s=(String)tm.getValueAt(i,0);
62
                                valid=validate(s);
63
                                String type = (String) tm.getValueAt(i,1);
64
                                int length = Integer.parseInt((String) tm.getValueAt(i,2));
65
                                if (type.equals("String") && length > MAX_FIELD_LENGTH) {
66
                                        JOptionPane.showMessageDialog(this, PluginServices.getText(this, "max_length_is") + ": " + MAX_FIELD_LENGTH+
67
                                                        "\n"+PluginServices.getText(this, "length_of_field")+ " '"+ s + "' " + PluginServices.getText(this, "will_be_truncated"));
68
                                        tm.setValueAt(String.valueOf(MAX_FIELD_LENGTH),i,2);
69
                                }
70

    
71
                }
72

    
73
                // ensure no field name is used more than once
74
                ArrayList fieldNames = new ArrayList();
75
                for (int i = 0; i < jTable.getRowCount(); i++) {
76
                        if (fieldNames.contains(tm.getValueAt(i,0))) {
77
                                valid = false;
78
                                JOptionPane.showMessageDialog(this, PluginServices.getText(this, "two_or_more_fields_with_the_same_name"));
79
                                break;
80
                        }
81
                        fieldNames.add(tm.getValueAt(i, 0));
82
                }
83

    
84
                if (valid)
85
                        super.next();
86
                if (!((FileBasedPanel)getWizardComponents().getWizardPanel(2)).getPath().equals(""))
87
                        setFinishButtonEnabled(true);
88
                else
89
                        setFinishButtonEnabled(false);
90
        }
91

    
92

    
93
        private boolean validate(String s) {
94
                boolean valid=true;
95
                if (s.indexOf(" ")!=-1) {
96
                        valid=false;
97
                        JOptionPane.showMessageDialog((Component)PluginServices.getMainFrame(),
98
                                        PluginServices.getText(this,"no_puede_continuar")+"\n"+
99
                                        PluginServices.getText(this,"field")+" : "+s+"\n"+
100
                                        PluginServices.getText(this,"contiene_espacios_en_blanco"));
101
                }
102
                return valid;
103
        }
104

    
105

    
106
        /**
107
         * This method initializes this
108
         *
109
         */
110
        private void initialize() {
111
        jLabel = new JLabel();
112
        jLabel.setText(PluginServices.getText(this,"define_fields"));
113
        this.setLayout(new BorderLayout(5,5));
114
        this.setSize(new java.awt.Dimension(499,232));
115
        this.add(jLabel, java.awt.BorderLayout.NORTH);
116
        this.add(getJScrollPane(), java.awt.BorderLayout.CENTER);
117
        this.add(getJPanelEast(), java.awt.BorderLayout.EAST);
118
        }
119

    
120

    
121
        /**
122
         * This method initializes jScrollPane
123
         *
124
         * @return javax.swing.JScrollPane
125
         */
126
        private JScrollPane getJScrollPane() {
127
                if (jScrollPane == null) {
128
                        jScrollPane = new JScrollPane();
129
                        jScrollPane.setViewportView(getJTable());
130
                }
131
                return jScrollPane;
132
        }
133

    
134

    
135
        /**
136
         * This method initializes jTable
137
         *
138
         * @return javax.swing.JTable
139
         */
140
        private JTable getJTable() {
141
                if (jTable == null) {
142
                        jTable = new JTable();
143

    
144
                        DefaultTableModel tm = (DefaultTableModel) jTable.getModel();
145
                        tm.addColumn(PluginServices.getText(this,"field"));
146

    
147
                        // TableColumn fieldTypeColumn = new TableColumn(1);
148
                        // fieldTypeColumn.setHeaderValue("Type");
149
                        // jTable.addColumn(fieldTypeColumn);
150
                        tm.addColumn(PluginServices.getText(this,"type"));
151
                        // MIRAR EL C?DIGO DEL BOT?N DE A?ADIR CAMPO PARA VER EL CellEditor con comboBox
152

    
153

    
154
                        /* TableColumn fieldLengthColumn = new TableColumn(2);
155
                        fieldLengthColumn.setHeaderValue("Length");
156
                        // fieldLengthColumn.setCellRenderer(new DefaultTableCellRenderer());
157
                        jTable.addColumn(fieldLengthColumn); */
158
                        tm.addColumn(PluginServices.getText(this,"length"));
159

    
160
//                        Ask to be notified of selection changes.
161
                        ListSelectionModel rowSM = jTable.getSelectionModel();
162
                        rowSM.addListSelectionListener(new ListSelectionListener() {
163
                            public void valueChanged(ListSelectionEvent e) {
164
                                //Ignore extra messages.
165
                                if (e.getValueIsAdjusting()) return;
166

    
167
                                ListSelectionModel lsm =
168
                                    (ListSelectionModel)e.getSource();
169
                                if (lsm.isSelectionEmpty()) {
170
                                    //no rows are selected
171
                                        jButtonDeleteField.setEnabled(false);
172
                                } else {
173
                                    // int selectedRow = lsm.getMinSelectionIndex();
174
                                    //selectedRow is selected
175
                                        jButtonDeleteField.setEnabled(true);
176
                                }
177
                            }
178
                        });
179

    
180
                        jTable.getColumn(PluginServices.getText(this,"field")).setWidth(180);
181
                }
182
                return jTable;
183
        }
184

    
185

    
186
        /**
187
         * This method initializes jPanelWest
188
         *
189
         * @return javax.swing.JPanel
190
         */
191
        private JPanel getJPanelEast() {
192
                if (jPanelEast == null) {
193
                        jPanelEast = new JPanel();
194
                        jPanelEast.setLayout(null);
195
                        jPanelEast.setPreferredSize(new java.awt.Dimension(170,100));
196
                        jPanelEast.add(getJButtonAddField(), null);
197
                        jPanelEast.add(getJButtonDeleteField(), null);
198
                }
199
                return jPanelEast;
200
        }
201

    
202

    
203
        /**
204
         * This method initializes jButtonAddField
205
         *
206
         * @return javax.swing.JButton
207
         */
208
        private JButton getJButtonAddField() {
209
                if (jButtonAddField == null) {
210
                        jButtonAddField = new JButton();
211
                        jButtonAddField.setText(PluginServices.getText(this,"add_field"));
212
                        jButtonAddField.setLocation(new java.awt.Point(7,5));
213
                        jButtonAddField.setSize(new java.awt.Dimension(145,23));
214
                        jButtonAddField.setPreferredSize(new java.awt.Dimension(100,26));
215
                        jButtonAddField.addActionListener(new java.awt.event.ActionListener() {
216
                                public void actionPerformed(java.awt.event.ActionEvent e) {
217
                                        DefaultTableModel tm = (DefaultTableModel) jTable.getModel();
218

    
219
                                        // Figure out a suitable field name
220
                                        ArrayList fieldNames = new ArrayList();
221
                                        for (int i = 0; i < jTable.getRowCount(); i++) {
222
                                                fieldNames.add(tm.getValueAt(i, 0));
223
                                        }
224
                                        String[] currentFieldNames = (String[]) fieldNames.toArray(new String[0]);
225
                                        String newField = PluginServices.getText(this, "new_field").replaceAll(" +", "_");
226
                                        int index=0;
227
                                        for (int i = 0; i < currentFieldNames.length; i++) {
228
                                                if (currentFieldNames[i].startsWith(newField)) {
229
                                                        try {
230
                                                                index = Integer.parseInt(currentFieldNames[i].replaceAll(newField,""));
231
                                                        } catch (Exception ex) { /* we don't care */}
232
                                                }
233
                                        }
234
                                        String newFieldName = newField+(++index);
235

    
236

    
237
                                        // Add a new row
238
                                        Object[] newRow = new Object[tm.getColumnCount()];
239
                                        newRow[0] = newFieldName;
240
                                        newRow[1] = "String";
241
                                        newRow[2] = "20";
242
                                        tm.addRow(newRow);
243

    
244
                                        // Esto lo a?ado aqu? porque si no tiene registros, no hace caso. (Por eso no
245
                                        // lo pongo en getJTable()
246
                                        TableColumn typeColumn = jTable.getColumnModel().getColumn(1);
247
                                        JComboBox comboBox = new JComboBox();
248
                                        comboBox.addItem("Boolean");
249
                                        comboBox.addItem("Date");
250
                                        comboBox.addItem("Integer");
251
                                        comboBox.addItem("Double");
252
                                        comboBox.addItem("String");
253
                                        typeColumn.setCellEditor(new DefaultCellEditor(comboBox));
254

    
255
                                        TableColumn widthColumn = jTable.getColumnModel().getColumn(2);
256

    
257
                                        // tm.setValueAt("NewField", tm.getRowCount()-1, 0);
258
                                }
259
                        });
260

    
261
                }
262
                return jButtonAddField;
263
        }
264

    
265

    
266
        /**
267
         * This method initializes jButton
268
         *
269
         * @return javax.swing.JButton
270
         */
271
        private JButton getJButtonDeleteField() {
272
                if (jButtonDeleteField == null) {
273
                        jButtonDeleteField = new JButton();
274
                        jButtonDeleteField.setText(PluginServices.getText(this,"delete_field"));
275
                        jButtonDeleteField.setLocation(new java.awt.Point(7,33));
276
                        jButtonDeleteField.setSize(new java.awt.Dimension(145,23));
277
                        jButtonDeleteField.setEnabled(false);
278
                        jButtonDeleteField.addActionListener(new java.awt.event.ActionListener() {
279
                                public void actionPerformed(java.awt.event.ActionEvent e) {
280
                                        int[] selecteds = jTable.getSelectedRows();
281
                                        DefaultTableModel tm = (DefaultTableModel) jTable.getModel();
282

    
283
                                        for (int i=selecteds.length-1; i >=0; i--)
284
                                                tm.removeRow(selecteds[i]);
285
                                }
286
                        });
287
                }
288
                return jButtonDeleteField;
289
        }
290

    
291

    
292
        /**
293
         * Convierte lo que hay en la tabla en una definici?n de campos
294
         * adecuada para crear un LayerDefinition
295
         * @return
296
         */
297
        public FieldDescription[] getFieldsDescription() {
298
                DefaultTableModel tm = (DefaultTableModel) jTable.getModel();
299
                FieldDescription[] fieldsDesc = new FieldDescription[tm.getRowCount()];
300

    
301
                for (int i=0; i < tm.getRowCount(); i++)
302
                {
303
                        fieldsDesc[i] = new FieldDescription();
304
                        fieldsDesc[i].setFieldName((String) tm.getValueAt(i,0));
305
                        String strType = (String) tm.getValueAt(i,1);
306
                        if (strType.equals("String"))
307
                                fieldsDesc[i].setFieldType(Types.VARCHAR);
308
                        if (strType.equals("Double"))
309
                                fieldsDesc[i].setFieldType(Types.DOUBLE);
310
                        if (strType.equals("Integer"))
311
                                fieldsDesc[i].setFieldType(Types.INTEGER);
312
                        if (strType.equals("Boolean"))
313
                                fieldsDesc[i].setFieldType(Types.BOOLEAN);
314
                        if (strType.equals("Date"))
315
                                fieldsDesc[i].setFieldType(Types.DATE);
316
                        int fieldLength = Integer.parseInt((String) tm.getValueAt(i,2));
317
                        fieldsDesc[i].setFieldLength(fieldLength);
318

    
319
                        // TODO: HACERLO BIEN
320
                        if (strType.equals("Double"))
321
                                fieldsDesc[i].setFieldDecimalCount(5);
322

    
323
                }
324

    
325
                return fieldsDesc;
326
        }
327

    
328

    
329

    
330
}  //  @jve:decl-index=0:visual-constraint="10,10"