wlyy2.0/edu-article/UserPlatform/.svn/pristine/6f/6fc306b8e2038985a239bcea5de8051572115783.svn-base

package com.yihu.platform.action;

import javax.servlet.http.HttpServletRequest;

import com.coreframework.db.DB;
import com.coreframework.db.Sql;
import com.yihu.platform.enums.MyDatabaseEnum;
import com.yihu.platform.utils.StringUtil;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import com.yihu.platform.utils.ApiUtil;

import net.sf.json.JSONObject;

/**
 * action 测试类 Created by wengsb on 2016/12/01.
 */
@Controller
@RequestMapping("common")
public class CommonAction {


    @RequestMapping("saveUserAgent")
    @ResponseBody
    public String saveUserAgent(HttpServletRequest request) {
        try {
            String userAgent = request.getParameter("userAgent");
            String userId = request.getParameter("userId");
            String userType = request.getParameter("userType");
            if (StringUtil.isEmpty(userAgent) || StringUtil.isEmpty(userId) || StringUtil.isEmpty(userId)) {
                return ApiUtil.getRespJSON(-10000, "必填参数为空").toString();
            }
            Sql sql = new Sql("select count(1) from user_mapping where status =1 and userId = ?");
            sql.addParamValue(userId);
            int count = DB.me().queryForInteger(MyDatabaseEnum.BasicServiceDB, sql);
            if (count == 0) {
                sql = new Sql("insert into user_mapping (userId,user_type,user_agent,status) values (?,?,?,1)");
                sql.addParamValue(userId);
                sql.addParamValue(userType);
                sql.addParamValue(userAgent);
                DB.me().insert(MyDatabaseEnum.BasicServiceDB, sql);
            } else {
                sql = new Sql("update user_mapping set user_agent = ?,last_time=NOW() where userId = ?");
                sql.addParamValue(userAgent);
                sql.addParamValue(userId);
                DB.me().update(MyDatabaseEnum.BasicServiceDB, sql);
            }
            JSONObject rv = ApiUtil.getRespJSON(10000, "成功");
            return rv.toString();
        } catch (Exception e) {
            e.printStackTrace();
            return ApiUtil.getRespJSON(-10000, e.getMessage()).toString();
        }
    }

}