package cn.transaction.controller;

import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import net.sf.json.JSONObject;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.servlet.ModelAndView;

import cn.transaction.domain.User;
import cn.transaction.service.IService;

@Controller
@RequestMapping("/crud.do")
public class CrudDemoController {
@Resource(name="service")
private IService service;
private String errorPage;

public IService getService() {
	return service;
}
public void setService(IService service) {
	this.service = service;
}
public String getErrorPage() {
	return errorPage;
}
public void setErrorPage(String errorPage) {
	this.errorPage = errorPage;
}

@RequestMapping(method = RequestMethod.GET)
public ModelAndView list(HttpServletRequest request,
		HttpServletResponse response){
	ModelAndView view = null;
	List list = new ArrayList();

	try{
		list = service.listUser();
		view = new ModelAndView("/register");
		request.setAttribute("list", list);
	}catch (Exception e) {
		// TODO: handle exception
		e.printStackTrace();
		request.setAttribute("error", "系统错误!");
		request.setAttribute("exception", e);
	}
	return view;
}

@RequestMapping(params = "method=listUserById")
public ModelAndView listUserById(HttpServletRequest request,
		HttpServletResponse response){
	ModelAndView view = null;
	List list = new ArrayList();

	String idStr = request.getParameter("id");
	int userId = Integer.parseInt(idStr);

	try{
		list = service.listUserById(userId);
		view = new ModelAndView("/register");
		request.setAttribute("list", list);
	}catch (Exception e) {
		// TODO: handle exception
		e.printStackTrace();
		request.setAttribute("error", "系统错误!");
		request.setAttribute("exception", e);
	}

	return view;

}

@RequestMapping(params = "method=delete")
public ModelAndView delete(HttpServletRequest request,
		HttpServletResponse response){
	ModelAndView view = null;
	List list = new ArrayList();

	String idStr = request.getParameter("id");
	int userId = Integer.parseInt(idStr);

	try{
		service.deleteUser(userId);
		list = service.listUser();
		view = new ModelAndView("/register");
		request.setAttribute("list", list);
	}catch (Exception e) {
		// TODO: handle exception
		e.printStackTrace();
		request.setAttribute("error", "系统错误!");
		request.setAttribute("exception", e);
	}

	return view;
}

@RequestMapping(params = "method=insert")
public ModelAndView insert(HttpServletRequest request,
		HttpServletResponse response)throws IOException{
	ModelAndView view = null;
	List list = new ArrayList();

	String json = request.getParameter("user");
	/*
	BufferedReader br = new BufferedReader(new InputStreamReader(
            (ServletInputStream) request.getInputStream()));
	String line = null;
	StringBuilder sb = new StringBuilder();
	while ((line = br.readLine()) != null) {
	    sb.append(line);
	}
	*/
	JSONObject jsonObj = JSONObject.fromObject(json.toString());
    User user = (User)JSONObject.toBean(jsonObj, User.class);
    System.out.println("name==>"+user.getUsername());

	try{
		service.insertUser(user);
		list = service.listUser();
		view = new ModelAndView("/register");
		request.setAttribute("list", list);

	}catch (Exception e) {
		// TODO: handle exception
		e.printStackTrace();
		request.setAttribute("error", "系统错误!");
		request.setAttribute("exception", e);
	}

	return view;
}

@RequestMapping(params = "method=edit")
public ModelAndView edit(HttpServletRequest request,
		HttpServletResponse response){
	ModelAndView view = null;
	List list = new ArrayList();

	String json = request.getParameter("user");
	JSONObject jsonObj = JSONObject.fromObject(json.toString());
    User user = (User)JSONObject.toBean(jsonObj, User.class);
    System.out.println("idss==>"+user.getUserid());

	try{
		service.updateUser(user);
		list = service.listUser();
		view = new ModelAndView("/register");
		request.setAttribute("list", list);
	}catch (Exception e) {
		// TODO: handle exception
		e.printStackTrace();
		request.setAttribute("error", "系统错误!");
		request.setAttribute("exception", e);
	}

	return view;
}

//点击编辑或新增按钮转向的页面
@RequestMapping(params = "method=insertOrUpdate")
public ModelAndView insertOrUpdate(HttpServletRequest request,
		HttpServletResponse response){
	ModelAndView view = null;
	List list = new ArrayList();
	String idStr = request.getParameter("id");
	int userId = -1;
	User user = null;

	if (null != idStr && !"".equals(idStr) ){
		userId = Integer.parseInt(idStr);
	}else{
		return null;
	}

	try{
		if (userId != -1)
			user = service.listUserById(userId).get(0);
		view = new ModelAndView("/userinfo");
		if (null != user)
			request.setAttribute("user", user);
	}catch (Exception e) {
		// TODO: handle exception
		e.printStackTrace();
		request.setAttribute("error", "系统错误!");
		request.setAttribute("exception", e);
	}

	return view;
}

}

……

onManager'; nested exception is org.springframework.beans.factory.BeanCreationEx
ception: Error creating bean with name 'txManager' defined in ServletContext res
ource [/WEB-INF/applicationContext.xml]: Invocation of init method failed; neste
d exception is org.hibernate.service.UnknownUnwrapTypeException: Cannot unwrap t
o requested type [javax.sql.DataSource]

net.sf.json.JSONException: A JSONObject text must begin with '{' at character 1 of object Object