//Source file: D:\\WORK\\1G項目實踐\\WSMS\\CI\\CODE\\src\\com\\intacpurun\\wsms\\comm\\Util.java

package com.intacpurun.wsms.comm;

import java.sql.*;
import java.util.*;

import com.intacpurun.wsms.comm.db.*;
import com.intacpurun.wsms.comm.vo.*;

/**
 * 工具類
 */
public class Util
{

   /**
    * @roseuid 44CF192C0232
    */
   private Util()
   {

   }

   /**
    * 獲得城市列表
    * @return List
    * @roseuid 44CEC89C000F
    */
   public static List getCityList()
   {
     List cityList = new ArrayList();

     String sql = "select cityid,cityname "+
                  "from cityinfo "+
                  "order by cityid";

     DbUtil db = DbUtil.open();
     ResultSet rs = db.executeQuery(sql);

    try
    {
      while (rs.next())
      {
        ListNode node = new ListNode();
        node.setId(rs.getString("cityid"));
        node.setName(rs.getString("cityName"));

        cityList.add(node);
      }
    } catch (SQLException ex)
    {
      System.out.println(ex);
      ex.printStackTrace();
    }finally
    {
      db.close();
    }

    return cityList;
   }
}