SSH案例(三)

该案例在原来基础上测试数据查询，采用Map封装和实体封装两种方式

项目结构如下：

web.xml文件和导包与之前一致

UserDao：

package cn.tedu.note.dao;

import java.util.List;
import java.util.Map;

import cn.tedu.note.entity.User;

public interface UserDao {
	public void addUser(User user);
	public void deleteUser(User user);
	public void updateUser(User user);
	public User findUserById(String id);
	public User findUserByName(String name);
	
	//返回List<User>
	public List<User> findUsersLike(String name);
	
	//查询后返回list-map不返回List<User>
	public List<Map<String, Object>> findUsersLikeName(String name);
}

实现类UserDaoImpl:

package cn.tedu.note.dao;

import java.util.List;
import java.util.Map;

import javax.annotation.Resource;
import javax.transaction.Transactional;

import org.springframework.orm.hibernate4.HibernateTemplate;
import org.springframework.stereotype.Repository;

import cn.tedu.note.entity.User;

@Repository("userDao")
@Transactional
public class UserDaoImpl implements UserDao{

	@Resource(name="hibernateTemplate")
	private HibernateTemplate hibernateTemplate;
	
	@Override
	public void addUser(User user) {
		hibernateTemplate.save(user);
	}

	@Override
	public void deleteUser(User user) {
		hibernateTemplate.delete(user);
	}

	@Override
	public void updateUser(User user) {
		hibernateTemplate.update(user);
	}

	@Override
	public User findUserById(String id) {
		return hibernateTemplate.get(User.class, id);
	}

	@Override
	public User findUserByName(String name) {
		//select * from cn_user where cn_user_name = ?
		//HQL
		//		   from User where name = ?
		String hql = "from User where name = ?";
		List<User> list = (List<User>) hibernateTemplate.find(hql, name);
		if(list.isEmpty()){
			return null;
		}
		return list.get(0);
	}

	@Override
	public List<User> findUsersLike(String name) {
		String param = "%" + name + "%";
		String hql = "from User where name like ?";
		List<User> list = (List<User>) hibernateTemplate.find(hql, param);
		return list;
	}
	
	@Override
	public List<Map<String, Object>> findUsersLikeName(String name) {
		//HQL
		//new map(id, name) from User where name like ?
		//将查询结果封装为map对象
		String param = "%" + name + "%";
		String hql = "select new map(id as id, name as name) from User where name like ?";
		List<Map<String, Object>> list = (List<Map<String, Object>>) hibernateTemplate.find(hql, param);
		return list;
	}


}

UserService:

package cn.tedu.note.service;

import java.util.List;
import java.util.Map;

import cn.tedu.note.entity.User;

public interface UserService {
	public User login(String username, String password);
	
	//返回List<User>
	public List<User> listUsersLike(String name);
	
	//返回Map
	public List<Map<String, Object>> listUsers(String name);
}

实现类UserServiceImpl：

package cn.tedu.note.service;

import java.util.List;
import java.util.Map;

import javax.annotation.Resource;
import javax.transaction.Transactional;

import org.springframework.stereotype.Service;

import cn.tedu.note.dao.UserDao;
import cn.tedu.note.entity.User;

@Service("userService")
public class UserServiceImpl implements UserService {

	@Resource(name="userDao")
	private UserDao userDao;
	
	@Override
	@Transactional
	public User login(String username, String password) {
		User user = userDao.findUserByName(username);
		if(user == null){
			//没有找到该用户
			throw new RuntimeException("用户名错误");
		}
		if(user.getPassword().equals(password)){
			return user;
		}
		throw new RuntimeException("密码错误");
	}
	
	@Override
	@Transactional
	public List<User> listUsersLike(String name) {
		if(name == null || name.trim().isEmpty()){
			throw new RuntimeException("参数不能为空");
		}
		return userDao.findUsersLike(name);
	}
	
	@Override
	@Transactional
	public List<Map<String, Object>> listUsers(String name) {
		if(name == null || name.trim().isEmpty()){
			throw new RuntimeException("参数不能为空");
		}
		return userDao.findUsersLikeName(name);
	}

	

}

控制器UserAction：

package cn.tedu.note.web;

import java.util.List;
import java.util.Map;

import javax.annotation.Resource;

import org.springframework.context.annotation.Scope;
import org.springframework.stereotype.Controller;

import cn.tedu.note.entity.User;
import cn.tedu.note.service.UserService;

@Controller
@Scope("prototype")
public class UserAction extends JsonAction{
	
	@Resource(name="userService")
	private UserService userService;
	
	private String username;
	private String password;
	
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	
	//将方法中的异常通过拦截器处理
	public String login(){
		User user = userService.login(username, password);
		//登陆成功
		setResult(user);
		return JSON;
	}
	
	//查询返回集合
	public String listLike(){
		List<User> list = userService.listUsersLike(username);
		setResult(list);
		return JSON;
	}
	
	//查询返回Map
	public String list(){
		 List<Map<String, Object>> list = userService.listUsers(username);
		 setResult(list);
		 return JSON;
	}
	
	
}

控制器继承了JsonAction，采用拦截器来处理异常

JsonAction：

package cn.tedu.note.web;

import java.util.HashMap;
import java.util.Map;

import org.apache.struts2.interceptor.ApplicationAware;
import org.apache.struts2.interceptor.RequestAware;
import org.apache.struts2.interceptor.SessionAware;

import com.opensymphony.xwork2.ActionSupport;

public abstract class JsonAction extends ActionSupport implements SessionAware,RequestAware,ApplicationAware{
	
	public static final String JSON = "json";
	
	protected Map<String, Object> request;
	protected Map<String, Object> session;
	protected Map<String, Object> application;
	public Map<String, Object> getRequest() {
		return request;
	}
	public void setRequest(Map<String, Object> request) {
		this.request = request;
	}
	public Map<String, Object> getSession() {
		return session;
	}
	public void setSession(Map<String, Object> session) {
		this.session = session;
	}
	public Map<String, Object> getApplication() {
		return application;
	}
	public void setApplication(Map<String, Object> application) {
		this.application = application;
	}
	
	/**
	 * 发送到客户端的Json结果
	 */
	public Map<String, Object> result = new HashMap<String, Object>();

	public Map<String, Object> getResult() {
		return result;
	}
	public void setResult(Map<String, Object> result) {
		this.result = result;
	}
	/**
	 * 设置正确返回值
	 * @param value
	 */
	protected void setResult(Object value){
		result.put("state", 0);
		result.put("message", "");
		result.put("data", value);
	}
	/**
	 * 设置错误返回值
	 * @param error
	 */
	protected void setResult(String error){
		result.put("state", 1);
		result.put("message", error);
		result.put("data", null);
	}
	/**
	 * 设置错误返回值
	 * @param e
	 */
	protected void setResult(Throwable e){
		this.setResult(e.getMessage());
	}
}

拦截器：

package cn.tedu.note.web;

import org.springframework.stereotype.Component;

import com.opensymphony.xwork2.ActionInvocation;
import com.opensymphony.xwork2.interceptor.Interceptor;

@Component
public class ExceptionInterceptor implements Interceptor{

	@Override
	public void destroy() {}

	@Override
	public void init() {}

	@Override
	public String intercept(ActionInvocation invocation) throws Exception {
		//拦截Action中的异常,只拦截这一类型的异常
		try{
			String str = invocation.invoke();//调用控制器
			return str;//返回正常结果
		}catch(Exception e){
			e.printStackTrace();
			Object obj = invocation.getAction();//返回被调用的控制器对象
			if(obj instanceof JsonAction){
				JsonAction action = (JsonAction) obj;
				action.setResult(e);
				return JsonAction.JSON;
			}
			throw e;
		}
	}

}

struts.xml文件：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC
    "-//Apache Software Foundation//DTD Struts Configuration 2.5//EN"
    "http://struts.apache.org/dtds/struts-2.5.dtd">
<struts>
	
	<package name="user" namespace="/user" extends="json-default">
	
		<!-- 定义拦截器 统一解决异常 处理问题 -->
		<interceptors>
			<!-- 自己的拦截器 -->
			<interceptor name="exInterceptor" class="exceptionInterceptor"/>
			<interceptor-stack name="jsonStack">
				<interceptor-ref name="defaultStack"/>
				<interceptor-ref name="exInterceptor"/>
			</interceptor-stack>
		</interceptors>
		
		<!-- 所有的Action都会被该拦截器拦截 不用再每个Action中添加 -->
		<default-interceptor-ref name="jsonStack"/>
		
		<!-- 定义一个全局Result 被全体Action共享 -->
		<global-results>
			<result type="json" name="json">
				<param name="root">result</param>
			</result>
		</global-results>
		
		<action name="login" class="userAction" method="login"/>
		
		<!-- 返回List<User> 封装了实体类的全部属性 -->
		<action name="listLike" class="userAction" method="listLike"/>
		
		<!-- 返回map 封装了部分属性 -->
		<action name="list" class="userAction" method="list"/>
	</package>
		
</struts>

一、浏览器模拟查询列表(返回map)

（1）成功

URL：http://localhost:8000/ssh/user/list?username=n

页面显示结果：

{"data":[{"name":"John","id":"10"},{"name":"Robin","id":"200"},{"name":"John","id":"33"},{"name":"Robin","id":"400"},{"name":"Robin","id":"500"},{"name":"Robin","id":"600"},{"name":"John","id":"9"}],"state":0,"message":""}

（2）失败

URL:http://localhost:8000/ssh/user/list?username=

页面显示结果：

{"data":null,"state":1,"message":"参数不能为空"}

二、浏览器模拟查询列表(返回实体类)

（1）成功

URL：http://localhost:8000/ssh/user/listLike?username=n

页面显示结果：

{"data":[{"id":"10","name":"John","nick":"J","password":"123","token":"OK"},{"id":"200","name":"Robin","nick":"","password":"123","token":""},{"id":"33","name":"John","nick":"J","password":"123","token":"OK"},{"id":"400","name":"Robin","nick":"","password":"123","token":""},{"id":"500","name":"Robin","nick":"","password":"123","token":""},{"id":"600","name":"Robin","nick":"","password":"123","token":""},{"id":"9","name":"John","nick":"J","password":"123","token":"OK"}],"state":0,"message":""}

（2）失败

URL:http://localhost:8000/ssh/user/listLike?username=

页面显示结果：

{"data":null,"state":1,"message":"参数不能为空"}