Geek asks and answers

Simple Java infrastructure / tool for accessing a database over the Internet?

I am looking for a Java web tool (preferably one that will work in both Weblogic and JBoss), which will allow me to control access to a specific database. I need to allow non-technical users to insert, update, and delete rows in a specific Oracle DB table. Strings will have a different data type (some dates, some numbers). The ability to add drop-down lists with specific values ​​will be nice.

It would also be nice, but not necessary (since we can always use a reverse proxy), it would be possible to control read / write access using LDAP / AD groups.

Another developer on my team suggested Spring / Roo, but it might be too heavy for what we want to do. There should be something simpler ... Oracle Apex is another option if we despair.

+3
source share
4 answers

Spring In my opinion, Roo is absolutely not redundant for this task. It actually supports reverse engineering of the database, so you can explicitly specify for which tables you want to have a CRUD view.

You will need a really simple script, something like this:

project --topLevelPackage org.whatever --projectName crud --java 6
persistence setup --provider HIBERNATE --database ORACLE

-> you will need to purchase ojdbc*.jarbecause it is not available from Maven

-> you will also need to customize database.propertiesaccording to your needs

database reverse engineer --schema my --includeTables "Table1 .." --package ~.domain 
controller all --package ~.web
logging setup --level DEBUG --> OPTIONAL
security setup --> OPTIONAL
exit

To do this, you can run your application.

+3

Grails - CRUD, , Java-. , - , . : https://www.ibm.com/developerworks/java/library/j-grails01158/

+6

- JSP , , . WAR JBoss Weblogic.

+1

, - Java, Create/Retrieve/Update/Delete (CRUD). , . , , , , .

Spring Roo - , , , . script, , , .

AppFuse, -, . . AppFuse QuickStart.

LDAP, . Java . , Spring .

-1

More articles:


All Articles