mybatis复习笔记1——环境搭建（IDEA）

电玩女神 2023-01-06 04:22 149阅读 0赞

# 搭建mybatis环境 #

### 1，创建maven工程，并编写pom.xml文件 ###

### ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg0MTMxMg_size_16_color_FFFFFF_t_70][] ###

### 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>Review</groupId>
        <artifactId>2021_01_first</artifactId>
        <version>1.0-SNAPSHOT</version>
        <packaging>jar</packaging>
        <dependencies>
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.4.5</version>
            </dependency>
    
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.6</version>
            </dependency>
    
            <dependency>
                <groupId>log4j</groupId>
                <artifactId>log4j</artifactId>
                <version>1.2.17</version>
            </dependency>
    
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.10</version>
                <scope>test</scope>
            </dependency>
    
        </dependencies>
    
    
    </project>

### 2，创建实体类和dao接口，实体类中的属性名要与数据库中的字段一一对应，数据类型要一致 ###

### ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg0MTMxMg_size_16_color_FFFFFF_t_70 1][] ###

### student类中的内容： ###

package com.itcast;
    
    import java.io.Serializable;
    
    public class Student implements Serializable {
        private String Sno;
        private String Sname;
        private String Ssex;
        private int Sage;
        private String Sdept;
    
        public String getSno() {
            return Sno;
        }
    
        public void setSno(String sno) {
            Sno = sno;
        }
    
        public String getSname() {
            return Sname;
        }
    
        public void setSname(String sname) {
            Sname = sname;
        }
    
        public String getSsex() {
            return Ssex;
        }
    
        public void setSsex(String ssex) {
            Ssex = ssex;
        }
    
        public int getSage() {
            return Sage;
        }
    
        public void setSage(int sage) {
            Sage = sage;
        }
    
        public String getSdept() {
            return Sdept;
        }
    
        public void setSdept(String sdept) {
            Sdept = sdept;
        }
    
        @Override
        public String toString() {
            return "Student{" +
                    "Sno='" + Sno + '\'' +
                    ", Sname='" + Sname + '\'' +
                    ", Ssex='" + Ssex + '\'' +
                    ", Sage=" + Sage +
                    ", Sdept='" + Sdept + '\'' +
                    '}';
        }
    }

### IStudent接口中的内容： ###

package com.itcast.dao;
    
    import com.itcast.Student;
    
    import java.util.List;
    /**学生的持久层接口*/
    public interface IStudent {
        List<Student> findAll();
    }

### 3，创建mybatis的主配置文件：sqlMapConfig.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>
    
        <environments default="mysql">
    
            <environment id="mysql">
    
                <transactionManager type="JDBC"></transactionManager>
    
                <dataSource type="POOLED">
    
                    <property name="driver" value="com.mysql.jdbc.Driver"/>
                    <property name="url" value="jdbc:mysql://localhost:3306/stu"/>
                    <property name="username" value="root"/>
                    <property name="password" value="1234"/>
                </dataSource>
            </environment>
        </environments>
        <mappers>
    
            <mapper resource="com/itcast/dao/IStudentDao.xml"/>
        </mappers>
    </configuration>

### 4，创建mybatis的映射配置文件：IStudentDao.xml——用来实现对数据库stu中的student表的控制，需要编写SQL语句 ###

<?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.itcast.dao.IStudent">
    
        <select id="findALL" >
        select * from student
      </select>
    </mapper>

### 5，编写测试是否可以控制数据库 ###

### ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg0MTMxMg_size_16_color_FFFFFF_t_70 2][] ###

### StudentTest的代码： ###

import com.itcast.Student;
    import com.itcast.dao.IStudent;
    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;
    import java.util.List;
    
    public class StudentTest {
        public static void main(String[] args) throws IOException {
            //1,读取配置文件
            InputStream in= Resources.getResourceAsStream("sqlMapConfig.xml");
            //2,创建SqlSessionFactory工厂
            SqlSessionFactoryBuilder builder= new SqlSessionFactoryBuilder();
            SqlSessionFactory factory= builder.build(in);
            //3,使用工厂生产SqlSession对象
            SqlSession session=factory.openSession();
            //4,使用session创建dao代理对象
            IStudent student=session.getMapper(IStudent.class);
            //5,执行代理对象的方法
            List<Student> students=student.findAll();
            for (Student stu : students){
                System.out.println(stu);
            }
            session.close();
            in.close();
        }
    }

### 6，数据库stu，数据表student ###

### ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg0MTMxMg_size_16_color_FFFFFF_t_70 3][] ###

## ##

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg0MTMxMg_size_16_color_FFFFFF_t_70]: /images/20221119/c992902228574eb59e55f4680d410e9f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg0MTMxMg_size_16_color_FFFFFF_t_70 1]: /images/20221119/30a092489d524ab39e110d2d53104a8f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg0MTMxMg_size_16_color_FFFFFF_t_70 2]: /images/20221119/b2ac7c21399545cab72756049dba7f9c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg0MTMxMg_size_16_color_FFFFFF_t_70 3]: /images/20221119/c85e7d387c0747fb887b952cda3d81e5.png