Storing/Reading an ItemStack from MySQL?

I dont have any idea how to use MySQL, I dont even understand how it works.
I want to save ALL the NBT Data, Enchantments, eg, with it, using preferably a string (Im not sure how this works! )
Thanks.
(Ill need EVERY bit of code to do this)

 

If you don't understand how it works, perhaps it is not the best solution for what you want to do?

There are a number of tutorials/libraries to easy development available on the forums.

http://forums.bukkit.org/threads/lib-sqlibrary-database-wrappers-for-all-database-engines.33849/

As for storing as a string, this may be possible using yaml, since ItemStacks can be serialized/deserialized by it, and yaml can be saved/loaded to/from a string.

 

tehbeard is that API?
And if it is, does the server need the server version on?

tehbeard it needs to be MySQL, as I need to transfer these files between 2 servers!

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

The core part (the JDBC mysql driver) is part of the bukkit jar.

As for SQLLibrary, I believe you roll it into your plugin. More specific questions on it are better answered in it's thread (I only have experience with using JDBC directly, not SQLLibrary)

 

tehbeard well, I now need help reading/writing an itemstack in a string now

 

YamlConfiguration config = new YamlConfiguration();


....

//to save
config.put("item",itemstackVariable);
String itemstackAsString = config.saveToString();

....
//to load
config.load(itemstackAsString);//might be loadString()

ItemStack is = (ItemStack)config.get("item")

 

tehbeard using MySQL, Not configs.

 

Why not save the config to mysql?