?? util.java
字號:
//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;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -