More specifics:
Honestly, I have not attempted to write any specific JSP code to connect and access the MySql database. I know this is not a good answer, but I am frustrated as to what to do using JSP pages.
Off the subject a little bit, but I have written a small stand alone java application to read a mySql database and display a few records.
The more I read on how to use a JSP page to access a database, the less clear it is. I understand the general concepts the book authors are describing, but they use their own custom tag libraries.
Should I write my own tag library to get information from a mySql database?
When I wrote the original email question, my hope was that someone would have a small example that would illustrate how to access a mySql database from a JSP page without using a tag library. Once I saw how this worked, I would then read more about developing my own tag library and attempt an example using my new custom library.
I was hoping that an example of someone having been down this road before could have written something like:
sample.jsp
------------------------
connect to the database using the MySql driver .... by the following statement:
...............
here is an example of an SQL statement to look up the field FullName field:
.........
the results of that query are stored in the following variable/vector, etc.
----------------
Summary:
I assure you I am not trying to be lazy and scurt the necessary learning pitfalls that strengthen the long term knowledge base.
I continue to read and reread to try and learn. I was hopeful someone could provide a sample JSP page with code for my small example using the field names I described previously. Or they could provide an example of their own JSP page with their field names and I could follow this as a pattern. But, maybe accessing databases needs to be from tag libraries, I don't know.
I appreciate your time. Any JSP code samples or additional direction as to what I can read would be greatly appreciated.
[This message has been edited by Scott Matthews (edited October 17, 2001).]