[TUT] How To Use JDBC In Your Plugins (MySQL Databases)

I was looking around, and i couldn't find a good tutorial on how to use MySQL in your plugins. Eventually, i found out. So i'm gonna show you how!

First, we need to make 3 variables:

Code:java

String user = "YOUR_USER";
String pass = "YOUR_PASSWORD";
String url = "jdbc:mysql://localhost:3306/database"; //localhost: Your MySQL host, 3306: Your MySQL port (3306 is the main), database: Your MySQL database
 

Now, we need to make the function/whatever you call it:

Code:java

	public void SampleFunction() throws SQLException { //Change "SampleFunction" to your own function name (Can be anything, unless it already exists)
		Connection conn = DriverManager.getConnection(url, user, pass); //Creates the connection
		PreparedStatement sampleQueryStatement = conn.prepareStatement("YOUR QUERY"); //Put your query in the quotes
		sampleQueryStatement.executeUpdate(); //Executes the query
		sampleQueryStatement.close(); //Closes the query
		conn.close(); //Closes the connection
	}
 

Now, we need to add this into the onEnable() (Or a command, etc)

Code:java

public void onEnable() {
    try {
        create_tablesConnect(); //Runs the function
    } catch (SQLException e) {
        e.printStackTrace();
    }
}
 

So, thats about it for using JDBC in your plugins. In the future, i will be making a more advanced tutorial, where you can get your user, pass and url from a config file. Thanks for reading! I hope this helped you. If i missed something or have a request, tell me in the comments!
Github Examples

 

Thanks been looking to implement MYSQL into some of my plugins, however 2 things do we need a library/external jar for this if so where do we get it? and secondly any tutorials on queries or how to add and retrieve stuff from the database Thank you

 

1: You only need to import *looks at code*

Code:java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

2: Ill add that, thanks!

Also, if anyone needs help, and if there getting errors, check this out: http://dev.bukkit.org/paste/4178/ I know theres probally a better way, i just do it this way anyways :3

Also, ill be doing some other tutorials, like saying /create and it creates some tables.

 

I advise you to look into database pooling also, more efficent.

 

I Probally Will.

 

Hi cheese, are you planning on continuing with this tut? its bloody useful

For anyone that gets stuck trying to add a Auto increment, you must also set KEY:

Code:

public void create_tables() throws SQLException
    {
        Connection conn = DriverManager.getConnection(url, user, pass);
        PreparedStatement sampleQueryStatement = conn.prepareStatement("CREATE TABLE users (p_id int NOT NULL AUTO_INCREMENT KEY)");
        sampleQueryStatement.executeUpdate();
        sampleQueryStatement.close();
        conn.close();
    }

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

 

I will be, but right now is a busy time. I'm going to college, but I'll still update.

Thanks! I'll add that in, zh00 get cr3dit

 

Can someone explain to me what exactly I should be putting here?

 

For user var, put your MySQL username, for pass, put your MySQL password, and for URL, replace "localhost" with your MySQL hosname, and replace "database" with your MySQL database name.

 

Uh. Never mind I guess. I clear have no idea how to make sense of this.

 

Here is a playlist for the new boston's SQL tutorials :

http://www.youtube.com/playlist?list=PL32BC9C878BA72085