Get/put something out from SQL

Hey!

I'm developing a plugin that is gonna include SQL in it. I don't want to run it with custom files, when this is not be best way to save and load objects on.

I'm wondering if anybody knows how i shoud get the data out of a table, where I want to get the "amount" from the "player".

I'm also wondering how I should put an specific amount to the "amount", and add the playerName to "player" statements.

Thanks.

 

You should watch some of thenewboston's SQL syntax tutorials (on YouTube).

 

Step 1, learn SQL, took me about 3-5 hours, now its easy, I learned from thenewbostons youtubw.
Step 2, look up JDBC, learn how to use it.
Step 3:
I) get a new connection to the database
II) Use SQL SELECT to get the data
III) Add that data to maybe a
A) hashmap
B) set
C) list
IV)????????
V) Profit!!!

 

Maybe you are interested in the bukkits database layer ebean orm as well. I don't even know why most people don't use it.

 

I prefer the Java Persistence Library that is included with bukkit. This means you can either use the built in SQLite or configure the server to use mySQL. Then you only work with objects, not tables. I find it easier to use but it might take longer to learn.

 

Learning annotations instead of SQL looks more easy for me especially if you have never worked with a query based language before.

 

http://forums.bukkit.org/posts/1569588/