栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

mybatis笔记(1)

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

mybatis笔记(1)

  • 首先新建一个Spring Boot项目。
  • 导入依赖
  • 编写XML文件

pom.xml



    4.0.0
    
        org.springframework.boot
        spring-boot-starter-parent
        2.3.4.RELEASE
         
    
    com.example
    mystudydemo
    0.0.1-SNAPSHOT
    mystudydemo
    Demo project for Spring Boot
    
        1.8
    
    
        
            org.springframework.boot
            spring-boot-starter-web
            
                
                    org.springframework.boot
                    spring-boot-starter-logging
                
            
        

        
            org.springframework.boot
            spring-boot-starter-test
            test
        

        
        
            org.springframework.boot
            spring-boot-starter-log4j2
        

        
            org.apache.logging.log4j
            log4j-core
            2.10.0
        

        
            org.apache.logging.log4j
            log4j-api
            2.10.0
        

        
            org.projectlombok
            lombok
            true
        

        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            2.1.3
        

        
            org.springframework.boot
            spring-boot-starter-thymeleaf
        

        
            mysql
            mysql-connector-java
            runtime
        

        
            org.springframework.boot
            spring-boot-starter-thymeleaf
        

    

    
        
            
                org.springframework.boot
                spring-boot-maven-plugin
            
        
    



Log4j2.xml



    
    
        
        
            
            
            
            
        
        
            
            
            
            
                
                
            
        
        
            
            
            
            
                
                
            
        
    
    
    
        
        
        
        
            
            
            
            
        
    

application.yml

spring:
  datasource:
    #用户名
    username: root
    #密码
    password: 123456
    # url需要指定时区serverTimezone为 GMT%2B8 :北京时间东八区
    url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8&useSSL=true
    # 新版的驱动类改成了com.mysql.cj.jdbc.Driver
    driver-class-name: com.mysql.cj.jdbc.Driver
#  使用mybatis配置文件时需要指明
  thymeleaf:
    prefix: classpath:/templates/
    suffix: .html
    mode: LEGACYHTML5
    encoding: UTF-8
    cache: false

server:
  servlet:
    context-path:
  port: 8080

application.properties

#配置Mybatis
#mybatis.config-location=classpath:mybatis/mybatis-config.xml
mybatis.mapper-locations=classpath:mybatis/mapper/*.xml
mybatis.type-aliases-package=com.example.mystudydemo.entity

User.java

package com.example.mystudydemo.entity;


import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.util.Date;


@Data
@NoArgsConstructor
@AllArgsConstructor
public class User {

    Integer id;

    String username;

    String password;

    String yourName;

    String sex;

    Integer age;

    String yourPhone;

    String yourMail;

    Date ctime;

    Date uptime;

}

UserMapper.java

package com.example.mystudydemo.dao;

import com.example.mystudydemo.entity.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface UserMapper {
    //获取所有数据
    List getAllUser();
    //获取一条数据
    User selectUserById(@Param("id") Integer id);
    //新增一条数据
    Integer insertUser(@Param("user") User user);
    //新增多条数据
    Boolean addUserMassages(@Param("list") List list);
    //新增多条数据
    Boolean insertUserMassages(@Param("list") List list);
    //更新数据
    Boolean updateUser(@Param("user") User user);
    //删除数据
    Boolean deleteFromUser(@Param("id") Integer id);

    Boolean deleteFromUsers(@Param("list") List list);

    User getUserByUserName(@Param("username") String username);


}

UserMapper.xml




    
        id,username,password,youname,sex,age,youphone,youmail,ctime,uptime
    
    
        
        
        
        
        
        
        
        
        
        
    

    
        select  from user
        where id = #{id}
    
    
        insert into user
        
            username,
            password,
            youname,
            sex,
            age,
            youphone,
            youmail,
            ctime,
            uptime,
        
        
            #{user.username},
            #{user.password},
            #{user.yourName},
            #{user.sex},
            #{user.age},
            #{user.yourPhone},
            #{user.yourMail},
            #{user.ctime},
            #{user.uptime},
        
    
    
        insert into user
        (username,password,youname,sex,age,youphone,youmail,ctime,uptime)
        values
        
            (#{item.username},#{item.password},#{item.yourName},#{item.sex},
             #{item.age},#{item.yourPhone},#{item.yourMail},now(),now())
        
    
    
        update user
        
            username = #{user.username},
            password = #{user.password},
            youname = #{user.yourName},
            sex = #{user.sex},
            age = #{user.age},
            youphone = #{user.yourPhone},
            youmail = #{user.yourMail},
            ctime = #{user.ctime},
            uptime = #{user.uptime},
        
        
            id = #{user.id}
        
    
    
        delete from user
            where id = #{id}
    
    
        delete from user
        where id in
        
            #{item}
        
    
    

数据表图片入下,懒得写SQL语句了。


到此,就用Mybatis实现了对单表的增删改查了。

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/937302.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号