Top "Resultset" questions

How can I retrieve a JDBC ResultSet as an ArrayList?

I'm doing a query to retrieve a large amount of IDs (integers). Instead of iterating millions of times through the …

java performance jdbc arraylist resultset

Resultset's getObject() method - how to use it properly?

I make a database query and store Account objects in the ResultSet. Here is the code: try { ResultSet rs = queryDatabase(); …

java jdbc resultset

Retrieve entire row with ResultSet

Is it possible to retrieve entire row without calling getInt(..) getString(..) for every column? I have multiple threads, each tread …

java jdbc resultset

Resultset get all values

How can i get all the values from all the columns? Ive tried with this code: values.add(rs.getString(…

java sql sqlite resultset

How to check that a ResultSet contains a specifically named field?

Having rs, an instance of java.sql.ResultSet, how to check that it contains a column named "theColumn"?

java jdbc resultset

Easy way to fill up ResultSet with data

I want to mock a ResultSet. Seriously. I'm refactoring one big complicated piece of code which is parsing data from …

java unit-testing jdbc mocking resultset

getDateTime from ResultSet java

I have two columns which store DateTime values in a MySql database, When I try to get them from a …

java mysql datetime resultset

Statement.execute(sql) vs executeUpdate(sql) and executeQuery(sql)

I have a question related to this method: st.execute(sql); where st obviously is a Statement object. Directly from …

java jdbc resultset

Fetch Oracle table type from stored procedure using JDBC

I'm trying to understand different ways of getting table data from Oracle stored procedures / functions using JDBC. The six ways …

oracle stored-procedures jdbc resultset out-parameters

How to get the char data type from mysql using resultset

I have been doing CRUD operation on database, but i could not find any direct method for the getting the …

java api jdbc resultset