Fetching and setting to MySQL

How do you go about fetching and setting information to a MySQL database (ie player stats/currency amounts) within Java?

 

@Markyroson "posting" is probably not the right word, anyway, have you tried using google? There are thousands of examples out there.

 

@Markyroson
Using google, I found this in about 15 seconds
http://stackoverflow.com/questions/13028381/fetching-stored-procedure-from-the-mysql-database

 

I changed the title and my original post to the correct terminology (changed "posting" to "setting"). I was just wondering if the community here had a better example than youtube videos and a couple of websites that had full out ones (was wondering especially after seeing bashing of youtube videos on forums).

 

@Markyroson Youtube videos are horrible, to be honest I would go with the Oracle Tutorials and maybe one or another site that has stuff right.

As a note, you should read about Prepared Statements to increase performance and prevent sql injection.

 

I did find a website that seemed to have it but I cannot find it on this PC (found it on mobile so will look there later) and I will post it in here.

I will look into prepared statements. How do they increase performance though?

 

@Markyroson The prepared statements are sent to the database and pre-compiled there, and can be used multiple times.

Doing something like this would be faster than creating a new statement for each query.

Code:

for(Data data : dataList) {
   preparedStatement .setInt(1, data.getId());
   preparedStatement.setString(2, data.getValue();
   preparedStatement.executeUpdate();
}

 

@Konato_K

In an imperceptible way, yes that would be faster.


@Markyroson

The only real reason you would use prepared statements is to prevent SQL injection, a particularly common and hilarious exploit that allows someone to wipe your database.

Also, do your queries on a separate thread, so as not to hang up the server.