Parsing MYSQL Insert statement

Question

I'm writing a Java tool to parse SQL Queries in order to get table and columns details. To parse SELECT statement I use MySQL JDBC ResultSetMetaData. Something like :

 String query = "select * from vendors";
 PreparedStatement pstmt = con.prepareStatement(query);
 ResultSetMetaData meta = pstmt.getMetaData();
 System.out.println(meta);

But this doesn't work for INSERT/UPDATE statement.

Does someone have a solution to do that?

I tried various other solutions without success.

Thanks

possible duplicate of Java - Getting Data from MySQL database — echo_Me
– echo_Me, Commented Mar 21, 2014 at 11:55

Balayesu Chilakalapudi · Accepted Answer · 2014-03-21 11:56:11Z

0

you can get the column name of the table using ResultsSetMetaData like this,

  ResultSetMetaData rsmd=res.getMetaData();
  int columnCount=rsmd.getColumnCount();
  for (int i = 1; i<= columnCount; i++) {
    columnHeading=columnHeading+"\t"+rsmd.getColumnName(i);

  System.out.println(columnHeading);

answered Mar 21, 2014 at 11:56

Balayesu Chilakalapudi

1,4023 gold badges20 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3445979 Over a year ago

Hi, Thanks for your answer. But your solution (what i've already made) doesn't work with INSERT/UDPDATE/DELETE statements.

Balayesu Chilakalapudi Over a year ago

search some online tutorials just like, come2niks.com/jdbc-insert-update-and-delete-example

Collectives™ on Stack Overflow

Parsing MYSQL Insert statement

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related