@SuppressWarnings("unchecked")
@Override
public List<UsuarioDTO> buscarUsuarioPaginados(UsuarioDTO usuario, Integer inicio, Integer tamano)
throws Exception {
SqlSession sesion = sqlMapper.openSession();
List<UsuarioDTO> lstUsuario = new ArrayList<UsuarioDTO>();
try {
if (usuario == null) {
UsuarioDTO provee = new UsuarioDTO();
provee.setInicio(inicio);
provee.setTamano(tamano);
lstUsuario =
(List<UsuarioDTO>) sesion.selectList("usuario.SQL_listaUsuarioPaginados", provee);
} else {
if (!usuario.getNom_usuario().isEmpty()) {
usuario.setNom_usuario("%" + usuario.getNom_usuario() + "%");
usuario.setInicio(inicio);
usuario.setTamano(tamano);
lstUsuario =
(List<UsuarioDTO>)
sesion.selectList("usuario.SQL_listaUsuarioNom_usuarioPaginados", usuario);
}
}
} finally {
sesion.close();
}
return lstUsuario;
}
public void testInsert() {
// session.commit();
List<Student> lists =
sqlSession.selectList("com.ldl.mybatis.dataobject.Student.findAllStudents");
for (Student student : lists) {
System.out.println(
"学生id:"
+ student.getId()
+ " name:"
+ student.getName()
+ " 班级名称:"
+ student.getClasses().getName());
}
System.out.println(
"--------------------------------------------------------------------------");
List<Classes> listc =
sqlSession.selectList("com.ldl.mybatis.dataobject.Student.findAllClasses");
for (Classes classes : listc) {
System.out.println("班级id:" + classes.getId() + " name:" + classes.getName());
for (Student student : classes.getStudentList()) {
System.out.println(
"--学生id:"
+ student.getId()
+ " name:"
+ student.getName()
+ " 班级名称:"
+ student.getClasses().getName());
}
}
}
@Test
public void learnToUseStoredProcWithDomainObjects() {
FilmInStockParam param = new FilmInStockParam();
param.setFilmId(12);
param.setStoreId(1);
List<FilmInStockId> results = session.selectList("callFilmInStock", param);
// TODO: remove this line if your database does not use OUT params
// in which case MyBatis won't populate the count entry in this hash
assertEquals(3, param.getCount());
assertEquals(3, results.size());
FilmInStockId f = results.get(0);
assertNotNull(f);
assertEquals(60, f.getFilmId().intValue());
f = results.get(1);
assertNotNull(f);
assertEquals(61, f.getFilmId().intValue());
f = results.get(2);
assertNotNull(f);
assertEquals(62, f.getFilmId().intValue());
}
/**
* 获取permission数据集合
*
* @author 尹逊志
* @throws JsonProcessingException
* @time 2015年4月13日下午10:29:36
*/
@ResponseBody
@RequestMapping(value = "/user/permissionList", method = RequestMethod.POST)
public String getPermissonData(HttpServletRequest request, HttpServletResponse response)
throws JsonProcessingException {
String rows = request.getParameter("rows");
String page = request.getParameter("page");
if (rows == null) {
rows = "20";
}
if (page == null) {
page = "1";
}
String resource = "/mybatis-config-test.xml";
InputStream is = UserController.class.getResourceAsStream(resource);
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);
SqlSession session = factory.openSession();
String statement = "com.myproject.mybatis.user.permissionMapper.getAll";
Map<String, Integer> map = new HashMap<String, Integer>();
map.put("pageNum", Integer.parseInt(page));
map.put("pageSize", Integer.parseInt(rows));
PageHelper.startPage(Integer.parseInt(page), Integer.parseInt(rows));
List<Permission> permissList = session.selectList(statement);
PageInfo<Permission> pageInfo = new PageInfo<Permission>(permissList);
session.commit();
session.close();
ResponseResult result = new ResponseResult();
result.setTotal(pageInfo.getTotal());
result.setRows(permissList);
ObjectMapper mapper = new ObjectMapper();
return mapper.writeValueAsString(result);
}
/**
* 根据查询参数获取一页的数据
*
* @return
*/
public List<CellMenuList> getCellMenuListsByQueryCriteria(
int start, int pageSize, CellMenuListQuery query) {
RowBounds rowBounds = new RowBounds(start, pageSize);
List<CellMenuList> rows =
sqlSession.selectList("getCellMenuListsByQueryCriteria", query, rowBounds);
return rows;
}
@Override
public List<log> getLogs(Map mp) {
List usr = null;
SqlSession session = util.getSqlsession();
usr = session.selectList("log.selectListByPage", mp);
return usr;
}
@Override
public Map getAllInfo() {
SqlSession session = util.getSqlsession();
company cp = new company();
cp.setId("1");
company cy = (company) session.selectOne("company.selectOneById", cp);
Map mp = new HashMap();
mp.put("company", cy);
List pc = session.selectList("productClass.selectList");
mp.put("productclass", pc);
List tm = session.selectList("team.selectList");
List bc = session.selectList("brochure.selectList");
mp.put("team", tm);
mp.put("brochure", bc);
return mp;
}
/**
* Update communication Medium
*
* @param ag
* @throws PersistenceException
*/
public void updateCommMedium(AssertionGroup ag) throws PersistenceException {
SqlSession session = sf.openSession();
try {
session.selectList("com.cockpitconfig.objects.CommunicationMapper.updateCommID", ag);
} finally {
session.close();
}
}
public List<Member> selectList() throws Exception {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
return sqlSession.selectList("spms.dao.MemberDao.selectList");
} finally {
sqlSession.close();
}
}
@Override
public ArrayList<User> userLsit() {
// TODO Auto-generated method stub
SqlSession session = getSession();
List<User> list = session.selectList("hooni.userList");
close(session);
return (ArrayList<User>) list;
}
@SuppressWarnings("unchecked")
protected <E> List<E> list(Class<E> type, String sqlKey, int count) {
SqlSession session = sqlSessionFactory.openSession();
try {
return (List<E>) session.selectList(sqlKey, count);
} finally {
session.close();
}
}
@Test
public void findUserByName() throws IOException {
InputStream inputStream = Resources.getResourceAsStream("SqlMapConfig.xml");
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession sqlSession = sessionFactory.openSession();
List<User> list = sqlSession.selectList("test.findUserByName", "小");
System.out.println(list);
sqlSession.close();
}
@Override
public List<Comment> getComments(int page, String boardCode) {
HashMap<String, Object> params = new HashMap<String, Object>();
params.put("page", page);
params.put("boardCode", boardCode);
return session.selectList("getComments", params);
}
public void testMyBaits() {
SqlSession session = DbManager.getSqlFactory().openSession();
String statement = "com.zyxr.repair.missionLoansMap.getMissionLoans";
List<MissionLoans> loans = session.selectList(statement);
for (MissionLoans loan : loans) {
System.out.println(loan);
}
System.out.println(loans.size());
}
public List<User> getAllUserByEmail(String email) {
SqlSession session = SessionFactory.getSessionFactory().openSession();
List<User> users = new ArrayList<User>();
try {
users = session.selectList("UserMapper.selectUser", email);
} finally {
session.close();
}
return users;
}
private <E> Object executeForMany(SqlSession sqlSession, Object[] args) {
List<E> result;
Object param = method.convertArgsToSqlCommandParam(args);
if (method.hasRowBounds()) {
RowBounds rowBounds = method.extractRowBounds(args);
result = sqlSession.<E>selectList(command.getName(), param, rowBounds);
} else {
result = sqlSession.<E>selectList(command.getName(), param);
}
// issue #510 Collections & arrays support
if (!method.getReturnType().isAssignableFrom(result.getClass())) {
if (method.getReturnType().isArray()) {
return convertToArray(result);
} else {
return convertToDeclaredCollection(sqlSession.getConfiguration(), result);
}
}
return result;
}
public List<Goods> getGoods() {
SqlSession session = SessionFactory.getSessionFactory().openSession();
List<Goods> goods;
try {
goods = session.selectList("UserMapper.selectGoods");
} finally {
session.close();
}
return goods;
}
public List<User> getCouriers() {
SqlSession session = SessionFactory.getSessionFactory().openSession();
List<User> users;
try {
users = session.selectList("UserMapper.getCouriers");
} finally {
session.close();
}
return users;
}
@SuppressWarnings("unchecked")
public List<Q_skill_modelBean> select() {
SqlSession session = sqlMapper.openSession();
try {
List<Q_skill_modelBean> list =
(List<Q_skill_modelBean>) session.selectList("q_skill_model.select");
return list;
} finally {
session.close();
}
}
@SuppressWarnings("unchecked")
@Override
public List<UsuarioDTO> buscarUsuario(UsuarioDTO usuario) throws Exception {
SqlSession sesion = sqlMapper.openSession();
List<UsuarioDTO> lstUsuario = new ArrayList<UsuarioDTO>();
try {
if (usuario == null) {
lstUsuario = (List<UsuarioDTO>) sesion.selectList("usuario.SQL_listaUsuario");
} else {
if (!usuario.getNom_usuario().isEmpty()) {
lstUsuario =
(List<UsuarioDTO>)
sesion.selectList(
"usuario.SQL_listaNom_usuario", "%" + usuario.getNom_usuario() + "%");
}
}
} finally {
sesion.close();
}
return lstUsuario;
}
/** 获取部门 */
public List<Department> getDepart() {
List<Department> list = null;
SqlSession session = getSession();
try {
list = session.selectList("user.getDepart", null);
} catch (Exception e) {
System.out.println("userDao层getDepart发生异常......");
e.printStackTrace();
} finally {
session.close();
}
return list;
}
public List<ServerInfo> queryListById(int serverId) {
String smtpId = "ServerInfo.queryById";
List<ServerInfo> list = null;
try {
session = sessionFactory.openSession();
list = session.selectList(smtpId, serverId);
session.close();
} catch (Exception e) {
session.rollback();
e.printStackTrace();
}
return list;
}
/**
* Returns the list of all Contact instances from the database.
*
* @return the list of all Contact instances from the database.
*/
@SuppressWarnings("unchecked")
public List<Blog> select() {
SqlSessionFactory sqlSessionFactory = MyBatisConnectionFactory.getSqlSessionFactory();
SqlSession session = sqlSessionFactory.openSession();
try {
List<Blog> list = session.selectList("Blog.selectBlog");
return list;
} finally {
session.close();
}
}
/**
* 获取用户list
*
* @param user
* @return
*/
public List<User> getUserList(User user) {
List<User> list = null;
SqlSession session = getSession();
try {
list = session.selectList("user.queryUser", user);
} catch (Exception e) {
System.out.println("userDao层getUserList发生异常.....");
e.printStackTrace();
} finally {
session.close();
}
return list;
}
/**
* 抓取特定修改狀態所屬清單
*
* @param id 上層的ID
* @return List<TeleratesVo>
*/
public List<View_teleratesVo> listViewByUpdateStatus(TeleratesVo vo) {
SqlSession session = null;
List<View_teleratesVo> objs = null;
try {
session = getSession();
objs = session.selectList("teleRates.findViewByUpdateStatus", vo);
} catch (Exception e) {
e.printStackTrace();
logger.error(e.getMessage());
} finally {
closeCoonnection(session);
}
return objs;
}
@SuppressWarnings("unchecked")
@Override
public List<MenuDTO> obtenerMenu(Integer codCargo) {
SqlSession sesion = sqlMapper.openSession();
List<MenuDTO> listaMenu = new ArrayList<MenuDTO>();
try {
listaMenu = (List<MenuDTO>) sesion.selectList("menu.SQL_listaMenuXCargo", codCargo);
} catch (Exception e) {
System.out.println(e);
} finally {
sesion.close();
}
return listaMenu;
}
/**
* 根據狀態值取得遠傳訂單資料
*
* @param itemno String
* @return FetorderVo
*/
public List<FetorderVo> listByBcode(String bcode) {
SqlSession session = null;
List<FetorderVo> objs = null;
try {
session = getSession();
objs = session.selectList("fetOrder.listByBcode", bcode);
} catch (Exception e) {
e.printStackTrace();
logger.error(e.getMessage());
} finally {
closeCoonnection(session);
}
return objs;
}
/**
* 抓取指定電信系統商
*
* @param long id
* @return List<ProjectVo>
*/
public List<ProjectVo> findProjectByTeleCom(ProjectVo vo) {
SqlSession session = null;
List<ProjectVo> objs = null;
try {
session = getSession();
objs = session.selectList("project.findProjectByTeleId", vo);
} catch (Exception e) {
e.printStackTrace();
logger.error(e.getMessage());
} finally {
closeCoonnection(session);
}
return objs;
}
@Override
protected List<Message> getItems(int offset, int limit) throws Exception {
List<Map<String, Object>> maps;
SqlSession session = SqlConfig.getSqlSessionManager().openSession();
params.put("offset", offset);
params.put("limit", limit);
try {
maps = session.selectList("Message.getMessagesToPrune", params);
} finally {
session.close();
}
List<Message> messages = new ArrayList<Message>();
DonkeyDao dao = daoFactory.getDao();
try {
for (Map<String, Object> map : maps) {
Long messageId = (Long) map.get("id");
long connectorReceivedDateMillis =
((Calendar) map.get("mm_received_date")).getTimeInMillis();
Map<Integer, ConnectorMessage> connectorMessages = null;
connectorMessages = dao.getConnectorMessages(channelId, messageId);
Message message = new Message();
message.setMessageId(messageId);
message.setChannelId(channelId);
message.setReceivedDate((Calendar) map.get("received_date"));
message.setProcessed((Boolean) map.get("processed"));
message.setServerId((String) map.get("server_id"));
message.setImportId((Long) map.get("import_id"));
message.getConnectorMessages().putAll(connectorMessages);
messages.add(message);
contentMessageIds.add(messageId);
if (messageDateThreshold != null
&& connectorReceivedDateMillis < messageDateThreshold.getTimeInMillis()) {
messageIds.add(messageId);
}
}
return messages;
} finally {
dao.close();
}
}
public static List<SolutionBin> getSolutions(String level_key) {
SqlSession session = sqlSessionFactory.openSession();
List<SolutionBin> solutionList = null;
System.out.println(level_key);
try {
solutionList = session.selectList("selectSolution", level_key);
} catch (NullPointerException e) {
System.out.println("error null list");
} finally {
session.commit();
session.close();
}
return solutionList;
}
