Question

警告: Exception from exceptionCommand 'servlet-exception

org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [update liber_db.operator_t set name=?, password=?, system=?, reader=?, book=?, borrow=?, query=? where id=?]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:643)
at org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:794)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:665)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:755)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:475)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:270)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
at

Answer 1

先看这句
SQL [update liber_db.operator_t set name=?, password=?, system=?, reader=?, book=?, borrow=?, query=? where id=?]; constraint [null];

constraint [null];的意思是你在更新的时候把字段更新成了null，但是这个字段又有不能为null的约束
再看
org.hibernate.exception.ConstraintViolationException。它的意思就是违反约束，也就是上面不能为null的约束

Answer 2

好像是，这个表 liber_db.operator_t 里面有不能为null 的列 而你传入值为null
把全部的exception 贴出来