小程式訪問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
@EnableAutoConfiguration
public class UserController {

@Autowired
UserService 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;

@Repository
public 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;

@Service
public 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>