Změna

[hans peter geerdes]

Dobrý den,
mám aplikaci,která funguje s cvičnou databazí.Potřeboval bych zajistit aby při 
výbědů řádku v JTable nebylo možné vybrat vice jak jeden řádek.Výbranný řádek 
vypíše danné oddelění do TextFieldu.Vlastně jsem si uvědomil že mám více 
variant totho to programu.Děkuji

První verze programu:
import java.util.Vector;
import java.sql.*;
import javax.swing.table.AbstractTableModel;
import javax.swing.event.TableModelEvent;

public class JDBCAdapter extends AbstractTableModel {
Connection connection;
Statement statement;
ResultSet resultSet;
String[] columnNames = {};
Vector rows = new Vector();
ResultSetMetaData metaData;

public JDBCAdapter(String url, String driverName,
String user, String passwd) {
try {
Class.forName(driverName);
System.out.println("Opening db connection");

connection = DriverManager.getConnection(url, user, passwd);
statement = connection.createStatement();
}
catch (ClassNotFoundException ex) {
System.err.println("Cannot find the database driver classes.");
System.err.println(ex);
}
catch (SQLException ex) {
System.err.println("Cannot connect to this database.");
System.err.println(ex);
}
}

public void executeQuery(String query) {
if (connection == null || statement == null) {
System.err.println("There is no database to execute the query.");
return;
}
try {
resultSet = statement.executeQuery(query);
metaData = resultSet.getMetaData();

int numberOfColumns = metaData.getColumnCount();
columnNames = new String[numberOfColumns];
// Get the column names and cache them.
// Then we can close the connection.
for(int column = 0; column < numberOfColumns; column++) {
columnNames[column] = metaData.getColumnLabel(column+1);
}

// Get all rows.
rows = new Vector();
while (resultSet.next()) {
Vector newRow = new Vector();
for (int i = 1; i <= getColumnCount(); i++) {
newRow.addElement(resultSet.getObject(i));
}
rows.addElement(newRow);
}
// close(); Need to copy the metaData, bug in jdbcdbc driver.
fireTableChanged(null); // Tell the listeners a new table has arrived. 
}
catch (SQLException ex) {
System.err.println(ex);
}
}

public void close() throws SQLException {
System.out.println("Closing db connection");
resultSet.close();
statement.close();
connection.close();
}

protected void finalize() throws Throwable {
close();
super.finalize();
}

//////////////////////////////////////////////////////////////////////////
//
// Implementation of the TableModel Interface
//
//////////////////////////////////////////////////////////////////////////

// MetaData

public String getColumnName(int column) {
if (columnNames[column] != null) {
return columnNames[column];
} else {
return "";
}
}

public Class getColumnClass(int column) {
int type;
try {
type = metaData.getColumnType(column+1);
}
catch (SQLException e) {
return super.getColumnClass(column);
}

switch(type) {
case Types.CHAR:
case Types.VARCHAR:
case Types.LONGVARCHAR:
return String.class;

case Types.BIT:
return Boolean.class;

case Types.TINYINT:
case Types.SMALLINT:
case Types.INTEGER:
return Integer.class;

case Types.BIGINT:
return Long.class;

case Types.FLOAT:
case Types.DOUBLE:
return Double.class;

case Types.DATE:
return java.sql.Date.class;

default:
return Object.class;
}
}

public boolean isCellEditable(int row, int column) {
try {
return metaData.isWritable(column+1);
}
catch (SQLException e) {
return false;
}
}

public int getColumnCount() {
return columnNames.length;
}

// Data methods

public int getRowCount() {
return rows.size();
}

public Object getValueAt(int aRow, int aColumn) {
Vector row = (Vector)rows.elementAt(aRow);
return row.elementAt(aColumn);
}

public String dbRepresentation(int column, Object value) {
int type;

if (value == null) {
return "null";
}

try {
type = metaData.getColumnType(column+1);
}
catch (SQLException e) {
return value.toString();
}

switch(type) {
case Types.INTEGER:
case Types.DOUBLE:
case Types.FLOAT:
return value.toString();
case Types.BIT:
return ((Boolean)value).booleanValue() ? "1" : "0";
case Types.DATE:
return value.toString(); // This will need some conversion.
default:
return "\""+value.toString()+"\"";
}

}

public void setValueAt(Object value, int row, int column) {
try {
String tableName = metaData.getTableName(column+1);
// Some of the drivers seem buggy, tableName should not be null.
if (tableName == null) {
System.out.println("Table name returned null.");
}
String columnName = getColumnName(column);
String query =
"update "+tableName+
" set "+columnName+" = "+dbRepresentation(column, value)+
" where ";
// We don't have a model of the schema so we don't know the
// primary keys or which columns to lock on. To demonstrate
// that editing is possible, we'll just lock on everything.
for(int col = 0; col<getColumnCount(); col++) {
String colName = getColumnName(col);
if (colName.equals("")) {
continue;
}
if (col != 0) {
query = query + " and ";
}
query = query + colName +" = "+
dbRepresentation(col, getValueAt(row, col));
}
System.out.println(query);
System.out.println("Not sending update to database");
// statement.executeQuery(query);
}
catch (SQLException e) {
// e.printStackTrace();
System.err.println("Update failed");
}
Vector dataRow = (Vector)rows.elementAt(row);
dataRow.setElementAt(value, column);

}
}

import java.applet.Applet;
import java.awt.*;
import java.awt.event.*;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.*;
import javax.swing.table.*;
import javax.swing.event.*;
import javax.swing.border.*;

public class TableExample implements LayoutManager {
static String[] ConnectOptionNames = { "Connect" };
static String ConnectTitle = "Connection Information";

Dimension origin = new Dimension(0, 0);

JButton fetchButton;
JButton showConnectionInfoButton;
JTable table;
JPanel connectionPanel;
JFrame frame; // The query/results window.

JLabel userNameLabel;
JTextField userNameField;
JLabel passwordLabel;
JTextField passwordField;
// JLabel queryLabel;
JTextArea queryTextArea;
JComponent queryAggregate;
JLabel serverLabel;
JTextField serverField;
JLabel driverLabel;
JTextField driverField;
JTextField departmentField = new JTextField();
JPanel mainPanel;
JPanel dolniPanel = new JPanel();
TableSorter sorter;
JDBCAdapter dataBase;
JScrollPane tableAggregate;

/**
* Brigs up a JDialog using JOptionPane containing the connectionPanel. 
* If the user clicks on the 'Connect' button the connection is reset.
*/
void activateConnectionDialog() {
if(JOptionPane.showOptionDialog(tableAggregate, connectionPanel, ConnectTitle,
JOptionPane.DEFAULT_OPTION, JOptionPane.INFORMATION_MESSAGE,
null, ConnectOptionNames, ConnectOptionNames[0]) == 0) {
connect();
frame.setVisible(true);
}
else if(!frame.isVisible())
System.exit(0);
}

/**
* Creates the connectionPanel, which will contain all the fields for
* the connection information.
*/
public void createConnectionDialog() {
// Create the labels and text fields.
userNameLabel = new JLabel("User name: ", JLabel.RIGHT);
userNameField = new JTextField("dba");

passwordLabel = new JLabel("Password: ", JLabel.RIGHT);
passwordField = new JTextField("sql");

serverLabel = new JLabel("Database URL: ", JLabel.RIGHT);
serverField = new 
JTextField("jdbc:sybase:Tds:localhost:2638/?JCONNECT_VERSION=5");

driverLabel = new JLabel("Driver: ", JLabel.RIGHT);
driverField = new JTextField("com.sybase.jdbc2.jdbc.SybDriver");


connectionPanel = new JPanel(false);
connectionPanel.setLayout(new BoxLayout(connectionPanel,
BoxLayout.X_AXIS));

JPanel namePanel = new JPanel(false);
namePanel.setLayout(new GridLayout(0, 1));
namePanel.add(userNameLabel);
namePanel.add(passwordLabel);
namePanel.add(serverLabel);
namePanel.add(driverLabel);

JPanel fieldPanel = new JPanel(false);
fieldPanel.setLayout(new GridLayout(0, 1));
fieldPanel.add(userNameField);
fieldPanel.add(passwordField);
fieldPanel.add(serverField);
fieldPanel.add(driverField);

connectionPanel.add(namePanel);
connectionPanel.add(fieldPanel);
}

public TableExample() {
mainPanel = new JPanel();

// Create the panel for the connection information
createConnectionDialog();

// Create the buttons.
showConnectionInfoButton = new JButton("Nastaveni");
showConnectionInfoButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
activateConnectionDialog();
}
}
);

fetchButton = new JButton("Nacist");
fetchButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
fetch();
}
}
);

// Create the query text area and label.
queryTextArea = new JTextArea("SELECT * FROM employee", 25, 25);
queryAggregate = new JScrollPane(queryTextArea);
queryAggregate.setBorder(new BevelBorder(BevelBorder.LOWERED));

// Create the table.
tableAggregate = createTable();
tableAggregate.setBorder(new BevelBorder(BevelBorder.LOWERED));

// Add all the components to the main panel.

mainPanel.add(fetchButton);

mainPanel.add(showConnectionInfoButton);
mainPanel.add(queryAggregate);
mainPanel.add(tableAggregate);

mainPanel.setLayout(this);
dolniPanel.setLayout(new GridLayout(0,4));
dolniPanel.add(new JLabel("Jmeno oddeleni - "));
dolniPanel.add(departmentField);

// Create a Frame and put the main panel in it.
frame = new JFrame("Tabulka");
frame.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {System.exit(0);}});
frame.setBackground(Color.lightGray);
frame.getContentPane().add(mainPanel);
frame.add(dolniPanel,BorderLayout.SOUTH);
frame.pack();
frame.setVisible(false);
frame.setBounds(200, 200, 640, 480);

activateConnectionDialog();
}

public void connect() {
dataBase = new JDBCAdapter(
serverField.getText(),
driverField.getText(),
userNameField.getText(),
passwordField.getText());
sorter.setModel(dataBase);
}

public void fetch() {
dataBase.executeQuery(queryTextArea.getText());
}

public JScrollPane createTable() {
sorter = new TableSorter();

//connect();
//fetch();

// Create the table
table = new JTable(sorter);
// Use a scrollbar, in case there are many columns.
table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

// Install a mouse listener in the TableHeader as the sorter UI.
sorter.addMouseListenerToHeaderInTable(table);
table.getSelectionModel().addListSelectionListener(new ListSelectionListener() {
public void valueChanged(ListSelectionEvent e) {
try {
ResultSet vysledek = dataBase.statement.executeQuery("select dept_name from 
department where dept_id = 
"+table.getValueAt(table.getSelectedRow(),4).toString());
vysledek.next();
departmentField.setText(vysledek.getString(1));
} catch (SQLException ex) {
ex.printStackTrace();
}
}
});
JScrollPane scrollpane = new JScrollPane(table);

return scrollpane;
}

public static void main(String s[]) {
new TableExample();
}

public Dimension preferredLayoutSize(Container c){return origin;}
public Dimension minimumLayoutSize(Container c){return origin;}
public void addLayoutComponent(String s, Component c) {}
public void removeLayoutComponent(Component c) {}
public void layoutContainer(Container c) {
Rectangle b = c.getBounds();
int topHeight = 90;
int inset = 4;
showConnectionInfoButton.setBounds(b.width-2*inset-120, inset, 120, 25);
fetchButton.setBounds(b.width-2*inset-120, 60, 120, 25);
// queryLabel.setBounds(10, 10, 100, 25);
queryAggregate.setBounds(inset, inset, b.width-2*inset - 150, 80);
tableAggregate.setBounds(new Rectangle(inset,
inset + topHeight,
b.width-2*inset,
b.height-2*inset - topHeight));
}

}

import javax.swing.table.*;
import javax.swing.event.TableModelListener;
import javax.swing.event.TableModelEvent;

public class TableMap extends AbstractTableModel implements TableModelListener
{
protected TableModel model;

public TableModel getModel() {
return model;
}

public void setModel(TableModel model) {
this.model = model;
model.addTableModelListener(this);
}

// By default, Implement TableModel by forwarding all messages
// to the model.

public Object getValueAt(int aRow, int aColumn) {
return model.getValueAt(aRow, aColumn);
}

public void setValueAt(Object aValue, int aRow, int aColumn) {
model.setValueAt(aValue, aRow, aColumn);
}

public int getRowCount() {
return (model == null) ? 0 : model.getRowCount();
}

public int getColumnCount() {
return (model == null) ? 0 : model.getColumnCount();
}

public String getColumnName(int aColumn) {
return model.getColumnName(aColumn);
}

public Class getColumnClass(int aColumn) {
return model.getColumnClass(aColumn);
}

public boolean isCellEditable(int row, int column) {
return model.isCellEditable(row, column);
}
//
// Implementation of the TableModelListener interface,
//

// By default forward all events to all the listeners.
public void tableChanged(TableModelEvent e) {
fireTableChanged(e);
}
}

import java.util.*;

import javax.swing.table.TableModel;
import javax.swing.event.TableModelEvent;

// Imports for picking up mouse events from the JTable.

import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.awt.event.InputEvent;
import javax.swing.JTable;
import javax.swing.table.JTableHeader;
import javax.swing.table.TableColumn;
import javax.swing.table.TableColumnModel;

public class TableSorter extends TableMap
{
int indexes[];
Vector sortingColumns = new Vector();
boolean ascending = true;
int compares;

public TableSorter()
{
indexes = new int[0]; // For consistency.
}

public TableSorter(TableModel model)
{
setModel(model);
}

public void setModel(TableModel model) {
super.setModel(model);
reallocateIndexes();
}

public int compareRowsByColumn(int row1, int row2, int column)
{
Class type = model.getColumnClass(column);
TableModel data = model;

// Check for nulls

Object o1 = data.getValueAt(row1, column);
Object o2 = data.getValueAt(row2, column);

// If both values are null return 0
if (o1 == null && o2 == null) {
return 0;
}
else if (o1 == null) { // Define null less than everything.
return -1;
}
else if (o2 == null) {
return 1;
}

/* We copy all returned values from the getValue call in case
an optimised model is reusing one object to return many values.
The Number subclasses in the JDK are immutable and so will not be used in
this way but other subclasses of Number might want to do this to save
space and avoid unnecessary heap allocation.
*/
if (type.getSuperclass() == java.lang.Number.class)
{
Number n1 = (Number)data.getValueAt(row1, column);
double d1 = n1.doubleValue();
Number n2 = (Number)data.getValueAt(row2, column);
double d2 = n2.doubleValue();

if (d1 < d2)
return -1;
else if (d1 > d2)
return 1;
else
return 0;
}
else if (type == java.util.Date.class)
{
Date d1 = (Date)data.getValueAt(row1, column);
long n1 = d1.getTime();
Date d2 = (Date)data.getValueAt(row2, column);
long n2 = d2.getTime();

if (n1 < n2)
return -1;
else if (n1 > n2)
return 1;
else return 0;
}
else if (type == String.class)
{
String s1 = (String)data.getValueAt(row1, column);
String s2 = (String)data.getValueAt(row2, column);
int result = s1.compareTo(s2);

if (result < 0)
return -1;
else if (result > 0)
return 1;
else return 0;
}
else if (type == Boolean.class)
{
Boolean bool1 = (Boolean)data.getValueAt(row1, column);
boolean b1 = bool1.booleanValue();
Boolean bool2 = (Boolean)data.getValueAt(row2, column);
boolean b2 = bool2.booleanValue();

if (b1 == b2)
return 0;
else if (b1) // Define false < true
return 1;
else
return -1;
}
else
{
Object v1 = data.getValueAt(row1, column);
String s1 = v1.toString();
Object v2 = data.getValueAt(row2, column);
String s2 = v2.toString();
int result = s1.compareTo(s2);

if (result < 0)
return -1;
else if (result > 0)
return 1;
else return 0;
}
}

public int compare(int row1, int row2)
{
compares++;
for(int level = 0; level < sortingColumns.size(); level++)
{
Integer column = (Integer)sortingColumns.elementAt(level);
int result = compareRowsByColumn(row1, row2, column.intValue());
if (result != 0)
return ascending ? result : -result;
}
return 0;
}

public void reallocateIndexes()
{
int rowCount = model.getRowCount();

// Set up a new array of indexes with the right number of elements
// for the new data model.
indexes = new int[rowCount];

// Initialise with the identity mapping.
for(int row = 0; row < rowCount; row++)
indexes[row] = row;
}

public void tableChanged(TableModelEvent e)
{
System.out.println("Sorter: tableChanged");
reallocateIndexes();

super.tableChanged(e);
}

public void checkModel()
{
if (indexes.length != model.getRowCount()) {
System.err.println("Sorter not informed of a change in model.");
}
}

public void sort(Object sender)
{
checkModel();

compares = 0;
// n2sort();
// qsort(0, indexes.length-1);
shuttlesort((int[])indexes.clone(), indexes, 0, indexes.length);
System.out.println("Compares: "+compares);
}

public void n2sort() {
for(int i = 0; i < getRowCount(); i++) {
for(int j = i+1; j < getRowCount(); j++) {
if (compare(indexes[i], indexes[j]) == -1) {
swap(i, j);
}
}
}
}

// This is a home-grown implementation which we have not had time
// to research - it may perform poorly in some circumstances. It
// requires twice the space of an in-place algorithm and makes
// NlogN assigments shuttling the values between the two
// arrays. The number of compares appears to vary between N-1 and
// NlogN depending on the initial order but the main reason for
// using it here is that, unlike qsort, it is stable.
public void shuttlesort(int from[], int to[], int low, int high) {
if (high - low < 2) {
return;
}
int middle = (low + high)/2;
shuttlesort(to, from, low, middle);
shuttlesort(to, from, middle, high);

int p = low;
int q = middle;

/* This is an optional short-cut; at each recursive call,
check to see if the elements in this subset are already
ordered. If so, no further comparisons are needed; the
sub-array can just be copied. The array must be copied rather
than assigned otherwise sister calls in the recursion might
get out of sinc. When the number of elements is three they
are partitioned so that the first set, [low, mid), has one
element and and the second, [mid, high), has two. We skip the
optimisation when the number of elements is three or less as
the first compare in the normal merge will produce the same
sequence of steps. This optimisation seems to be worthwhile
for partially ordered lists but some analysis is needed to
find out how the performance drops to Nlog(N) as the initial
order diminishes - it may drop very quickly. */

if (high - low >= 4 && compare(from[middle-1], from[middle]) <= 0) {
for (int i = low; i < high; i++) {
to[i] = from[i];
}
return;
}

// A normal merge.

for(int i = low; i < high; i++) {
if (q >= high || (p < middle && compare(from[p], from[q]) <= 0)) { 
to[i] = from[p++];
}
else {
to[i] = from[q++];
}
}
}

public void swap(int i, int j) {
int tmp = indexes[i];
indexes[i] = indexes[j];
indexes[j] = tmp;
}

// The mapping only affects the contents of the data rows.
// Pass all requests to these rows through the mapping array: "indexes".

public Object getValueAt(int aRow, int aColumn)
{
checkModel();
return model.getValueAt(indexes[aRow], aColumn);
}

public void setValueAt(Object aValue, int aRow, int aColumn)
{
checkModel();
model.setValueAt(aValue, indexes[aRow], aColumn);
}

public void sortByColumn(int column) {
sortByColumn(column, true);
}

public void sortByColumn(int column, boolean ascending) {
this.ascending = ascending;
sortingColumns.removeAllElements();
sortingColumns.addElement(new Integer(column));
sort(this);
super.tableChanged(new TableModelEvent(this));
}

// There is no-where else to put this.
// Add a mouse listener to the Table to trigger a table sort
// when a column heading is clicked in the JTable.
public void addMouseListenerToHeaderInTable(JTable table) {
final TableSorter sorter = this;
final JTable tableView = table;
tableView.setColumnSelectionAllowed(false);
MouseAdapter listMouseListener = new MouseAdapter() {
public void mouseClicked(MouseEvent e) {
TableColumnModel columnModel = tableView.getColumnModel();
int viewColumn = columnModel.getColumnIndexAte.get));
int column = tableView.convertColumnIndexToModel(viewColumn);
if(e.getClickCount() == 1 && column != -1) {
System.out.println("Sorting ...");
int shiftPressed = e.getModifiers()&InputEvent.SHIFT_MASK;
boolean ascending = (shiftPressed == 0);
sorter.sortByColumn(column, ascending);
}
}
};
JTableHeader th = tableView.getTableHeader();
th.addMouseListener(listMouseListener);
}



}

A zde přikládám druhou verzi:
import java.awt.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.border.Border;
import javax.swing.event.*;
import javax.swing.table.*;
public class Main extends JFrame {
static Main okno = new Main();
Vector vektor;
JTable tabulka;
Connection conn;
Statement stat;
ResultSet rs;
JScrollPane sp = new JScrollPane();
JTextField odd = new JTextField("není");
String sqlStare="";

public Main() {
init();
pripojeni();
}
public void init() {
setLocation(0,0);
setExtendedState(MAXIMIZED_BOTH);
setTitle("title");
setSize(700,600);
setDefaultCloseOperation(EXIT_ON_CLOSE);
odd.setEditable(false);
JScrollPane js = new JScrollPane();
JPanel panel = new JPanel();
js.setViewportView(panel);


add(sp,BorderLayout.CENTER);
add(js,BorderLayout.NORTH);
panel.setLayout(new GridLayout(0,5));
JLabel popis = new JLabel("Jméno odd?lení: ");

panel.add(popis);
panel.add(odd);



}
public static void main(String[] args) {
SwingUtilities.invokeLater(new Runnable() {
public void run() {
okno.setVisible(true);
}
});
}

private void pripojeni() {
try {
Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
}
catch (ClassNotFoundException ex) {
JOptionPane.showMessageDialog(this,"JDBC Driver nebyl nalezen 
!!!!","Chyba",JOptionPane.WARNING_MESSAGE);
System.exit(0);
}
try {
conn = 
DriverManager.getConnection("jdbc:sybase:Tds:localhost:2638/?SERVICENAME=asademo","dba","sql");
stat = conn.createStatement();
result();
}
catch (SQLException ex) {
JOptionPane.showMessageDialog(this,"Nelze se p?ipojit k databázi 
!!!","Chyba",JOptionPane.WARNING_MESSAGE);
System.exit(0);
}


}

private void result() {
vektor = new Vector();
Vector radekvektora;
Vector sloupce = new Vector();
try {
rs = stat.executeQuery("Select * from employee order by emp_id");
while (rs.next()) {
radekvektora = new Vector();
for(int i=1; i<rs.getMetaData().getColumnCount()+1; ++i) {
radekvektora.addElement(rs.getObject(i));
}
vektor.addElement(radekvektora);
}
for(int i=1; i<rs.getMetaData().getColumnCount()+1; ++i) {
sloupce.addElement(rs.getMetaData().getColumnLabel(i));
}
}
catch (SQLException ex) {
JOptionPane.showMessageDialog(this,"Chyba dotazu 
SQL","Chyba",JOptionPane.WARNING_MESSAGE);
System.out.println(ex.getMessage());
}
tabulka = new JTable(vektor,sloupce);
tabulka.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
tabulka.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
tabulka.setDefaultEditor(Object.class,new TableCellEditor() {
public void addCellEditorListener(CellEditorListener l) {
}
public void cancelCellEditing() {
}
public Object getCellEditorValue() {
return new Object();
}
public Component getTableCellEditorComponent(JTable table, Object value, 
boolean isSelected, int row, int column) {
return new DefaultTableCellRenderer();
}
public boolean isCellEditable(EventObject anEvent) {
return false;
}
public void removeCellEditorListener(CellEditorListener l) {
}
public boolean shouldSelectCell(EventObject anEvent) {
return false;
}
public boolean stopCellEditing() {
return true;
}
});

tabulka.getSelectionModel().addListSelectionListener(new 
ListSelectionListener() {
public void valueChanged(ListSelectionEvent e) {
nactiForm();
}
});
sp.setViewportView(tabulka);

}

public void nactiForm() {
String sql = "select dept_name from department where dept_id = 
"+tabulka.getValueAt(tabulka.getSelectedRow(),4).toString();
if(!sqlStare.equals(sql)) {
//System.out.println(sql);
try {
sqlStare=sql;
ResultSet rs2 = stat.executeQuery(sql);
rs2.next();
odd.setText(rs2.getString("dept_name"));


} catch (SQLException ex) {
odd.setText("není");


}
}
}
}