request for very simple SQL extension

[rutabuga]

can any one give a very simple code snippet that:

conects to an SQL server
querys and a data value

all help is apreciated

ive tryed the following which dosnt seam to work

Code: Select all

IDBManager dbManager = getParentExtension().getParentZone().getDBManager();
		Connection connection;
		try {
			connection = dbManager.getConnection();
			PreparedStatement stmt = connection.prepareStatement("SELECT pword,id FROM muppets WHERE name=Kermit");
			ResultSet res = stmt.executeQuery();
			dbPword = res.getString("pword");
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

[Sigtran]

how did you determine that it doesnt work? e.g. did you print out the results / sent it to the client?

You can try the following, if you like:
on the server:

Code: Select all

addRequestHandler("getMuppets", GetMuppets.class);

and create an extension:

Code: Select all

import java.sql.SQLException;
import com.smartfoxserver.v2.db.IDBManager;
import com.smartfoxserver.v2.entities.User;
import com.smartfoxserver.v2.entities.data.ISFSArray;
import com.smartfoxserver.v2.entities.data.ISFSObject;
import com.smartfoxserver.v2.entities.data.SFSObject;
import com.smartfoxserver.v2.extensions.BaseClientRequestHandler;
import com.smartfoxserver.v2.extensions.ExtensionLogLevel;

public class GetMuppets extends BaseClientRequestHandler
{
	@Override
	public void handleClientRequest(User theUser, ISFSObject params)
	{
		IDBManager dbManager = getParentExtension().getParentZone().getDBManager();
		String sql = "SELECT pword,id FROM muppets WHERE name=Kermit";
		trace(sql);
		
		try
		{
			ISFSArray result = dbManager.executeQuery(sql);
			ISFSObject response = new SFSObject();
			response.putSFSArray("Muppets", result);
			
			// Send back to requester
			send("getMuppets", response, theUser);
		}
		catch (SQLException e)
		{
			trace(ExtensionLogLevel.WARN, "SQL Failed: " + e.toString());
		}
	}
}

Hope you can figure the Client side and the above helps. The prepared statement you have created seems correct to me, so just make sure you are actually tracing it / logging / requesting /etc