应用程序异常,访问的页面出现异常

Question

org.springframework.jdbc.BadSqlGrammarException:

Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION fhadmin.LOANPERIOD does not exist

The error may exist in file [D:\tomcat\apache-tomcat-7.0.57\webapps\FHADMINM\WEB-INF\classes\mybatis1\interest\InterestMapper.xml]

The error may involve InterestMapper.datalistPage-Inline

The error occurred while setting parameters

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION fhadmin.LOANPERIOD does not exist

; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION fhadmin.LOANPERIOD does not exist

InteresMapper.xml如下：
<?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">

<!--表名 -->
<sql id="tableName">
    TB_INTERESTINTEREST
</sql>

<!-- 字段 -->
<sql id="Field">
    CLIENTNAME, 
    PRODUCTNAME,    
    GUARANTEEMETHOD,    
    LOANPAYMENTAMOUNT,  
    LOANPERIOD(MONTHS), 
    ACCOUNTOPENINGDATE, 
    DATEOFEXPIRY,   
    LENDINGRATE,    
    LENDINGRATE(MONTH), 
    LOANBALANCE,    
    WRITEOFFTHEPRINCIPAL,   
    ARREARS,    
    IRREVOCABLEINTEREST,    
    ACCOUNTSTATUS,  
    DATEOFCLASSIFICATION,   
    CLASSIFICATIONRESULT,   
    HANDLINGBANK,   
    ATTN,   
    INTEREST_ID
</sql>

<!-- 字段值 -->
<sql id="FieldValue">
    #{CLIENTNAME},  
    #{PRODUCTNAME}, 
    #{GUARANTEEMETHOD}, 
    #{LOANPAYMENTAMOUNT},   
    #{LOANPERIOD(MONTHS)},  
    #{ACCOUNTOPENINGDATE},  
    #{DATEOFEXPIRY},    
    #{LENDINGRATE}, 
    #{LENDINGRATE(MONTH)},  
    #{LOANBALANCE}, 
    #{WRITEOFFTHEPRINCIPAL},    
    #{ARREARS}, 
    #{IRREVOCABLEINTEREST}, 
    #{ACCOUNTSTATUS},   
    #{DATEOFCLASSIFICATION},    
    #{CLASSIFICATIONRESULT},    
    #{HANDLINGBANK},    
    #{ATTN},    
    #{INTEREST_ID}
</sql>

<!-- 新增-->
<insert id="save" parameterType="pd">
    insert into 
<include refid="tableName"></include>
    (
<include refid="Field"></include>
    ) values (
<include refid="FieldValue"></include>
    )
</insert>

<!-- 删除-->
<delete id="delete" parameterType="pd">
    delete from
    <include refid="tableName"></include>
    where 
        INTEREST_ID = #{INTEREST_ID}
</delete>

<!-- 修改 -->
<update id="edit" parameterType="pd">
    update
    <include refid="tableName"></include>
    set 
        CLIENTNAME = #{CLIENTNAME},
        PRODUCTNAME = #{PRODUCTNAME},
        GUARANTEEMETHOD = #{GUARANTEEMETHOD},
        LOANPAYMENTAMOUNT = #{LOANPAYMENTAMOUNT},
        LOANPERIOD(MONTHS) = #{LOANPERIOD(MONTHS)},
        ACCOUNTOPENINGDATE = #{ACCOUNTOPENINGDATE},
        DATEOFEXPIRY = #{DATEOFEXPIRY},
        LENDINGRATE = #{LENDINGRATE},
        LENDINGRATE(MONTH) = #{LENDINGRATE(MONTH)},
        LOANBALANCE = #{LOANBALANCE},
        WRITEOFFTHEPRINCIPAL = #{WRITEOFFTHEPRINCIPAL},
        ARREARS = #{ARREARS},
        IRREVOCABLEINTEREST = #{IRREVOCABLEINTEREST},
        ACCOUNTSTATUS = #{ACCOUNTSTATUS},
        DATEOFCLASSIFICATION = #{DATEOFCLASSIFICATION},
        CLASSIFICATIONRESULT = #{CLASSIFICATIONRESULT},
        HANDLINGBANK = #{HANDLINGBANK},
        ATTN = #{ATTN},
    INTEREST_ID = INTEREST_ID
    where 
    INTEREST_ID = #{INTEREST_ID}
</update>

<!-- 通过ID获取数据 -->
<select id="findById" parameterType="pd" resultType="pd">
    select 
    <include refid="Field"></include>
    from 
    <include refid="tableName"></include>
    where 
        INTEREST_ID = #{INTEREST_ID}
</select>

<!-- 列表 -->
<select id="datalistPage" parameterType="page" resultType="pd">
    select
    <include refid="Field"></include>
    from 
    <include refid="tableName"></include>
    where 1=1
    <if test="pd.keywords!= null and pd.keywords != ''"><!-- 关键词检索 -->
        and
            (
            <!--    根据需求自己加检索条件
                字段1 LIKE CONCAT(CONCAT('%', #{pd.keywords}),'%')
                 or 
                字段2 LIKE CONCAT(CONCAT('%', #{pd.keywords}),'%') 
            -->
            )
    </if>
</select>

<!-- 列表(全部) -->
<select id="listAll" parameterType="pd" resultType="pd">
    select
    <include refid="Field"></include>
    from 
    <include refid="tableName"></include>
</select>

<!-- 批量删除 -->
<delete id="deleteAll" parameterType="String">
    delete from
    <include refid="tableName"></include>
    where 
        INTEREST_ID in
    <foreach item="item" index="index" collection="array" open="(" separator="," close=")">
             #{item}
    </foreach>
</delete>

Answer 1

你 的 InterestMapper.xml 这个 配置的不正确 进去看看你写的 sql 或者 引入的mapper 看看 是否正确