Plugin not working

I dont realy know what is hapening with this code nut I cant retrive the integer from my db look at my code

Code:java

private static Connection con;
            private static Statement sta;
            private static ResultSet result;
 
 
            public static void ConnectToDatabase(){
                try {
                    con = DriverManager.getConnection("jdbc:mysql://mysql1.000webhost.com/a9755211_player", "a9755211_player", "Lucas1918");
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            public int getHumanity(UUID pluuid) throws SQLException{
                ConnectToDatabase();
                try{
 
                    String query = "SELECT humanity FROM warz_player WHERE uuid=" + pluuid.toString();
                    result = sta.executeQuery(query);
                    result.getInt("humanity");
 
                } catch (Exception e){
                    e.printStackTrace();
                }
                return result.getInt("humanity");
            }
            public static int getZombies(UUID pluuid) throws SQLException{
                try{
 
                    String query = "SELECT zombies FROM warz_player WHERE uuid=" + pluuid.toString();
                    result = sta.executeQuery(query);
 
 
 
                } catch (Exception e){
                    e.printStackTrace();
                }
                return result.getInt("zombies");
            }
            public int getbandits(UUID pluuid) throws SQLException{
                try{
 
                    String query = "SELECT bandits FROM warz_player WHERE uuid=" + pluuid.toString();
                    result = sta.executeQuery(query);
 
 
                } catch (Exception e){
                    e.printStackTrace();
                }
                return result.getInt("bandits");
            }
            public int getMurders(UUID pluuid) throws SQLException{
                try{
 
                    String query = "SELECT murders FROM warz_player WHERE uuid=" + pluuid.toString();
                    result = sta.executeQuery(query);
 
 
                } catch (Exception e){
                    e.printStackTrace();
                }
                return result.getInt("murders");
            }

 

Well, first, read this and fix that connect method.

 

While we're giving off-topic suggestions, OP should use prepared statements

Not really helpful without showing us the NPE...

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

 

I was going to save pointing that out until after he fixed the aforementioned issue. Note the cause of his NPE

 

oh wow...

 

Just an idea... how about not posting your credentials online?

 

Garris0n hintss

Not to mention the excessive use of statics....

 

can anyone just tell me how can I get int from a database
?

 

read over your code a few times, it's pretty obvious (hint: what is sta equal to?)

 

1)

Code:

It should be:
uuid=' + id.toString() + '

2) Close the Result set and statement
3)Check if the result set is not null
4)make sure you have established a connection and every player is getting register on the database
5)Avoid statements. Use PreparedStatements instead
6) Docs.

Edit: Use a new statement and result set each time. They dont get GC'd unless you close them