How do I create an Object in Mybattis (Spring) mapper using select on a table (Spring)



I am new to MyBatis-Spring. I have two SQL tables lets say A list of Universities and a list of Students


UNIVERISTY table has id, name, listOfStudents


STUDENTS table has name_ofStudent, GPA, age, major, id, universityId


I have University.java, Student.java, UniversityManager.java, StudentManager.java (both with crud operations in their manager) (read's parameter is an int id)


if this is my UniversityMapper.xml (Below) How do I "SELECT" (by ID) a University? I know how the basic select works but my main question is once I select get by id the name of the university how do I also so get the list of students belonging to that students. I want to know how to select using mybatis the list of students that match the universityID and create a student object and make it part of the universty object. PLEASE Urgent Help!



<?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="java.University">
<resultMap id="BaseResultMap" type="java.University">
<id column="ID" jdbcType="VARCHAR" property="id" />
<result column="NAME" jdbcType="VARCHAR" property="name" />
</resultMap>
<insert id="createUniversity" parameterType="java.University">
insert into DATABASE.University(ID, NAME)
values (#{id,jdbcType=VARCHAR}, #{name,jdbcType=VARCHAR})
</insert>

<select id="getUniversity" parameterType="int" resultMap="java.University">

THIS IS WHERE I NEED HELP!
THIS IS WHERE I NEED HELP!
THIS IS WHERE I NEED HELP!

</select>

<update id="updateUniversity" parameterType="java.University">
update DATABASE.University
set ID= #{id,jdbcType=VARCHAR},
NAME= #{name,jdbcType=VARCHAR}
</update>
<delete id="deleteUniversity" parameterType="java.University">
delete from DATABASE.University
where ID= #{id,jdbcType=VARCHAR}
</delete>
</mapper>


THANK YOU!


No comments:

Post a Comment