Java Code Examples for org.apache.ibatis.type.JdbcType#TIMESTAMP

The following examples show how to use org.apache.ibatis.type.JdbcType#TIMESTAMP . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example 1

Source File: InvtListMapper.java From maintain with MIT License

6 votes

@Results(id = "invtListResult", value = {
	@Result(property = "headGuid", column = "head_guid", id = true),
	@Result(property = "gNum", column = "g_num", jdbcType = JdbcType.INTEGER),
	@Result(property = "itemRecordNo", column = "item_record_no"),
	@Result(property = "itemNo", column = "item_no"),
	@Result(property = "itemName", column = "item_name"),
	@Result(property = "gCode", column = "g_code"),
	@Result(property = "gName", column = "g_name"),
	@Result(property = "gModel", column = "g_model"),
	@Result(property = "barCode", column = "bar_code"),
	@Result(property = "country", column = "country"),
	@Result(property = "currency", column = "currency"),
	@Result(property = "qty", column = "qty", jdbcType = JdbcType.INTEGER),
	@Result(property = "qty1", column = "qty1", jdbcType = JdbcType.INTEGER),
	@Result(property = "qty2", column = "qty2", jdbcType = JdbcType.INTEGER),
	@Result(property = "unit", column = "unit"),
	@Result(property = "unit1", column = "unit_1"),
	@Result(property = "unit2", column = "unit_2"),
	@Result(property = "price", column = "price", jdbcType = JdbcType.DOUBLE),
	@Result(property = "totalPrice", column = "total_price", jdbcType = JdbcType.DOUBLE),
	@Result(property = "note", column = "note"),
	@Result(property = "sysDate", column = "sys_date", jdbcType = JdbcType.TIMESTAMP),
})
@SelectProvider(type = InvtListSqlProvide.class, method = "getInvtListListByHeadGuidSql")
List<InvtList> getInvtListListByHeadGuid(String headGuid);

Example 2

Source File: PubRtnMapper.java From maintain with MIT License

6 votes

@Results(id = "pubRtnResult", value = {
	@Result(property = "msgGuid", column = "msg_guid", id = true),
	@Result(property = "bizType", column = "biz_type"),
	@Result(property = "bizGuid", column = "biz_guid"),
	@Result(property = "preNo", column = "pre_no"),
	@Result(property = "h2kNo", column = "h2k_no"),
	@Result(property = "appStatus", column = "app_status"),
	@Result(property = "rtnStatus", column = "rtn_status"),
	@Result(property = "rtnTime", column = "rtn_time", jdbcType = JdbcType.TIMESTAMP),
	@Result(property = "rtnInfo", column = "rtn_info"),
	@Result(property = "note", column = "note"),
	@Result(property = "sysDays", column = "sys_days", jdbcType = JdbcType.INTEGER),
	@Result(property = "sysDate", column = "sys_date", jdbcType = JdbcType.TIMESTAMP)
})
@SelectProvider(type = PubRtnSqlProvide.class, method = "getPubRtnListByBizGuidSql")
List<PubRtn> getPubRtnListByBizGuid(String bizGuid);

Example 3

Source File: ImpInvtHeadMapper.java From maintain with MIT License

5 votes

@Results(id = "impInvtHeadResult", value = {
	@Result(property = "guid", column = "guid", id = true),
	@Result(property = "preNo", column = "pre_no"),
	@Result(property = "invtNo", column = "invt_no"),
	@Result(property = "detailsCode", column = "detailscode"),
	@Result(property = "applyCode", column = "applycode"),
	@Result(property = "auditState", column = "audit_state"),
	@Result(property = "bwName", column = "bw_name"),
	@Result(property = "applyDate", column = "apply_date", jdbcType = JdbcType.TIMESTAMP),
	@Result(property = "payCode", column = "payecode"),
	@Result(property = "payName", column = "payename")
})
@SelectProvider(type = ImpInvtHeadSqlProvide.class, method = "getInvtHeadListByInvtNoSql")
List<ImpInvtHead> getInvtHeadListByInvtNo(String invtNo);

Example 4

Source File: DeliveryListMapper.java From maintain with MIT License

5 votes

@Results(id = "deliveryListResult", value = {
	@Result(property = "headGuid", column = "head_guid", id = true),
	@Result(property = "gNum", column = "g_num", id = true, jdbcType = JdbcType.INTEGER),
	@Result(property = "logisticsNo", column = "logistics_no"),
	@Result(property = "note", column = "note"),
	@Result(property = "sysDate", column = "sys_date", jdbcType = JdbcType.TIMESTAMP)
})
@SelectProvider(type = DeliveryListSqlProvide.class, method = "getDeliveryListByGuidSql")
List<DeliveryList> getDeliveryListByGuid(String headGuid);

Example 5

Source File: InvtCancelMapper.java From maintain with MIT License

5 votes

@Results(id = "invtCancelResult", value = {
	@Result(property = "headGuid", column = "head_guid", id = true),
	@Result(property = "appType", column = "app_type"),
	@Result(property = "appTime", column = "app_time", jdbcType = JdbcType.TIMESTAMP),
	@Result(property = "appStatus", column = "app_status"),
	@Result(property = "appUid", column = "app_uid"),
	@Result(property = "appUname", column = "app_uname"),
	@Result(property = "appSenderId", column = "app_sender_id"),
	@Result(property = "declTime", column = "decl_time"),
	@Result(property = "customsCode", column = "customs_code"),
	@Result(property = "orderNo", column = "order_no"),
	@Result(property = "ebpCode", column = "ebp_code"),
	@Result(property = "ebpName", column = "ebp_name"),
	@Result(property = "ebcCode", column = "ebc_code"),
	@Result(property = "ebcName", column = "ebc_name"),
	@Result(property = "logisticsNo", column = "logistics_no"),
	@Result(property = "logisticsCode", column = "logistics_code"),
	@Result(property = "logisticsName", column = "logistics_name"),
	@Result(property = "copNo", column = "cop_no"),
	@Result(property = "preNo", column = "pre_no"),
	@Result(property = "invtNo", column = "invt_no"),
	@Result(property = "buyerIdType", column = "buyer_id_type"),
	@Result(property = "buyerIdNumber", column = "buyer_id_number"),
	@Result(property = "buyerName", column = "buyer_name"),
	@Result(property = "buyerTelephone", column = "buyer_telephone"),
	@Result(property = "agentCode", column = "agent_code"),
	@Result(property = "agentCode", column = "agent_name"),
	@Result(property = "reason", column = "reason"),
	@Result(property = "note", column = "note"),
	@Result(property = "delFlag", column = "del_flag"),
	@Result(property = "msgGuid", column = "msg_guid"),
	@Result(property = "sysDays", column = "sys_days"),
	@Result(property = "sysDate", column = "sys_date"),
})
@SelectProvider(type = InvtCancelSqlProvide.class, method = "getInvtCancelListSql")
List<InvtCancel> getInvtCancelList(InvtCancel invtCancel);

Example 6

Source File: DeliveryHeadMapper.java From maintain with MIT License

5 votes

@Results(id = "deliveryHeadResult", value = {
	@Result(property = "headGuid", column = "head_guid", id = true),
	@Result(property = "appType", column = "app_type"),
	@Result(property = "appTime", column = "app_time", jdbcType = JdbcType.TIMESTAMP),
	@Result(property = "appStatus", column = "app_status"),
	@Result(property = "appUid", column = "app_uid"),
	@Result(property = "appUname", column = "app_uname"),
	@Result(property = "appSenderId", column = "app_sender_id"),
	@Result(property = "declTime", column = "decl_time", jdbcType = JdbcType.TIMESTAMP),
	@Result(property = "customsCode", column = "customs_code"),
	@Result(property = "copNo", column = "cop_no"),
	@Result(property = "preNo", column = "pre_no"),
	@Result(property = "rkdNo", column = "rkd_no"),
	@Result(property = "operatorCode", column = "operator_code"),
	@Result(property = "operatorName", column = "operator_name"),
	@Result(property = "ieFlag", column = "ie_flag"),
	@Result(property = "trafMode", column = "traf_mode"),
	@Result(property = "trafNo", column = "traf_no"),
	@Result(property = "voyageNo", column = "voyage_no"),
	@Result(property = "billNo", column = "bill_no"),
	@Result(property = "logisticsCode", column = "logistics_code"),
	@Result(property = "logisticsName", column = "logistics_name"),
	@Result(property = "unloadLocation", column = "unload_location"),
	@Result(property = "note", column = "note"),
	@Result(property = "delFlag", column = "del_flag", jdbcType = JdbcType.INTEGER),
	@Result(property = "msgGuid", column = "msg_guid"),
	@Result(property = "sysDays", column = "sys_days", jdbcType = JdbcType.INTEGER),
	@Result(property = "sysDate", column = "sys_date", jdbcType = JdbcType.TIMESTAMP),
})
@SelectProvider(type = DeliveryHeadSqlProvide.class, method = "getDeliveryHeadListSql")
List<DeliveryHead> getDeliveryHeadList(DeliveryHead deliveryHead);

Example 7

Source File: DateTypeHandler.java From stategen with GNU Affero General Public License v3.0

4 votes

@Override
public void setNonNullParameter(PreparedStatement ps, int i, Date parameter,
                                JdbcType jdbcType) throws SQLException {
    super.setNonNullParameter(ps, i, parameter, JdbcType.TIMESTAMP);
}

Example 8

Source File: InvtHeadMapper.java From maintain with MIT License

4 votes

@Results(id = "invtHeadResult", value = {
		@Result(property = "headGuid", column = "head_guid", id = true),
//		@Result(property = "pubRtnList", javaType = List.class, column = "head_guid",
//			many = @Many(fetchType = FetchType.LAZY,
//				select = "online.zhaopei.myproject.mapper.ecssent.PubRtnMapper.getPubRtnListByBizGuid")),
		@Result(property = "appType", column = "app_type"),
		@Result(property = "appStatus", column = "app_status"),
		@Result(property = "appTime", column = "app_time", jdbcType = JdbcType.TIMESTAMP),
		@Result(property = "sysDate", column = "sys_date", jdbcType = JdbcType.TIMESTAMP),
		@Result(property = "appSenderId", column = "app_sender_id"),
		@Result(property = "orderNo", column = "order_no"),
		@Result(property = "ebcCode", column = "ebc_code"),
		@Result(property = "ebcName", column = "ebc_name"),
		@Result(property = "logisticsNo", column = "logistics_no"),
		@Result(property = "logisticsCode", column = "logistics_code"),
		@Result(property = "logisticsName", column = "logistics_name"),
		@Result(property = "copNo", column = "cop_no"),
		@Result(property = "preNo", column = "pre_no"),
		@Result(property = "invtNo", column = "invt_no"),
		@Result(property = "agentCode", column = "agent_code"),
		@Result(property = "agentName", column = "agent_name"),
		@Result(property = "areaCode", column = "area_code"),
		@Result(property = "areaName", column = "area_name"),
		@Result(property = "distStatus", column = "dist_status"),
		@Result(property = "portCode", column = "port_code"),
		@Result(property = "ebpCode", column = "ebp_code"),
		@Result(property = "ebpName", column = "ebp_name"),
		@Result(property = "ieDate", column = "ie_date"),
		@Result(property = "tradeMode", column = "trade_mode"),
		@Result(property = "emsNo", column = "ems_no"),
		@Result(property = "loctNo", column = "loct_no"),
		@Result(property = "buyerName", column = "buyer_name"),
		@Result(property = "country", column = "country"),
		@Result(property = "trafNo", column = "traf_no"),
		@Result(property = "wrapType", column = "wrap_type"),
		@Result(property = "packNo", column = "pack_no"),
		@Result(property = "buyerIdType", column = "buyer_id_type"),
		@Result(property = "consigneeAddress", column = "consignee_address"),
		@Result(property = "voyageNo", column = "voyage_no"),
		@Result(property = "assureCode", column = "assure_code"),
		@Result(property = "grossWeight", column = "gross_weight"),
		@Result(property = "buyerIdNumber", column = "buyer_id_number"),
		@Result(property = "licenseNo", column = "license_no"),
		@Result(property = "billNo", column = "bill_no"),
		@Result(property = "insuredFee", column = "insured_fee"),
		@Result(property = "netWeight", column = "net_weight"),
		@Result(property = "buyerTelephone", column = "buyer_telephone"),
		@Result(property = "trafMode", column = "traf_mode"),
		@Result(property = "freight", column = "freight"),
		@Result(property = "currency", column = "currency"),
		@Result(property = "note", column = "note"),
		@Result(property = "rtnInfo", column = "rtn_info"),
		@Result(property = "detailsCode", column = "detailscode"),
		@Result(property = "auditState", column = "audit_state"),
		@Result(property = "bwName", column = "bw_name"),
		@Result(property = "payName", column = "payname"),
		@Result(property = "goodsValue", column = "goodsvalue"),
		@Result(property = "distNo", column = "dist_no"),
		@Result(property = "distStat", column = "dist_stat"),
		@Result(property = "customsCode", column = "customs_code"),
		@Result(property = "distTime", column = "dist_time"),
		@Result(property = "rtnTime", column = "rtn_time"),
		@Result(property = "rtnSysDate", column = "rtn_sys_date"),
		@Result(property = "cusStatus", column = "cus_status"),
	})
	@SelectProvider(type = InvtHeadSqlProvide.class, method = "getInvtHeadListSql")
	List<InvtHead> getInvtHeadList(InvtHead invtHead);