Hi !
Featured games (85)
games approved by the League of Dukes
Games in Showcase (636)
Games in Android Showcase (178)
games submitted by our members
Games in WIP (688)
games currently in development
News: Read the Java Gaming Resources, or peek at the official Java tutorials
    Home     Help   Search   Login   Register   
Pages: [1]
  ignore  |  Print  
  Databases and High Score storing.  (Read 1802 times)
0 Members and 1 Guest are viewing this topic.
Offline Manfred

Senior Newbie

Java games rock!

« Posted 2004-11-17 16:27:32 »

I'm trying to figure out how to store high scores in a MySQL DB.  From the research I've done, I would have to download and install some some JDBC drivers for MySQL.  

Problem is that my web page host won't allow for the running of any java on their server.  The tech didn't seem to knowledgable on the subject(or maybe that was me), just said no to the JDBC drivers, and said to use Perl or PHP.  

Is there any way to bridge the gap?  Send a score to a Perl script or use PHP somehow(also not my field of expertise)?  
Offline mhale

Senior Newbie

Take pity, I'm just a poor blob!

« Reply #1 - Posted 2004-11-17 17:23:27 »

If you have a mysql database on a web server, then a java client can connect to it using jdbc with no java required on the server. That is, the JDBC driver is on the client not the server side.

To get yourself started, download JDBC MySQL connector from, and play with client code like:

String host,database,username,password;

String url = "jdbc:mysql://"+host+"/"+database+"?user="+username+"&?password="+password;
Connection con =DriverManager.getConnection(url);
Offline oNyx

JGO Coder

Medals: 2

pixels! :x

« Reply #2 - Posted 2004-11-17 17:25:05 »;action=display;num=1093643008;start=3#3

I've already explained that kind of stuff 3 times now and I won't do that again Wink


That's really scary. Everyone could just connect and delete the whole database etc (they have user+password).

弾幕 ☆ @mahonnaiseblog
Games published by our own members! Check 'em out!
Legends of Yore - The Casual Retro Roguelike
Offline mhale

Senior Newbie

Take pity, I'm just a poor blob!

« Reply #3 - Posted 2004-11-17 19:50:16 »

Yes, it is scary. But, MySQL allows you to setup permissions for SQL statements, so you can prevent people from executing arbitrary sql statements.
Offline Manfred

Senior Newbie

Java games rock!

« Reply #4 - Posted 2004-11-17 23:11:24 »

I must have misunderstood what I was reading.  Thanks for your help folks.
Offline crystalsquid

Junior Devvie

... Boing ...

« Reply #5 - Posted 2004-11-18 15:23:13 »

We use PHP pages to do this.

The Java client can simply request a specific php page like hiscore.php and supply the arguments for the name, number, etc. The PHP on the server side can then do whatever database processing you like and return a fake 'page' to the applet, complete with the top 10 scores, and your rank.
Pages: [1]
  ignore  |  Print  
You cannot reply to this message, because it is very, very old.

Dwinin (73 views)
2015-11-07 13:29:08

Rems19 (81 views)
2015-10-31 01:36:56

Rems19 (78 views)
2015-10-31 01:32:37

williamwoles (107 views)
2015-10-23 10:42:59

williamwoles (93 views)
2015-10-23 10:42:45

Jervac_ (111 views)
2015-10-18 23:29:12

DarkCart (135 views)
2015-10-16 00:58:11

KaiHH (118 views)
2015-10-11 14:10:14

KaiHH (157 views)
2015-10-11 13:26:18

BurntPizza (172 views)
2015-10-08 03:11:46
Rendering resources
by Roquen
2015-11-13 14:37:59

Rendering resources
by Roquen
2015-11-13 14:36:58

Math: Resources
by Roquen
2015-10-22 07:46:10

Networking Resources
by Roquen
2015-10-16 07:12:30

Rendering resources
by Roquen
2015-10-15 07:40:48

Math: Inequality properties
by Roquen
2015-10-01 13:30:46

Math: Inequality properties
by Roquen
2015-09-30 16:06:05

HotSpot Options
by Roquen
2015-08-29 11:33:11 is not responsible for the content posted by its members, including references to external websites, and other references that may or may not have a relation with our primarily gaming and game production oriented community. inquiries and complaints can be sent via email to the info‑account of the company managing the website of java‑
Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines | Managed by Enhanced Four Valid XHTML 1.0! Valid CSS!