?? clientinfoutil.java.svn-base
字號(hào):
package com.nsi.components.util;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import com.nsi.components.util.info.ClientInfo;
import com.nsi.control.exceptions.NsiEventException;
import com.nsi.persistence.DataSrcUtil;
import com.nsi.persistence.IsqlDataSource;
import com.nsi.util.ValHelper;
public final class ClientInfoUtil
{
private static Log log = LogFactory.getLog(ClientInfoUtil.class);
/**
* private constructor of ClientInfoUtil, prevent instantiation
*/
private ClientInfoUtil()
{
}
private static class ClientInfoUtilHolder
{
static final ClientInfoUtil clientInfoUtil = new ClientInfoUtil();
}
/**
* @return an instance of ClientInfoUtil
*/
public static ClientInfoUtil getInstance()
{
return ClientInfoUtilHolder.clientInfoUtil;
}
public List<ClientInfo> getClientlist()
{
List<ClientInfo> list = new ArrayList<ClientInfo>();
List<Map<String,String>> result = new ArrayList<Map<String,String>>();
String sSql = "select clientid, shortname, client from ct_client order by client";
try
{
IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
Connection conn = null;
try
{
conn = src.getConnection();
result = src.executeRetrieve(conn, sSql);
src.closeConn(conn);
}
catch( SQLException se )
{
log.error( "getClientlist() caught SQLException: ", se );
}
catch( Exception ex )
{
log.error( "getClientlist() caught Exception: ", ex );
}
finally
{
src.closeConn(conn);
}
if( !result.isEmpty())
{
int size = result.size();
for( int i=0;i<size;i++)
{
Map<String,String> resultMap = result.get(i);
ClientInfo info = new ClientInfo();
info.setClientid(ValHelper.getInstance().getValue(resultMap, "clientid"));
info.setShortname(ValHelper.getInstance().getValue(resultMap, "shortname"));
info.setClient(ValHelper.getInstance().getValue(resultMap, "client"));
list.add( info);
}
}
}
catch( NsiEventException nsiex )
{
log.error( "getClientlist() caught NsiEventException: ", nsiex );
}
return list;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -