这里我是把Date的转成Long,方法不一,如下:
SELECT
a.accountsid AS "id",
a.accountsId AS "accountsId",
a.userId AS "userId",
a.reimburseId AS "reimburse.id",
a.accountsType AS "accountsType",
a.accountsDate AS "accountsDate",
a.accountsStartData AS "accountsStartData",
a.accountsEndData AS "accountsEndData",
a.roadMoney AS "roadMoney",
a.roadContent AS "roadContent",
a.accountsMoney AS "accountsMoney",
a.accountsKilometres AS "accountsKilometres",
a.accountsSumMoney AS "accountsSumMoney",
a.accountsDescription AS "accountsDescription",
a.accountsRemarks AS "accountsRemarks",
a.auditInfo AS "auditInfo",
a.city AS "city",
a.currency AS "currency",<