Thread Status:

Not open for further replies.

1. Offline

   TomShar

   How could I check is a value isn't in the database?
   
   Code:
   ResultSet rs = mysql.query("Select * FROM FFA WHERE playername = '" + p.getName() + "'");
   How can I check if that returns nothing aka that name is not in the database?​

   
   using this: http://forums.bukkit.org/threads/lib-tut-mysql-sqlite-bukkit-drivers.33849/

    

   TomShar, Jun 24, 2012

   #1
2. Offline

   Forge_User_58953186

   http://docs.oracle.com/javase/1.4.2/docs/api/java/sql/ResultSet.html#first()

    

   Forge_User_58953186, Jun 24, 2012

   #2
3. Offline

   hockeygoalie5

   After you execute your query, use this:
   

   Code:

   if(!rs.next()) {
       // returned nothing
   }
   

    

   hockeygoalie5, Jun 24, 2012

   #3

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