How Do I Show A List of Strings from MySQL to Bukkkit?

Hey, I need to know how do i view this information? it connects and setups fine. Here is The Link That I am using it from:

http://forums.bukkit.org/threads/tutorial-using-mysql-in-your-plugins.132309/

Here Is My Code:

Code:java

try {
    final Statement s = MySQL.open().createStatement();
    for (Player p : Bukkit.getOnlinePlayers()) {
        try {
            p.setPlayerListName(settings.getRank().getString(s.executeQuery("SELECT rank FROM players WHERE plName= '" + p.getName() + "';") + ".chat").replace("&", "§") + p.getName() + "" + ChatColor.RESET);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
} catch (SQLException e1) {
    e1.printStackTrace();
}

Thank You For Your Support.

 

Bump

First Bukkit forums go down and now no reply. lol

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

 

Help!!!!!!!!!!!!!!!!!!!

 

Code:java

    public String getString(String item, String table, String where) {
        try {
            connect = DriverManager.getConnection(dbUrl, dbUser, dbPass);
            ResultSet rs = connect.createStatement().executeQuery("SELECT " + item + " FROM " + table + " WHERE " + where);
            if (rs.next()) {
                return rs.getString(1);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }

I use this for my projects.

 

Thnks will try it out in the morning

 

it works with my edits:

Code:java

package com.fruitspvp;
 
import java.sql.ResultSet;
import java.sql.Statement;
 
public class MySQLCmds {
 
    static MySQLCmds instance = new MySQLCmds();
 
    public static MySQLCmds getInstance() {
        return instance;
    }
 
    public String getString(String item, String table, String where, String whereClause) throws Exception {
        Statement s = EnableMain.getInstance().MySQL.open().createStatement();
        ResultSet rs = s.executeQuery("SELECT " + item + " FROM " + table + " WHERE " + where + "=('" + whereClause + "');");
        rs.next();
        return rs.getString(1);
    }
 
}
 

 

ok now how do you get a list of strings?

My Code:

Code:java

    public ArrayList<String> getStringList(String player) throws Exception {
        Statement s = EnableMain.getInstance().MySQL.open().createStatement();
        ResultSet rs = s.executeQuery("SELECT 'kits' FROM kits WHERE '" + player + "' IN (SELECT '" + player + "' FROM players GROUP BY '" + player + "' HAVING count(*) > 1);");
        rs.next();
        return null;
    }

Thanks For Future Help

should i just create a new thread?

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