Thread Status:

Not open for further replies.

1. Offline

   Forge_User_27334204

   Hi,
   I want to read the kills from a player. For this, I have a MySQL Database, where I have already the kills. How can I now read them with my plugin?
   Lg

    

   Forge_User_27334204, Jun 15, 2014

   #1
2. Offline

   Forge_User_16377210

   Code:java

   Connection conn;
   Statement stmt;
   ResultSet rs;
    
   Class.forName("com.mysql.jdbc.Driver");
   conn = DriverManager.getConnection("jdbc:mysql://IP?user=USER&password=PASSWORD");
   stmt = conn.createStatement();
   rs = stmt.queryUpdate("SELECT kills FROM DATABASE WHERE username='username'");
   while(rs.next) {
   //Do something with it
   }

   
   For instance, replace the USER with the login username and PASSWORD with login password, DATABASE with the tabel name and username with the user you want the kills from.

    

   Forge_User_16377210, Jun 15, 2014

   #2

Thread Status:

Not open for further replies.

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in