小程序访问idea后台数据库，执行查询、登录和注册功能(小程序调用数据库)。

功能小程序接入后台服务器，数据功能开发工具微信开发工具通过查询数据及反馈、登录验证、注册添加。微信开发上的代码比较简单，先写后台，自上而下的文件结构，后面是访问地址，在客户端也就是小程序端访问。

实现功能:小程序访问后台服务器实现ID查询数据及反馈、登录验证、注册、添加数据等功能。

开发工具:微信开发工具，IDEA，Mysql。

微信开发上的代码比较简单，先写Idea后台，文件结构是自上而下，UserController。

包com . example . testsql . controller；导入com . example . testsql . service . userservice；导入org . spring framework . beans . factory . annotation . auto wired；导入org . spring framework . boot . auto configure . enable auto configuration；导入org . spring framework . web . bind . annotation . request mapping；导入org . spring framework . web . bind . annotation . rest controller；@ rest controller @ enableautoconfiguration public class user controller { @ AutowiredUserService userService；//@RequestMapping后跟访问url的地址。在客户端，也就是小程序端，访问URL = http://localhost:8080/log in就是查询，访问URL = http://localhost:8080/getlog in就是登录。访问URL = http://localhost:8080/getuser是注册，@ RequestMapping ("/login ")公共字符串getuser (integer ID) {system。out . println(" ID:"+ID)；返回用户服务。Sel(同上)。toString()；} @ request mapping("/getlog in ")public int getlog in(字符串用户名，字符串密码){ system . out . println(" registration "+用户名+密码)；int count=userService.login(用户名，密码)；返回计数；} @ requestmapping ("/getuser ")公共字符串getuser(字符串用户名，字符串密码){ system . out . println(" registration "+用户名+密码)；userService.getUserByLoginName(用户名，密码)；返回“成功”；}}用户

包com . example . testsql . entity；公共类用户{私有整数id；私有字符串用户名；私有字符串密码；私有字符串realNamepublic Integer getId(){ return id；} public void setId(Integer id){ this . id = id；} public String get userName(){ return userName；} public void set userName(String userName){ this . userName = userName；}公共字符串get passWord(){ return passWord；} public void set passWord(String passWord){ this . passWord = passWord；}公共字符串get realName(){ return realName；} public void set realName(String realName){ this . realName = realName；} @覆盖公共字符串toString(){ return " { "+"/" id/":"+id+"，/" userName/":/"+userName+"/"+"，/" passWord/":/"+passWord+"/"+"，/" real name/":/"+real name+"/"+" } "；}}用户映射程序

包com . example . testsql . mapper；导入com . example . testsql . entity . user；导入org . Apache . ibatis . annotations . param；导入org . spring framework . stereotype . repository；@ repository public interface User mapper {用户Sel(@ Param(" id ")int id)；用户getUserByLoginName(@ Param(" userName ")字符串用户名，@Param("passWord ")字符串密码)；int login(@Param("userName ")字符串用户名，@Param("passWord ")字符串密码)；}用户服务

包com . example . testsql . service；导入com . example . testsql . entity . user；导入com . example . testsql . mapper . user mapper；导入org . spring framework . beans . factory . annotation . auto wired；导入org . spring framework . stereotype . service；@ service public class UserService { @ auto wired user mapper user mapper；公共用户Sel(int id){返回用户映射程序。Sel(身份证)；}公共用户getUserByLoginName(字符串用户名，字符串密码){ return User mapper . getUserByLoginName(用户名，密码)；} public int login(字符串用户名，字符串密码){ return userMapper.login(用户名，密码)；} } TestsqlAppliation

包com . example . testsql；导入org . mybatis . spring . annotation . mapper scan；导入org . spring framework . boot . spring application；导入org . spring framework . boot . auto configure . spring boot application；导入org . spring framework . boot . auto configure . JDBC . data source auto configuration；导入org . spring framework . boot . auto configure . ORM . JPA . hibernate JPA auto configuration；@ MapperScan(" com . example . testsql . mapper ")@ spring boot application(exclude = { data source auto configuration . class，hibernatejpaautoconfiguration . class })公共类testsql application { public static void main(String[]args)抛出异常{ system . out . println((" success "))；spring application . run(testsql application . class，args)；}}用户映射

select * from user where id = # { id } select count(id)from user where userName = #{userName} and passWord = #{passWord}插入用户(用户名，密码)值(# { userName }，# { passWord })