----------------------------大神帮看下,从SQL语句中抽取表名-----------------------

雄牛 2017-05-06 05:24:38

感觉代码有很多BUG,但目前还没测出来,路过的帮瞄一瞄...谢谢



  //精简SQL语句,准确定位表名

        public static string resultTable(string strSQL)

        {

            string sTable = strSQL;

            if (strSQL.Contains("insert into"))

            {

                sTable = sTable.Substring(sTable.IndexOf("insert into"), sTable.Length - sTable.IndexOf("insert into"));

                sTable = sTable.Substring(sTable.IndexOf("insert into"), sTable.IndexOf("(") - sTable.IndexOf("insert into")).Trim();//截取表名

                sTable = sTable.Replace("insert into", "").Trim();

            }

            if (strSQL.Contains("update"))

            {

                sTable = sTable.Substring(sTable.IndexOf("update"), sTable.Length - sTable.IndexOf("update"));

                sTable = sTable.Substring(sTable.IndexOf("update"), sTable.IndexOf("set") - sTable.IndexOf("update")).Trim();//截取表名

                sTable = sTable.Replace("update", "").Trim();

            }

            if (strSQL.Contains("delete from") && strSQL.Contains("where"))

            {

                sTable = sTable.Substring(sTable.IndexOf("delete from"), sTable.Length - sTable.IndexOf("delete from"));

                sTable = sTable.Substring(sTable.IndexOf("delete from"), sTable.IndexOf("where") - sTable.IndexOf("delete from")).Trim();//截取表名

                sTable = sTable.Replace("delete from", "").Trim();

            }

            return sTable;

        }