700字范文,内容丰富有趣,生活中的好帮手!
700字范文 > mysql 1364 hy000_mysql SQL Error: 1364 SQLState: HY000 保存错误

mysql 1364 hy000_mysql SQL Error: 1364 SQLState: HY000 保存错误

时间:2022-05-08 04:39:00

相关推荐

mysql 1364 hy000_mysql SQL Error: 1364  SQLState: HY000 保存错误

OrderForm orderForm = new OrderForm();

orderForm.setAddIp((String) map.get("ip"));// ip

orderForm.setAddTime(new Date());// 日期

orderForm.setOrderStatus(10);// 订单状态

orderForm.setAddUserId((long) map.get("addUserId"));

orderForm.setOrderType((byte) 0);// 下单方式

orderForm.setInvoiceType(0);

SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmssSSS"); // 时间格式精确到毫秒

String code = sdf.format(System.currentTimeMillis()); // 获得时间戳(毫秒)

orderForm.setOrderCode(map.get("userId") + code);// 订单号

orderForm.setMsg(storeAndGoodsVos.get(i).getMsg());

orderForm.setUserId((Long) map.get("userId"));

orderForm.setStoreId(storeAndGoodsVos.get(i).getStoreId());

orderForm.setTotalPrice((BigDecimal) map.get("totalPrice"));

orderForm.setOriginalPrice((BigDecimal) map.get("originalPrice"));

Address address = addressDao.findById((Long) map.get("addrId"));

Area area = new Area();

if (null != address) {

if (null != address.getArea()) {

area = address.getArea().getAreaByParentId();

}

}

orderForm.setAddress(address);

orderForm.setShopEvaluate(0);

orderForm.setIsDelete(false);

orderFormDao.save(orderForm);

if (orderForm.getOrderId() > 0) {

保存后报错 Field 'select TABLE_NAME

from information_schema.COLUMNS

is_delete' doesn't have a default value 但是我数据库表有is_delete字段 默认为0 实体类注解配置好了@Column(name = "is_delete")

public Boolean getIsDelete() {

return this.isDelete;

}

public void setIsDelete(Boolean isDelete) {

this.isDelete = isDelete;

}

之前好用 突然不好用了

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。