<?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.gm.dao.MajorDao">`在这里插入代码片`
<!--查询所有专业-->
<select id="findAll" resultType="Major">
select * from major
</select>
<!--添加专业-->
<insert id="addMajor" parameterType="Major">
INSERT INTO major (mbh,mname,mdesc) VALUES (#{mbh},#{mname},#{mdesc});
</insert>
<!--删除专业-->
<delete id="delMajor" parameterType="Integer">
delete from major where id = #{id}
</delete>
<!--根据id查询-->
<select id="findById" parameterType="Integer" resultType="Major">
select * from major where id = #{id}
</select>
<!--更新专业-->
<update id="updMajor" parameterType="Major">
update major set mbh = #{mbh},mname = #{mname},mdesc = #{mdesc} where id = #{id}
</update>
<!--模糊查询-->
<select id="findByMh" parameterType="String" resultType="Major">
SELECT *
FROM major
WHERE mname LIKE CONCAT('%',#{mname},'%')
</select>
</mapper>
<?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.gm.dao.UserDao">
<select id="findByUsername" parameterType="String" resultType="User">
select * from user where username = #{username}
</select>
<update id="updPw" parameterType="User">
update user set password = #{newpwd} where id = #{id}
</update>
</mapper>
Processed:
0.012, SQL:
9
