Sqlite 主键问题

 [ArticleID]  AUTOINC NOT NULL PRIMARY KEY 添加时出错 网上找了很多资料原来主键只能是 INTEGER, 改成 [ArticleID] INTEGER NOT NULL PRIMARY KEY,

完整代码如下:

 private final static String INSERT_ARTICLE = "insert into [Cl_Article] ([ArticleID],[ClassID],[Title],[Author],[CopyFrom],[Content],[DefaultPicUrl]) values (NULL,?,?,?,?,?,?)";
 

public void Add(ArticleInfo obj) {
  Connection conn = DbHelper.getConnect();
        PreparedStatement pstm = null;
        try {
            pstm = conn.prepareStatement(INSERT_ARTICLE);
            pstm.setInt(1,obj.getClassID());
            pstm.setString(2,obj.getTitle());
            pstm.setString(3,obj.getAuthor());
            pstm.setString(4,obj.getCopyFrom());
            pstm.setString(5,obj.getContent());
            pstm.setString(6,obj.getDefaultPicUrl());

            pstm.executeUpdate();
        }
        catch (SQLException ex) {
            System.err.println("Article.java Add(ArticleInfo obj) 添加发生错误 : " + ex.getMessage());
         }
         finally{
           
             try {
                 pstm.close();
             }
             catch (Exception ex) {
              System.out.println("Article.java Add(ArticleInfo obj) 关闭 pstm 失败 : " + ex.getMessage());
             }
             try {
                 conn.close();
             }
             catch (Exception ex) {
              System.out.println("Article.java Add(ArticleInfo obj) 关闭数据库连接失败 : " +ex.getMessage());
             }
         }
  
 }