package com.hqyj.gwr.register; import com.fasterxml.jackson.databind.ObjectMapper; import com.hqyj.gwr.vo.Result; import com.until.JDBCUtil; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; @WebServlet("/registerServlet") public class registerServlet extends HttpServlet { @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); response.setContentType("text/html;charset=utf-8"); String id = request.getParameter("name"); Connection conn = null; PreparedStatement pre = null; ResultSet set = null; String uname=""; // try { conn = JDBCUtil.getCon(); String QUERY = "select id from information "; //2.创建SQL语句对象 pre = conn.prepareStatement(QUERY); //4.发送SQL set = pre.executeQuery(); //获取记录 System.out.println(set); while (set.next()) { uname=set.getString("id"); } if (uname.equals(id)){ Result result = new Result("200","用户名已经存在",null); //将我们的result转换成json格式给前端 ObjectMapper objectMapper = new ObjectMapper(); String resultJson = objectMapper.writeValueAsString(result); response.getWriter().write(resultJson); }else{ //登录失败 Result result = new Result("500","用户名可用",null); //将我们的result转换成json格式给前端 ObjectMapper objectMapper = new ObjectMapper(); String resultJson = objectMapper.writeValueAsString(result); response.getWriter().write(resultJson); } } catch (Exception e) { e.printStackTrace(); } finally { //关闭资源 JDBCUtil.closeAll(set, pre,conn); } } }
利用Ajax技术与前端进行交互判断用户名是否存在
最新推荐文章于 2023-08-27 22:42:05 发布