mybatis\u4e0a\u3067SQL\u306b\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u52d5\u7684\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u6e21\u3059\u65b9\u6cd5\u306f2\u901a\u308a\u3042\u308a\u307e\u3059\u3002<\/p>\n
\u5b9f\u884c\u6642\u306bSQL\u306b\u5408\u308f\u305b\u3066\u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u578b\u3092\u5909\u3048\u3066\u304f\u308c\u308b\u3002\uff08”\u3067\u56f2\u3080\u3068\u304b)
\n\u7528\u9014\uff1awhere\u53e5\u306e\u6761\u4ef6\u3092\u52d5\u7684\u306b\u3059\u308b\u3068\u304b\u3002<\/p>\n
mybatis\u4e0a\u306eSQL\u8a18\u8ff0\u5185\u5bb9
\n\uff08poge\u306fchar\u578b\u3060\u3068\u3059\u308b\uff09<\/p>\n
\r\nSELECT\r\n hoge,\r\n poge,\r\nFROM\r\n hoge_table\r\nWHERE\r\n poge = #{pogeNumber}\r\n<\/pre>\n\u2193
\npogeNumber\u306b1\u3092\u8a2d\u5b9a\u3002
\n\u2193
\n\u5b9f\u969b\u306b\u51e6\u7406\u3055\u308c\u308bSQL\u6587<\/p>\n
\r\nSELECT\r\n hoge,\r\n poge,\r\nFROM\r\n hoge_table\r\nWHERE\r\n poge = '1'\r\n<\/pre>\n${ }<\/h4>\n
\u6307\u5b9a\u3055\u308c\u305f\u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u5024\u3092\u305d\u306e\u307e\u307e\u6e21\u3059\u3002
\n\u7528\u9014\uff1aSQL\u5b9f\u884c\u5bfe\u8c61\u306e\u30c6\u30fc\u30d6\u30eb\u3084\u53d6\u5f97\u5bfe\u8c61\u306e\u30ab\u30e9\u30e0\u3092\u52d5\u7684\u306b\u3059\u308b\u3068\u304b\u3002<\/p>\n
mybatis\u4e0a\u306eSQL\u8a18\u8ff0\u5185\u5bb9<\/p>\n
\r\nSELECT\r\n hoge,\r\n poge,\r\nFROM\r\n ${tableName}_table\r\nWHERE\r\n poge = '1'\r\n<\/pre>\n\u2193
\n${tableName}\u306bhoge\u3092\u8a2d\u5b9a\u3002
\n\u2193
\n\u5b9f\u969b\u306b\u51e6\u7406\u3055\u308c\u308bSQL\u6587<\/p>\n
\r\nSELECT\r\n hoge,\r\n poge,\r\nFROM\r\n hoge_table\r\nWHERE\r\n poge = '1'\r\n<\/pre>\n\u4e8b\u8c61<\/h3>\n
\u4eca\u56de\u306f\u3001${}\u3092\u4f7f\u3063\u3066\u30c6\u30fc\u30d6\u30eb\u3092\u52d5\u7684\u306b\u5909\u3048\u3088\u3046\u3068\u3057\u3066\u3044\u307e\u3057\u305f\u3002<\/p>\n
mybatis\u7528\u30a4\u30f3\u30bf\u30d5\u30a7\u30fc\u30b9<\/p>\n
\r\npublic interface HogeRepository {\r\n HogeDTO searchHogeTable(String pogeNumber);\r\n}\r\n<\/pre>\nmybatisSQL\u7528xml<\/p>\n
\r\n<?xml version="1.0" encoding="UTF-8"?>\r\n<!DOCTYPE mapper PUBLIC "-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN"\r\n "http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd">\r\n\r\n<mapper namespace="hoge.repository.HogeRepository">\r\n <select id="searchHogeTable" resultMap="HogeDTO" parameterType="string">\r\n <![CDATA[\r\n SELECT\r\n hoge,\r\n poge,\r\n FROM\r\n ${tableName}_table\r\n WHERE\r\n poge = '1'\r\n ]]>\r\n <\/select>\r\n<\/mapper>\r\n<\/pre>\nSQL\u5b9f\u884c
\n#{}\u3068\u540c\u3058\u30ce\u30ea\u3067\u5b9f\u884c\u3055\u305b\u3088\u3046\u3068\u3057\u3066\u3044\u307e\u3057\u305f\u3002<\/p>\n
\r\nString tabelName = "hoge";\r\nHogeDTO hogeDto = repository.searchHogeTable(tabelName);\r\n<\/pre>\n\u30a8\u30e9\u30fc\u5185\u5bb9<\/h3>\n\r\n[2018\/02\/09 14:20:39] [main] [o.s.b.c.s.AbstractStep] [ERROR] Encountered an error executing step hoge.step01 in job hoge\r\norg.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'tableName' in 'class java.lang.String'\r\n\tat org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)\r\n\tat org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)\r\n\tat com.sun.proxy.$Proxy17.selectOne(Unknown Source)\r\n\tat org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166)\r\n\tat org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:82)\r\n\tat org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)\r\n\tat com.sun.proxy.$Proxy19.getKinkoInfo(Unknown Source)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)\r\n\tat java.lang.reflect.Method.invoke(Unknown Source)\r\n\tat org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)\r\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)\r\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)\r\n\tat org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)\r\n\tat org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)\r\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)\r\n\tat org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)\r\n\tat com.sun.proxy.$Proxy9.execute(Unknown Source)\r\n\tat org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:406)\r\n\tat org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:330)\r\n\tat org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)\r\n\tat org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:271)\r\n\tat org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:81)\r\n\tat org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:374)\r\n\tat org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:215)\r\n\tat org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:144)\r\n\tat org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:257)\r\n\tat org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:200)\r\n\tat org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:148)\r\n\tat org.springframework.batch.core.job.flow.JobFlowExecutor.executeStep(JobFlowExecutor.java:64)\r\n\tat org.springframework.batch.core.job.flow.support.state.StepState.handle(StepState.java:67)\r\n\tat org.springframework.batch.core.job.flow.support.SimpleFlow.resume(SimpleFlow.java:169)\r\n\tat org.springframework.batch.core.job.flow.support.SimpleFlow.start(SimpleFlow.java:144)\r\n\tat org.springframework.batch.core.job.flow.FlowJob.doExecute(FlowJob.java:134)\r\n\tat org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:306)\r\n\tat org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:135)\r\n\tat org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)\r\n\tat org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:128)\r\n\tat org.springframework.batch.core.launch.support.CommandLineJobRunner.start(CommandLineJobRunner.java:362)\r\n\tat org.springframework.batch.core.launch.support.CommandLineJobRunner.main(CommandLineJobRunner.java:592)\r\nCaused by: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'tableName' in 'class java.lang.String'\r\n\tat org.apache.ibatis.reflection.Reflector.getGetInvoker(Reflector.java:422)\r\n\tat org.apache.ibatis.reflection.MetaClass.getGetInvoker(MetaClass.java:164)\r\n\tat org.apache.ibatis.reflection.wrapper.BeanWrapper.getBeanProperty(BeanWrapper.java:162)\r\n\tat org.apache.ibatis.reflection.wrapper.BeanWrapper.get(BeanWrapper.java:49)\r\n\tat org.apache.ibatis.reflection.MetaObject.getValue(MetaObject.java:122)\r\n\tat org.apache.ibatis.scripting.xmltags.DynamicContext$ContextMap.get(DynamicContext.java:94)\r\n\tat org.apache.ibatis.scripting.xmltags.DynamicContext$ContextAccessor.getProperty(DynamicContext.java:108)\r\n\tat org.apache.ibatis.ognl.OgnlRuntime.getProperty(OgnlRuntime.java:2666)\r\n\tat org.apache.ibatis.ognl.ASTProperty.getValueBody(ASTProperty.java:114)\r\n\tat org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)\r\n\tat org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)\r\n\tat org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:467)\r\n\tat org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:431)\r\n\tat org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:44)\r\n\tat org.apache.ibatis.scripting.xmltags.TextSqlNode$BindingTokenParser.handleToken(TextSqlNode.java:77)\r\n\tat org.apache.ibatis.parsing.GenericTokenParser.parse(GenericTokenParser.java:78)\r\n\tat org.apache.ibatis.scripting.xmltags.TextSqlNode.apply(TextSqlNode.java:51)\r\n\tat org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:33)\r\n\tat org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:41)\r\n\tat org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:292)\r\n\tat org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)\r\n\tat org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)\r\n\tat org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)\r\n\tat org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)\r\n\tat java.lang.reflect.Method.invoke(Unknown Source)\r\n\tat org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)\r\n\t... 41 common frames omitted\r\n<\/pre>\n\u539f\u56e0<\/h3>\n
\u3069\u3046\u3084\u3089String\u578b\u306f#{}\u306f\u4f7f\u3048\u308b\u3051\u3069\u3001${}\u306b\u5165\u308c\u308b\u30d1\u30e9\u30e1\u30fc\u30bf\u3068\u3057\u3066\u306f\u4f7f\u3048\u306a\u3044\u3089\u3057\u3044\u3002
\n${}\u3092\u4f7f\u7528\u3059\u308b\u5834\u5408\u3001Map\u578b\u3092\u4f7f\u3046\u3002
\n\u307e\u305f\u306f\u30d1\u30e9\u30e1\u30fc\u30bf\u7528\u30af\u30e9\u30b9\u3092\u4f5c\u3063\u3066\u6e21\u3059\u3002<\/p>\n
\u89e3\u6c7a\u7b56<\/h3>\n
parameterType\u3092Map\u306b\u5909\u66f4\u3002<\/p>\n
mybatis\u7528\u30a4\u30f3\u30bf\u30d5\u30a7\u30fc\u30b9<\/p>\n
\r\npublic interface HogeRepository {\r\n HogeDTO searchHogeTable(Map map);\r\n}\r\n<\/pre>\nmybatisSQL\u7528xml<\/p>\n
\r\n<?xml version="1.0" encoding="UTF-8"?>\r\n<!DOCTYPE mapper PUBLIC "-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN"\r\n "http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd">\r\n\r\n<mapper namespace="hoge.repository.HogeRepository">\r\n <select id="searchHogeTable" resultMap="HogeDTO" parameterType="Map">\r\n <![CDATA[\r\n SELECT\r\n hoge,\r\n poge,\r\n FROM\r\n ${tableName}_table\r\n WHERE\r\n poge = '1'\r\n ]]>\r\n <\/select>\r\n<\/mapper>\r\n<\/pre>\nSQL\u5b9f\u884c<\/p>\n
\r\nMap map = null;\r\nmap.put("tableName", "hoge");\r\nHogeDTO hogeDto = repository.searchHogeTable(map);\r\n<\/pre>\n\u7121\u4e8bSQL\u3092\u5b9f\u884c\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n
\u53c2\u8003<\/h3>\n
iBatis\u306e\u52d5\u7684\u30d1\u30e9\u30e1\u30fc\u30bf\u300c$\u300d\u3068\u300c#\u300d\u306e\u9055\u3044\u306b\u3064\u3044\u3066<\/a>
\nSpringBootMyBatis\u306e\u30a8\u30e9\u30fc\uff1aThere is no getter for property named ‘\u3007\u3007’ in ‘class java.lang.String’\u304c\u89e3\u6c7a\u3067\u304d\u306a\u3044<\/a>
\nThere is no getter for property named ‘tablename’ in ‘class java.lang.String’<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"mybatis\u3067string\u578b\u3092\u52d5\u7684\u30d1\u30e9\u30e1\u30fc\u30bf\uff08${ }\uff09\u3067\u6e21\u305d\u3046\u3068\u3057\u305f\u3089\u30a8\u30e9\u30fc\u3000MyBatisSy […]<\/p>\n","protected":false},"author":1,"featured_media":273,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,7,6],"tags":[96,13,103],"class_list":["post-270","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mybatis","category-error-bugs","category-programing","tag-java","tag-mybatis","tag-mybatissystemexception"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=\/wp\/v2\/posts\/270","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=270"}],"version-history":[{"count":5,"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=\/wp\/v2\/posts\/270\/revisions"}],"predecessor-version":[{"id":480,"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=\/wp\/v2\/posts\/270\/revisions\/480"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=\/wp\/v2\/media\/273"}],"wp:attachment":[{"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=270"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ito-u-oti.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}