Add data to a JSP page in SQL Server

Myeclip and SQL Server collocation really bad use, too many bugs Google and Baidu I searched back and forth for several hours some bugs have not been solved, most of them are JDBC problems.

Issue: You cannot insert an explicit value for an identity column in table ' article ' when IDENTITY_INSERT is set to OFF.

Solve:

My increment column is an ID, but this column is not written when I insert it, and can automatically add 1 error notation: INSERT into article (Id,pid,rootid,title,cont,pdate,isleaf) VALUES (null,0,1, ' Gfgisok ', ' isOK ', GETDATE (), 0)

SET IDENTITY_INSERT article on

Insert into article (PID,ROOTID,TITLE,CONT,PDATE,ISLEAF) VALUES (0,1, ' gfgisok ', ' isOK ', GETDATE (), 0)

(pid,rootid,title,cont,pdate,isleaf) must be added, or debugging has been through.

I have not finished writing another day to add more ...

Add data to a JSP page in SQL Server