Eclipse,用springboot搭建maven项目,验证小程序登录用户在MySQL数据库中是否存在数据

Eclipse中文件目录结构:

从上往下依次排序;
首先是UserController.java文件

UserMapper.java文件

User.java文件

UserService.java文件

MyMapper.java

Application.java

Swagger2.java

generatorConfig.xml

UserMapper.xml

application-dev.propertiesapplication.properties
pom.xml
< ?xml version=“1.0” encoding=“UTF-8”?>
< project xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”
xmlns=“http://maven.apache.org/POM/4.0.0”
xsi:schemaLocation=“http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd”>
< modelVersion>4.0.0< /modelVersion>
< packaging>war< /packaging>
< groupId>tk.mybatis< /groupId>
< artifactId>SpringBootWeChat< /artifactId>
< version>1.0.0-SNAPSHOT< /version>

<parent>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-starter-parent</artifactId>
	<version>1.5.6.RELEASE</version>
</parent>

<properties>
	<java.version>1.8</java.version>
	<mybatis.spring.version>1.2.4</mybatis.spring.version>
</properties>

<dependencies>

	<dependency>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-web</artifactId>
	</dependency>
	<dependency>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-jdbc</artifactId>
	</dependency>
	<dependency>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-aop</artifactId>
	</dependency>
	<dependency>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-freemarker</artifactId>
	</dependency>
	<dependency>
	    <groupId>org.springframework.boot</groupId>
	    <artifactId>spring-boot-starter-test</artifactId>
	    <scope>test</scope>
	</dependency>
	<dependency>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-devtools</artifactId>
		<optional>true</optional>
	</dependency>
	<dependency>
	    <groupId>org.springframework</groupId>
	    <artifactId>spring-test</artifactId>
	    <scope>test</scope>
	</dependency>
	<dependency>
		<groupId>mysql</groupId>
		<artifactId>mysql-connector-java</artifactId>
	</dependency>

	<dependency>
		<groupId>com.fasterxml.jackson.core</groupId>
		<artifactId>jackson-core</artifactId>
	</dependency>
	<dependency>
		<groupId>com.fasterxml.jackson.core</groupId>
		<artifactId>jackson-databind</artifactId>
	</dependency>
	<dependency>
		<groupId>com.fasterxml.jackson.datatype</groupId>
		<artifactId>jackson-datatype-joda</artifactId>
	</dependency>
	<dependency>
		<groupId>com.fasterxml.jackson.module</groupId>
		<artifactId>jackson-module-parameter-names</artifactId>
	</dependency>

	<dependency>
		<groupId>com.alibaba</groupId>
		<artifactId>druid</artifactId>
		<version>1.0.11</version>
	</dependency>

	<!--mapper -->
	<dependency>
		<groupId>tk.mybatis</groupId>
		<artifactId>mapper-spring-boot-starter</artifactId>
		<version>1.2.0</version>
	</dependency>
	<!--pagehelper -->
	<dependency>
		<groupId>com.github.pagehelper</groupId>
		<artifactId>pagehelper-spring-boot-starter</artifactId>
		<version>RELEASE</version>
	</dependency>

	<dependency>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-configuration-processor</artifactId>
		<optional>true</optional>
	</dependency>

	<dependency>
		<groupId>com.alibaba</groupId>
		<artifactId>druid-spring-boot-starter</artifactId>
		<version>1.1.0</version>
	</dependency>
	<dependency>
		<groupId>org.apache.commons</groupId>
		<artifactId>commons-lang3</artifactId>
		<version>3.1</version>
	</dependency>
	<dependency>
		<groupId>com.nimbusds</groupId>
		<artifactId>nimbus-jose-jwt</artifactId>
		<version>5.1</version>
	</dependency>
	<dependency>
		<groupId>io.springfox</groupId>
		<artifactId>springfox-swagger2</artifactId>
		<version>2.6.1</version>
	</dependency>
	<dependency>
		<groupId>io.springfox</groupId>
		<artifactId>springfox-swagger-ui</artifactId>
		<version>2.6.1</version>
	</dependency>
	<dependency> 
		<groupId>org.apache.shiro</groupId>
		<artifactId>shiro-core</artifactId>
		<version>1.2.4</version>
	</dependency>
	<dependency>
		<groupId>com.google.zxing</groupId>
		<artifactId>core</artifactId>
		<version>3.3.0</version>
	</dependency>
	<dependency>
		<groupId>com.belerweb</groupId>
		<artifactId>pinyin4j</artifactId>
		<version>2.5.0</version>
	</dependency>
	<dependency>
	    <groupId>org.apache.poi</groupId>
	    <artifactId>poi</artifactId> 
	    <version>3.16</version>
	</dependency>	
	<dependency>
		<groupId>org.apache.poi</groupId>
		<artifactId>poi-ooxml</artifactId>
		<version>3.16</version>
	</dependency>	
	<dependency>
	    <groupId>commons-io</groupId>
	    <artifactId>commons-io</artifactId>
	    <version>2.6</version>
	</dependency>
	<dependency>
	    <groupId>net.sf.jxls</groupId>
	    <artifactId>jxls-core</artifactId>
	    <version>1.0.3</version>
	</dependency>
	<dependency>
	    <groupId>org.apache.commons</groupId>
	    <artifactId>commons-jexl</artifactId>
	    <version>2.1.1</version>
	</dependency>
	<dependency>
	    <groupId>junit</groupId>
	    <artifactId>junit</artifactId>
	    <scope>test</scope>
	</dependency>
	
	<dependency>
		<groupId>net.sf.json-lib</groupId>
	 	<artifactId>json-lib</artifactId>
	  	<version>2.4</version>
	  	<classifier>jdk15</classifier>
	</dependency>
	
	<dependency>
		<groupId>org.jdom</groupId>
		<artifactId>jdom</artifactId>
		<version>1.1.3</version>
	</dependency>
	<dependency>  
	    <groupId>org.bouncycastle</groupId>  
	    <artifactId>bcprov-jdk16</artifactId>  
	    <version>1.46</version>  
	</dependency>  
	  
	<dependency>  
	    <groupId>commons-codec</groupId>  
	    <artifactId>commons-codec</artifactId>  
	    <version>1.10</version>  
	</dependency>  
	
	<dependency>  
	    <groupId>com.alibaba</groupId>  
	    <artifactId>fastjson</artifactId>  
	    <version>1.2.29</version>  
	</dependency>  
    <dependency>
        <groupId>org.apache.httpcomponents</groupId>
        <artifactId>httpclient</artifactId>
        <version>4.5.4</version>
    </dependency>

</dependencies>  		 

<build>
	<plugins>
		<plugin>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-maven-plugin</artifactId>
			<dependencies>
				<dependency>
					<groupId>org.springframework</groupId>
					<artifactId>springloaded</artifactId>
					<version>1.2.5.RELEASE</version>
				</dependency>
			</dependencies>
		</plugin>
		<plugin>
			<groupId>org.mybatis.generator</groupId>
			<artifactId>mybatis-generator-maven-plugin</artifactId>
			<version>1.3.2</version>
			<configuration>
				<configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>
				<overwrite>true</overwrite>
				<verbose>true</verbose>
			</configuration>
			<dependencies>
				<dependency>
					<groupId>mysql</groupId>
					<artifactId>mysql-connector-java</artifactId>
					<version>${mysql.version}</version>
				</dependency>
				<dependency>
					<groupId>tk.mybatis</groupId>
					<artifactId>mapper</artifactId>
					<version>3.4.0</version>
				</dependency>
			</dependencies>
		</plugin>
		<plugin>
	    <groupId>org.apache.maven.plugins</groupId>
	    <artifactId>maven-resources-plugin</artifactId>
	    <configuration>
	    <encoding>UTF-8</encoding>
	    <nonFilteredFileExtensions>
	       <nonFilteredFileExtension>xlsx</nonFilteredFileExtension>
	       <nonFilteredFileExtension>xls</nonFilteredFileExtension>
	    </nonFilteredFileExtensions>
	    </configuration>
	</plugin>
	 
	</plugins>
</build>

后台配置好后,接下来的就是小程序的了;

.wxml文件
login.js文件(里面因为要显示完全,所以标签里面被我加了空格,切记要把空格去掉)

// pages/login_test/login.js
Page({

/**

• 页面的初始数据
  */
  data: {
  username: ‘’,
  password: ‘’
  },

input_name:function(e){
this.setData({
username: e.detail.value
})
},
input_pwd: function (e) {
this.setData({
password: e.detail.value
})
},
submitButton: function () {
console.log(“点击按钮!” + “获取到的用户名:” + this.data.username + “获取到的密码:” + this.data.password)
var that = this;

wx.request({
  url: 'http://localhost:8080/user/login',
  method: 'POST',
  header: { 'content-type': 'application/x-www-form-urlencoded' },
  data:{
    'username': that.data.username,
    'password': that.data.password,
  },
  success: function (res) {
    console.log("回调函数:" + res.data)
    var resData = res.data;
    if(resData == true){
        wx.showToast({
          title: '登录成功',
          duration:2000
        })
    }else {
      wx.showToast({
        title: '登录失败',
        duration:2000
      })
    }
  }
})

},
/**

• 生命周期函数–监听页面加载
  */
  onLoad: function (options) {

},

/**

• 生命周期函数–监听页面初次渲染完成
  */
  onReady: function () {

},

/**

• 生命周期函数–监听页面显示
  */
  onShow: function () {

},

/**

• 生命周期函数–监听页面隐藏
  */
  onHide: function () {

},

/**

• 生命周期函数–监听页面卸载
  */
  onUnload: function () {

},

/**

• 页面相关事件处理函数–监听用户下拉动作
  */
  onPullDownRefresh: function () {

},

/**

• 页面上拉触底事件的处理函数
  */
  onReachBottom: function () {

},

/**

• 用户点击右上角分享
  */
  onShareAppMessage: function () {

}
})

下面这个是M有SQL数据库创建user表
随意添加一条数据:
输入错误的测试数据:
后台也会打印:

输入正确的数据:
后台打印结果:

到此大功告成了!!!