SpringCloud（1）——SpringDataJpa解决Blob查询乱码问题

Reference：

　　　　Jpa2.1  MySQL

 

1、首先MySQL表中

2、对应实体类

/**
     * 消息内容
     */
    @Lob
    @Basic(fetch = FetchType.LAZY)
    @Column(columnDefinition = "BLOB",nullable=true)
    private byte[] messagecontent;

3、JpaRepository

@Repository
public interface MessageinfoRepository extends JpaRepository<Messageinfo,Long> {

    /**
     * 查询我的消息类型列表信息
     * @return
     */
    @Query("select cm from Codetype c, Codemanage cm \n" +
            "where c.codetype = cm.id.codetype and c.codetype = 'MessageType' order by cm.id.codecode")
    List<Codemanage> findMessType();


    /**
     * 根据消息类型查询消息列表的分页信息
     * @param messageType 消息类型
     * @param pageable 分页
     * @return T
     */
    @Query("select m.id as id, m.messagetype as messagetype, " +
            "m.messagecontent as messagecontent, m. messagedate as messagedate, " +
            "m. messagetime as messagetime, m.messageimg as messageimg from Messageinfo m where m.messagetype = ?1")
    List<Map<String, Object>> findMessInfoByMessType(String messageType, Pageable pageable);


}

"list.get(0)"调整为"map"