Java JDBC - From database to Arraylist

Question

I am looking for a more generic approach to add rows from a database to its corresponding model.

Where am i now...

I have multiple tables in a database with information about computerparts, ex. cpu(manufacturer, cores, speed ...), which I have added to an ArrayList<Cpu>. I construct the models by fetching the information from the database like so;

public ArrayList<Cpu> getAllCpu(ArrayList<Cpu> cpu, String sql) throws.. {

    ResultSet rs = queryGetResultSet("SELECT * FROM cpu");

    while(rs.next()){
        String manufacturer = rs.getString(1);
        String socket_type = rs.getString(2);
        // multiple lines, with string, integers and boolean types ...

        Cpu cpu = new Cpu(manufacturer, socket_type, ... );
        results.add(cpu);
    }

    return cpu;
}

Is there a neat way to avoid making multiple methods like this one, for my computerparts?

My end-goal would be to call something like the following;

ArrayList<Cpu> cpu = new ArrayList<>()
cpu = MyVeryIntelligentCode.getAll(cpu);

... and be able to get a list of all my cpu's in the database, and if I made a new table for McFlurry-types along with a model, I could use the same function to fetch an ArrayList for that!

Thanks in advance, you guys have helped me alot so far, but this time I had to ask a question myself!

You could use something like Commons DbUtils (or even a full-grown ORM library). — Thilo, Mar 04 '16 at 03:53
Sounds like you might be looking for an ORM (Object/Relational Mapping), e.g. [Hibernate](http://hibernate.org/orm/). — Andreas, Mar 04 '16 at 03:53

score 0 · Accepted Answer · answered Mar 04 '16 at 05:07

0

Look at Spring jdbsTemplate queryForList

https://docs.spring.io/spring/docs/current/javadoc-api/org/springframework/jdbc/core/JdbcTemplate.html

answered Mar 04 '16 at 05:07

kolchanov

2,018
2
14
32

Java JDBC - From database to Arraylist

I am looking for a more generic approach to add rows from a database to its corresponding model.

1 Answers1