粗心错误集锦-SpringBoot开发的项目

错误一：Error Code: 1265. Data truncated for column 'has_read' at row 1 0.000 sec。

String INSERT_FIELDS = " from_id, to_id, content, has_read, conversation_id, created_date ";
    String SELECT_FIELDS = " id, " + INSERT_FIELDS;

    @Insert({"insert into ", TABLE_NAME, "(", INSERT_FIELDS,
            ") values (#{fromId},#{toId},#{content},#{createdDate},#{hasRead},#{conversationId})"})

上面错误原因在于对应字段位置写的不对。

错误二：Error attempting to get column 'id' from result set.  Cause: java.sql.SQLException: Column 'id' not found.; uncategorized SQLException; SQL state [S0022]; error code [0]; Column 'id' not found.; nested exception is java.sql.SQLException: Column 'id' not found.

@Select({"select count(id) from ", TABLE_NAME , " where entity_id = #{entityId} and entity_type=#{entityType}"})
            //注：此处没有选出字段，所有根本没有下面Results。所以一直报错。
    /*@Results({
            @Result(property = "id" ,column="id"),
            @Result(property = "content" ,column="content"),
            @Result(property = "userId" ,column="user_id"),
            @Result(property = "entityId" ,column="entity_id"),
            @Result(property = "entityType" ,column="entity_type"),
            @Result(property = "createdDate" ,column="created_date"),
            @Result(property = "status" ,column="status")})*/
    int getCommentCount(@Param("entityId") int entityId, @Param("entityType") int entityType);

此处没有选出字段，所有根本没有下面Results。所以一直报错

错误三：Caused by: java.net.ConnectException: Connection refused: connect

mysql数据库未启动