불친절한자수씨

import com.google.gwt.gears.core.client.GearsException; import com.google.gwt.gears.database.client.Database; import com.google.gwt.gears.database.client.DatabaseException; import com.google.gwt.gears.database.client.ResultSet; public class GearsPortal { private static GearsPortal instance; public static GearsPortal getInstance() { if (instance == null) instance = new GearsPortal(); return instance; } private static final String DATABASE_NAME = "wiseone_db"; private Database database; public GearsPortal() { initDatabase(); createTable(); } private void initDatabase() { try { database = new Database(DATABASE_NAME); } catch (GearsException e) { e.printStackTrace(); } } private void createTable() { try { database.execute("CREATE TABLE IF NOT EXISTS TPT3010(userIndex text, portalInfo text)"); } catch (DatabaseException e) { e.printStackTrace(); } } protected Database getDatabase() { return database; } public String getPortalInfo(String userIndex) { String portalInfo = null; try { ResultSet rs = getDatabase().execute("SELECT portalInfo FROM TPT3010 WHERE userIndex = ?", new String[] { userIndex }); portalInfo = rs.getFieldAsString(0); } catch (DatabaseException e) { e.printStackTrace(); } return portalInfo; } public void setPortalInfo(String userIndex, String portalInfo) { try { if (getPortalInfo(userIndex) == null) { getDatabase().execute("INSERT INTO TPT3010 VALUES( ?, ? )", new String[] { userIndex, portalInfo }); System.out.println("insert data"); } else { getDatabase().execute("UPDATE TPT3010 SET portalInfo = ? WHERE userIndex = ?", new String[] { portalInfo, userIndex }); System.out.println("update data"); } } catch (DatabaseException e) { e.printStackTrace(); } } }

일반적인 gears 시에 factory 를 통해서 database 객체를 가지고 오는데 캡슐화 되어 있어서
Database 를 open 하고 table 을 생성한 후에 사용하면 됩니다.

좀 아쉬운 점은 executeList 가 없다는 점...  나중에 시간나면 포럼에 글 올리거나 직접 수정해야겠네요~