IT修真院·坑乎 | Java(后端),CSS(前端),JavaScript(前端),PM(产品经理),UI(交互设计),QA(测试),Android(安卓APP),iOS(苹果APP),OP(运维),Python(后端)日常在线问答学习平台

该问题已被官方收录

拼接sql语句，输入不能被识别。

0

1

spring

class="cursor-pointer"> 详细描述

class="cursor-pointer"> 源码

    <!--批量更新-->
    <update id="updateCustomers" parameterType="java.util.List">
        /* UPDATE TABLE set
        name =
        case
        WHEN id=#{id} THEN #{list.name}
        tel =
        case
        WHEN id=#{id} THEN #{list.tel}
        address =
        case
        WHEN id=#{id} THEN #{list.address}
        email =
        case
        WHEN id=#{id} THEN #{list.email}
        WHERE id IN
        (list.id)*/
        /*SET以及id in中的内容通过foreach遍历传入的list取得*/
        UPDATE customer SET
        customer.name=
        <foreach collection="list" item="item" index="index" open="case id" separator=" " close="end">
            <if test="item.name != null and item.name != ''">
                when #{item.id} then #{item.name}
            </if>
            <if test="item.name == null or item.name ==''">
                when =#{item.id} then customer.name
            </if>
        </foreach>
        ,customer.tel=
        <foreach collection="list" item="item" index="index" open="case id" separator=" " close="end">
            <if test="item.tel != null and item.tel != ''">
                when #{item.id} then #{item.tel}
            </if>
            <if test="item.tel == null or item.tel ==''">
                when #{item.id} then customer.tel
            </if>
        </foreach>
        ,customer.address=
        <foreach collection="list" item="item" index="index" open="case id" separator=" " close="end">
            <if test="item.address != null and item.address != ''">
                when #{item.id} then #{item.address}
            </if>
            <if test="item.address == null or item.address ==''">
                when #{item.id} then customer.address
            </if>
        </foreach>
        ,customer.email
        <foreach collection="list" item="item" index="index" open="case id" separator=" " close="end">
            <if test="item.email != null and item.email != ''">
                when #{item.id} then #{item.name}
            </if>
            <if test="item.email == null or item.email ==''">
                when #{item.id} then customer.email
            </if>
        </foreach>
        WHERE customer.id IN
        <foreach collection="list" item="item" index="index" open="(" close=")" separator=",">
            <if test="item.id != null">
                #{item.id}
            </if>
            <if test="item.id == null">
                1
            </if>
        </foreach>
    </update>

该问题已被官方收录

导入jar包后和slf4j全线冲突

0

1

tiles

class="cursor-pointer"> 详细描述

class="cursor-pointer"> 错误截图

该问题已被官方收录

命名为applicationContext.xml，后缀不管用

0

1

SSM

class="cursor-pointer"> 详细描述

class="cursor-pointer"> 错误截图

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:aop="http://www.springframework.org/schema/aop"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context-3.0.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">

<context:annotation-config/>
    <context:component-scan base-package="com"/>

<aop:aspectj-autoproxy proxy-target-class="true"/>

<mvc:annotation-driven/>

<mvc:default-servlet-handler/>

</beans>

该问题已被官方收录

参数索引超出范围

0

1

SSM

class="cursor-pointer"> 详细描述

class="cursor-pointer"> 错误截图

该问题已被官方收录

实现一级标题下的二级标题

0

1

class="cursor-pointer"> 详细描述

该问题已被官方收录

json数据无法获取

0

1

json

class="cursor-pointer"> 详细描述

class="cursor-pointer"> 错误截图

class="cursor-pointer"> 源码

<!doctype html><html lang="en"><head><title>HTTP Status 400 – Bad Request</title><style type="text/css">h1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} h2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} h3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} body {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} b {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} p {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;} a {color:black;} a.name {color:black;} .line {height:1px;background-color:#525D76;border:none;}</style></head><body><h1>HTTP Status 400 – Bad Request</h1><hr class="line" /><p><b>Type</b> Status Report</p><p><b>Description</b> The server cannot or will not process the request due to something that is perceived to be a client error (e.g., malformed request syntax, invalid request message framing, or deceptive request routing).</p><hr class="line" /><h3>Apache Tomcat/9.0.0.M18</h3></body></html>

该问题已被官方收录

maven里jar包该在怎么用，POM.XML的作用是什么

1

maven

class="cursor-pointer"> 详细描述

class="cursor-pointer"> 错误截图