SpringBoot Mybatis项目搭建

古城微笑少年丶 2023-05-31 10:14 6阅读 0赞

**思路：使用STS开发工具，引入相关依赖包，在application.properties中配置相关信息，编写实体层、服务层、控制层相关代码**

## **一.STS新建SpringBoot项目** ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2NzA2ODc4_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2NzA2ODc4_size_16_color_FFFFFF_t_70 1][]

## **二.在pom.xml中引入相关依赖** ##

<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>com.boot</groupId>
    	<artifactId>testSpringBoot</artifactId>
    	<version>0.0.1-SNAPSHOT</version>
    	<name>testSpringBoot</name>
    	<packaging>jar</packaging>
    	<parent>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-parent</artifactId>
    		<version>1.5.9.RELEASE</version>
    		<relativePath/>
    	</parent>
    	<dependencies>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-web</artifactId>
                <version>1.3.5.RELEASE</version>
    		</dependency>
    		
    		
    		<dependency>
    		    <groupId>org.mybatis.spring.boot</groupId>
    		    <artifactId>mybatis-spring-boot-starter</artifactId>
    		    <version>1.3.1</version>
    		</dependency>
    		
    		
    		<dependency>
    		    <groupId>org.springframework.boot</groupId>
    		    <artifactId>spring-boot-starter-thymeleaf</artifactId>
    		</dependency>
    		  <dependency>
    		      <groupId>net.sourceforge.nekohtml</groupId>
    		      <artifactId>nekohtml</artifactId>
    		      <version>1.9.22</version>
    		 </dependency>
    		
    	    <dependency>
    	        <groupId>mysql</groupId>
    	        <artifactId>mysql-connector-java</artifactId>
    	    </dependency>
    	     <dependency>
    	      <groupId>org.springframework.boot</groupId>
    	      <artifactId>spring-boot-starter-test</artifactId>
    	    </dependency>
    	    
    		<dependency>
    		   <groupId>org.springframework.boot</groupId>
    		   <artifactId>spring-boot-starter-aop</artifactId>
    		</dependency>
    	</dependencies>
    	<build>
    	<plugins>
    		
    		<plugin>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-maven-plugin</artifactId>
    		</plugin>
    	</plugins>
    </build>
    </project>

**项目结构如下：**

![20191024152619701.png][]

## **三.配置application.properties相关信息** ##

#配置模板信息
    spring.thymeleaf.mode= LEGACYHTML5
    spring.thymeleaf.encoding= UTF-8
    spring.thymeleaf.content-type= text/html
    # 开发禁用缓存
    spring.thymeleaf.cache= false
    #配置数据源
    spring.datasource.url= jdbc:mysql://localhost:3306/cncert?characterEncoding=UTF-8&useSSL=true
    spring.datasource.username= root
    spring.datasource.password= #####
    # 可省略驱动配置, sprin-boot 会由url检测出驱动类型
    # driver-class-name: com.mysql.jdbc.Driver
    spring.datasource.hikari.connection-timeout= 60000 
    mybatis.mapperLocations= classpath:com/xuan/mapper/*.xml
    mybatis.typeAliasesPackage= com.xuan.cncert.entity
    # spring-boot默认打印输出info级别以上的，可在此处修改输出级别
    logging.level.root= info

# #

## **四.编写实体层代码** ##

public class User {  
        private Integer userid;  
        private String username;  
        private String password;  
        private String email; 
        private String account;
        
        public String getAccount() {
    		return account;
    	}
    	public void setAccount(String account) {
    		this.account = account;
    	}
    	public Integer getUserid() {
    		return userid;
    	}
    	public void setUserid(Integer userid) {
    		this.userid = userid;
    	}
    	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 getEmail() {
    		return email;
    	}
    
    	public void setEmail(String email) {
    		this.email = email;
    	}
    
    
          
    }

## **五.编写Dao层** ##

@Mapper
    public interface UserDao {  
    	/**
    	 * 根据用户相关信息查找用户
    	 * @param user
    	 * @return
    	 */
        public User getUserByUserInfo(User user);
        /**
         * 增加用户
         * @param user
         * @return
         */
        public Integer addUser(User user);
      
    }

## **六.编写service层** ##

public interface UserService {
    	/**
    	 * 根据用户相关信息查找用户
    	 * @param user
    	 * @return
    	 */
    	User getUserByUserInfo(User user); 
    	/**
    	 * 增加用户
    	 * @param user
    	 * @return
    	 */
    	Integer addUser(User user);
    }

@Service
    public class UserServiceImpl implements UserService{
    	@Autowired  
    	private UserDao userDao;  
    	/**
    	 * 根据用户相关信息查找用户
    	 * @param user
    	 * @return
    	 */
    	@Override
    	public User getUserByUserInfo(User user) {
    		return userDao.getUserByUserInfo(user);  
    	}
    	/**
    	 * 增加用户
    	 */
    	@Override
    	public Integer addUser(User user) {
    		return userDao.addUser(user);  
    	}
    
    }

## 七.编写mapper.xml文件 ##

<?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.xuan.###.dao.UserDao">  
      
        <resultMap id="BaseResultMap" type="com.xuan.###.entity.User">  
            <id column="userid" property="userid" jdbcType="INTEGER" />  
            <result column="username" property="username" jdbcType="CHAR" />  
            <result column="password" property="password" jdbcType="CHAR" />  
            <result column="email" property="email" jdbcType="CHAR" />  
        </resultMap>  
          
        <select id="selectUserById" parameterType="int" resultMap="BaseResultMap">  
            SELECT * FROM userinfo WHERE userid = #{userId}  
        </select> 
          
        <select id="getUserByUserInfo" parameterType="com.xuan.###.entity.User" resultMap="BaseResultMap">  
            SELECT 
            	a.userid as userid,
            	a.username as username,
            	a.email as email 
            FROM userinfo a 
           <where>  
           		1=1 
    	        <if test="account != null and account != '' ">  
    	            AND a.account = #{account}  
    	        </if>  
    	        <if test="password != null and password != '' ">  
    	            AND a.password = #{password}  
    	        </if> 
    	   </where> 
        </select>  
        <insert id="addUser" parameterType="User">
            INSERT INTO userinfo(account,
            password, email)
            VALUES(#{account}, #{password}, #{email})
        </insert>
    </mapper>

## **八.编写Controller** ##

@Controller
    @RequestMapping("/user")
    public class UserController {
    	@Autowired 
    	private UserService userService; 
    	
    	@GetMapping(value = "/hello")
        public String hello() {
        	return "hello";
        }
    	/**
    	 * 校验登录信息
    	 * @param model
    	 * @param request
    	 * @param session
    	 * @return
    	 */
    	@PostMapping(value = "loginCheck")
    	@ResponseBody 
    	public void loginCheck(Model model,HttpServletRequest request,HttpServletResponse response,HttpSession session){      
    		response.setContentType("text/html");
    		response.setCharacterEncoding("utf-8");
    		String result = "";
    		try {
    			request.setCharacterEncoding("utf-8");
    		} catch (UnsupportedEncodingException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}  //设置获取请求的参数方式为utf-8 能够解析中文参数
    		PrintWriter out = null;
    		try {
    			out = response.getWriter();
    		} catch (IOException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    		String account = request.getParameter("account");
            String password = request.getParameter("password");
            User checkUser = new User();
            checkUser.setAccount(account);
            checkUser.setPassword(password);
            User getUser = userService.getUserByUserInfo(checkUser);
            if(getUser != null){
            	session.setAttribute("user", getUser);
            	result = "success";
            }else{
            	result = "error";
            }
            out.print(result);
    		out.flush();
    		out.close();   
        } 
    	/**
    	 * 校验注册信息
    	 * @param model
    	 * @param request
    	 * @param session
    	 * @return
    	 */
    	@PostMapping(value = "registerCheck")
    	@ResponseBody 
    	public void registerCheck(Model model,HttpServletRequest request,HttpServletResponse response,HttpSession session){      
    		response.setContentType("text/html");
    		response.setCharacterEncoding("utf-8");
    		String result = "";
    		try {
    			request.setCharacterEncoding("utf-8");
    		} catch (UnsupportedEncodingException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}  //设置获取请求的参数方式为utf-8 能够解析中文参数
    		PrintWriter out = null;
    		try {
    			out = response.getWriter();
    		} catch (IOException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    		String account = request.getParameter("account");
            String password = request.getParameter("password");
            String email = request.getParameter("email");
            User checkUser = new User();
            checkUser.setAccount(account);
            User getUser = userService.getUserByUserInfo(checkUser);
            if(getUser != null){
            	result = "error";
            }else{
            	User addUser = new User();
            	addUser.setAccount(account);
            	addUser.setPassword(password);
            	addUser.setEmail(email);
            	Integer num = userService.addUser(addUser);
                session.setAttribute("user", addUser);
            	result = "success";
            }
            out.print(result);
    		out.flush();
    		out.close();   
        } 
    	
    }

## **九.测试** ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2NzA2ODc4_size_16_color_FFFFFF_t_70 2][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2NzA2ODc4_size_16_color_FFFFFF_t_70]: /images/20230531/1788fe5d33464bfbaefe003225250e69.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2NzA2ODc4_size_16_color_FFFFFF_t_70 1]: /images/20230531/3760ac740c7c499482acba3ed4177fea.png
[20191024152619701.png]: /images/20230531/2a8c1073f87d4f14b0f6585771fa47f2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2NzA2ODc4_size_16_color_FFFFFF_t_70 2]: /images/20230531/87eddd68469247438a9de45f9f69be6e.png