CODEWITHSUNDEEP
javasqljdbc
CaiNiaoCoder
CaiNiaoCoder

Reputation: 3319

Generating SQL by data modification on Swing table

I want to build a jdbc client tool. it will display data that returned by select query in Swing table, and may allow user to edit the data on the table. my question is what's the best way to generate standard sql string(insert delete update) for saving modification back to database ?

  1. is there any open library can help me ?
  2. I need to support common database such as mysql, oracle, db2, sysbase, informix.
  3. I need to support arbitary sql query, no ORM framework used.
  4. if you think I should do it by meself, do you have any suggestion ?

Upvotes: 1

Views: 142

Answers (2)

emecas
emecas

Reputation: 1586

1) You can use Apache Cayenne

2) It supports common databases (such as mysql, oracle, db2, sysbase, informix)

http://cayenne.apache.org/docs/3.0/database-support.html

3) You can use arbitary SQL queries by using SQLTemplate class. It allows to customizing SQL dialects.

http://cayenne.apache.org/docs/3.0/sqltemplate-basics.html

Upvotes: 1

Jhubbert
Jhubbert

Reputation: 48

Look into Hibernate (Java)

or

Java DB OBjects

http://dbobjects.sourceforge.net/

Upvotes: 0

Related Questions