springboot基于Android的房屋租赁App源码

房屋租赁App设计的目的是为用户提供房源信息、租房订单、房源资讯等方面的平台。

与PC端应用程序相比，房屋租赁App的设计主要面向于房主，旨在为管理员和租客、房主提供一个房屋租赁App。租客可以通过APP及时查看房源信息等。

房屋租赁App是在安卓操作系统下的应用平台。为防止出现兼容性及稳定性问题，编辑器选择的是Hbuildex，用户与后台之间的数据存储主要通过MySQL。用户在使用应用时产生的数据通过 java等语言传递给数据库。通过此方式促进房屋租赁App信息流动和数据传输效率，提供一个内容丰富、功能多样、易于操作的房屋租赁App。

关键词：房屋租赁App；java语言；MySQL数据库

springboot基于Android的房屋租赁App源码和答辩PPT论文010

Abstract

The purpose of the housing rental app is to provide users with a platform for housing information, rental orders, housing information and other aspects.

Compared with the PC-end application, the design of the house rental app is mainly aimed at homeowners, and aims to provide a house rental app for administrators, tenants and homeowners. Tenants can check the house information in time through APP.

The housing rental app is an application platform under the Android operating system. To prevent compatibility and stability problems, the editor selects Hbuildex, and the data storage between users and the background is mainly through MySQL. The data generated by users when using the application is transferred to the database through java and other languages. In this way, promote the information flow and data transmission efficiency of the housing rental app, and provide a housing rental app with rich content, diverse functions and easy operation.

Key words: house rental app; Java language; MySQL database

<?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.ruoyi.project.garbagesort.challengeResult.mapper.ChallengeResultMapper">
    
    <resultMap type="ChallengeResult" id="ChallengeResultResult">
        <result property="id"    column="id"    />
        <result property="score"    column="score"    />
        <result property="result"    column="result"    />
        <result property="times"    column="times"    />
        <result property="userName"    column="user_name"    />
    </resultMap>

    <sql id="selectChallengeResultVo">
        select id, score, result, times, user_name from challenge_result
    </sql>

    <select id="selectChallengeResultList" parameterType="ChallengeResult" resultMap="ChallengeResultResult">
        <include refid="selectChallengeResultVo"/>
        <where>  
            <if test="score != null "> and score = #{score}</if>
            <if test="result != null  and result != ''"> and result = #{result}</if>
            <if test="times != null "> and times = #{times}</if>
            <if test="userName != null  and userName != ''"> and user_name like concat('%', #{userName}, '%')</if>
        </where>
    </select>
    
    <select id="selectChallengeResultById" parameterType="Long" resultMap="ChallengeResultResult">
        <include refid="selectChallengeResultVo"/>
        where id = #{id}
    </select>
        
    <insert id="insertChallengeResult" parameterType="ChallengeResult" useGeneratedKeys="true" keyProperty="id">
        insert into challenge_result
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="score != null">score,</if>
            <if test="result != null">result,</if>
            <if test="times != null">times,</if>
            <if test="userName != null">user_name,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="score != null">#{score},</if>
            <if test="result != null">#{result},</if>
            <if test="times != null">#{times},</if>
            <if test="userName != null">#{userName},</if>
         </trim>
    </insert>

    <update id="updateChallengeResult" parameterType="ChallengeResult">
        update challenge_result
        <trim prefix="SET" suffixOverrides=",">
            <if test="score != null">score = #{score},</if>
            <if test="result != null">result = #{result},</if>
            <if test="times != null">times = #{times},</if>
            <if test="userName != null">user_name = #{userName},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteChallengeResultById" parameterType="Long">
        delete from challenge_result where id = #{id}
    </delete>

    <delete id="deleteChallengeResultByIds" parameterType="String">
        delete from challenge_result where id in 
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>

</mapper>