[SQLServer 2000 Driver for JDBC][SQLServer]违反了 PRIMARY KEY 约束 'trainInformationID'。不能在对象 'O_TRAIN_INFOMATION' 中插入重复键。我有两个表,一个表的主键是另一个表的外键.就是一对多的关系
但是我往多的一段只能加入一条数据!加入第二条的时候就报上面的错误!郁闷死!什么原因这是?
谁能根据上面的报错给我找着原因啊
但是我往多的一段只能加入一条数据!加入第二条的时候就报上面的错误!郁闷死!什么原因这是?
谁能根据上面的报错给我找着原因啊
解决方案 »
- JAVA API的学习
- 数组的相关操作--------孙鑫视频
- 客户端sorket编程 读取网络电子称数据
- java中如何操纵css文件?
- 请问聊天窒的私聊是怎么实现的
- ☆☆ jdbc调存储过程不能带SCHEMA???☆ ☆
- native方法的使用
- 我的导师给我出了一个论文题目《java多线程技术探讨》
- 各位高高手,有没有MS SQLServer6.5的JDBC驱动?救人一命胜造十级**,忘了咋说的了.
- 问题提得有点不好意思:最简单的JAVA代码编辑成class后,用java test.class运行时提示Exception in thread "main"...
- contenPane小问题
- myeclipse自动排序时怎么让被注释的也排序?
BEGIN
DROP TABLE O_TRAIN_CATEGORY
PRINT '<<< DROPPED TABLE O_TRAIN_CATEGORY >>>'
END
go
IF OBJECT_ID('O_TRAIN_INFOMATION') IS NOT NULL
BEGIN
DROP TABLE O_TRAIN_INFOMATION
PRINT '<<< DROPPED TABLE O_TRAIN_INFOMATION >>>'
END
go
/*
* TABLE: O_TRAIN_CATEGORY
*/CREATE TABLE O_TRAIN_CATEGORY(
trainCategoryID int NOT NULL,
trainCategoryName varchar(30) NOT NULL,
trainCategoryActiveStatus int DEFAULT 1 NOT NULL,
CONSTRAINT trainCategoryID PRIMARY KEY NONCLUSTERED (trainCategoryID)
)
goIF OBJECT_ID('O_TRAIN_CATEGORY') IS NOT NULL
PRINT '<<< CREATED TABLE O_TRAIN_CATEGORY >>>'
ELSE
PRINT '<<< FAILED CREATING TABLE O_TRAIN_CATEGORY >>>'
go/*
* TABLE: O_TRAIN_INFOMATION
*/CREATE TABLE O_TRAIN_INFOMATION(
trainInformationID int NOT NULL,
trainInformationTitle varchar(30) NOT NULL,
trainInformationContent varchar(80) NOT NULL,
trainInformationStartTime datetime NOT NULL,
trainInformationFinishTime datetime NOT NULL,
traineeName varchar(30) NULL,
trainInformationActiveStatus int DEFAULT 1 NOT NULL,
trainRe varchar(100) NULL,
trainCategoryID int NOT NULL,
CONSTRAINT trainInformationID PRIMARY KEY NONCLUSTERED (trainInformationID)
)
goIF OBJECT_ID('O_TRAIN_INFOMATION') IS NOT NULL
PRINT '<<< CREATED TABLE O_TRAIN_INFOMATION >>>'
ELSE
PRINT '<<< FAILED CREATING TABLE O_TRAIN_INFOMATION >>>'
go/*
* TABLE: O_TRAIN_INFOMATION
*/ALTER TABLE O_TRAIN_INFOMATION ADD CONSTRAINT RefO_TRAIN_CATEGORY4
FOREIGN KEY (trainCategoryID)
REFERENCES O_TRAIN_CATEGORY(trainCategoryID)
go
这是我的建表语句
代码看看哇