1、要求保存数据格式为yyyy-MM-dd HH:mm:ss
a. java中数据类型为java.util.Date
b.Mysql中数据类型为datetime
c.Mybatis的mapper中类型为TIMESTAMP
如:
<mapper namespace="cn.manage.mapper.LoginLogMapper" >
<resultMap id="BaseResultMap" type="cn.manage.entity.LoginLog" >
<id column="id" property="id" jdbcType="INTEGER" />
<result column="login_name" property="loginName" jdbcType="VARCHAR" />
<result column="login_time" property="loginTime" jdbcType="TIMESTAMP" />
<result column="login_ip" property="loginIp" jdbcType="VARCHAR" />
<result column="source" property="source" jdbcType="VARCHAR" />
<result column="remark" property="remark" jdbcType="VARCHAR" />
</resultMap>
LoginLog loginLog = new LoginLog() ;
loginLog.setLoginName(user.getId());
loginLog.setLoginTime(new Date()); // import java.util.Date;
login_time
datetime
仅供参考...