不知道哪里出了问题
相关代码:
package com.imooc.mybatis.entity; public class Student { private Integer id; private Integer regNo; private String name; private String sex; private Integer age; private String grade; private String major; private String classNo; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public Integer getRegNo() { return regNo; } public void setRegNo(Integer regNo) { this.regNo = regNo; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } public Integer getAge() { return age; } public void setAge(Integer age) { this.age = age; } public String getGrade() { return grade; } public void setGrade(String grade) { this.grade = grade; } public String getMajor() { return major; } public void setMajor(String major) { this.major = major; } public String getClassNo() { return classNo; } public void setClassNo(String classNo) { this.classNo = classNo; } @Override public String toString() { return "Student{" + "id=" + id + ", regNo=" + regNo + ", name='" + name + '\'' + ", sex='" + sex + '\'' + ", age=" + age + ", grade='" + grade + '\'' + ", major='" + major + '\'' + '}'; } }
相关代码:
package com.imooc.mybatis.entity; import java.util.List; public class Classes { private Integer id; private String classNo; private String name; private String major; private List<Student> student; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getClassNo() { return classNo; } public void setClassNo(String classNo) { this.classNo = classNo; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getMajor() { return major; } public void setMajor(String major) { this.major = major; } public List<Student> getStudent() { return student; } public void setStudent(List<Student> student) { this.student = student; } }
相关代码:
//作业 @Test public void testOneToMany1(){ List<Classes> list = session.selectList("classes.selectByClassNo"); for (Classes classes:list){ System.out.println(classes.getName()+":"+classes.getStudent().size()); } }
相关代码:
<?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="classes"> <resultMap id="a" type="com.imooc.mybatis.entity.Classes"> <id property="id" column="id"/> <collection property="classNo" select="s.selectByClassNo" column="class_no"/> </resultMap> <select id="selectByClassNo" resultMap="a"> select * from classes limit 0,1; </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="s"> <select id="haha" resultType="com.imooc.mybatis.entity.Student"> select * from student order by id </select> <insert id="insert" parameterType="com.imooc.mybatis.entity.Student"> insert into student(reg_no, name,sex,age,grade,major) values (#{regNo},#{name},#{sex},#{age},#{grade},#{major}) <selectKey keyProperty="id" resultType="Integer" order="AFTER"> select last_insert_id() </selectKey> <!-- <selectKey resultType="Integer" keyProperty="id" order="AFTER">--> <!-- select last_insert_id();--> <!-- </selectKey>--> </insert> <select id="dynamicSQL" parameterType="java.util.Map" resultType="com.imooc.mybatis.entity.Student"> select * from student <where> <if test="age != null"> and age >#{age} </if> <if test="sex != null"> and sex =#{sex} </if> </where> </select> //这是自由编程的代码 <select id="selectByClassNo" parameterType="String" resultType="com.imooc.mybatis.entity.Student"> select * from student where class_no=#{value} </select> </mapper>
相关代码:
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <settings> <setting name="mapUnderscoreToCamelCase" value="true"/> </settings> <environments default="dev"> <environment id="dev"> <transactionManager type="JDBC"></transactionManager> <dataSource type="POOLED"> <property name="driver" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/school?useUnicode=true&characterEncoding=UTF-8"/> <property name="username" value="root"/> <property name="password" value="abc123456"/> </dataSource> </environment> </environments> <mappers> <mapper resource="mappers/goods.xml"/> <mapper resource="mappers/goods_detail.xml"/> <mapper resource="mappers/student.xml"/> <mapper resource="mappers/classes.xml"/> </mappers> </configuration>
相关截图:
13
收起
正在回答 回答被采纳积分+1
1回答
恭喜解决一个难题,获得1积分~
来为老师/同学的回答评分吧
0 星