ANSWERS: 1
-
Use JDBC, most databases support JDBC access. Once you have a JDBC driver for the database you can write code fairly easily to run queries against that database. Each database has its own security built into it, so allowing access would be implemented depending on the security the database vendor has to offer, such as setting up Roles, Table access, etc.. For example: Oracle http://www.oracle.com/technology/sample_code/tech/java/jsps/ojsp/dbaccessjdbc.html MySQL http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2162&lngWId=2
Copyright 2023, Wired Ivy, LLC

by 