JDBC Tutorials - Herong's Tutorial Examples - v3.14, by Herong Yang
Derby (Java DB) - Running SELECT Queries
This section describes how to run SELECT queries through the JDBC driver.
After inserting data into my Access database, I want to get it back with a SELECT query. Here is my sample program to get all rows back from the table HY_Address:
/* DerbyQuery.java * Copyright (c) HerongYang.com. All Rights Reserved. */ import java.sql.*; public class DerbyQuery { public static void main(String [] args) { Connection con = null; try { con = DriverManager.getConnection("jdbc:derby://localhost/TestDB"); Statement sta = con.createStatement(); // getting the data back ResultSet res = sta.executeQuery( "SELECT * FROM HY_Address"); System.out.println("List of Addresses: "); while (res.next()) { System.out.println( " "+res.getInt("ID") + ", "+res.getString("StreetName") + ", "+res.getString("City")); } res.close(); sta.close(); con.close(); } catch (Exception e) { System.err.println("Exception: "+e.getMessage()); } } }
The output looked correct to me:
herong> java -cp %DERBY_HOME%\lib\derbyclient.jar DerbyQuery.java herong> java -cp $DERBY_HOME/lib/derbyclient.jar DerbyQuery.java List of Addresses: 1, 5 Baker Road, Bellevue 2, 25 Bay St., Hull 3, 251 Main St., W. York
Table of Contents
JDBC (Java Database Connectivity) Introduction
Installing and Running Derby (Java DB)
Derby (Java DB) Driver Features
Loading Derby JDBC Driver Classes
Creating Connections to Derby (Java DB) Network Server
Derby (Java DB) Network Server and JDBC Driver Info
Derby (Java DB) - Creating New Tables
Derby (Java DB) - Inserting Data Rows to Existing Tables
►Derby (Java DB) - Running SELECT Queries
Derby (Java DB) JDBC DataSource Objects
Derby (Java DB) - DML Statements
Derby (Java DB) - ResultSet Objects of Queries
Derby (Java DB) - PreparedStatement
Summary of JDBC Drivers and Database Servers