添加创建时间与更新时间

64850858

2021-06-07 667257a75a228ce7fe50a8a3cc8160628876015f

 src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceMapper.java

@@ -30,6 +30,8 @@
                "expires," +
                "registerTime," +
                "keepaliveTime," +
                "createTime," +
                "updateTime," +
                "online" +
            ") VALUES (" +
                "#{deviceId}," +
@@ -45,13 +47,15 @@
                "#{expires}," +
                "#{registerTime}," +
                "#{keepaliveTime}," +
                "datetime('now','localtime')," +
                "datetime('now','localtime')," +
                "#{online}" +
            ")")
    int add(Device device);

    @Update(value = {" <script>" +
                "UPDATE device " +
                "SET deviceId='${deviceId}'" +
                "SET updateTime=datetime('now','localtime')" +
                "<if test=\"name != null\">, name='${name}'</if>" +
                "<if test=\"manufacturer != null\">, manufacturer='${manufacturer}'</if>" +
                "<if test=\"model != null\">, model='${model}'</if>" +