The-sharp number cannot be used within the mybatis forach tag, but you can use $ - Codes Helper - Programming Question Answer

The-sharp number cannot be used within the mybatis forach tag, but you can use $

mybatis foreach tag

<if test="map.itemNos!=null and map.itemNos.size()>0">
            AND EXISTS (SELECT 1 FROM COM_INV_ITEMS WHERE INVENTORY_ITEM_ID= h.INVENTORY_ITEM_ID AND SEGMENT1 IN
            <foreach item="itemNo" index="index" collection="map.itemNos"  open="(" separator="," close=")">
                -sharp{itemNo}
            </foreach>
            )
</if>

the following error will be reported when using the above method,

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter "__frch_item_0" not found. Available parameters are [param1, param2, page, map]
    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
    org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
    org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    com.huaqin.hfw.web.filter.Acl.doFilter(Acl.java:268)
    org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347)
    org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263)
    org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
    org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71)
    com.huaqin.fcstrp.filter.OidcAuthenticationFilter.doFilter(OidcAuthenticationFilter.java:35)
    com.huaqin.hfw.log.ContextFilter.doFilter(ContextFilter.java:33)

but with the same code, there is no problem simply replacing-sharp {itemNo} with ${itemNo}. Why? Baidu google has been searched all over, and no one has ever encountered such a problem

Mybatis

Mar.04,2021

Previous: How do I update the data in Listview in fragment?

Next: Win7 installation sqlserver2012 failed to wait for the database engine to recover? Online and urgent

Mybatis .xml files in spring-boot can only be placed under resources/mapper/?
the .xml file of mybatis in spring-boot can only be placed under resources mappper, like this: put together with the interface, not uniformly placed under the resources mapper, separate, easy to manage. thanks! ...

Mybatis springboot

Feb.26,2021
Annotation invalidation of dao interface using mybatis @ CacheNamespace cache
use mybatis to configure custom secondary cache. Using xml annotation can use < cache type= "com.test.dao.MybatisRedisCache " > to successfully use custom cache, but using @ CacheNamespace (implementation = MybatisRedisCache.class) on the dao i...

Java spring mybatis redis mysql

Feb.27,2021
What is the problem with the data returned by the sql query in the mysql database?
Multi-table management, because the sum operation is used, so even if there is no data mybatis query will become one. The result is that null, if the default value is set on the sum, such as 0, it will return a piece of data that only the field sum is 0....

Mybatis msyql

Feb.28,2021
Oracle database insertion problem of Mybatise
when using Mybatise, I use the following code to operate on the database. No error is reported, and it executes successfully, but the database does not find data @Test public void testInsertUser(){ SqlSession sqlSession = sessionFactory.o...

Insert oracle mybatis java

Feb.28,2021
Intellij cannot use mybatis's comments in the project?
...

Java mybatis

Mar.01,2021
Invalidation of MyBatis SELECT statement
when using MyBatis, there is a problem with an incomprehensible SELECT statement. <select id="getHotelList" resultType="com.genius.travelline.product.entity.Hotel"> SELECT a.id AS "id", a.title AS "t...

Mybatis

Mar.01,2021
How does mybatis match the year, month and day of the date field?
first, there is a field of Date type in the database. If you want to query all the records of 2018-04-08, but ignore the following time, minutes and seconds, how do you write the query statement and the mybatis mapping file? ...

Mybatis

Mar.01,2021
SSM operation error: UnsatisfiedDependencyException
there is a problem that I can t solve when I just learned ssm,. No, no, no. The directory structure is as follows error message: Caught exception while allowing TestExecutionListener [org.springframework.test.context.support.DependencyInjectionTes...

Mybatis spring java

Mar.02,2021
How mybatis example generates sql of or condition
I want to use the example class of mybatis to generate the following sql statement: SELECT * FROM User where nick_name like "%1502%" or real_name like "%1502%" or mobile like "%1502%" this is how I used it: UserExample u...

Java sql mybatis

Mar.02,2021
Sql server queries and reports errors based on date type
the data sent from the front desk is of date type, and then query how to report such an error in the field of date type of sql server database based on this data: ,date : : : ...

Sqlserver sql-server sql-statement mybatis ssm

Mar.02,2021
Ask for help c3p0-0.9.1.2 NewProxyPreparedStatement.isClosed () Z is abstract
error prompt use: <dependency> <groupId>org.springframework< groupId> <artifactId>spring-orm< artifactId> <version>4.3.14.RELEASE< version> < dependency> <depend...

Java mybatis spring-mvc spring

Mar.03,2021
SqlSession was not registered.
Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@79669d23] was not registered for synchronization because synchronization is not active Closing non transactional SqlSession [org.apache.ibatis.session.defaults.Def...

Springboot mybatis

Mar.03,2021
Can association in mybatis be used in nesting?
for example, can I do this <association property=""> <association property="">< association> < association> I tried, and the compilation passed, but there was an error at run time, if not. the...

Mybatis

Mar.04,2021
How mybatis executes multiple native statements
when operating on the database, the table is locked, the field value of the table is updated, the query is returned, and finally the table is unlocked. The sql statements executed without jdbc for are as follows: LOCK TABLE yh WRITE; UPDATE yh SET val...

Mysql mybatis

Mar.04,2021
How does mybatis iterate through a string?
is a string made up of multiple id String ids = "1 id 2, 3 4 ". Now you want to traverse through the mybatis without cutting it into an array. What do you do according to the delete operation according to the id? I reported an error here: < where > ...

Java-ee java-web ssm java mybatis

Mar.05,2021
Mybatis collection mapping id is null
I m sorry about my careless problems. < span> ...

Mybatis spring-mvc

Mar.05,2021
JedisPool injects spring into null
recently, when (spring) integrates redis in a project, I always hold a null pointer exception when going to the factory instance: but the unit test is always normal: the following is the redis-config.xml file public class SpringContextUtil implement...

Redis spring java mybatis

Mar.05,2021
Mybatis nested query error TooManyResultsException
select <include refid="Base_Column_List" > from sys_permission where id = -sharp{id,jdbcType=INTEGER} < select> < mapper> if you change dao to List < SysRole > getRoleWithPermission (Inte...

Mybatis spring-mvc

Mar.05,2021
How SSM initializes index.jsp or index.ftl pages
how should I open the index implementation on the home page of the website to query the relevant data from the background database and then bind it to the page? ...

Freemarker mysql mybatis spring-mvc spring

Mar.06,2021
[help] c3p0:JDBC driver, cannot unregister when the Web application stops. To prevent memory leaks, the JDBC driver has been forcibly logged out.
using JDBCDataSouce is normal, startup and stop are normal, and no error is reported. when switching to C3P0 configuration in C3P0 XML:  <bean id="dataSource_c3p0_properties" class="com.mchange.v2.c3p0.ComboPooledD...

Jdbc c3p0 mybatis java

Mar.06,2021

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b34017-2bef3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b34017-2bef3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?