Ajax+Springboot+jooq实现登录功能

Ajax+Springboot+jooq实现登录功能

简介

本人是某师范大学刚读大二的计算机专业小白，下面看效果

Springboot

Spring Boot是由Pivotal团队提供的全新框架，其设计目的是用来简化新Spring应用的初始搭建以及开发过程。该框架使用了特定的方式来进行配置，从而使开发人员不再需要定义样板化的配置。通过这种方式，Spring Boot致力于在蓬勃发展的快速应用开发领域(rapid application development)成为领导者。

jooq

jOOQ（Java Object Oriented Querying，即面向Java对象查询）是一个高效地合并了复杂SQL、类型安全、源码生成、ActiveRecord、存储过程以及高级数据类型的Java API的类库。

ajax代码

function login() {
        //获取输入框中的内容
        var S_number =	$("#S_number").val();
        var password =	$("#password").val();
        //使用$.ajax发送异步请求
        $.ajax({
            url:"http://localhost:8080/SpringBoot/Login",//请求路径
            type:"POST",
            data:{
                "S_number": S_number,
                "password": password
            },
            //通过学号登录，登录成功显示姓名
            success:function (data) {
                var user = JSON.parse(data);
                if (user.message == "登录成功") {
                    //跳转到管理系统
                    alert("欢迎: " + user.username);
                    document.getElementById("demo").innerHTML = user.message;
                }else {
                    alert(user.message);
                    document.getElementById("demo").innerHTML = user.message;
                }
            },//响应成功后的回调函数
            error:function (data) {
                alert("响应结果出错"+data)
            },//如果请求响应出现错误，会执行的回调函数
        })

}

java代码

package com.springboot.demo;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class DemoApplication {
    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }

}

package com.springboot.demo.controller;

import com.alibaba.fastjson.JSON;
import com.springboot.demo.Data.LoginData;
import com.springboot.demo.User.Person;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.ArrayList;
import java.util.List;


@Controller
@RequestMapping("/SpringBoot")
public class LoginController {
    private final String ur = "http://localhost:8080/SpringBoot/index";
    private final String url = "http://localhost:8080/SpringBoot/Login";
    @ResponseBody
    @RequestMapping("/Login")
    public String hello(HttpServletRequest request, HttpServletResponse response){
        response.setHeader("Access-Control-Allow-Origin", "*");
        String S_number=request.getParameter("S_number");
        String password=request.getParameter("password");
        //jooq返回list，springboot来操作这个list
        List<Person> people = new ArrayList<Person>();
        people = new LoginData().selectAll();
        Person person = new Person();
        for (int i = 0;i<people.size();i++){
            if (S_number.equals(people.get(i).getNumber())){
                if (password.equals(people.get(i).getPassword())){
                    person.setUsername(people.get(i).getUsername());
                    person.setMessage("登录成功");
                }else {
                    person.setMessage("登录失败，密码错误");
                }
            }else {
                person.setMessage("登录失败，学号不存在");
            }
        }

        String pJson = JSON.toJSONString(person);
        System.out.println(pJson);
        return pJson;
    }

}

jooq代码

package com.springboot.demo.Data;

import com.springboot.demo.User.Person;
import org.jooq.*;
import org.jooq.impl.DSL;

import java.sql.Connection;
import java.sql.DriverManager;
import java.util.ArrayList;
import java.util.List;

public class LoginData {
    private static String driver="com.mysql.cj.jdbc.Driver";
    private static String url="jdbc:mysql://127.0.0.1:3306/testjdbc?serverTimezone=UTC";
    private static String username="root";
    private static String password="psd_123456";

    private static Connection ct=null;
    private static DSLContext dslContext=null;
    private static Result<Record> result=null;
    private static Table<Record> table=null;

    static {
        try {
            Class.forName(driver);
            ct= DriverManager.getConnection(url, username, password);
            dslContext= DSL.using(ct);
            table=DSL.table("Person");
            System.out.println("jooq数据库连接成功");
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

 
    public static List<Person> selectAll(){

        ArrayList<Person> list = null;
//		result=dslContext.selectFrom(table).fetch();
        result=dslContext.select().from(table).fetch();
        if(result!=null) {
            list=new ArrayList<Person>();
            for(Record record : result) {

                Person temp = new Person();
                temp.setUsername((String) record.getValue("username"));
                temp.setPassword((String) record.getValue("password"));
                temp.setNumber((String) record.getValue("number"));
                list.add(temp);
            }
        }
        return list;
    }

    public static Person selectByname(String number){

        Person person=null;
        result=dslContext.selectFrom(table).where("number = "+number).fetch();

        if(result!=null) {

            Record record=result.get(0);
            person=new Person();
            person.setUsername((String) record.getValue("username"));
            person.setPassword((String) record.getValue("password"));
            person.setNumber((String) record.getValue("number"));
        }
        return person;
    }

}

表