java and sql into JList

Question

What is the best way to get my mysql data into a JList. I can connect to the database and output the results. I've been looking at various ways online but not getting the desired results. Instead of posting any code, are there any great tutorials showing how this is done, or any code snips.

    try {
        Class.forName("com.mysql.jdbc.Driver");
        con = DriverManager.getConnection
        ("jdbc:mysql://www", "....", "....");

        st = con.createStatement();

        } catch (Exception ex) {
        System.out.println("error" + ex);
        }
        try {           

            String query = "select * from demo";
            rs = st.executeQuery(query);
            System.out.println("Records from Database");
            while(rs.next()) {                      
            String number  = rs.getString("number");
            System.out.println(number);         

            }
        } catch (Exception ex) {

        System.out.println("error" + ex);
        }
    }       
}

trashgod · Accepted Answer · 2012-10-22 16:26:24Z

4

It looks like you understand how to query the database using JDBC. Now you just need to use the results to construct your preferred ListModel, as shown in How to Use Lists.

answered Oct 22, 2012 at 16:26

trashgod

206k33 gold badges264 silver badges1.1k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

The Cat · Accepted Answer · 2012-10-22 16:26:02Z

2

I use a spring class called SimpleJdbcTemplate that you can use to query the database. Its fairly lightweight but avoids having to set up the XML mappings needed in Mybatis! or Hibernate.

Here is a fairly comprehensive tutorial .

answered Oct 22, 2012 at 16:26

The Cat

2,4756 gold badges26 silver badges37 bronze badges

Comments

r0ast3d · Accepted Answer · 2012-10-22 16:13:04Z

0

Mybatis! or Hibernate - for the shortest answer.

answered Oct 22, 2012 at 16:13

r0ast3d

2,6351 gold badge14 silver badges18 bronze badges

Collectives™ on Stack Overflow

java and sql into JList

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related