try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("SELECT route_id, npc_id, move_point, chatText, move_x, move_y, move_z, delay, running FROM walker_routes");
ResultSet rset = statement.executeQuery();
L2NpcWalkerNode route;
while (rset.next())
{
route = new L2NpcWalkerNode();
route.setRouteId(rset.getInt("route_id"));
route.setNpcId(rset.getInt("npc_id"));
route.setMovePoint(rset.getString("move_point"));
route.setChatText(rset.getString("chatText"));
route.setMoveX(rset.getInt("move_x"));
route.setMoveY(rset.getInt("move_y"));
route.setMoveZ(rset.getInt("move_z"));
route.setDelay(rset.getInt("delay"));
route.setRunning(rset.getBoolean("running"));
_routes.add(route);
}