第一步,通过maven配置mysql的包
复制maven的配置粘贴到porn.xml文件中
3. 配置MyBatis启动版本
利用SpringBoot配置MyBatis,SpringBoot的配置文件都写在下面文件中
创建与数据库文件对应的实体类
使用快捷键生成Get和Set方法
新建一个Dao包中的UserMap方法,用来与数据操作的SQL对应
下一步,需要配置一个文件,将这些方法与对应的SQL语句关联起来
在资源文件中,创建一个mapper文件
下面写对应的配置文件
里面包含了增删改查以及其对应的SQL
<?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.nowcoder.community.dao.UserMapper">
<sql id="insertFields">
username, password, salt, email, type, status, activation_code, header_url,
create_time
</sql>
<sql id="selectFields">
id, username, password, salt, email, type, status, activation_code, header_url,
create_time
</sql>
<select id="selectById" resultType="User">
select <include refid="selectFields"></include>
from user
where id = #{id}
</select>
<select id="selectByName" resultType="User">
select <include refid="selectFields"></include>
from user
where username = #{username}
</select>
<select id="selectByEmail" resultType="User">
select <include refid="selectFields"></include>
create_time from user
where username = #{username}
</select>
<insert id="insertUser" parameterType="User" keyProperty="id">
insert into user (<include refid="insertFields "></include>)
values(#{username},#{password},#{salt},#{email},#{type},#{status},
#{activationCode},#{headerUrl},#{createTime})
</insert>
<update id="updateStatus">
update user set status = #{status} where id = #{id}
</update>
<update id="updateHeader">
update user set header_url = #{headerUrl} where id = #{id}
</update>
<update id="updatePassword">
update user set password = #{password} where id = #{id}
</update>
</mapper>
测试,报了一大堆错,不知道怎么搞
作业