String query = "create table student ( " +  
" snumber int primary key," +           //加上主键约束primary key
" sname varchar(20) ," +  
" sgender varchar(4) ," +
" sage int ," +  
" smath double ," +
" senglish double ," +  
" schinese double ," +  
" sphysical double ," +
" schemistry double ," +
" spoint double , " +
" Primary key ( snumber )" +
")" ;

------解决方案--------------------
String query = "create table student ( " + 
" snumber int ," +
" sname varchar(20) ," + 
" sgender varchar(4) ," +
" sage int ," + 
" smath double ," +
" senglish double ," + 
" schinese double ," + 
" sphysical double ," +
" schemistry double ," +
" spoint double , " +
" Primary key ( snumber ), UNIQUE KEY `idx_snumber` (`snumber`)" +
")" ;

------解决方案--------------------
探讨


引用:
应该是主键没添加成功。可能你的写法有误？如果主键添加成功 违反主键约束会提示报错的。
用这种试试 snumber int primary key,
把 Primary key (snumber) 这个删了。


JDriver = "sun.jdbc.odbc.JdbcOdbcDriver"
我的驱动， 添加 "snumber int primary ke……


------解决方案--------------------
LZ把建表和主键的语句分开试试。参照下面的

首先对 id 这个列，增加一个 NOT NULL 约束，然后再设置为主键。

1> ALTER TABLE test_tab
2>   ALTER COLUMN id INT NOT NULL;

1> ALTER TABLE test_tab
2>    ADD CONSTRAINT pk_test_tab PRIMARY KEY(id);