java EE企业级应用与开发实验三 实现学生信息查询系统附源码

1.创建一个maven项目，再编辑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>org.example</groupId>
    <artifactId>mybatistest</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <maven.compiler.source>16</maven.compiler.source>
        <maven.compiler.target>16</maven.compiler.target>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>
    <dependencies>
        <!--mybatis-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
        </dependency>
        <!--单元测试-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>
        <!--mysql驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.25</version>
            <scope>runtime</scope>
        </dependency>
    </dependencies>
    <build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>

</project>

2.在recourses目录下创建db.properties,注意password的值是你mysql设置的密码

mysql.driver=com.mysql.cj.jdbc.Driver
mysql.url=jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&\
  characterEncoding=utf8&useUnicode=true&useSSL=false
mysql.username=root
mysql.password=123456

3.同样在resources目录下创建mybatis-config.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>

    <!--引入外部的db.properties-->
    <properties resource="db.properties"/>
    <typeAliases>
        <package name="com.itheima.pojo"/>
    </typeAliases>


    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC" />
            <dataSource type="POOLED">
                <property name="driver" value="${mysql.driver}"/>
                <property name="url" value="${mysql.url}"/>
                <property name="username" value="${mysql.username}"/>
                <property name="password" value="${mysql.password}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!--配置文件的地址-->
        <mapper resource="com/itheima/mapper/StudentMapper.xml"/>
    </mappers>
</configuration>

4.准备数据库，创建一个dm_student数据表

USE mybatis;
CREATE TABLE dm_student(
    id INT(32) primary key auto_increment,
		name VARCHAR(50),
		major VARCHAR(50),
		sno VARCHAR(16) );
		
		INSERT INTO dm_student VALUES('1','江添','数学','10001');
		INSERT INTO dm_student VALUES('2','盛望','金融','10002');
		INSERT INTO dm_student VALUES('3','贺朝','金融','10003');
		INSERT INTO dm_student VALUES('4','谢俞','医学','10004');
		INSERT INTO dm_student VALUES('5','顾晏','法学','10005');
		INSERT INTO dm_student VALUES('6','燕绥之','法学','10006');
		INSERT INTO dm_student VALUES('7','嬴政','历史','10007');
	

5.POJO类准备

在src/main/java目录下创建包com.ithiema.pojo

然后在com.ithiema.pojo包下创建类Student

package com.itheima.pojo;

public class Student {
    private int id;
    private String name;
    private String major;
    private String sno;
@Override
public String toString() {
    return "Student [id=" + id + ",name=" + name +
            ", major=" + major  + ",sno=" + sno + "}";

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getMajor() {
        return major;
    }

    public void setMajor(String major) {
        this.major = major;
    }
    public String getSno(){
        return sno;
    }
    public void setSno(String sno){
        this.sno = sno;
    }
}

6.创建映射文件StudentMapper.xml文件

最好在resources目录下创建com/ithiema/mapper目录，然后在此目录下创建StudentMapper.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:名称空间，由于临时文件可能有很多个，为了防止crud语句的唯一标识被重复，需要设置空间名称
-->
<mapper namespace="com.itheima.mapper.StudentMapper">
    <select id="findStudentByNameAndMajor"
            parameterType="com.itheima.pojo.Student"
            resultType="com.itheima.pojo.Student">
        select * from dm_student where 1=1
        <choose>
            <when test="name!=null and name !=''">
                and name like concat('%',#{name},'%')
            </when>
            <when test="major!=null and major!=''">
                and major= #{major}
            </when>
            <otherwise>
                and sno is not null
            </otherwise>
        </choose>
    </select>
    <select id="findByList" parameterType="com.itheima.pojo.Student" resultType="com.itheima.pojo.Student">
        select * from dm_student where id in
        <foreach item="id" collection="list"
                 open="(" close=")" separator=",">
            #{id}
        </foreach>
    </select>
</mapper>

7.修改核心配置文件，见上第三步代码里<!--配置文件地址-->，已添加

8.创建获取SqlSession对象的工具类

在src/main/java目录下创建MyBatisUtils类

package com.itheima.utils;

import java.io.Reader;

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

    /**
     * 工具类
     */
    public class MyBatisUtils {
        private static SqlSessionFactory sqlSessionFactory = null;

        // 初始化SqlSessionFactory对象
        static {
            try {
                // 使用MyBatis提供的Resources类加载MyBatis的配置文件
                Reader reader =
                        Resources.getResourceAsReader("mybatis-config.xml");
                // 构建SqlSessionFactory工厂
                sqlSessionFactory =
                        new SqlSessionFactoryBuilder().build(reader);
            } catch (Exception e) {
                e.printStackTrace();
            }
        }

        // 获取SqlSession对象的静态方法
        public static SqlSession getSession() {
            return sqlSessionFactory.openSession();
        }
    }

9.创建并修改测试类

在test/java目录下创建com/ithiema包，在这个包下创建测试类StudentTest

package com.itheima;

import com.itheima.pojo.Employee;
import com.itheima.pojo.Student;
import com.itheima.utils.MyBatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.ArrayList;
import java.util.List;

public class StudentTest {
    @Test
    public void findStudentByNameAndMajor(){
        //获取sqlSession
        SqlSession session = MyBatisUtils.getSession();
        //执行sql
        Student student = new Student();
        student.setName("江添");
        student.setMajor("法学");
        List<Student> studentList = session.selectList("com.itheima.mapper.StudentMapper.findStudentByNameAndMajor",student);
        //遍历结果
        for (Student s:studentList){
            System.out.println(s);
        }

        session.close();

    }
    @Test
    //根据学生id批量查询学生信息
    public void findByListTest(){
        SqlSession session =MyBatisUtils.getSession();
        List<Integer> ids= new ArrayList<>();
        ids.add(1);
        ids.add(2);
        ids.add(3);
        ids.add(4);
       List<Student> studentList = session.selectList("com.itheima.mapper.StudentMapper.findByList",ids);
        for (Student s:studentList){
            System.out.println(s);
        }

        session.close();
    }

}

10.最后调试即可。附上目录及运行结果