Parser to parse SQL query and return column name and corresponding table name in Java

Question

Possible duplicate:
SQL parser library for Java

I need a parser that should return me the column names with their corresponding table names in the format

column_name table_name

Preferably a java library that can make the implementation easier, because I do not want to delve into all the nuances of SQL parsing.

Yours faithfully,

+3

user727272 Jun 15 '11 at 6:27

2 answers

a_horse_with_no_name · Answer 1 · 2011-06-15T07:12:01+0000

If you have a database connection, you can do this using a prepared statement:

String sql = "....";
PreparedStatement pstmt = connection.prepareStatement(sql);
ResultSetMetaData meta = pstmt.getMetaData();

, , , .

AlexR · Answer 2 · 2011-06-15T07:04:22+0000

! Google :

, .