Maven---MyBatis

最新推荐文章于 2023-03-05 01:24:39 发布
最新推荐文章于 2023-03-05 01:24:39 发布
阅读量991 收藏
点赞数
分类专栏： java Mybatis 文章标签： maven java intellij-idea
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/wqww_1/article/details/123476326
版权

Maven—MyBatis

CRUD

目录结构

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-s1egOw9R-1647234763474)(Maven---MyBatis/image-20201129202726599.png)]

首先创建mybatis-study父目录

mybatis-study -->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>mybatis-study</groupId>
    <artifactId>mybatis-study</artifactId>
    <packaging>pom</packaging>
    <version>1.0-SNAPSHOT</version>
    <modules>
        <module>MyBatis01</module>
    </modules>

    <dependencies>
        <!--MySQL JDBC依赖包-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>
        <!--MyBatis依赖包-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.2</version>
        </dependency>
        <dependency>
            <groupId>org.junit</groupId>
            <artifactId>com.springsource.org.junit</artifactId>
            <version>4.7.0</version>
        </dependency>
    </dependencies>

  <!--为了解决*Mapper.xml编译不了的问题-->
    <build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
        </resources>
    </build>
</project>

然后创建MyBatis01子工程

MyBatis01---->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">
    <parent>
        <artifactId>mybatis-study</artifactId>
        <groupId>mybatis-study</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>MyBatis-01</artifactId>

    <build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
        </resources>
    </build>
</project>

在resources里面创建

db.properties

db.driver=com.mysql.jdbc.Driver
db.url=jdbc:mysql://localhost:3306/zkc?useSSL=true&amp;useUnicode=true&amp;characterEncoding=utf8
db.username=root
db.password=root

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>
    <properties resource="db.properties"/>
    <typeAliases>
        <package name="com.zkc.pojo"/>
    </typeAliases>
    <!--环境配置
        default 设置是environment节点中的id
    -->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${db.driver}"/>
                <property name="url"  value="${db.url}"/>
                <property name="username" value="${db.username}"/>
                <property name="password" value="${db.password}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!--<mapper resource="com/zkc/dao/BookMapper.xml"/>-->
        <package name="com.zkc.dao"/>
    </mappers>
</configuration>

pojo —>Book

package com.zkc.pojo;

public class Book {
    private int no;
    private String name;
    private String author;
    private String sort;

    public int getNo() {
        return no;
    }

    public void setNo(int no) {
        this.no = no;
    }

    public String getName() {
        return name;
    }

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

    public String getAuthor() {
        return author;
    }

    public void setAuthor(String author) {
        this.author = author;
    }

    public String getSort() {
        return sort;
    }

    public void setSort(String sort) {
        this.sort = sort;
    }

    @Override
    public String toString() {
        return "Book{" +
                "no=" + no +
                ", name='" + name + '\'' +
                ", author='" + author + '\'' +
                ", sort='" + sort + '\'' +
                '}';
    }
}

dao—>BookMapper

package com.zkc.dao;

import com.zkc.pojo.Book;

import java.util.List;

public interface BookMapper {
    List<Book> getBookList();

    Book getBookByNo(int no);

    int addBook(Book book);

    int updateBook(Book book);

    int delBook(int no);
}

dao---->BookMapper.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.zkc.dao.BookMapper">
    <select id="getBookList" resultType="Book">
        select * from book
    </select>

    <select id="getBookByNo" parameterType="int" resultType="Book">
        select * from book where no = #{no}
    </select>

    <insert id="addBook" parameterType="Book">
        insert into book (name,author,sort) values(#{name},#{author},#{sort})
    </insert>
    
    <update id="updateBook" parameterType="Book">
        update book set name=#{name},author=#{author},sort=#{sort} where no=#{no};
    </update>

    <delete id="delBook" parameterType="int">
        delete from book where no = #{no}
    </delete>
</mapper>

utills—>MyBatisUtills

package com.zkc.utills;
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 MyBatisUtills {
    private static SqlSessionFactory sqlSessionFactory;
    static {
        try{
            String source = "mybatis-config.xml";
            InputStream inputStream = Resources.getResourceAsStream(source);
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        }catch (IOException e){
            e.printStackTrace();
        }
    }
    //获取SqlSession连接
    public static SqlSession getSqlSession(){
        return sqlSessionFactory.openSession();
    }
}

测试MyTest

package com.zkc.test;

import com.zkc.dao.BookMapper;
import com.zkc.pojo.Book;
import com.zkc.utills.MyBatisUtills;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.List;

public class MyTest {
    /**
     * 查询全部
     */
    @Test
    public void test(){
        SqlSession sqlSession = MyBatisUtills.getSqlSession();
        BookMapper bookMapper = sqlSession.getMapper(BookMapper.class);
        List<Book> bookList = bookMapper.getBookList();
        for (Book book : bookList) {
            System.out.println(book);
        }
        sqlSession.close();
    }

    /**
     * 查询根据no查询
     */
    @Test
    public void getByBookId(){
        SqlSession sqlSession = MyBatisUtills.getSqlSession();
        BookMapper bookMapper = sqlSession.getMapper(BookMapper.class);
        Book book = bookMapper.getBookByNo(1);
        System.out.println(book);
        sqlSession.close();
    }

    /**
     * 添加图书信息
     */
    @Test
    public void addBook(){
        SqlSession sqlSession = MyBatisUtills.getSqlSession();
        BookMapper bookMapper = sqlSession.getMapper(BookMapper.class);
        Book book = new Book();
        book.setName("坏蛋是怎样炼成的");
        book.setAuthor("张三");
        book.setSort("网络小说");
        int num = bookMapper.addBook(book);
        if(num > 0){
            System.out.println("插入成功！");
        }
        sqlSession.commit();
        sqlSession.close();
    }

    /**
     * 修改图书信息
     */
    @Test
    public void updateBook(){
        SqlSession sqlSession = MyBatisUtills.getSqlSession();
        BookMapper bookMapper = sqlSession.getMapper(BookMapper.class);
        Book book = bookMapper.getBookByNo(10);
        book.setName("圣墟");
        book.setAuthor("城东");
        book.setSort("网络小说");
        int num = bookMapper.updateBook(book);
        if(num > 0){
            System.out.println("修改成功！");
        }
        sqlSession.commit();
        sqlSession.close();
    }

    /**
     * 删除图书信息
     */
    @Test
    public void delBook(){
        SqlSession sqlSession = MyBatisUtills.getSqlSession();
        BookMapper bookMapper = sqlSession.getMapper(BookMapper.class);
        int num = bookMapper.delBook(11);
        if(num > 0){
            System.out.println("删除成功");
        }
        sqlSession.commit();
        sqlSession.close();

    }
}

环境配置environments

 <!--环境配置
        default 设置是environment节点中的id
    -->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${db.driver}"/>
                <property name="url"  value="${db.url}"/>
                <property name="username" value="${db.username}"/>
                <property name="password" value="${db.password}"/>
            </dataSource>
        </environment>
    </environments>

属性properties

<!--引入外部配置文件-->
    <properties resource="db.properties"/>

类型别名typeAliases

 <!--设置别名-->
    <typeAliases>
      	<!--可以设置别名-->
        <!--<typeAlias type="com.zkc.pojo" alias="Book"/>-->
      	<!--扫描包下面所有的类，别名为类名，首字母小写-->
        <package name="com.zkc.pojo" />
    </typeAliases>

也是可以在类上直接设置别名,然后扫描类

@Alias("Hello")
public class Book {
    private int no;
    private String name;
    private String author;
    private String sort;
  ...
}

映射器mappers

	<mappers>
        <!--<mapper resource="com/zkc/dao/BookMapper.xml"/>-->
        <!--<mapper class="com.zkc.dao.BookMapper"/>-->
        <package name="com.zkc.dao"/>
    </mappers>

生命周期和作用域

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-E89jQE8w-1647234763475)(Maven---MyBatis/image-20201129214021151.png)]

SqlSessionFactoryBuilder

一旦创建SqlSessionFactory就不需要了

SqlSessionFactory

一旦创建就一直存在

SqlSession

链接到链接池的一个请求

resultMap解决数据库与javabean名称不一致

 <resultMap id="BookMap" type="Book">
        <result column="no" property="id"/>
        <result column="name" property="name"/>
        <result column="author" property="author"/>
        <result column="sort" property="sort"/>
    </resultMap>

 <select id="getBookList" resultMap="BookMap">
        select * from book
    </select>

日志

STDOUT_LOGGING
 <!--配置日志-->
    <settings>
        <setting name="logImpl" value="STDOUT_LOGGING"/>
    </settings>

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-apXMNQLJ-1647234763476)(Maven---MyBatis/image-20201129221246967.png)]

LOG4J
 <!--配置日志-->
    <settings>
        <setting name="logImpl" value="LOG4J"/>
    </settings>

导入log4j的文件

<dependencies>
        <!--导入log4j包-->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>
    </dependencies>

创建log4j.properties文件

# 将等级为DEBUG的日志信息输出到console和file
log4j.rootLogger=debug,console,file

#日志控制台输出信息
log4j.appender.console=org.apache.log4j.ConsoleAppender
log4j.appender.console.Target=System.out
log4j.appender.console.Threshold=DEBUG
log4j.appender.console.layout=org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %5p %c{1}:%L - %m%n

#日志输出文件信息
log4j.appender.file=org.apache.log4j.RollingFileAppender
log4j.appender.file.File=./log/zkc.log
log4j.appender.file.MaxFileSize=10mb
log4j.appender.file.Threshold=DEBUG
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %5p %c{1}:%L - %m%n


log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
log4j的简单实用
 @Test
    public void TestLog4j(){
        Logger logger = Logger.getLogger(MyTest.class);
        logger.info("info:进入MyTest");
        logger.debug("debug:进入MyTest");
        logger.error("error:进入MyTest");
    }

分页实现

limit

BookMapper接口

List<Book> getLimitBook(Map<String,Object> map);

BookMapper.xml

<select id="getLimitBook" parameterType="map" resultMap="BookMap">
      select * from book limit #{startIndex},#{pageSize}
</select>

测试

 @Test
    public void getLimitBook(){
        SqlSession sqlSession = MyBatisUtills.getSqlSession();
        BookMapper bookMapper = sqlSession.getMapper(BookMapper.class);
        Map<String,Object> map = new HashMap<String,Object>();
        map.put("startIndex",2);
        map.put("pageSize",2);
        List<Book> bookList = bookMapper.getLimitBook(map);
        for (Book book : bookList) {
            System.out.println(book);
        }
        sqlSession.close();
    }

RowBounds分页

PageHelper分页

使用注解开发

CRUD

BookMapper接口

    @Select("select * from user")
    List<Book> getBookList();

    @Select("select * from user where id = #{id}")
    Book getBookById(@Param("id") int id);

测试

 /**
     * 查询全部
     */
    @Test
    public void test(){
        SqlSession sqlSession = MyBatisUtills.getSqlSession();
        BookMapper bookMapper = sqlSession.getMapper(BookMapper.class);
        List<Book> bookList = bookMapper.getBookList();
        for (Book book : bookList) {
            System.out.println(book);
        }
        sqlSession.close();
    }

    @Test
    public void getBookById(){
        SqlSession sqlSession = MyBatisUtills.getSqlSession();
        BookMapper bookMapper = sqlSession.getMapper(BookMapper.class);
        Book book = bookMapper.getBookById(1);
        System.out.println(book);
        sqlSession.close();
    }

Lombok

参数
@Data
@AllArgsConstructor
@NoArgsConstructor
@ToString
@EqualsAndHashCode

首先settings里面plugins—>lombok

<!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <version>1.18.8</version>
    <scope>provided</scope>
</dependency>

多对一

建表

CREATE TABLE `teacher` (
`id` INT(10) NOT NULL,
`name` VARCHAR(30) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8
INSERT INTO teacher(`id`, `name`) VALUES (1, '秦老师');
CREATE TABLE `student` (
`id` INT(10) NOT NULL,
`name` VARCHAR(30) DEFAULT NULL,
`tid` INT(10) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fktid` (`tid`),
CONSTRAINT `fktid` FOREIGN KEY (`tid`) REFERENCES `teacher` (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8
INSERT INTO `student` (`id`, `name`, `tid`) VALUES ('1', '小明', '1');
INSERT INTO `student` (`id`, `name`, `tid`) VALUES ('2', '小红', '1');
INSERT INTO `student` (`id`, `name`, `tid`) VALUES ('3', '小张', '1');
INSERT INTO `student` (`id`, `name`, `tid`) VALUES ('4', '小李', '1');
INSERT INTO `student` (`id`, `name`, `tid`) VALUES ('5', '小王', '1');

student

@Data
public class Student {
    private int id;
    private String name;
    private int tid;
    private Teacher teacher;
}

teacher

@Data
public class Teacher {
    private int id;
    private String name;
}

StudentMapper

public interface StudentMapper {
    List<Student> getStudent();
}

TeacherMapper

public interface TeacherMapper {
    Teacher getTeacherById(int id);
}

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="com.zkc.mapper.StudentMapper">
    
        <resultMap id="StudentTeacher" type="student">
            <id property="id" column="id"/>
            <result property="name" column="name"/>
            <result property="tid" column="tid"/>
            <association property="teacher" column="tid" javaType="Teacher">
                <id property="id" column="id"/>
                <result property="name" column="name"/>
            </association>
        </resultMap>
    
        <select id="getStudent" resultMap="StudentTeacher">
          select * from student
        </select>
</mapper>

TeacherMapper.xml

一对多

Teacher

@Data
public class Teacher {
    private int id;
    private String name;

    private List<Student> studentList;
}

TeacherMapper

public interface TeacherMapper {
    List<Teacher> getTeacherById();
}

TeacherMapper.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.zkc.mapper.TeacherMapper">
    <resultMap id="TeacherMap" type="Teacher">
        <id property="id" column="id"/>
        <result property="name" column="tname"/>
        <collection property="studentList" ofType="Student">
            <id property="id" column="sid"/>
            <result property="name" column="sname"/>
            <result property="tid" column="stid"/>
        </collection>
    </resultMap>
    <select id="getTeacherById"  resultMap="TeacherMap">
        select
            t.id,t.name as tname,s.id as sid,s.name as sname,s.tid as stid
            from teacher t
            inner join student s
            on t.id = s.tid
    </select>
</mapper>

MyTest

@Test
public void getBy() {
    SqlSession sqlSession = MyBatisUtills.getSqlSession();
    TeacherMapper teacherMapper = sqlSession.getMapper(TeacherMapper.class);
    List<Teacher> list = teacherMapper.getTeacherById();
    for(Teacher teacher : list){
        System.out.println(teacher);
    }
    sqlSession.close();
}
        <id property="id" column="sid"/>
            <result property="name" column="sname"/>
            <result property="tid" column="stid"/>
        </collection>
    </resultMap>
    <select id="getTeacherById"  resultMap="TeacherMap">
        select
            t.id,t.name as tname,s.id as sid,s.name as sname,s.tid as stid
            from teacher t
            inner join student s
            on t.id = s.tid
    </select>
</mapper>

MyTest

@Test
public void getBy() {
    SqlSession sqlSession = MyBatisUtills.getSqlSession();
    TeacherMapper teacherMapper = sqlSession.getMapper(TeacherMapper.class);
    List<Teacher> list = teacherMapper.getTeacherById();
    for(Teacher teacher : list){
        System.out.println(teacher);
    }
    sqlSession.close();
}
wqww_1
关注
专栏目录
Maven&Mybatis简单了解
qq_45753879的博客
02-15 773
Maven&Mybatis Maven 概念: Maven是一个项目管理和构建工具,基于项目对象模型(POM)的概念,通过一小段描述信息来管理项目的构建,报告和文档 项目结构(IDEA从上往下) 名称 作用 maven-project 项目名称 src 源代码和测试代码目录 main 源代码目录 java 源代码Java文件目录 resources 源代码配置文件目录 webapp Web项目核心目录 test 测试代码目录 java 测试代码Java
eclipse_mybatis_maven_oracle逆向工程
阿瑟与非
08-03 693
效果图： 注意：generatorConfig.xml的目录一定要正确 pom.xml &lt;project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.o...
Maven+Mybatis一些简单例子
weixin_30299539的博客
12-05 188
一、创建maven工程 把依赖的包写在pom.xml中。保存后，工程会有错，需要在工程上右键选择“Maven-->Update Project” pom.xml内容为 <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance...
maven-mybaties-generator学习笔记整理
墨者的博客
08-24 271
MGB可以反向生成对应数据表的实体bean、mapper接口类以及对应的sqlmap.xml，关于该插件的详细介绍可以参考官方介绍。 接下来整理一下使用maven管理的SSM框架中如何使用mybaties-generator插件： 1、pom中引入插件 org.mybatis.generator mybatis-gene
myBatis实例
一人一屋淋雨声
05-05 283
mybatis 是一款优秀的支持自定义sql 查询、存储过程和高级映射的持久层框架，myBatis可以使用xml或者注解进行配置和映射，myBatis通过代码和参数映射到配置的sql形成的最终执行的sql语句Mybatis并没有将java对象与数据库关联起来，而是将java方法与sql语句关联myBatis支持数据缓存create database mybatis Default characte...
mybatis-plus-generator-maven-plugin-1.0.0.jar
11-15
为了在项目中快捷方便的代码生成，将mybatis-plus-generator封装为了一个maven的插件`mybatis-plus-generator-maven-plugin。使用文档参考：https://blog.csdn.net/xiweiller/article/details/103072165
mybatis-generator-maven-plugin-1.3.2.jar
02-26
java运行依赖jar包
mybatis-generator-maven-plugin-1.4.0.jar
02-26
java运行依赖jar包
mybatis-plus-generator-maven-plugin-1.0.0依赖的pom.xml
11-15
mybatis-plus-generator-maven-plugin-v1.0.0依赖的pom.xml，用于mybatis-plus-generator-maven-plugin-1.0.0.jar本地仓库上传时依赖使用
mybatis-generator-yml-maven-plugin：MyBatis Generator yml配置，lombok插件，swagger插件支持
02-04
English | 目的 默认情况下，使用yml配置来简化MyBatis Generator使用的xml配置 ...步骤1：确保您的项目是Maven项目，将mybatis-generator-yml-maven-plugin添加到您的maven pom.xml文件中： <groupId>
mybatis+maven+入门
jackieclzheng的专栏
04-17 275
MyBatis 1.1 概念 MyBatis 本是apache的一个开源项目iBatis, 2010年这个项目由apache software foundation 迁移到了google code，并且改名为MyBatis 。2013年11月迁移到Github。 iBATIS一词来源于“internet”和“abatis”的组合，是一个基于Java的持久层框架。iBATIS提供的持久层框架包...
Spring + mybaties + mysql + maven开发
qiu265843468的专栏
11-15 332
pom.xml <properties> <spring.version>4.1.5.RELEASE</spring.version> <mybatis.version>3.2.8</mybatis.version> <mybatis-spring.version>1.2.2</mybatis-spring.version> </properties> <!-
Maven,MyBatis详解
qq_62958114的博客
07-06 5382
maven、mybatis和mapper详解！
Maven搭建Mybatis框架详解
weixin_68768997的博客
03-05 2207
首先我们需要加载mybatis的核心配置文件，并获取sqlSessionFactory对象，并通过sqlsessionFactory对象获取执行SQL语句的sqlSession对象，调用查询方法selectList()方法，此时selectList方法中的变量即为userMapper.xml配置文件中的namespac.id，如此即可执行相关SQL语句，如图所示：（加载mybatis核心配置文件可在mybatis官网中寻找）此时，我们Maven项目的环境变量已经配置完成，接着创建一个Maven项目。
Maven+Mybatis的基本使用
热门推荐
CodeChen
10-22 1万+
  Maven:            是一个项目管理工具，负责管理项目开发过程中的几乎所有东西,主要用于项目构建，依赖管理，项目信息管理,Maven为开发者提供了一套完整的构建生命周期框架,开发团队几乎不用花多少时间就能够自动完成工程的基础构建配置,因为Maven使用了一个标准的目录结构和一个默认的构建生命周期,在有多个开发团队环境的情况下,Maven能够在很短的时间内使得每项工作都按照标准...
mybatis+maven实例
alu842517686的博客
03-27 6868
1、创建表，并插入数据： CREATE TABLE `alu`.`t_user` ( `USER_ID` int(11) NOT NULL AUTO_INCREMENT, `USER_NAME` char(30) NOT NULL, `USER_PASSWORD` char(10) NOT NULL, PRIMARY KEY (`USER_ID`), KEY `IDX_NAM
基于Maven的Mybatis入门
Loading的博客
08-01 4207
一、新建一个Maven项目 二、在pom.xml中添加依赖关系 &amp;lt;dependencies&amp;gt; &amp;lt;dependency&amp;gt; &amp;lt;groupId&amp;gt;org.mybatis&amp;lt;/groupId&amp;gt; &amp;lt;artifactId&amp;gt;mybatis&amp;
使用IDEA Maven搭建Mybatis环境
weixin_48279836的博客
03-10 1120
本文是使用IDEA Maven搭建Mybatis环境 涉及到的搭配环境 JDK1.8 Maven3.6.3 IDEA2019 MySQL数据库 一、Maven介绍 Maven 是一个项目管理工具，可以对 Java 项目进行构建、依赖管理，是一个自动化构建工具。 自动化构建工具：将原材料（java、js、css、html....）->产品（可发布项目） 编译-打包-部署-测试 -> 自动构建。 二、Mybatis介绍 MyBatis 本是a..
在Maven中配置Mybatis
weixin_45802810的博客
07-10 3823
前期准备 1、首先，创建一个Maven项目，如果不了解如何创建的话请看往期博客，先创一个父Maven项目batis-maven，接着再创建一个Maven子项目mybatis-01,然后在父项目的pom.xml中配置相关信息，在子Maven项目中去进行功能的测试 <?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http:/
mybatis-generator-maven-plugin 1.3.2
最新发布
04-29
mybatis-generator-maven-plugin 1.3.2 是一个Maven插件，用于生成Mybatis框架的Mapper接口和XML映射文件以及Java模型类。该插件的主要作用是自动生成相关的Java代码和XML文件，从而简化开发人员的工作量和时间成本...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值