Java JDBC - Listing Records Example
This program lists customers from a NorthWind-like database.
The example demonstrates the use of JDBC statements and SQL SELECT calls.
To run this example against a MySQL database you would do:
/path/to/java
-Djdbc.drivers=com.mysql.jdbc.Driver
-classpath .:mysql-connector-java-3.1.8-bin.jar
ListCustomers
"jdbc:mysql://my.server.com:3306/Northwind?user=myuser&password=mypassword"
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class ListCustomers {
public static void main(String[] args) {
if (args.length < 1) {
System.err.println("Usage: ListCustomers <url>");
System.exit(1);
}
String url = args[0];
try {
// Connect to the database
Connection con = DriverManager.getConnection(url);
try {
String sql = "SELECT CustomerID, CompanyName, ContactName FROM Customers";
// Create a statement
Statement stmt = con.createStatement();
// execute the query
ResultSet resultSet = stmt.executeQuery(sql);
// for all results
while (resultSet.next()) {
// print the columns of the current row (indexed by name)
System.out.print(resultSet.getString("CustomerID"));
System.out.print(", ");
System.out.print(resultSet.getString("CompanyName"));
System.out.print(", ");
System.out.print(resultSet.getString("ContactName"));
System.out.println();
}
stmt.close();
} finally {
con.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
