数据层
2022-05-14 本文已影响0人
如果大雨落下
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>
