河源开发

@RenderPage("~/Views/Shared/_Test.cshtml")

@using (Html.BeginForm())
{
}

调试查看源码时没有 form 标记

改成

@Html.Partial("~/Views/Shared/_Test.cshtml")

@using (Html.BeginForm())
{
}

就解决了。

使用rs.next()是否为true来判断，会使游标前移一位，可能丢掉一条记录

if(rs.next()) {
rs.first();
}这样是不是可以重新回到原始位置

改下算法就可以了 太大意了最终结果

   pstm = conn.prepareStatement("select * From Cl_ArticleClass Where ParentID=? order by OrderID");
              pstm.setInt(1,parentid);
              rs = pstm.executeQuery();
              if(rs.next()){
               coll= new ArrayList<ArticleClassInfo>();
               
             do{
         ArticleClassInfo ac = new ArticleClassInfo();
        ac.setClassID(rs.getInt("ClassID"));
        ac.setParentPath(rs.getString("ParentPath"));
        ac.setClassName(rs.getString("ClassName"));
        ac.setChild(rs.getInt("Child"));
        ac.setNextID(rs.getInt("NextID"));
        ac.setDepth(rs.getInt("Depth"));
        coll.add(ac);
     } while(rs.next());
              }

 [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());
             }
         }
  
 }