mybatis 支持输出的打印

mybatis:
  mapper-locations: classpath:mapper/*.xml
  type-aliases-package: com.dtyy.pojo
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

这个错误就是某个字段为nil了,或者某个字段超过长度限制了

Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@43a67c8c] was not registered for synchronization because synchronization is not active
JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@3bbc5cc8] will not be managed by Spring

用户相关

<?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.dtyy.dao.UserDao">

    <select id="getAllUsers" resultType="User">
        SELECT * from t_users
    </select>

    <select id="getUserById" resultType="User">
        select * from t_users where user_id = #{user_id}
    </select>

    <insert id="addUser" parameterType="User">
        insert into t_users (user_id,password,username,avatar,gender,role,register_time,mail) values (#{user_id},#{password},#{username},#{avatar},#{gender},#{role},#{register_time},#{mail})
    </insert>

    <delete id="deleteUser" parameterType="String">
        delete from t_users where user_id = #{user_id}
    </delete>

    <update id="updateUser" parameterType="User">
        update t_users set password = #{password},username = #{username},avatar = #{avatar},gender = #{gender},role = #{role},register_time = #{register_time},mail = #{mail} where user_id = #{user_id}
    </update>

</mapper>

option相关

<?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.dtyy.dao.OptionDao">
    <select id="getAllOptions" resultType="Option">
        SELECT * from t_options
    </select>

    <select id="getOption" resultType="Option">
        select * from t_options where option_id = #{option_id}
    </select>

    <insert id="addOption" parameterType="Option">
        insert into t_options (option_id,name,description) values (#{option_id},#{name},#{description})
    </insert>

    <delete id="deleteOption" parameterType="String">
        delete from t_options where option_id = #{option_id}
    </delete>

    <update id="updateOption" parameterType="Option">
        update t_options set name = #{name},description = #{description} where option_id = #{option_id}
    </update>

</mapper>