Need not to know

缓存我寻见一片海 碧蓝且耀着光大片船只航行其上 都向着远方                          Shared by Foriver_江河 © 1997-8023 江河 All Rights Reserved....

动态SQL<if>标签有序列表定义列表choose (when, otherwise)trim (where, set)foreach<if>标签<select id="getUserListIf" parameterType="map" resultType="User"> SELECT * FROM study.user WHERE userProperties is not null <if test="userName != null

〖代码〗MybatisUtil工具类package utils;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.IOExceptio

〖代码〗Mybatis核心配置文件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> <!--引入数

〖代码〗mapper映射文件UserMapper.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="dao.UserDao"> <sel

Mybatis框架的jar包说明jar包文件名说明asm-xxx.jar操作java字节码的类库cglib-xxx.jar用来动态集成java类或实现接口commons-logging-xxx.jar用于通用日志处理javassist-xxx-GA.jar分析、编辑和创建java字节码的类库log4j-xxx.jar日志系统slf4j-api-xxx.jar日志系统的封装，对外提供统一的API接口slf4j-log4j12-xxx.jar

解决模糊查询    1.java代码执行的时候，传递通配符%%List<User> userList = mapper.getUserLike("%李%");    2.在SQL拼接中使用通配符%%SELECT * FROM study.user WHERE userName LIKE "%"#{userName}"%";我寻见一片海 碧蓝且耀着光大片船只航行其上 都向着远方  &nbs