Mybaties一对一。一对多
<resultMap type="com.icss.mybaties.Pojo.User" id="mybatiesClass">
<!-- 手工匹配java类中的变量名和数据库的变量名 property javabean文件里面的变量名匹配数据库的段名column -->
<result property="idd" column="id" />
<result property="user_name" column="user" />
<!--property这个是teacher创建的teacher类对象 column对应主表的列名 -->
<!-- 一对一查询 -->
<association property="teacher" column="user_name" select="findbyteachername"
fetchType="lazy">
</association>
<!-- 一对多查询 -->
<collection
property="studentList"
column="user_name"
select="findstudent"
fetchType="lazy">
</collection>
</resultMap>//下面是子表单查询
<select id="findbyteachername" resultType="com.icss.mybaties.Pojo.teacher">
select * from teacher where tname=#{tname}
</select>
<!-- 自增序列 -->
<insert keyProperty="id" useGeneratedKeys="true" id="insertT" >
insert into test
(myname)
values
(#{myname})
</insert>