int count = 0;
DataSource ds = Conn.getDS();
if (ds != null) {
QueryRunner qr = new QueryRunner(ds);
String sql = "update t_order set sstatus=?,smsg=?,sauser=?,dadate=? where nid=?"+orderBean.getNid();
Object[] tmp = {orderBean.getSstatus(),orderBean.getSmsg(),orderBean.getSauser(),orderBean.getNid()};
try {
count = qr.update(sql, tmp);里面dadate是MYSQL的Date类型,用什么方法可以获取系统时间,并赋值给Date类型,然后用getString类型赋值
DataSource ds = Conn.getDS();
if (ds != null) {
QueryRunner qr = new QueryRunner(ds);
String sql = "update t_order set sstatus=?,smsg=?,sauser=?,dadate=? where nid=?"+orderBean.getNid();
Object[] tmp = {orderBean.getSstatus(),orderBean.getSmsg(),orderBean.getSauser(),orderBean.getNid()};
try {
count = qr.update(sql, tmp);里面dadate是MYSQL的Date类型,用什么方法可以获取系统时间,并赋值给Date类型,然后用getString类型赋值
不行吗?dadate默认为当前时间吗?
为什么不在mysql中直接设置呢?
String sql = "update t_order set sstatus=?,smsg=?,sauser=?,dadate=to_date(?,'yyyy-Mm-dd') where nid=?"+orderBean.getNid();