Question

java.sql.SQLIntegrityConstraintViolationException:是什么错误

The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL120227211351350' defined on 'TB_TABS'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
.......

部分代码：
public void storeTabs(int tabNum, String tabName){
if(tabName == null || tabName.equals(""))
return;
if(!tabExist(tabName)){
try{
String sql = "insert into tb_tabs values(?,?,?)";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setInt(1, tabNum);
ps.setString(2, tabName);
ps.setInt(3, tabNum +5);
ps.execute(); //提示错误在这个地方
ps.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}

Answer 1

it would have caused a duplicate(重复) key value in a unique or primary key
说的是因为有一个唯一的键值重复了,可能是你插入了两条主键一样的数据,数据库里的主键是不能重复的

Answer 2

异常信息里面提示了，是你插入数据与你的表中的约束有冲突，与你的主键或者设置有唯一约束的列有冲突！

Answer 3

integrity constraint 不是完整性约束么