上下导航

最新推荐文章于 2024-10-13 21:08:42 发布

dotnet90

最新推荐文章于 2024-10-13 21:08:42 发布

阅读量752

点赞数

文章标签： string exception mysql 数据库 null

本文链接：https://blog.csdn.net/dotnet90/article/details/1484480

版权

public string[] getPreNextID( string tableName ,string recID )
        {
           string[] retIDAry = new string[2] { "",""};
            try
            {
                //如果要跨数据库请进行相应的修改
                if (recID == "-1") return retIDAry;
                string mySql = " select ( SELECT max(ID) FROM " + tableName + " where id < '" + recID + "') as preID,( SELECT min(ID) FROM " + tableName + " where id > '" + recID + "' ) as nextID ";
                IDbPaladin dbp = baseProcess.getDbPaladin();//todo:orachange
                DataView dv = dbp.runSqlQuery(mySql);
                if ( dv!=null && dv.Count >0 )
                {
                    retIDAry[0] = dv[0][0].ToString();//preID
                    retIDAry[1] = dv[0][1].ToString();//nextID
                }
            }
            catch (Exception )
            {
            }
            return retIDAry;
        }