Java Database Programming Bible- P6: Welcome to Java Database Programming Bible. This book is for readers who are already familiar with Java, and who want to know more about working with databases. The JDBC Application Programming Interface has made database programming an important aspect of Java development, particularly where Web applications are concerned. | Chapter 7 Retrieving Data with SQL Queries CREATE statements class TableQueryFrame extends JInternalFrame protected JTable table protected JScrollPane tableScroller protected JTextArea SQLPane new JTextArea protected JButton queryButton new JButton Execute Query protected Databaseutilities dbUtils protected String tableName null protected String colNames null protected String dataTypes null protected String SQLQuery null protected String SQLCommandRoot public TableQueryFrame String tableName Databaseutilities dbUtils tableName dbUtils setSize 600 400 A setLocation 10 10 setClosable true setMaximizable true setlconifiable true setResizable true getContentPane .setLayout new BorderLayout tableName dbUtils setTitle Query tableName init setVisible true initialize the JInternalFrame private void init -249- Team-Fly Please purchase PDF Split-Merge on to remove this watermark. Chapter 7 Retrieving Data with SQL Queries colNames tableName dataTypes tableName SQLQuery SELECT TOP 5 FROM tableName Vector dataSet SQLQuery table createTable colNames dataSet JScrollPane sqlScroller new JScrollPane SQLPane tableScroller new JScrollPane table JSplitPane splitter new JSplitPane sqlScroller tableScroller 100 getContentPane .add splitter getContentPane .add queryButton new ButtonListener protected JTable createTable String colNames Vector dataSet int nRows String rowData new String nRows for int i 0 i nRows i Vector row Vector i for int j 0 j j rowData i j Object j .toString JTable table new JTable rowData colNames return table Listener for the Query Button class ButtonListener implements ActionListener public void actionPerformed ActionEvent event SQLQuery .
