在myeclipse下在访问修改数据的时候出现 Duplicate entry '1' for key 'PRIMARY'

0 0

在myeclipse下在访问修改数据的时候出现 Duplicate entry '1' for key 'PRIMARY'5

在myeclipse下修改数据库中数据的时候出现了
Duplicate entry '1' for key 'PRIMARY'，数据库表中assetsid为主键，我应该怎样来修改代码实现修改数据的功能，求各位帮忙解决。。。
public boolean update(AssetsaddForm assetsaddForm) {

int assetsid = assetsaddForm.getAssetsid();
String assetsname = assetsaddForm.getAssetsname();
String assetscategory = assetsaddForm.getAssetscategory();
String assetstype = assetsaddForm.getAssetstype();
String assetsfactory = assetsaddForm.getAssetsfactory();
int assetsnum = assetsaddForm.getAssetsnum();
String assetsbuydate = assetsaddForm.getAssetsbuydate();
String assetsstate = assetsaddForm.getAssetsstate();
String assetssource = assetsaddForm.getAssetssource();
float assetsvalue = assetsaddForm.getAssetsvalue();
float assetsresidualrate = assetsaddForm.getAssetsresidualrate();
int assetsage = assetsaddForm.getAssetsage();

Statement stmt = null;
if (assetsid <= 0) {
return false;
}

try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/logistics", "root", "123456");
stmt = conn.createStatement();

String sql="Update assetsdata set assetsname="+assetsname
+",assetscategory='"+assetscategory
+"',assetstype='"+assetstype
+"',assetsfactory='"+assetsfactory
+"',assetsnum="+assetsnum
+",assetsbuydate="+assetsbuydate
+",assetsstate="+assetsstate
+"',assetssource='"+assetssource
+"',assetsvalue="+assetsvalue
+",assetsresidualrate="+assetsresidualrate
+",assetsage="+assetsage
+" where assetsid="+assetsid+"";
System.out.println(assetsid);
stmt.executeUpdate(sql);

} catch (Exception ex) {
System.out.println(ex.getMessage());
return false;
} finally {
try {
stmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}
return true;
}