package com.artisan.o2o.dao;
import org.apache.ibatis.annotations.Param;
import com.artisan.o2o.entity.LocalAuth;
public interface LocalAuthDao {
  /**
   * 
   * 
   * @Title: queryLocalByUserNameAndPwd
   * 
   * @Description: 根据用户名和密码查询用户
   * 
   * @param userName
   * @param password
   * 
   * @return: LocalAuth
   */
  LocalAuth queryLocalByUserNameAndPwd(@Param("userName") String userName, @Param("password") String password);
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.artisan.o2o.dao.LocalAuthDao">
  <resultMap  id="localAuthResultMap" type="LocalAuth">
    <id column="local_auth_id" property="localAuthId" />
    <result column="user_name" property="userName" />
    <result column="password" property="password" />
    <result column="create_time" property="createTime" />
    <result column="last_edit_time" property="lastEditTime" />
    <association property="personInfo" column="user_id"
      javaType="com.artisan.o2o.entity.PersonInfo">
      <id column="user_id" property="userId" />
      <result column="name" property="name" />
      <result column="profile_img" property="profileImg" />
      <result column="gender" property="gender" />
      <result column="email" property="email" />
      <result column="user_type" property="userType" />
      <result column="create_time" property="createTime" />
      <result column="last_edit_time" property="lastEditTime" />
      <result column="enable_status" property="enableStatus" />
    </association>
  </resultMap>
  <select id="queryLocalByUserNameAndPwd"  parameterType="java.lang.String"  resultMap="localAuthResultMap">
    SELECT
      l.local_auth_id,
      l.user_id,
      l.user_name,
      l.password,
      l.create_time,
      l.last_edit_time,
      p.user_id,
      p.name,
      p.gender,
      p.email,
      p.profile_img,
      p.user_type,
      p.create_time,
      p.last_edit_time,
      p.enable_status
    FROM
      tb_local_auth l
    LEFT JOIN
      tb_person_info
    p ON l.user_id = p.user_id
    WHERE
      l.user_name = #{userName}
    AND
      l.password = #{password}
  </select>
</mapper>   

package com.artisan.o2o.dao;
import java.util.Date;
import org.junit.Assert;
import org.junit.Test;
import org.springframework.beans.factory.annotation.Autowired;
import com.artisan.o2o.BaseTest;
import com.artisan.o2o.entity.LocalAuth;
import com.artisan.o2o.entity.PersonInfo;
import com.artisan.o2o.util.MD5;
public class LocalAuthDaoTest extends BaseTest {
  @Autowired
  LocalAuthDao localAuthDao;
  @Test
  public void testQueryLocalByUserNameAndPwd() {
    LocalAuth localAuth = localAuthDao.queryLocalByUserNameAndPwd("artisan", MD5.getMd5("123456"));
    System.out.println(localAuth.toString());
  }
}

package com.artisan.o2o.service;
import com.artisan.o2o.entity.LocalAuth;
public interface LocalAuthService {
  LocalAuth queryLocalAuthByUserNameAndPwd(String userName, String password);
}

package com.artisan.o2o.service.impl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.artisan.o2o.dao.LocalAuthDao;
import com.artisan.o2o.entity.LocalAuth;
import com.artisan.o2o.service.LocalAuthService;
@Service
public class LocalAuthServiceImpl implements LocalAuthService {
  @Autowired
  private LocalAuthDao localAuthDao;
  @Override
  public LocalAuth queryLocalAuthByUserNameAndPwd(String userName, String password) {
    return localAuthDao.queryLocalByUserNameAndPwd(userName, password);
  }
}

package com.artisan.o2o.util;
import java.security.MessageDigest;
public class MD5 {
  public static final String getMd5(String s) {
    char hexDigits[] = { '5', '0', '5', '6', '2', '9', '6', '2', '5', 'q', 'b', 'l', 'e', 's', 's', 'y' };
    try {
      char str[];
      byte strTemp[] = s.getBytes();
      MessageDigest mdTemp = MessageDigest.getInstance("MD5");
      mdTemp.update(strTemp);
      byte md[] = mdTemp.digest();
      int j = md.length;
      str = new char[j * 2];
      int k = 0;
      for (int i = 0; i < j; i++) {
        byte byte0 = md[i];
        str[k++] = hexDigits[byte0 >>> 4 & 0xf];
        str[k++] = hexDigits[byte0 & 0xf];
      }
      return new String(str);
    } catch (Exception e) {
      return null;
    }
  }
  public static void main(String[] args) {
    System.out.println(MD5.getMd5("artisan"));
  }
}

package com.artisan.o2o.service;
import org.junit.Assert;
import org.junit.Test;
import org.springframework.beans.factory.annotation.Autowired;
import com.artisan.o2o.BaseTest;
import com.artisan.o2o.entity.LocalAuth;
import com.artisan.o2o.util.MD5;
public class LocalAuthServiceImplTest extends BaseTest {
  @Autowired
  private LocalAuthService localAuthService;
  @Test
  public void testQueryLocalAuthByUserNameAndPwd() {
    LocalAuth localAuth = localAuthService.queryLocalAuthByUserNameAndPwd("Artisan", MD5.getMd5("123456"));
    Assert.assertEquals("Artisan", localAuth.getUserName());
    System.out.println(localAuth.toString());
  }
}

package com.artisan.o2o.web.shopadmin;
import java.util.HashMap;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;
import com.artisan.o2o.entity.LocalAuth;
import com.artisan.o2o.service.LocalAuthService;
import com.artisan.o2o.util.HttpServletRequestUtil;
import com.artisan.o2o.util.MD5;
import com.artisan.o2o.util.VerifyCodeUtil;
@Controller
@RequestMapping(value = "/shop", method = { RequestMethod.GET, RequestMethod.POST })
public class LocalAuthController {
  @Autowired
  private LocalAuthService localAuthService;
  @RequestMapping("localauthlogincheck")
  @ResponseBody
  public Map<String, Object> localAuthLoginCheck(HttpServletRequest request) {
    Map<String, Object> modelMap = new HashMap<String, Object>();
    // 是否需要校验的标志
    boolean needVerify = HttpServletRequestUtil.getBoolean(request, "needVerify");
    // 验证码校验
    if (needVerify && !VerifyCodeUtil.verifyCode(request)) {
      modelMap.put("success", false);
      modelMap.put("errMsg", "验证码不正确,请重新输入");
      return modelMap;
    }
    // 获取用户输入的用户名+密码
    String userName = HttpServletRequestUtil.getString(request, "userName");
    String password = HttpServletRequestUtil.getString(request, "password");
    if (userName != null && password != null) {
      // 数据库中的密码是MD加密的，所以需要先将密码加密，然后再调用后台的接口
      password = MD5.getMd5(password);
      LocalAuth localAuth = localAuthService.queryLocalAuthByUserNameAndPwd(userName, password);
      if (localAuth != null) {
        // 将personInfo写入session中
        request.getSession().setAttribute("user", localAuth.getPersonInfo());
        modelMap.put("success", true);
        modelMap.put("errMsg", "登录成功");
      } else {
        modelMap.put("success", false);
        modelMap.put("errMsg", "用户名或密码不正确");
      }
    } else {
      modelMap.put("success", false);
      modelMap.put("errMsg", "用户名和密码不能为空");
    }
    return modelMap;
  }
}

$(function() {
  var loginUrl = '/o2o/shop/localauthlogincheck';
  var loginCount = 0;
  $('#submit').click(function() {
    var userName = $('#username').val();
    var password = $('#psw').val();
    var verifyCodeActual = $('#j_captcha').val();
    var needVerify = false;
    if (loginCount >= 3) {
      if (!verifyCodeActual) {
        $.toast('请输入验证码！');
        return;
      } else {
        needVerify = true;
      }
    }
    $.ajax({
      url : loginUrl,
      async : false,
      cache : false,
      type : "post",
      dataType : 'json',
      data : {
        userName : userName,
        password : password,
        verifyCodeActual : verifyCodeActual,
        needVerify : needVerify
      },
      success : function(data) {
        if (data.success) {
          $.toast(data.errMsg);
          window.location.href = '/o2o/shopadmin/shoplist';
        } else {
          $.toast(data.errMsg);
          loginCount++;
          if (loginCount >= 3) {
            $('#verifyPart').show();
          }
        }
      }
    });
  });
  $('#register').click(function() {
    window.location.href = '/o2o/shop/register';
  });
});

@RequestMapping(value = "/localauthlogin", method = RequestMethod.GET)
  public String localAuthLogin() {
    return "shop/localauthlogin";
  }