mybatis搭建流程和错误解决

mybatis搭建

一、引入依赖包pom.xml

<!--mysql-->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.6</version>
</dependency>
<!--mybatis坐标-->
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.5.4</version>
</dependency>
<!-- 分页助手 -->
<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper</artifactId>
    <version>3.7.5</version>
</dependency>

<dependency>
    <groupId>com.github.jsqlparser</groupId>
    <artifactId>jsqlparser</artifactId>
    <version>0.9.1</version>
</dependency>

二、resources配置文件

1.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>
    <!--加载properties文件-->
    <properties resource="jdbc.properties"></properties>
    <!--设置别名-->
    <typeAliases>
        <!--方式一：给单个实体起别名-->
        <!-- <typeAlias type="com.lagou.domain.User" alias="user"></typeAlias>-->
        <!--方式二：批量起别名 别名就是类名，且不区分大小写-->
        <package name="com.zx.model"/>
    </typeAliases>
    <plugins>
        <plugin interceptor="com.github.pagehelper.PageHelper">
            <!--dialect: 指定方言 limit-->
            <property name="dialect" value="mysql"/>
        </plugin>
    </plugins>
    <!--environments: 运行环境-->
    <environments default="development">
        <environment id="development">
            <!--当前的事务事务管理器是JDBC-->
            <transactionManager type="JDBC"></transactionManager>
            <!--数据源信息 POOLED：使用mybatis的连接池-->
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>
    <!--引入映射配置文件-->
    <mappers>
        <!--批量加载映射-->
        <!--需要xml和java mapper接口 同包同名-->
        <package name="com.zx.mapper"/>
    </mappers>
</configuration>

2.jdbc.properties的文件

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://service.cf:3306/db_web?useSSL=false&characterEncoding=utf-8&timeZone=CST
jdbc.username=root
jdbc.password=HBQ521521cf*

3.日志（非必须）

### direct log messages to stdout ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### direct messages to file mylog.log ###
log4j.appender.file=org.apache.log4j.FileAppender
log4j.appender.file.File=c:/mylog.log
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### set log levels - for more verbose logging change 'info' to 'debug' ###
log4j.rootLogger=debug, stdout

三、用mybatis代替UserDao里面的方法原始jdbcutil

1.注解形式实现mapper方法

//通过用户名查询用户
@Select("select * from user where userName = #{userName}")
User selectPasswordByUser(@Param("userName") String userName);

//增加用户
@Insert("insert into user(username,password,sex,age,major) values(#{user.userName},#{user.password},#{user.sex},#{user.age},#{user.major})")
int createUser(@Param("user") User user);
   
//修改用户
@Update("update user set password = #{setUser.setPassword} where userName = #{setUser.userName} and password = #{setUser.password}")
int setPassword(@Param("setUser") SetUser setUser); 
   
//删除用户
@Delete("delete from user where id =#{id} ")
int deleteUser(@Param("id") Integer id); 

2.xml配置文件来mapper实现

四 、 用UserMapper所产生的代理对象来代替UserDao来调用方法

// 加载配置文件
InputStream is = Resources.getResourceAsStream("SqlMapConfig.xml"); 
// 获取SqlSessionFactory工厂对象 
SqlSessionFactory sqlSessionFactory = newSqlSessionFactoryBuilder().build(is); 
// 获取SqlSe会话对象 
SqlSession sqlSession = sqlSessionFactory.openSession(); 
// 执行sql

// 当前返回的 其实是基于UserMapper所产生的代理对象：底层：JDK动态代理 实际类型：proxy
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
//事务提交
sqlSession.commit();
//关闭session
sqlSession.close();

五、分页插件

//pageNum设置当前页数，pageSize每页条数
PageHelper.startPage(Integer.parseInt(pageNum),Integer.parseInt(pageSize));
List<User> users = mapper.selectUserList(userListDTO);
// 获取分页相关的其他参数
PageInfo<User> pageInfo = new PageInfo<User>(users);
System.out.println("总条数"+ pageInfo.getTotal());
System.out.println("总页数"+ pageInfo.getPages());

//获取真正的列表
List<User> list = pageInfo.getList();

---

注意事项

• 除了select,剩下的增，改，删，都需要手动提交事务，关闭资源sqlSession.commit();