public void adduser(UserBean user) throws SQLException{
String query = "INSERT INTO usersInformation ( username, " +
"password, email ) VALUES ( '" + user.getUsername() + "', '" +
user.getPassword() + "', '" + user.getEmail() + "' )" ;
statement.execute(query);
}
在这一行我得到了这个异常:有人能帮帮我吗?异常:被终止,因为它会在'USERSINFORMATION'上定义的'SQL140525011235350'标识的唯一或主键约束或唯一索引中导致重复的键值。
[编辑]这是我的bean类
public class UserBean {
private String username;
private String password;
private String email;
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
}
index.jsp (index.jsp的邮件部分)
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<jsp:useBean id = "userbean" class = "newpackage.UserBean" />
<jsp:useBean id = "userdatabean" class = "newpackage.UserDataBean" />
<jsp:setProperty name ="userbean" property="*"/>
<% userdatabean.adduser(userbean); %>
从异常详细信息可以清楚地看出,该语句在主键字段中输入了重复值,从而违反了唯一键约束。检查您的数据并插入相应的