SSM整合时候的Mytabis插入的SQL错误问题
你大爷D 2017-07-20 09:52:22 Logs实体类
package com.cn.model;
private String logid;
private String ip;
private Date insertTime;
private String condate;
private String userId;
与数据库的属性是对应的,日期都是Date,别的都是varchar
Controller层获取的值之后插入
Logs log=new Logs();
log.setCondate(condate);
log.setLogid(logid);
log.setInsertTime(new Date());
log.setUserId(id);
log.setIp(ips);
Service的DAO的方法
public void inserDate(Logs log);
Service实现的方法
public void inserDate(Logs log) {
// TODO Auto-generated method stub
dao.add(log);
}
Dao的对应的插入方法
public void add(Logs log);
Dao的XML的插入
<insert id="add" parameterType="com.cn.model.Logs" >
insert into logs(logid,ip,insertTime,condate,userId) values(#{logid},#{ip},#{insertTime,jdbcType=DATE},#{condate},#{userId})
</insert>
//这是DAO。xml的三个方法的SQL,其他两个方法以及前后台走通,就中间的insert into 方法不行,一执行就报错误,请看最下面
<select id="cheks" parameterType="UserModel" resultType="int">
select count(*) from usertest where userName=#{userName} and userPassWord=#{userPassWord}
</select>
<insert id="add" parameterType="com.cn.model.Logs" >
insert into logs(logid,ip,insertTime,condate,userId) values(#{logid},#{ip},#{insertTime,jdbcType=DATE},#{condate},#{userId})
</insert>
<select id="findOne" parameterType="String" resultType="UserModelS">
select * from usertest where userName=#{userName}
</select>
这是错误
org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet [SpringServlet] in context with path [/Together] threw exception [Handler processing failed; nested exception is java.lang.AbstractMethodError: oracle.jdbc.driver.OracleConnection.prepareStatement(Ljava/lang/String;I)Ljava/sql/PreparedStatement;] with root cause
java.lang.AbstractMethodError: oracle.jdbc.driver.OracleConnection.prepareStatement(Ljava/lang/String;I)Ljava/sql/PreparedStatement;