<!-- 学生端登录 -->
<select id="login" resultMap="maplogin">
select * from student where stu_id = #{stuId} and stu_pwd = #{stuPwd}
<lect>
<!-- 查询学生信息 -->
<select id="selectStudent" resultMap="maplogin">
select * from student
<lect>
<resultMap id="maplogin" type="com.example.bean.Student">
<id property="stuId" column="stu_id" />
<id property="graId" column="gra_id" />
<result property="stuName" column="stu_name" />
<result property="stuGrade" column="stu_grade" />
<result property="stuSex" column="stu_sex" />
<result property="stuPwd" column="stu_pwd" />
</resultMap>
<select id="login" resultMap="maplogin">
select * from student where stu_id = #{stuId} and stu_pwd = #{stuPwd}
<lect>
<!-- 查询学生信息 -->
<select id="selectStudent" resultMap="maplogin">
select * from student
<lect>
<resultMap id="maplogin" type="com.example.bean.Student">
<id property="stuId" column="stu_id" />
<id property="graId" column="gra_id" />
<result property="stuName" column="stu_name" />
<result property="stuGrade" column="stu_grade" />
<result property="stuSex" column="stu_sex" />
<result property="stuPwd" column="stu_pwd" />
</resultMap>