Query를 Mapper에 전달하여 실행시키는 방법

Posted by 단순대왕 Spring/MyBatis : 2015. 4. 16. 13:47

@Autowired 

CustomerEventMapper customerEventMapper;


@Test

public void test() {

String queryString = "select titleEng from TABLE where id = '100'";

SQLAdapterVO sqlAdapter = new SQLAdapterVO();

sqlAdapter.setSqlQuery(queryString);

String titleEng = customerEventService.testService(sqlAdapter);

}


public class SQLAdapterVO implements Serializable {

private static final long serialVersionUID = 1L;

private String sqlQuery;


public String getSqlQuery() {

return sqlQuery;

}


public void setSqlQuery(String sqlQuery) {

this.sqlQuery = sqlQuery;

}


public static long getSerialversionuid() {

return serialVersionUID;

}


@Override

public String toString() {

return "SQLAdapterVO [sqlQuery=" + sqlQuery + "]";

}

}


<mapper namespace="com.user.CustomerEventMapper">

<select id="testService" resultType="java.lang.String"  parameterType="com.service.SQLAdapterVO">

${sqlQuery}

</select>

</mapper>

'Spring > MyBatis' 카테고리의 다른 글

MyBatis 객체의 생명 주기  (0) 2014.11.06
MyBatis API  (0) 2014.11.06
  
 «이전 1 ··· 4 5 6 7 8 9 10 ··· 77  다음»