基于javaweb+SSM校园快递物流管理系统
开发工具:eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
<if test="orderno != null" >
orderno = #{orderno} ,
</if>
<if test="yuangongid != null" >
yuangongid = #{yuangongid} ,
</if>
<if test="content != null" >
content = #{content} ,
</if>
<if test="username != null" >
username = #{username} ,
</if>
<if test="userphone != null" >
userphone = #{userphone} ,
</if>
<if test="shijian != null" >
shijian = #{shijian} ,
</if>
<if test="status != null" >
status = #{status}
</if>
</sql>
<!-- 查询时条件 -->
<sql id="Order_where">
<if test="id != null" >
and id = #{id}
* 取当前日期(yyyy-mm-dd hh:mm:ss)
*
* @return 时间Timestamp
*/
public static String getTodayDateTime() {
return format(new Date());
}
/**
* 取得n分钟后的时间
*
* @param date 日期
* @param afterMins
* @return 时间Timestamp
*/
public static Date getAfterMinute(Date date, long afterMins) {
if (date == null)
date = new Date();
long longTime = date.getTime() + afterMins * 60 * 1000;
return new Date(longTime);
if (sDate.length() == 10) {
sDate = sDate + " 00:00:00";
}
if (sDate.length() == 16) {
sDate = sDate + ":00";
}
return Timestamp.valueOf(sDate);
}
/**
* Date转换为Timestamp
*/
public static Timestamp convert(Date date) {
return new Timestamp(date.getTime());
}
and id=#{id}
</u