ÃֽŠ°Ô½Ã±Û(JAVA)
2017.04.27 / 19:29
MyBatis3 resultTypeÀ» ÀÚ¹ÙºóÀ¸·Î ÁöÁ¤Çϱâ
Scoda
Ãßõ ¼ö 195
myBatis ¿¡¼´Â ´Ù¾çÇÑ ÇüÅÂÀÇ resultTypeÀ» Á¦°øÇÑ´Ù.
ƯÈ÷ ¿©·¯ µ¥ÀÌÅÍÀÇ °ªµéÀ» ¹Þ¾Æ¾ß ÇÏ´Â °æ¿ì HashMapÀ» ÁÖ·Î ¸¹ÀÌ »ç¿ëÇϴµ¥, ÇÊ¿ä¿¡ µû¶ó VO¸¦ »ç¿ëÇØ¾ß ÇÒ¶§°¡ ÀÖ´Ù.
±×·¡¼ myBatis¿¡¼´Â resultTypeÀ¸·Î ÀÚ¹Ùºó°ú °°Àº VO¸¦ ÁöÁ¤ÇÒ¼ö ÀÖ´Ù.
VO¸¦ »ç¿ëÇϸé mybatis´Â °á°ú°ªÀ» voÀÇ setter¸¦ ÀÌ¿ëÇÏ¿© ³Ö¾îÁÖ°Ô µÇ°í, ÀÌ¿ëÀÚ´Â getter¸¦ ÅëÇؼ ÇØ´ç µ¥ÀÌÅ͸¦ »ç¿ëÇÏ¸é µÈ´Ù.
1. VO ÀÛ¼º
package
com.test.vo;
public
class
TestVo {
// ID
int
id ;
// À̸§
String name ;
public
int
getId() {
return
id;
}
public
void
setId(
int
id) {
this
.id = id;
}
public
String getName() {
return
name;
}
public
void
setName(String name) {
this
.name = name;
}
}
2. Äõ¸® ÀÛ¼º
<
select
id
=
"getContentsP"
parameterType
=
"hashmap"
resultType
=
"com.test.vo.TestVo"
>
SELECT
id, name
FROM
TB_Test
WHERE
id = #{name} and age = #{age}
</
select
>
<
select
id
=
"getContentsPList"
resultType
=
"com.test.vo.TestVo"
>
SELECT
id, name
FROM
TB_test
</
select
>
3. sql È£Ãâ ¹× µ¥ÀÌÅÍ ÀÌ¿ëÇϱâ
<%@ page language=
"java"
contentType=
"text/html; charset=UTF-8"
pageEncoding=
"UTF-8"
%>
<%
@page
import
=
"com.test.sqlMap.SqlSessionManager"
%>
<%
@page
import
=
"org.apache.ibatis.session.SqlSessionFactory"
%>
<%
@page
import
=
"org.apache.ibatis.session.SqlSession"
%>
<%
@page
import
=
"java.util.*"
%>
<%
@page
import
=
"com.test.vo.*"
%>
<%
SqlSessionFactory sqlSessionFactory = SqlSessionManager.getSqlSession();
SqlSession sqlSession = sqlSessionFactory.openSession();
try
{
// HashMap parameter ³Ñ°Ü¼ ´ÜÀÏ Çà °¡Á®¿À±â
HashMap pHm =
new
HashMap();
pHm.put(
"name"
,
"È«±æµ¿"
) ;
pHm.put(
"age"
,
"28"
) ;
// ´ÜÀÏ Çà °¡Á®¿À±â
TestVo testVo = sqlSession.selectOne(
"Test.getContentsP"
, pHm) ;
// Ãâ·ÂÇϱâ
System.out.println(testVo.getId()) ;
System.out.println(testVo.getName()) ;
// º¹¼ö Çà °¡Á®¿À±â
List<TestVo> list = sqlSession.selectList(
"Test.getContentsList"
) ;
for
(
int
i=
0
; i < list.size(); i++){
TestVo testpVo = list.get(i) ;
// Ãâ·ÂÇϱâ
System.out.println(testpVo.getId()) ;
System.out.println(testpVo.getName()) ;
}
}
catch
(Exception e){
e.printStackTrace() ;
}
finally
{
sqlSession.close() ;
}
%>
TIP) Vo´Â resultType »Ó¸¸ ¾Æ´Ï¶ó parameterTypeÀ¸·Îµµ ÁöÁ¤ÀÌ °¡´ÉÇÏ´Ù.
Ãâó: http://fruitdev.tistory.com/32 [°úÀÏ°¡°Ô °³¹ßÀÚ]
Ãâó: http://fruitdev.tistory.com/32 [°úÀÏ°¡°Ô °³¹ßÀÚ]