package njitt.software.crm.controller;
import java.util.List;
import javax.servlet.http.HttpSession;
import javax.websocket.Session;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import njitt.software.crm.bean.UserInfo;
import njitt.software.crm.service.UserInfoService;
@Controller
public class UserInfoController {
@Autowired
private UserInfoService service;
@RequestMapping("/findUserInfos")
public String findUserInfos(Model model,HttpSession session){
List<UserInfo> user = service.findUserInfo();
model.addAttribute("Session",user);
session.setAttribute("Session",user);
return "index";
}
}
package njitt.software.crm.mapper;
import java.util.List;
import njitt.software.crm.bean.UserInfo;
public interface UserInfoMapper {
public List<UserInfo> findUserInfo();
}
package njitt.software.crm.service.impl;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import njitt.software.crm.bean.UserInfo;
import njitt.software.crm.mapper.UserInfoMapper;
import njitt.software.crm.service.UserInfoService;
@Service
@Transactional
public class UserInfoServiceImpl implements UserInfoService {
@Autowired
private UserInfoMapper user;
@Override
public List<UserInfo> findUserInfo() {
return user.findUserInfo();
}
}
package njitt.software.crm.service;
import java.util.List;
import njitt.software.crm.bean.UserInfo;
public interface UserInfoService {
public List<UserInfo> findUserInfo();
}
package njitt.software.crm.test;
import java.util.List;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import njitt.software.crm.bean.UserInfo;
import njitt.software.crm.service.UserInfoService;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations="classpath:applicationContext.xml")
public class UserInfoTest {
@Autowired
private UserInfoService userInfoService;
@Test
public void findUserInfo() {
List<UserInfo> list = userInfoService.findUserInfo();
for(UserInfo userInfo : list) {
System.out.println(userInfo);
}
}
}
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE html>
<html>
<head>
<base href="<%=basePath%>">
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<meta charset="utf-8">
<title>Insert title here</title>
</head>
<body>
<div>
<table>
<thead>
<tr>
<td>编号</td>
<td>名称</td>
<td>cpu</td>
<td>内存</td>
</tr>
</thead>
<tbody>
<c:forEach items="${Session}" var="Session">
<tr>
<td>${Session.id}</td>
<td>${Session.name}</td>
<td>${Session.cpu}</td>
<td>${Session.memory}</td>
</tr>
</c:forEach>
</tbody>
</table>
</div>
</body>
</html>