Dave Miller wrote:
> a wrote:
>> Hi
>>
>> Can I create a resultset that have all the specified columns? And, I
>> have to
>> populate it with data. When the database is offline, then I can
>> simulate it
>> to test my code. Please provide simple example.
>>
>> Thanks
>>
>>
> A resultset is stored in memory - I'm unsure what you mean about
> "offline". To get all of the columns, ask for all of the columns.
>
> A simple resultset example:
>
> java.sql.Connection c = DriverManager.getConnection("your driver and
> path to db", "your db user id", "your db password");
> Statement get = c.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
> ResultSet.CONCUR_READ_ONLY);
> ResultSet rs = get.executeQuery("your query");
>
> //use your result set from here
The newer RowSet interface lets you disconnect from the database while
using
the results, unlike normal ResultSets.
--
Lew
|
