package org.kodejava.example.sql; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; public class TableNameExample { private static final String DRIVER = "com.mysql.jdbc.Driver"; private static final String URL = "jdbc:mysql://localhost/testdb"; private static final String USERNAME = "root"; private static final String PASSWORD = ""; public static void main(String[] args) throws Exception { Connection connection = null; try { Class.forName(DRIVER); connection = DriverManager.getConnection(URL, USERNAME, PASSWORD); Statement statement = connection.createStatement(); String query = "SELECT a.id, a.username, a.country_id, b.country_name " + "FROM users a " + "LEFT JOIN countries b " + "ON a.country_id = b.id"; ResultSet resultSet = statement.executeQuery(query); // // Here we have a query that use multiple table, we then want to // know to which table a column is belong to. In the ResultSetMetaData // there is a getTableName() method that can do this functionality. // ResultSetMetaData metadata = resultSet.getMetaData(); String tableName = metadata.getTableName(1); System.out.println("Table name of column 'id' = " + tableName); tableName = metadata.getTableName(4); System.out.println("Table name of column 'country name' = " + tableName); } catch (SQLException e) { e.printStackTrace(); } finally { connection.close(); } } }
Wayan
Programmer, runner, recreational diver, live in the island of Bali, Indonesia. Mostly programming in Java, Spring Framework, Hibernate / JPA. Support me, buy me ☕ or 🍵
Latest posts by Wayan (see all)
- How do I set the default Java (JDK) version on Mac OS X? - November 14, 2017
- A User Interface is Like a Joke - November 10, 2017
- How do I pass password to sudo commands? - October 17, 2017