AjaxSpringbootjooq实现登录功能AjaxSpringbootjooq实现登录功能简介Springbootjooqajax代码java代码jooq代码表AjaxSpringbootjooq实现登录功能简介本人是某师范大学刚读大二的计算机专业小白下面看效果SpringbootSpring Boot是由Pivotal团队提供的全新框架其设计目的是用来简化新Spring应用的初始搭建以及开发过程。该框架使用了特定的方式来进行配置从而使开发人员不再需要定义样板化的配置。通过这种方式Spring Boot致力于在蓬勃发展的快速应用开发领域(rapid application development)成为领导者。jooqjOOQJava Object Oriented Querying即面向Java对象查询是一个高效地合并了复杂SQL、类型安全、源码生成、ActiveRecord、存储过程以及高级数据类型的Java API的类库。ajax代码functionlogin(){//获取输入框中的内容varS_number$(#S_number).val();varpassword$(#password).val();//使用$.ajax发送异步请求$.ajax({url:http://localhost:8080/SpringBoot/Login,//请求路径type:POST,data:{S_number:S_number,password:password},//通过学号登录登录成功显示姓名success:function(data){varuserJSON.parse(data);if(user.message登录成功){//跳转到管理系统alert(欢迎: user.username);document.getElementById(demo).innerHTMLuser.message;}else{alert(user.message);document.getElementById(demo).innerHTMLuser.message;}},//响应成功后的回调函数error:function(data){alert(响应结果出错data)},//如果请求响应出现错误会执行的回调函数})}java代码packagecom.springboot.demo;importorg.springframework.boot.SpringApplication;importorg.springframework.boot.autoconfigure.SpringBootApplication;SpringBootApplicationpublicclassDemoApplication{publicstaticvoidmain(String[]args){SpringApplication.run(DemoApplication.class,args);}}packagecom.springboot.demo.controller;importcom.alibaba.fastjson.JSON;importcom.springboot.demo.Data.LoginData;importcom.springboot.demo.User.Person;importorg.springframework.stereotype.Controller;importorg.springframework.web.bind.annotation.RequestMapping;importorg.springframework.web.bind.annotation.ResponseBody;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importjava.util.ArrayList;importjava.util.List;ControllerRequestMapping(/SpringBoot)publicclassLoginController{privatefinalString urhttp://localhost:8080/SpringBoot/index;privatefinalString urlhttp://localhost:8080/SpringBoot/Login;ResponseBodyRequestMapping(/Login)publicStringhello(HttpServletRequest request,HttpServletResponse response){response.setHeader(Access-Control-Allow-Origin,*);String S_numberrequest.getParameter(S_number);String passwordrequest.getParameter(password);//jooq返回listspringboot来操作这个listListPersonpeoplenewArrayListPerson();peoplenewLoginData().selectAll();Person personnewPerson();for(inti0;ipeople.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 pJsonJSON.toJSONString(person);System.out.println(pJson);returnpJson;}}jooq代码packagecom.springboot.demo.Data;importcom.springboot.demo.User.Person;importorg.jooq.*;importorg.jooq.impl.DSL;importjava.sql.Connection;importjava.sql.DriverManager;importjava.util.ArrayList;importjava.util.List;publicclassLoginData{privatestaticString drivercom.mysql.cj.jdbc.Driver;privatestaticString urljdbc:mysql://127.0.0.1:3306/testjdbc?serverTimezoneUTC;privatestaticString usernameroot;privatestaticString passwordpsd_123456;privatestaticConnection ctnull;privatestaticDSLContext dslContextnull;privatestaticResultRecordresultnull;privatestaticTableRecordtablenull;static{try{Class.forName(driver);ctDriverManager.getConnection(url,username,password);dslContextDSL.using(ct);tableDSL.table(Person);System.out.println(jooq数据库连接成功);}catch(Exceptione){// TODO Auto-generated catch blocke.printStackTrace();}}publicstaticListPersonselectAll(){ArrayListPersonlistnull;// resultdslContext.selectFrom(table).fetch();resultdslContext.select().from(table).fetch();if(result!null){listnewArrayListPerson();for(Record record:result){Person tempnewPerson();temp.setUsername((String)record.getValue(username));temp.setPassword((String)record.getValue(password));temp.setNumber((String)record.getValue(number));list.add(temp);}}returnlist;}publicstaticPersonselectByname(String number){Person personnull;resultdslContext.selectFrom(table).where(number number).fetch();if(result!null){Record recordresult.get(0);personnewPerson();person.setUsername((String)record.getValue(username));person.setPassword((String)record.getValue(password));person.setNumber((String)record.getValue(number));}returnperson;}}表