Java-Gaming.org    
Featured games (79)
games approved by the League of Dukes
Games in Showcase (477)
Games in Android Showcase (109)
games submitted by our members
Games in WIP (536)
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 1389 times)
0 Members and 1 Guest are viewing this topic.
Offline Manfred

Senior Newbie




Java games rock!


« Posted 2004-11-17 17: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 18: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 www.mysql.com, and play with client code like:


String host,database,username,password;

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

JGO Coder


Medals: 1


pixels! :x


« Reply #2 - Posted 2004-11-17 18:25:05 »

http://www.java-gaming.org/cgi-bin/JGNetForums/YaBB.cgi?board=2D;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

@mhale

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 20: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-18 00:11:24 »

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

Junior Member




... Boing ...


« Reply #5 - Posted 2004-11-18 16: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.

 

Add your game by posting it in the WIP section,
or publish it in Showcase.

The first screenshot will be displayed as a thumbnail.

CogWheelz (18 views)
2014-07-30 21:08:39

Riven (25 views)
2014-07-29 18:09:19

Riven (15 views)
2014-07-29 18:08:52

Dwinin (12 views)
2014-07-29 10:59:34

E.R. Fleming (33 views)
2014-07-29 03:07:13

E.R. Fleming (12 views)
2014-07-29 03:06:25

pw (43 views)
2014-07-24 01:59:36

Riven (43 views)
2014-07-23 21:16:32

Riven (30 views)
2014-07-23 21:07:15

Riven (31 views)
2014-07-23 20:56:16
List of Learning Resources
by SilverTiger
2014-07-31 18:29:50

List of Learning Resources
by SilverTiger
2014-07-31 18:26:06

List of Learning Resources
by SilverTiger
2014-07-31 13:54:12

HotSpot Options
by dleskov
2014-07-08 03:59:08

Java and Game Development Tutorials
by SwordsMiner
2014-06-14 00:58:24

Java and Game Development Tutorials
by SwordsMiner
2014-06-14 00:47:22

How do I start Java Game Development?
by ra4king
2014-05-17 11:13:37

HotSpot Options
by Roquen
2014-05-15 09:59:54
java-gaming.org 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‑gaming.org
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!