ibatis에서 map 사용하기.

ibatis에서 다들 list를 쓰고 있는데, map도 지원된다.

queryForMap() 메소드를 활용하면 Map을 리턴한다.

 

 

 

 

출처:

http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+get+a+Map+of+results+instead+of+a+List

 

The following section will explain in detail how to use the queryForMap().

The queryForMap()'s are most useful when you need to work with the result of a query. In the example below I will use a query that return Student objects as a result. Lets start with the Student class.

Student.java

public class Student implements java.io.Serializable {

private String id, firstName, lastName;

public String getId() {
    return id;
}

public void setId(String id) {
    this.id = id;
}

public String getFirstName() {
    return firstName;
}

public void setFirstName(String firstName) {
    this.firstName = firstName;
}

public String getLastName() {
    return lastName;
}

public void setLastName(String lastName) {
    this.lastName = lastName;
}

And now the SqlMap ....

<resultMap id="studentResult" class="com.domain.Student">
    <result column="id" property="id" />
    <result column="first_name" property="firstName" />
    <result column="last_name" property="lastName" />
</resultMap>

<select id="getAllStudents" resultMap="studentResult">
select
    *
from students
</select>

Now that the basics are out of the way query away!

Lets say that you need to do some fast serching on the returned students. The best way is to have a Map of the Student objects to their id's.

This is where the queryForMap() comes into play. There are two different options and both will be dicussed. The first is perfect for the example given above.

public Map getAllStudents() {

    Map<String, Student> studentsMap = queryForMap("getAllStudents", null, "id");

    Student student = studentsMap.get("123456");
    
    ...
}

You can see that the third parameter in the call looks for the property "id" in the result map and then creates the map with that property as the key.

The second option allow you to specify both the key and the value.

Map<String, String> studentsMap = queryForMap("getAllStudents", null, "id", "firstName");

The above code will return a Map with the id as the key and the firstName as the value.

There are many other uses for these method so feel free to add them on

 

 

'DB' 카테고리의 다른 글

mysql에서 버젼보기  (0)	2007.10.19
ERR=12505 에러  (1)	2007.10.11
delete, truncate, drop의 차이점  (0)	2007.09.27
<img src="http://blogimgs.naver.com/nblog/ico_scrap01.gif" class="i_scrap" width="50" height="15" alt="본문스크랩" /> [강좌] 프레임?p없이 &quot;IBatis 처음 사용하기&quot; 슈퍼 초..  (0)	2007.09.23
ORA-01013 에러  (0)	2007.09.23

Posted by '김용환'

,