Mybatis框架的简单搭建（参数注入的方式)

工具:idea 2021.3.0+maven （视频来源：硅谷,白嫖党懂的都懂）

包依赖

    4.0.0

    com.atchengdu
    mynatis_maven02
    1.0-SNAPSHOT

    
        11
        11
    
    jar
    
        
            org.mybatis
            mybatis
            3.5.7
        
        
            junit
            junit
            4.11
            test
        
        
            mysql
            mysql-connector-java
            8.0.27
        
        
            log4j
            log4j
            1.2.17
        
    

mybatis的默认配置文件

mapper接口配置文件

  
    
      select *from t_user;
  

  
    select *from t_user where username = #{username};
  
 
  
    select  *from t_user where  username=#{arg0} and password=#{arg1};
  
 
  
    select *from t_user where username=#{username} and password=#{password};
  
 
  
    insert into t_user values (null,#{username},#{password},#{age},#{sex},#{email});
  
  
  
    select *from t_user where username=#{username} and password=#{password};
  

User类

package com.atchengdu.mybatis.polo;

public class User {
    private Integer id;
    private String username;
    private String password;
    private Integer age;
    private String sex;
    private String email;

    public User() {
    }

    public User(Integer id, String username, String password, Integer age, String sex, String email) {
        this.id = id;
        this.username = username;
        this.password = password;
        this.age = age;
        this.sex = sex;
        this.email = email;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    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 Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + ''' +
                ", password='" + password + ''' +
                ", age=" + age +
                ", sex='" + sex + ''' +
                ", email='" + email + ''' +
                '}';
    }
}

user类对应的mapper接口

package com.atchengdu.mybatis.mapper;

import com.atchengdu.mybatis.polo.User;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface Parametermapper {

     List getalluser();

     User getuserByusername(String username);

     User checklogin(String username ,String password);
     User checkloginbyMap(Map map);
     void Adduser(User user);
     //使用注解来验证登录 需要使用注解的方式
     //mybatis可以把参数以自己设置的键来存放数据
     User yanzhanlogin(@Param("username") String username,@Param("password") String password);
}

测试类以及参数注入的五种方式

package com.atchengdu.mybatis;

import com.atchengdu.mybatis.mapper.Parametermapper;
import com.atchengdu.mybatis.polo.User;
import com.atchengdu.mybatis.utils.sqlsessionutil;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.HashMap;
import java.util.Map;

public class test {
    
    @Test
    public void Test(){
        SqlSession sqlsession = sqlsessionutil.getSqlsession();
        Parametermapper mapper = sqlsession.getMapper(Parametermapper.class);
        for(User user:mapper.getalluser()){
            System.out.println(user);
        }

    }

    @Test
    public void Test2(){
        SqlSession sqlsession = sqlsessionutil.getSqlsession();
        Parametermapper mapper = sqlsession.getMapper(Parametermapper.class);
        System.out.println( mapper.getuserByusername("张三"));
    }

    @Test
    public void Test3(){
        SqlSession sqlsession = sqlsessionutil.getSqlsession();
        Parametermapper mapper = sqlsession.getMapper(Parametermapper.class);
        System.out.println( mapper.checklogin("张三","123456"));
    }

    @Test
    public void Test4(){
        SqlSession sqlsession = sqlsessionutil.getSqlsession();
        Parametermapper mapper = sqlsession.getMapper(Parametermapper.class);
        Map map=new HashMap<>();
        map.put("username","admin");
        map.put("password","123456");
        System.out.println(mapper.checkloginbyMap(map));
    }

    @Test
    public void Test5(){
        SqlSession sqlsession = sqlsessionutil.getSqlsession();
        Parametermapper mapper = sqlsession.getMapper(Parametermapper.class);
        User user=new User(null,"xiaoxiao","123456",19,"女","xiaoixao@qq.com");
          mapper.Adduser(user);
    }

    @Test
    public void Test6(){
        SqlSession sqlsession = sqlsessionutil.getSqlsession();
        Parametermapper mapper = sqlsession.getMapper(Parametermapper.class);
        System.out.println( mapper.yanzhanlogin("张三","123456"));
    }
}