my dog learned polymorphism
The moose likes JDBC and Relational Databases and the fly likes Very Newbie question (seeing as I am one...) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Very Newbie question (seeing as I am one...)" Watch "Very Newbie question (seeing as I am one...)" New topic

Very Newbie question (seeing as I am one...)

Chris Cary

Joined: Jun 07, 2002
Posts: 2
I'm trying to get a jsp file to output data to MySQL (not into access or anything like that.) and I'm having trouble finding out how to do it. The only info I've found is either incomprehensible, or WAYYYYY over my head.
Can anyone help a poor newbie understand (in very very simple terms) how to do something like this?
Many thanks.
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

JSP tutorial
JDBC tutorial
you might want to look at servlets to handle the jdbc stuff.
[ June 11, 2002: Message edited by: Jamie Robertson ]
Chris Cary

Joined: Jun 07, 2002
Posts: 2
Thanks for the suggestion, but I've already checked out both sites. The JSP is fairly straightforward to me, but I don't have the foggiest idea what to do with the JDBC.
Basically, what I don't know how to do is...
Set up MySQL to be remotely accessable on win 2000,
Tell some JSP page running on a tomcat server (on the same comp as MySQL) to add data to a MySQL database.
I do know how to write basic JSP pages, and I know all the fundamental commands for MySQL. It's simply an issue of setting MySQL up to recieve commands, and then getting the JSP to actually GIVE those commands.
Heck, I don't even know if I NEED JDBC.
Thanks for any help that might come flying my way.
Just because you're not paranoid doesn't mean they aren't out to get you.
Adam Hardy
Ranch Hand

Joined: Oct 09, 2001
Posts: 567
As long as your win2000 box has got a network card and a tcpip driver installed, the basic mysql installation should allow it to be accessed over the network.

I have seen things you people would not believe, attack ships on fire off the shoulder of Orion, c-beams sparkling in the dark near the Tennhauser Gate. All these moments will be lost in time, like tears in the rain.
I agree. Here's the link:
subject: Very Newbie question (seeing as I am one...)
It's not a secret anymore!