import java.sql.*;

public class CityRDBMapper
 extends AbstractMapper
 implements DBAccountConsts
{

    protected Object getFromStorage(OID oid)
    {
        try {
            String key = oid.toString();
            String url = "jdbc:odbc:reservsys";
            Connection con =
                DriverManager.getConnection(url,
                                            USERNAME, PASSWORD);
            Statement stmt =
                con.createStatement();
            ResultSet dbRec = 
                stmt.executeQuery("Select * from CITY where key ="
                                  + key);

            String name = dbRec.getString("NAME");
            City c = new City(oid, name);
            return c;
        } catch (SQLException se) {
            return null;
        }
    }

    protected void putToStorage(OID oid, Object o) {
        // ...
    }
}