Hello. Are there any Java libraries that provide a ready-made easy database interface, where you can create, delete and edit tables in the database. If possible, also a simplified interface for working with data in tables. If anyone met these, please write.
Those. for example, I need to create a table, I call a certain function, send the table parameters there, and the library generates a SQL query and sends it to the database.
It is necessary to work with MS SQL Server 2005.

PS Work without entities. All data and parameters are dynamic.

    4 answers 4

    If you are using Spring or have the ability / desire to connect it, you can take a look at its tools to simplify working with JDBC . I don’t know about separate methods for creating tables, but there is a lot of functionality to simplify connection management, query parameterization, transaction management ... Actually, the table at the top of this page demonstrates.

      Try easy ORM - tyts It pleases me that it can be used under a droid.

        You need to use Hiberneit, well, and the JDBC driver to connect to the database.

        • As far as I know, Hibernate works with tables and entities. Those. when there is a table and to it - essence. One entity object = one row of the table. Does the hibernate also create tables, make queries to tables for which no entities were created ( @Entity )? And also puts in a certain object? - Anton Mukhin
        • Hibernate will allow you to use the table as a Java object and conveniently refer to it, i.e. Heber is like an add-on for convenience over JDBC - Gorets
        • Yeah, it's a pity that along with the tables I will not create entities (@Entity objects). So would hiberneyt approached. My tables should be created and then used. While without the use of entity objects. The most that is more or less so far is like Spring tools. - Anton Mukhin

        Either naked JDBC, or Hibernate and similar frameworks.