第四个MyBatis练习，方法的传参分类

做一道光

已于 2022-05-29 23:38:48 修改

阅读量94

点赞数 2

分类专栏： MyBatis 文章标签： java 开发语言

于 2022-05-29 21:11:31 首次发布

本文链接：https://blog.csdn.net/weixin_59334478/article/details/125034646

版权

MyBatis 专栏收录该内容

11 篇文章 2 订阅

订阅专栏

项目结构

1.创建Student实体类

package com.it.domain;

public class Student {
    private int sno;
    private String sname;
    private  String ssex;
    private int sage;
    private String sdept;

    public int getSno() {
        return sno;
    }

    public void setSno(int sno) {
        this.sno = sno;
    }

    public String getSname() {
        return sname;
    }

    public void setSname(String sname) {
        this.sname = sname;
    }

    public String getSsex() {
        return ssex;
    }

    public void setSsex(String ssex) {
        this.ssex = ssex;
    }

    public int getSage() {
        return sage;
    }

    public void setSage(int sage) {
        this.sage = sage;
    }

    public String getSdept() {
        return sdept;
    }

    public void setSdept(String sdept) {
        this.sdept = sdept;
    }

    @Override
    public String toString() {
        return "Student{" +
                "sno=" + sno +
                ", sname='" + sname + '\'' +
                ", ssex='" + ssex + '\'' +
                ", sage=" + sage +
                ", sdept='" + sdept + '\'' +
                '}';
    }
}

2.创建StudentDao接口类

package com.it.dao;

import com.it.dao.vo.QueryParam;
import com.it.domain.Student;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface StudentDao {
    //一个简单类型的参数：只能传递一个参数
    List<Student> selectStudents1(Integer sage);
    //多个参数：使用@Param命名参数,里面的值是自定义参数名称，可以传递多个参数
    List<Student> selectStudents2(@Param("mySdept") String sdept,@Param("mySage") int sage);
    //多个参数：使用对象类型，使用的对象类型没有限制，也可以使用Student类，使用的这些对象只不过是作为一种存储数值的媒介传递参数
    List<Student> selectStudents3(QueryParam queryParam);
    List<Student> selectStudents4(Student student);

    int insertStudents(Student student);
}

3.创建StudentDao接口类的映射文件StudentDao.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.it.dao.StudentDao">
<!--select标签中的id对应的是接口中方法的名字，
parameterType对应的是接口中方法的参数类型,java.lang.Integer是全限定名称；也可以写成别名int；
还可以去掉该属性，都可以正常运行。mybatis可以通过反射机制得到参数的数据类型，
resultType对应的是返回的类型-->

<!--注意：不要再select标签中写注释，会导致程序无法正常运行    -->

<!--      sage=#{sage}中的参数可以任意写，也可以写成sage=#{aaaa},只要符合变量的命名规则就可以了-->
    <select id="selectStudents1" parameterType="java.lang.Integer" resultType="com.it.domain.Student">
        select sno,sname,sage,ssex,sdept from student where sage=#{sage}
    </select>

<!--dept=#{mySdept}中大括号中填写的参数必须是接口方法中命名的参数名称-->
    <select id="selectStudents2" resultType="com.it.domain.Student">
select sno,sname,sage,ssex,sdept from student where sdept=#{mySdept} and sage=#{mySage}
    </select>

<!--   #{}大括号里面的是传递过来的对象的属性-->
    <select id="selectStudents3" resultType="com.it.domain.Student">
select sno,sname,sage,ssex,sdept from student where sname=#{nameParam} or sage=#{ageParam}
    </select>
    <select id="selectStudents4" resultType="com.it.domain.Student">
         select sno,sname,sage,ssex,sdept from student where sname=#{sname} or sage=#{sage}
    </select>



    <insert id="insertStudents" >
        insert into student values (#{sno},#{sname},#{ssex},#{sage},#{sdept})
    </insert>
</mapper>

4.创建MyBatis.xml文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <settings>
        <setting name="logImpl" value="STDOUT_LOGGING"/>
    </settings>
    <environments default="mydev">
        <environment id="mydev">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="com/it/dao/StudentDao.xml"/>
    </mappers>
</configuration>

5.创建MyBatisUntils工具类

package com.it.untils;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.InputStream;

public class MyBatisUntils {
//    SqlSessionFactory设置静态属性，是因为SqlSessionFactory ： 重量级对象，
//    程序创建一个对象耗时比较长，使用资源比较多，在整个项目中，有一个就够用了。
    private static SqlSessionFactory factory = null;
//    静态代码块，在加载该类时运行，且运行一次，避免了多次调用该方法多次运行，节约了时间和空间
    static {
//   测试了一下，虽然我的MyBatis配置文件名称是MyBatis.xml,但是输入mybatis.xml也可以成功运行
//   这个项目是我新建的，不存在调用该工程其他模块的mybatis.xml配置文件的情况，这可以说明这里应该是不区分大小写的
        String config="MyBatis.xml";
        InputStream resourceAsStream=null;
        try {
            resourceAsStream = Resources.getResourceAsStream(config);
            SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
            factory = builder.build(resourceAsStream);
        } catch (IOException e) {
            e.printStackTrace();
        }

    }

    //获取SqlSession的方法
    public static SqlSession getSqlSession(){
        SqlSession sqlSession=null;
        if (factory!=null){
            sqlSession = factory.openSession(true);
        }
        return sqlSession;
    }
}

6.创建QueryParam实体类

package com.it.dao.vo;

public class QueryParam {
    private String nameParam;
    private Integer ageParam;

    public String getNameParam() {
        return nameParam;
    }

    public void setNameParam(String nameParam) {
        this.nameParam = nameParam;
    }

    public Integer getAgeParam() {
        return ageParam;
    }

    public void setAgeParam(Integer ageParam) {
        this.ageParam = ageParam;
    }

    @Override
    public String toString() {
        return "QueryParam{" +
                "nameParam='" + nameParam + '\'' +
                ", ageParam=" + ageParam +
                '}';
    }
}

7.创建测试类

package com.it;

import static org.junit.Assert.assertTrue;

import com.it.dao.StudentDao;
import com.it.dao.vo.QueryParam;
import com.it.domain.Student;
import com.it.untils.MyBatisUntils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.List;

/**
 * Unit test for simple App.
 */
public class AppTest 
{
    @Test
    public  void selectStudents1Test(){
        SqlSession sqlSession = MyBatisUntils.getSqlSession();
        //getMapper能获取dao接口的实现类
        StudentDao mapper = sqlSession.getMapper(StudentDao.class);
        //调用mapper,执行数据库操作。
        List<Student> studentList = mapper.selectStudents1(20);
        for (Student stu:studentList){
            System.out.println(stu);
        }
    }

    @Test
    public void  selectStudents2Test(){
        SqlSession sqlSession = MyBatisUntils.getSqlSession();
        StudentDao mapper = sqlSession.getMapper(StudentDao.class);
        List<Student> studentList = mapper.selectStudents2("信电", 20);
        for (Student stu:studentList){
            System.out.println(stu);
        }
    }
    @Test
    public void selectStudents3Test(){
        SqlSession sqlSession = MyBatisUntils.getSqlSession();
        StudentDao mapper = sqlSession.getMapper(StudentDao.class);

        QueryParam queryParam = new QueryParam();
        queryParam.setNameParam("小明");
        queryParam.setAgeParam(20);

        List<Student> studentList = mapper.selectStudents3(queryParam);
        for (Student stu:studentList){
            System.out.println(stu);
        }
    }

    @Test
    public void selectStudents4Test(){
        SqlSession sqlSession = MyBatisUntils.getSqlSession();
        StudentDao mapper = sqlSession.getMapper(StudentDao.class);

        Student student=new Student();
        student.setSname("小明");
        student.setSage(20);

        List<Student> studentList = mapper.selectStudents4(student);
        for (Student stu:studentList){
            System.out.println(stu);
        }
    }

}

传递普通类型时的JAVA类型对应的mybatis的别名