一:获取参数的时候对参数进行处理
@ResponseBody
@RequestMapping(value = "/loginIface", produces = "text/html;charset=UTF-8")
public String loginface(HttpServletRequest request,
HttpServletResponse response, ModelMap modelMap)
{
String centerCode = request.getParameter("centerCode");
String loginName = request.getParameter("loginName");
String password = request.getParameter("password");
ResultJsonWarp result = new ResultJsonWarp();
if ( !CommonUtil.isNotEmptyString(centerCode))
{
result.setFlag(GlobalConstant.JSON_FAIL_FLAG_KEY);
result.setMsg("中心不能为空!");
return result.toJsonString();
}
else if ( !CommonUtil.isNotEmptyString(loginName))
{
result.setFlag(GlobalConstant.JSON_FAIL_FLAG_KEY);
result.setMsg("登录名不能为空!");
return result.toJsonString();
}
else if ( !CommonUtil.isNotEmptyString(password))
{
result.setFlag(GlobalConstant.JSON_FAIL_FLAG_KEY);
result.setMsg("密码不能为空!");
return result.toJsonString();
}
二: 在dao层对查询数据进行处理
public BPerson queryPersonByLoginName(String loginName)
{
StringBuffer sql = new StringBuffer("select ");
sql.append(" PersonCode, CenterCode, StationCode, Name, PhoneNum1, PhoneNum2, ");
sql.append(" PersonType, WorkCode, password, IsActive, LoginName from bperson ");
sql.append(" where LoginName= ? ");
System.out.println(sql.toString());
log.info(sql);
BPerson bPerson = null;
try
{
bPerson = (BPerson)getJdbcTemplate().queryForObject(sql.toString(),
new Object[] {loginName},
ParameterizedBeanPropertyRowMapper.newInstance(BPerson.class));
}
catch (Exception e)
{
log.error("queryPerson:Exception=\n" + e.getMessage());
}
return bPerson;
}