一个javabean如下

有四个日期Date类型 createTime, payDate, deliverDate,confirmDate;

import java.util.Date;public class Orders {    private int oid;    private int bid;//箱子号    private int uid;//用户信息，卖家    private String orderCode;//订单号    private int receiver;//买家    private String userMessage;//卖家信息    private String phone;//联系方式    private Date createTime;//创建订单信息    private Date payDate;//支付日期    private Date deliverDate;//发货日期    private Date confirmDate;//确认收货日期    private int orderState;//订单状态    private int pid;//产品信息    public Orders() {        super();    }    public Orders(int oid, int bid, int uid, String orderCode, int receiver, String userMessage, String phone,            Date createTime, Date payDate, Date deliverDate, Date confirmDate, int orderState, int pid) {        super();        this.oid = oid;        this.bid = bid;        this.uid = uid;        this.orderCode = orderCode;        this.receiver = receiver;        this.userMessage = userMessage;        this.phone = phone;        this.createTime = createTime;        this.payDate = payDate;        this.deliverDate = deliverDate;        this.confirmDate = confirmDate;        this.orderState = orderState;        this.pid = pid;    }    public int getOid() {        return oid;    }    public void setOid(int oid) {        this.oid = oid;    }    public int getBid() {        return bid;    }    public void setBid(int bid) {        this.bid = bid;    }    public int getUid() {        return uid;    }    public void setUid(int uid) {        this.uid = uid;    }    public String getOrderCode() {        return orderCode;    }    public void setOrderCode(String orderCode) {        this.orderCode = orderCode;    }    public int getReceiver() {        return receiver;    }    public void setReceiver(int receiver) {        this.receiver = receiver;    }    public String getUserMessage() {        return userMessage;    }    public void setUserMessage(String userMessage) {        this.userMessage = userMessage;    }    public String getPhone() {        return phone;    }    public void setPhone(String phone) {        this.phone = phone;    }    public Date getCreateTime() {        return createTime;    }    public void setCreateTime(Date createTime) {        this.createTime = createTime;    }    public Date getPayDate() {        return payDate;    }    public void setPayDate(Date payDate) {        this.payDate = payDate;    }    public Date getDeliverDate() {        return deliverDate;    }    public void setDeliverDate(Date deliverDate) {        this.deliverDate = deliverDate;    }    public Date getConfirmDate() {        return confirmDate;    }    public void setConfirmDate(Date confirmDate) {        this.confirmDate = confirmDate;    }    public int getOrderState() {        return orderState;    }    public void setOrderState(int orderState) {        this.orderState = orderState;    }    public int getPid() {        return pid;    }    public void setPid(int pid) {        this.pid = pid;    }    @Override    public String toString() {        return "Orders [oid=" + oid + ", bid=" + bid + ", uid=" + uid + ", orderCode=" + orderCode + ", receiver="                + receiver + ", userMessage=" + userMessage + ", phone=" + phone + ", createTime=" + createTime                + ", payDate=" + payDate + ", deliverDate=" + deliverDate + ", confirmDate=" + confirmDate                + ", orderState=" + orderState + ", pid=" + pid + "]";    }}

 

此javabean对应的数据库如下

 

将orders一个类存入数据库，在类型转换上遇到了点问题

 

这是写的一个datetime与date转换的一个类

　　public class DateUtil {
      　　//将date转化为datetime    public static java.sql.Timestamp dtot(java.util.Date d) {        if (null == d)            return null;        return new java.sql.Timestamp(d.getTime());    }    　　//将datetime转化为date    public static java.util.Date ttod(java.sql.Timestamp t) {        if (null == t)            return null;        return new java.util.Date(t.getTime());    }}

 

OrdersDao的添加方法

在添加时调用，一开始调用的话，在get方法时候又会为data（加粗部分）

public void add(Orders order) {        String sql = "insert into Orders(oid,uid,bid,orderCode,receiver,phone,userMessage,createTime,payDate,deliverDate,cofirmDate,orderState,pid) values(?,?,?,?,?,?,?,?,?,?,?,?,?);";        try {            DBUtil.update(sql, order.getOid(),order.getUid(),order.getBid(),order.getOrderCode(),order.getReceiver(),order.getPhone(),order.getUserMessage(), DateUtil.dtot(order.getCreateTime()),DateUtil.dtot(order.getPayDate()),DateUtil.dtot(order.getDeliverDate()),DateUtil.dtot(order.getConfirmDate()), order.getOrderState(),order.getPid());        }catch(Exception e) {            e.printStackTrace();        }    }