corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Geek Day » Linking .jsp pages to a MySQL database


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Linking .jsp pages to a MySQL database
chris_lee100
Member
Registered: 14th Jul 02
User status: Offline
3rd Jan 04 at 15:36   View User's Profile U2U Member Reply With Quote
I know this isnt about Corsas hence general chat.

Can anyone explain to me the tools i need and the process of creating a MySql database which can be read from and writen to via .jsp pages. I don't grasp how the MySql exists and where it lies. Do i need to download something from the MySql website first or can I create "virtual" tables and records just by writing code, like, perhaps an array?

Thanks for looking.

[Edited on 13-01-2007 by Ian]
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
3rd Jan 04 at 20:45   View Garage View User's Profile U2U Member Reply With Quote
http://www.mysql.com/ and get the binaries.

You'll probably want the MyODBC drivers as well to get data in to your JSP.
Trotty
Member
Registered: 22nd Feb 01
Location: Bristol
User status: Offline
3rd Jan 04 at 20:47   View User's Profile U2U Member Reply With Quote
Yup, and look at MySQLAdmin to create the tables, etc - its a reletively nice GUI interface rather than command line stuff
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
3rd Jan 04 at 20:48   View Garage View User's Profile U2U Member Reply With Quote
Whats wrong with command line?
Trotty
Member
Registered: 22nd Feb 01
Location: Bristol
User status: Offline
3rd Jan 04 at 20:51   View User's Profile U2U Member Reply With Quote
It's a pain in the bloody arse!!

DOS I can handle, creating databases, tables, attributes, etc is just too damn long winded!
Antz
Member
Registered: 28th Jul 03
Location: Leeds         Drives: Myself Insane!
User status: Offline
1st Feb 04 at 13:12   View User's Profile U2U Member Reply With Quote
Command line is the best way, you learn alot more and you can see how it's all done, always take the harder option if you wanna learn stuff with PC's.... if you break it... you'll know not to do it again won't ya?? :-P
Joff
Member
Registered: 17th Oct 00
Location: Cambridgeshire
User status: Offline
1st Feb 04 at 14:21   View User's Profile U2U Member Reply With Quote
SQLyog is better than MySQLAdmin IMHO
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
1st Feb 04 at 14:23   View Garage View User's Profile U2U Member Reply With Quote
I've always used phpMyAdmin myself but then of course you need a web server with PHP capability.

 
New Topic
New Poll

  Related Threads Author Forum Replies Views Last Post
Anyone good @ Programming ?? chris_lee100 Geek Day 3 1067
9th Jan 04 at 22:10
by Laney		  
forum hacking - SQL's Drew Geek Day 15 1720
9th Sep 04 at 23:50
by Ian		  
Server Help Jodi_the_g Geek Day 7 1458
19th Jan 06 at 15:18
by Jodi_the_g		  
MYSQL Database liamC Geek Day 3 797
18th Dec 06 at 17:57
by aPk		  
MYSQL Problem(s) liamC Geek Day 23 1064
14th Jan 07 at 14:21
by Ian		  

Corsa Sport » Message Board » Off Day » Geek Day » Linking .jsp pages to a MySQL database 29 database queries in 0.0127580 seconds