?? retrieveusersutil.java
字號:
/**
*
*/
package com.air.backend.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.air.exceptions.AirException;
import com.air.model.Fight;
import com.air.model.LoginUser;
import com.air.persistence.DataSrcUtil;
import com.air.persistence.IsqlDataSource;
import com.air.util.ValHelper;
/**
* @author jelly_yang
*
*/
public class RetrieveUsersUtil {
private static Log log = LogFactory.getLog(RetrieveUsersUtil.class);
private RetrieveUsersUtil() {
// TODO Auto-generated constructor stub
}
public static class RetrieveUsersUtilHolder{
static RetrieveUsersUtil retrieveUsersUtil = new RetrieveUsersUtil();
}
public static RetrieveUsersUtil getInstance(){
return RetrieveUsersUtilHolder.retrieveUsersUtil;
}
public List<LoginUser> getUsers()throws AirException{
List<LoginUser> list = new ArrayList<LoginUser>();
List<Map<String,String>> result = new ArrayList<Map<String,String>>();
String sSql = "select * from users";
IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
Connection conn = null;
log.debug("retrieveFight() -- sSql["+ sSql+ "]");
try
{
conn = src.getConnection();
result = src.executeRetrieve(conn, sSql);
}
catch(SQLException se)
{
log.error("getUsers() caught SQLException: " + se);
}
catch(Exception ex)
{
log.error("getUsers() 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);
String username = ValHelper.getInstance().getValue(resultMap, "username");
String name = ValHelper.getInstance().getValue(resultMap, "name");
String sex = ValHelper.getInstance().getValue(resultMap, "sex");
LoginUser user = new LoginUser();
user.setUsername(username);
user.setName(name);
user.setSex(sex);
list.add( user );
}
}
return list;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -