springboot之登录注册

springboot之登录注册

目录结构

pom.xml

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0"

         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

         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>

    <groupId>lubanDemo</groupId>

    <artifactId>demo</artifactId>

    <version>1.0-SNAPSHOT</version>

    <dependencies>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-context</artifactId>

            <version>5.1.5.RELEASE</version>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-web</artifactId>

            <version>5.1.5.RELEASE</version>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-web</artifactId>

            <version>2.1.3.RELEASE</version>

        </dependency>

        <!-- https://mvnrepository.com/artifact/org.mybatis.spring.boot/mybatis-spring-boot-starter -->

        <dependency>

            <groupId>org.mybatis.spring.boot</groupId>

            <artifactId>mybatis-spring-boot-starter</artifactId>

            <version>2.0.0</version>

        </dependency>

        <dependency>

            <groupId>mysql</groupId>

            <artifactId>mysql-connector-java</artifactId>

            <version>8.0.15</version>

        </dependency>

    </dependencies>

</project>

　　Aplication

package com;

import org.springframework.boot.SpringApplication;

import org.springframework.boot.autoconfigure.SpringBootApplication;

import org.springframework.context.annotation.Bean;

import org.springframework.jdbc.datasource.DriverManagerDataSource;

import javax.sql.DataSource;

@SpringBootApplication

public class Application {

    public static void main(String[] args) {

        SpringApplication.run(Application.class,args);

    }

    //数据库连接

    @Bean

    public DataSource dataSource() {

        DriverManagerDataSource driverManagerDataSource = new DriverManagerDataSource();

        driverManagerDataSource.setUsername("root");

        driverManagerDataSource.setPassword("root");

        driverManagerDataSource.setUrl("jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai");

        driverManagerDataSource.setDriverClassName("com.mysql.jdbc.Driver");

        return driverManagerDataSource;

    }

}

　　MyTomcat

//内嵌Tomcat

@Component

public class MyTomcat implements WebServerFactoryCustomizer<TomcatServletWebServerFactory> {

    public void customize(TomcatServletWebServerFactory factory) {

        factory.setPort(9001);

    }

}

　　UserController

@Controller

public class UserController {

    @Autowired

    UserService userService;

    @RequestMapping("/login")

    public String login(){

        return "login.html";

    }

    @RequestMapping("/loginsuc")

    @ResponseBody

    public String loginsuc(String name,String password){

        System.out.println(name);

        System.out.println(userService.query(name, password));

        System.out.println("login controller");

        Map<String,String> map = new HashMap<String, String>();

        map.put("success","success");

        return "success";

    }

    @RequestMapping("/regist")

    public String regist(){

        return "regist.html";

    }

    @RequestMapping("/registsuc")

    @ResponseBody

    public String registsuc(String name,String password){

        System.out.println(name);

        System.out.println(userService.add(name, password));

        System.out.println("login controller");

        Map<String,String> map = new HashMap<String, String>();

        map.put("success","success");

        return "success";

    }

　　UserMapper

@Mapper

public interface UserMapper {

    //写一下你的sql

    @Select("select * from user where user_name=#{uname} and pass_word=#{password}")

    public List<Map<String,Object>> query(@Param("uname") String uname, @Param("password") String password);

    @Select("insert into user(user_name,pass_word) values (#{uname},#{password})")

    public List<Map<String,Object>> add(@Param("uname") String uname, @Param("password") String password);

}

　　UserService

@Component

public class UserService {

    @Autowired

    UserMapper userMapper;

    public List<Map<String,Object>> query(String uname, String password){

        return  userMapper.query(uname,password);

    }

    public List<Map<String,Object>> add(String uname, String password){

        return  userMapper.add(uname,password);

    }

}

　　login

<!DOCTYPE html>

<html lang="en">

<head>

        <meta charset="UTF-8">

        <title>Title</title>

</head>

<script src="jquery.js"></script>

<script>

    function login() {

        $.ajax({

            url: '/loginsuc',

            type: 'get',

            dataType: 'text',

            data: {"name": $('#name').val(), "password": $('#password').val()},

            success: function (d) {

                            console.log(d)

               if (d === "success") {

                    window.location.href = 'show.html';

                } else {

                    window.location.href = 'error.html';

               }

            }

        })

    }

</script>

<body>

     <p> 请输入用户名和密码</p>

     <form>

             <table>

                 <tr>

                     <td>用户名</td>

                     <td><input type="text" id="name" ></td>

                 </tr>

                 <tr>

                     <td>密 码</td>

                     <td><input type="password" id="password" ></td>

                 </tr>

                 <tr>

                     <td colspan="2">

                         <input type="button" onclick="login()" value="登陆">

                    </td>

                 </tr>

             </table>

         </form>

</body>

</html>