out/artifacts/StuSystem_war_exploded/WEB-INF/classes/com/stusystem/mappings/UserDao.xml

微信扫码关注公众号，代码整理好后第一时间通知你。

<?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"> 

<!-- namesapce ,DAO的package路径  -->
<mapper namespace="com.stusystem.dao.UserDao">
	<!-- 根据用户输入的用户名和密码查询是否存在此用户  -->
	<select id="getUsrInfoByNameAndPsw" parameterType="com.stusystem.entity.Userbean" resultType="com.stusystem.entity.Userbean">
		select * from user where user_id=#{userId} and password=#{password} and admin=#{admin}
	</select>
	<!-- 修改登录用户的密码  -->
	<update id="mmxg" parameterType="com.stusystem.entity.Userbean">
		UPDATE user SET password = #{xmm} WHERE (user_id=#{userId})
	</update>
	
	<insert id="userAdd" parameterType="com.stusystem.entity.Userbean">
		INSERT INTO `user` (`user_id`, `user_name`, `password`, `admin`) VALUES (#{userId},#{userName},#{password},#{admin})
	</insert>
	
</mapper>