小程序访问idea后台数据库执行查询，登录，注册功能

实现功能：小程序访问后台服务器实现通过ID查询数据并反馈，登录校验，注册添加数据功能

开发工具：微信开发工具，IDEA，Mysql

微信开发上的代码比较简单，先写Idea后台的，
上文件结构

从上至下，UserController

package com.example.testsql.controller;import com.example.testsql.service.UserService;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.boot.autoconfigure.EnableAutoConfiguration;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RestController;@RestController@EnableAutoConfigurationpublic class UserController {@AutowiredUserService userService;//@RequestMapping后接得是访问url的地址，在客户端也就是小程序端访问url=http://localhost:8080/login就是查询，访问url=http://localhost:8080/getlogin就是登录，访问url=http://localhost:8080/getUser就是注册，    @RequestMapping("/login")    public String GetUser(Integer id){    System.out.println("id:"+id);        return userService.Sel(id).toString();    }    @RequestMapping("/getlogin")    public int GetLogin(String userName,String passWord){        System.out.println("注册"+userName+passWord);        int count=userService.login(userName,passWord);        return  count;    }    @RequestMapping("/getUser")    public String GetUser(String userName,String passWord){        System.out.println("注册"+userName+passWord);       userService.getUserByLoginName(userName,passWord);        return "success";    }}

User

package com.example.testsql.entity;public class User {    private Integer id;    private String userName;    private String passWord;    private String realName;    public Integer getId() {        return id;    }    public void setId(Integer id) {        this.id = id;    }    public String getUserName() {        return userName;    }    public void setUserName(String userName) {        this.userName = userName;    }    public String getPassWord() {        return passWord;    }    public void setPassWord(String passWord) {        this.passWord = passWord;    }    public String getRealName() {        return realName;    }    public void setRealName(String realName) {        this.realName = realName;    }    @Override    public String toString() {        return "{"                + "/"id/":"                + id                + ",/"userName/":/""                + userName + "/""                + ",/"passWord/":/""                + passWord + "/""                + ",/"realName/":/""                + realName + "/""                + "}";    }}

UserMapper

package com.example.testsql.mapper;import com.example.testsql.entity.User;import org.apache.ibatis.annotations.Param;import org.springframework.stereotype.Repository;@Repositorypublic interface UserMapper {    User Sel(@Param("id") int id);    User getUserByLoginName(@Param("userName") String userName,@Param("passWord")  String password);    int login(@Param("userName") String userName,@Param("passWord")  String password);}

UserService

package com.example.testsql.service;import com.example.testsql.entity.User;import com.example.testsql.mapper.UserMapper;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;@Servicepublic class UserService {    @Autowired    UserMapper userMapper;    public User Sel(int id){        return userMapper.Sel(id);    }    public User getUserByLoginName(String userName,String passWord){        return userMapper.getUserByLoginName(userName,passWord);    }    public int login(String userName,String passWord){        return userMapper.login(userName,passWord);    }}

TestsqlAppliation

package com.example.testsql;import org.mybatis.spring.annotation.MapperScan;import org.springframework.boot.SpringApplication;import org.springframework.boot.autoconfigure.SpringBootApplication;import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;import org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaAutoConfiguration;@MapperScan("com.example.testsql.mapper")@SpringBootApplication(exclude={DataSourceAutoConfiguration.class, HibernateJpaAutoConfiguration.class})public class TestsqlApplication{    public static void main(String[] args) throws Exception {        System.out.println(("success"));        SpringApplication.run(TestsqlApplication.class, args);    }}

UserMapping

<?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.example.testsql.mapper.UserMapper">    <resultMap id="BaseResultMap" type="com.example.testsql.entity.User">        <result column="id" jdbcType="INTEGER" property="id" />        <result column="userName" jdbcType="VARCHAR" property="userName" />        <result column="passWord" jdbcType="VARCHAR" property="passWord" />        <result column="realName" jdbcType="VARCHAR" property="realName" />    </resultMap>    <select id="Sel" resultType="com.example.testsql.entity.User">        select * from user where id = #{id}    </select>    <select id="login" resultType="java.lang.Integer">        select  count(id) from user where userName = #{userName} and passWord=#{passWord}    </select>    <insert id="getUserByLoginName" parameterType="com.example.testsql.entity.User">        insert into user         (userName,passWord) values(#{userName},#{passWord})    </insert></mapper>