JavaWeb project looks something like this
customerInfo object has all the values, and none is empty.
here is the add method
public boolean customerInfoAdd(SendCard customerInfo){
try {
sqlSession.insert("insertSendCard", customerInfo);
} catch (Exception e) {
log.error(":insertSendCard");
e.printStackTrace();
return false;
}
return true;
}<insert id="insertSendCard" parameterType="com.****.****.****.****">
<![CDATA[
insert into T_SENDCARD(
sendcardid,
termid,
idno,
name,
telphone,
address,
cardno,
issuedate,
operator,
sex,
nationality,
birthday,
cardtype,
organs
)
values
(
-sharp{sendcardid},
-sharp{termno},
-sharp{idcard_no},
-sharp{cus_name},
-sharp{phone},
-sharp{home_address},
-sharp{bankcardno},
-sharp{status_datetime},
-sharp{bankuserid},
-sharp{sex},
-sharp{nation},
-sharp{birthday},
-sharp{cardtype},
-sharp{fzjg}
)
]]>
</insert>
failed to insert data.
[0410 11:07:27 424 INFO ] [http-bio-8080-exec-7] factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
[0410 11:07:27 451 INFO ] [http-bio-8080-exec-7] jdbc.support.SQLErrorCodesFactory - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
[0410 11:07:27 456 ERROR] [http-bio-8080-exec-7] TradeLogDaoImpl - :insertSendCard