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

该问题已被官方收录

使用SSM时，在Mapper.xml中添加了SQL语句，但运行时报错找不到该语句

1

SSM jetty/tomcat

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

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

class="cursor-pointer"> 源码

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.jnshu.dao.UserMapper">
    <resultMap id="BaseResultMap" type="com.jnshu.model.User">
        <constructor>
            <idArg column="id" jdbcType="INTEGER" javaType="java.lang.Integer"/>
            <arg column="user_name" jdbcType="VARCHAR" javaType="java.lang.String"/>
            <arg column="password" jdbcType="VARCHAR" javaType="java.lang.String"/>
            <arg column="tel_num" jdbcType="VARCHAR" javaType="java.lang.String"/>
            <arg column="email" jdbcType="VARCHAR" javaType="java.lang.String"/>
            <arg column="user_image" jdbcType="VARCHAR" javaType="java.lang.String"/>
            <arg column="salt" jdbcType="VARCHAR" javaType="java.lang.String"/>
            <arg column="login_time" jdbcType="BIGINT" javaType="java.lang.Long"/>
            <arg column="creat_name" jdbcType="CHAR" javaType="java.lang.String"/>
            <arg column="creat_time" jdbcType="BIGINT" javaType="java.lang.Long"/>
            <arg column="update_name" jdbcType="CHAR" javaType="java.lang.String"/>
            <arg column="update_time" jdbcType="BIGINT" javaType="java.lang.Long"/>
        </constructor>
    </resultMap>

    <sql id="Base_Column_List">
    id, user_name, tel_num, email, user_image, password, salt, login_time, creat_name, creat_time, update_name, update_time
  </sql>

    <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer">
        select
        <include refid="Base_Column_List"/>
        from user
        where id = #{id,jdbcType=INTEGER}
    </select>

    <select id="selectByName" resultType="com.jnshu.model.User" parameterType="java.lang.String">
        select
       password,salt
        from user
        where user_name = #{userName,jdbcType=VARCHAR}
    </select>

    <update id="updateByName" parameterType="com.jnshu.model.User">
update user
set
login_time = #{loginTime,jdbcType=BIGINT}
where
user_name = #{userName,jdbcType=VARCHAR}
</update>

    <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
    delete from user
    where id = #{id,jdbcType=INTEGER}
  </delete>


    <insert id="insert" parameterType="com.jnshu.model.User">
    insert into user (id, user_name, tel_num, email, user_image, password, salt,
      login_time, creat_name, creat_time, 
      update_name, update_time)
    values (#{id,jdbcType=INTEGER}, #{userName,jdbcType=VARCHAR},#{telNum,jdbcType=VARCHAR},#{eamil,jdbcType=VARCHAR},#{userImage,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR},
      #{loginTime,jdbcType=BIGINT}, #{creatName,jdbcType=CHAR}, #{creatTime,jdbcType=BIGINT}, 
      #{updateName,jdbcType=CHAR}, #{updateTime,jdbcType=BIGINT})
  </insert>
    <insert id="insertSelective" parameterType="com.jnshu.model.User">
        insert into user
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">
                id,
            </if>
            <if test="userName != null">
                user_name,
            </if>
            <if test="telNum != null">
                tel_num,
            </if>
            <if test="email != null">
                email,
            </if>
            <if test="userImage != null">
                user_image,
            </if>
            <if test="password != null">
                password,
            </if>
            <if test="salt != null">
                salt,
            </if>
            <if test="loginTime != null">
                login_time,
            </if>
            <if test="creatName != null">
                creat_name,
            </if>
            <if test="creatTime != null">
                creat_time,
            </if>
            <if test="updateName != null">
                update_name,
            </if>
            <if test="updateTime != null">
                update_time,
            </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">
                #{id,jdbcType=INTEGER},
            </if>
            <if test="userName != null">
                #{userName,jdbcType=VARCHAR},
            </if>
            <if test="telNum != null">
                #{telNum,jdbcType=VARCHAR},
            </if>
            <if test="email != null">
                #{email,jdbcType=VARCHAR},
            </if>
            <if test="userImage != null">
                #{userImage,jdbcType=VARCHAR},
            </if>
            <if test="password != null">
                #{password,jdbcType=VARCHAR},
            </if>
            <if test="salt != null">
                #{salt,jdbcType=VARCHAR},
            </if>
            <if test="loginTime != null">
                #{loginTime,jdbcType=BIGINT},
            </if>
            <if test="creatName != null">
                #{creatName,jdbcType=CHAR},
            </if>
            <if test="creatTime != null">
                #{creatTime,jdbcType=BIGINT},
            </if>
            <if test="updateName != null">
                #{updateName,jdbcType=CHAR},
            </if>
            <if test="updateTime != null">
                #{updateTime,jdbcType=BIGINT},
            </if>
        </trim>
    </insert>


    <update id="updateByPrimaryKeySelective" parameterType="com.jnshu.model.User">
        update user
        <set>
            <if test="userName != null">
                user_name = #{userName,jdbcType=VARCHAR},
            </if>
            <if test="telNum != null">
                tel_num = #{telNum,jdbcType=VARCHAR},
            </if>
            <if test="email != null">
                email = #{email,jdbcType=VARCHAR},
            </if>
            <if test="userImage != null">
                user_image = #{userImage,jdbcType=VARCHAR},
            </if>
            <if test="password != null">
                password = #{password,jdbcType=VARCHAR},
            </if>
            <if test="salt != null">
                salt = #{salt,jdbcType=VARCHAR},
            </if>
            <if test="loginTime != null">
                login_time = #{loginTime,jdbcType=BIGINT},
            </if>
            <if test="creatName != null">
                creat_name = #{creatName,jdbcType=CHAR},
            </if>
            <if test="creatTime != null">
                creat_time = #{creatTime,jdbcType=BIGINT},
            </if>
            <if test="updateName != null">
                update_name = #{updateName,jdbcType=CHAR},
            </if>
            <if test="updateTime != null">
                update_time = #{updateTime,jdbcType=BIGINT},
            </if>
        </set>
        where id = #{id,jdbcType=INTEGER}
    </update>
    <update id="updateByPrimaryKey" parameterType="com.jnshu.model.User">
    update user
    set user_name = #{userName,jdbcType=VARCHAR},
      password = #{password,jdbcType=VARCHAR},
      tel_num = #{telNum,jdbcType=VARCHAR},
      email = #{email,jdbcType=VARCHAR},
      user_image = #{userImage,jdbcType=VARCHAR},
      salt = #{salt,jdbcType=VARCHAR},
      login_time = #{loginTime,jdbcType=BIGINT},
      creat_name = #{creatName,jdbcType=CHAR},
      creat_time = #{creatTime,jdbcType=BIGINT},
      update_name = #{updateName,jdbcType=CHAR},
      update_time = #{updateTime,jdbcType=BIGINT}
    where id = #{id,jdbcType=INTEGER}
  </update>
    <select id="selectByIdAndName" resultMap="BaseResultMap" parameterType="com.jnshu.model.User">
select * from user
where  user_name = #{userName} and password = #{password}
</select>
    <select id="countAll" resultType="java.lang.Integer">
    SELECT count(*)  FROM user
  </select>

    <update id="updateImageByName" parameterType="java.lang.String">
        update user
        set
        user_image = #{userImage,jdbcType=VARCHAR}
        where user_name = #{userName,jdbcType=VARCHAR}
    </update>

</mapper>

该问题已被官方收录

加载多个properties文件时，Spring只识别第一个

2

1

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

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

class="cursor-pointer"> 源码

<util:properties id="util_Spring" local-override="true" location="classpath:properties/until.properties"/>

    <bean id="qnOssUntil"
          class="com.jnshu.tools.QnOssUntil">
        <property name="accessKey" value="#{util_Spring['QNOSS.accessKey']}"/>
        <property name="secretKey" value="#{util_Spring['QNOSS.secretKey']}"/>
        <property name="bucket" value="#{util_Spring['QNOSS.bucket']}"/>
        <property name="bucketName" value="#{util_Spring['Cos.bucketName']}"/>
    </bean>

    <bean id="cosClient" class="com.qcloud.cos.COSClient">
        <constructor-arg name="clientConfig" ref="clientConfig"/>
        <constructor-arg name="cred" ref="cred"/>
    </bean>
    <bean name="cred" class="com.qcloud.cos.auth.BasicCOSCredentials">
        <constructor-arg name="accessKey" value="#{util_Spring['Cos.accessKey']}"/>
        <constructor-arg name="secretKey" value="#{util_Spring['Cos.secretKey']}"/>
        <constructor-arg name="appId" value="#{util_Spring['Cos.appid']}"/>
    </bean>
    <bean name="clientConfig" class="com.qcloud.cos.ClientConfig">
        <constructor-arg name="region" value="#{util_Spring['Cos.region']}"/>
    </bean>

<bean id="sendEmailUtil" class="com.jnshu.tools.SendEmailUtil">
    <property name="account" value="#{util_Spring['e.account']}"/>
    <property name="pass" value="#{util_Spring['e.pass']}"/>
    <property name="host" value="#{util_Spring['e.host']}"/>
    <property name="port" value="#{util_Spring['e.port']}"/>
    <property name="protocol" value="#{util_Spring['e.protocol']}"/>
</bean>

    <bean id="smsUtil" class="com.jnshu.tools.SmsUtil">
        <property name="appid" value="#{util_Spring['sms.appid']}"/>
        <property name="appkey" value="#{util_Spring['sms.appkey']}"/>
        <property name="templateId" value="#{util_Spring['sms.templateId']}"/>
        <property name="smsSign" value="#{util_Spring['sms.smsSign']}"/>
    </bean>

该问题已被官方收录

复盘的时候配置nginx访问域名后的接口错误

0

1

复盘踩坑

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

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

该问题已被官方收录

spring rmi空针

1

springRMI

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

class="cursor-pointer"> 源码

Exception in thread "main" java.lang.NullPointerException
	at com.student.service.StudentServiceIpl.selectByPrimaryKey(StudentServiceIpl.java:39)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.remoting.support.RemoteInvocationTraceInterceptor.invoke(RemoteInvocationTraceInterceptor.java:78)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
	at com.sun.proxy.$Proxy1.selectByPrimaryKey(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.remoting.support.RemoteInvocation.invoke(RemoteInvocation.java:212)
	at org.springframework.remoting.support.DefaultRemoteInvocationExecutor.invoke(DefaultRemoteInvocationExecutor.java:39)
	at org.springframework.remoting.support.RemoteInvocationBasedExporter.invoke(RemoteInvocationBasedExporter.java:78)
	at org.springframework.remoting.rmi.RmiBasedExporter.invoke(RmiBasedExporter.java:73)
	at org.springframework.remoting.rmi.RmiInvocationWrapper.invoke(RmiInvocationWrapper.java:74)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:361)
	at sun.rmi.transport.Transport$1.run(Transport.java:200)
	at sun.rmi.transport.Transport$1.run(Transport.java:197)
	at java.security.AccessController.doPrivileged(Native Method)
	at sun.rmi.transport.Transport.serviceCall(Transport.java:196)
	at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:568)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:826)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:683)
	at java.security.AccessController.doPrivileged(Native Method)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:682)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
	at org.springframework.remoting.support.RemoteInvocationUtils.fillInClientStackTraceIfPossible(RemoteInvocationUtils.java:45)
	at org.springframework.remoting.rmi.RmiClientInterceptor.doInvoke(RmiClientInterceptor.java:353)
	at org.springframework.remoting.rmi.RmiClientInterceptor.invoke(RmiClientInterceptor.java:260)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
	at com.sun.proxy.$Proxy8.selectByPrimaryKey(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:43)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
	at com.sun.proxy.$Proxy20.selectByPrimaryKey(Unknown Source)
	at com.student.rmi.main.main(main.java:11)

该问题已被官方收录

服务器

1

JSP

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

class="cursor-pointer"> 源码

   server {

         

        listen       80;

        server_name 47.102.221.113; 

        location / {

        

            proxy_pass http://47.102.221.113:8080;

        

        }

        

        location ~\.(css|js|png|jpg)$ {

            

            root /opt/images;（我静态资源的位置）

            

        }

        }

该问题已被官方收录

在分离server后部署服务器报错

1

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

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

该问题已被官方收录

加了缓存之后压测要怎样才能看出缓存的效果呢？

2

1

压测

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

该问题已被官方收录

shiro如何整合JWT

0

1

shiro

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

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

该问题已被官方收录

连接数据库失败

2

1

mybatis

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

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

该问题已被官方收录

无法识别properties文件

1

缓存相关

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

做任务六的时候需要加载到mencached的配置文件，然后在spring-mybatis里的xml文件添加 <import resource="app-context-xmemcached.xml"/>，但是无法加载到xml相关的properties文件

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        
        <property name="mapperLocations" value="classpath:UserMapper.xml"/>
    </bean>

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