问题描述
报错:no typehandler found for property time
(注:time是localdatetime类型的字段)
localdatetimetypehandler
public class localdatetimetypehandler implements typehandler<localdatetime> {
private datetimeformatter formatter = datetimeformatter.ofpattern("yyyy-mm-dd hh:mm:ss");
@override
public void setparameter(preparedstatement ps, int i, localdatetime parameter, jdbctype jdbctype) throws sqlexception {
if (parameter != null) {
ps.setstring(i, formatter.format(parameter));
} else {
ps.settimestamp(i, null);
}
}
@override
public localdatetime getresult(resultset rs, string columnname) throws sqlexception {
string datestr = rs.getstring(columnname);
return datestr == null ? null : localdatetime.parse(datestr, formatter);
}
@override
public localdatetime getresult(resultset rs, int columnindex) throws sqlexception {
string datestr = rs.getstring(columnindex);
return datestr == null ? null : localdatetime.parse(datestr, formatter);
}
@override
public localdatetime getresult(callablestatement cs, int columnindex) throws sqlexception {
string datestr = cs.getstring(columnindex);
return datestr == null ? null : localdatetime.parse(datestr, formatter);
}
}
mybatis-config.xml
<?xml version="1.0" encoding="utf-8" ?>
<!doctype configuration
public "-//mybatis.org//dtd config 3.0//en"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<settings>
</settings>
<typehandlers>
<typehandler handler="com.vanwardsmart.mybatis.localdatetimetypehandler" javatype="java.time.localdatetime"/>
</typehandlers>
</configuration>到此这篇关于mybatis3.4.0不支持localdatetime的解决方法(no typehandler found for property time)的文章就介绍到这了,更多相关mybatis3.4.0不支持localdatetime内容请搜索代码网以前的文章或继续浏览下面的相关文章希望大家以后多多支持代码网!
发表评论