Java - get garbled result(List) from MySQL

Question

The result should be like [1,2,3,4], but i get garbled result like this

[com.test.db.Network@383c7b61, com.test.db.Network@7f87898,
 com.test.db.Network@6b93f47a, com.test.db.Network@50fb09cc]

Below is my related class

private static void doLocationList(PrintWriter responseOut) throws Exception
{
//---testing show network ID list
int x=0;
Network network = new Network();
responseOut.println("this is I: " +network.getNetworkID(x));

......
}

This is from another class

public static List<Network> getNetworkID(int networkID) throws Exception
{
List<Network> idList = new ArrayList<Network>();
Connection conn = getConnection();
PreparedStatement Statement = conn.prepareStatement("Select id from network");
ResultSet result = Statement.executeQuery();
    while(result.next()) {
        Network network = new Network();
        network.setId(result.getInt("id"));
        idList.add(network);
    }

return idList;
}

Any idea? Please help.

possible duplicate of [Java - How to create a println/print method for a custom class](http://stackoverflow.com/questions/8001664/java-how-to-create-a-println-print-method-for-a-custom-class) — Sotirios Delimanolis, Apr 17 '14 at 04:28
Because the "select id from network" (in MySQL) will get 1,2,3,4.. So i want to get back the array numbers. — Lc Wei, Apr 17 '14 at 04:32
That gets numbers, but that's not what you're printing. You're printing a `List`. — Sotirios Delimanolis, Apr 17 '14 at 04:33
I'm not sure the way i get the array number is correct or not, i just want to get result like [1,2,3,4]. The List should be change to String or something? — Lc Wei, Apr 17 '14 at 04:44

score 1 · Accepted Answer · edited May 23 '17 at 10:26

1

If you want to print the list of objects directly, you need to override the toString() method in the Network class and specify how to print the values when an object of this class is printed directly.

The default toString() method is as shown in Object class docs. Have a look at this post about toString()

edited May 23 '17 at 10:26

Community

1
1

answered Apr 17 '14 at 04:27

anirudh

4,116
2
20
35

Java - get garbled result(List) from MySQL

1 Answers1