springboot 1.4.0+jpa
判断用户表单输入的用户名是否存在,异步的查询数据库,如果用户名存在则提示"该用户已经存在",否则提示可以注册
前台页面 register.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8"/>
<script src="/webjars/jquery/3.1.1/jquery.min.js"></script>
<script src="/webjars/bootstrap/3.3.7-1/js/bootstrap.min.js"></script>
<title>WebJars Demo</title>
<link rel="stylesheet" href="/webjars/bootstrap/3.3.7-1/css/bootstrap.min.css" />
<script>
$(function () {
$("#username").blur(function () {
var username=$(this).val();
$.post("/api/findUser",{username:username},function (data) {
var span= $("#s_username")
if(data.userExsit){
span.css("color","red");
span.html(data.msg);
}else{
span.css("color","pink");
span.html(data.msg)
}
},"json")
})
})
</script>
</head>
<body>
<form action="">
<input type="text" id="username" placeholder="请输入用户名"/>
<span id="s_username"></span>
<br/>
<input type="password" name="password" placeholder="请输入密码"/>
<input type="submit" value="注册"/>
</form>
</body>
</html>
后台代码
package com.example.demo.test.controller;
import com.example.demo.test.Repositry.peopleRepositry;
import com.example.demo.test.entity.People;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import javax.servlet.http.HttpServletRequest;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@RequestMapping("api")
@Controller
public class ajaxController {
@Autowired
private peopleRepositry peopleRepositry;
@ResponseBody
@PostMapping(value = "findUser")
public Map<String, Object> people(HttpServletRequest request) {
Map<String, Object> map = new HashMap<String, Object>();
String username = request.getParameter("username");
// People people =peopleRepositry.findOne(1);
List<People> list = peopleRepositry.findAll();
List<Object> list1 = new ArrayList<>();
for (People people : list) {
list1.add(people.getUsername());
}
if (list1.contains(username)) {
map.put("userExsit", true);
map.put("msg", "老铁这个用户名太受欢迎,请更换一个");
} else {
map.put("userExsit", false);
map.put("msg", "老铁这个用户名可用");
}
return map;
}
}
数据库
启动项目 测试
源码地址