Java JDBC Sort Table Contents
Chapter:
JDBC
Last Updated:
10-09-2016 07:18:55 UTC
Program:
/* ............... START ............... */
import java.sql.*;
public class JavaJDCBSortExample {
public static void main(String[] args) throws Exception {
Class.forName("org.apache.derby.jdbc.ClientDriver");
Connection con = DriverManager.
getConnection("jdbc:derby://localhost:1527/testDb", "name", "pass");
Statement stmt = con.createStatement();
String query = "select * from emp order by name";
String query1 = "select * from emp order by name, job";
ResultSet rs = stmt.executeQuery(query);
System.out.println("Table contents sorted by Name");
System.out.println("Id Name Job");
while (rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
String job = rs.getString("job");
System.out.println(id + " " + name + " " + job);
}
rs = stmt.executeQuery(query1);
System.out.println("Table contents after sorted by Name & job");
System.out.println("Id Name Job");
while (rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
String job = rs.getString("job");
System.out.println(id + " " + name + " " + job);
}
}
}
/* ............... END ............... */
Tags
JDBC Sort Table Contents, Java, JDBC