总算能贴代码了

最新推荐文章于 2023-03-01 14:21:52 发布

猴子酋长

最新推荐文章于 2023-03-01 14:21:52 发布

阅读量317

点赞数

分类专栏：随便写写文章标签： string command null class struct object

本文链接：https://blog.csdn.net/sp_chenjie/article/details/4087391

版权

随便写写专栏收录该内容

10 篇文章 0 订阅

订阅专栏

这篇博客介绍了如何使用C#解析XML文件中的SQL语句，并将数据结构化为SqlData结构。同时，展示了如何基于这个结构创建MySqlCommand对象，进行参数化查询。

摘要由CSDN通过智能技术生成

public class Class1
    {
        public struct SqlData
        {
            public String sqlStatement;
            public String[] sqlParamKey;
            public String[] sqlParamType;
        }

private Hashtable htSqlStatementData = null;

        public Hashtable SqlStatementData
        {
            get
            {
                return htSqlStatementData;
            }
        }

        public Class1()
        {
            htSqlStatementData = new Hashtable();
            getXmlSql();
        }

        private void getXmlSql()
        {
            try
            {
                XmlDocument dom = new XmlDocument();
                dom.Load("SqlStatement.xml");

XmlNodeList nodeListSql = dom.GetElementsByTagName("SQL");

                if (nodeListSql == null)
                {
                    return;
                }

                for (int i = 0; i < nodeListSql.Count; i++)
                {
                    XmlNode sqlNode = nodeListSql[i];
                    String sqlId = sqlNode.Attributes["ID"].Value;
                    int paramCount = 0;
                    int.TryParse(sqlNode.Attributes["PARAMCOUNT"].Value, out paramCount);

                    SqlData sqlData = new SqlData();
                    sqlData.sqlParamKey = new string[paramCount];
                    sqlData.sqlParamType = new string[paramCount];

XmlNodeList nodeListSqlDetails = sqlNode.ChildNodes;

                    if (nodeListSql == null)
                    {
                        continue;
                    }

int paramIndex = 0;

                    for (int j = 0; j < nodeListSqlDetails.Count; j++)
                    {
                        XmlNode sqlNodeDetail = nodeListSqlDetails[j];
                        if ("STATMENT".Equals(sqlNodeDetail.Name))
                        {
                            XmlNode textNode = sqlNodeDetail.FirstChild;
                            sqlData.sqlStatement = textNode.Value;
                            continue;
                        }

                        if ("PARAMENT".Equals(sqlNodeDetail.Name))
                        {
                            if (sqlData.sqlParamKey.Length <= paramIndex)
                            {
                                break;
                            }
                            sqlData.sqlParamKey[paramIndex] = sqlNodeDetail.Attributes["ID"].Value;
                            sqlData.sqlParamType[paramIndex] = sqlNodeDetail.Attributes["TYPE"].Value;

                        }
                    }
                    htSqlStatementData.Add(sqlId, sqlData);
                }

            }
            catch
            {
            }

        }

        public MySqlCommand getMySqlCommand(MySqlConnection con, string strCommandId, Hashtable htParam)
        {
            MySqlCommand command = con.CreateCommand();

            Object objHashData = htSqlStatementData[strCommandId];
            if (objHashData == null)
            {
                return null;
            }
            SqlData sqlData = (SqlData)objHashData;

command.CommandText = sqlData.sqlStatement;

            if (sqlData.sqlParamKey == null || sqlData.sqlParamKey.Length == 0)
            {
                return command;
            }

            for (int i = 0; i < sqlData.sqlParamKey.Length; i++)
            {
                MySqlParameter param = new MySqlParameter();
                param.ParameterName = sqlData.sqlParamKey[i];
                param.MySqlDbType = (MySqlDbType)Enum.Parse(typeof(MySqlDbType), sqlData.sqlParamType[i], true);
                param.Value = htParam[sqlData.sqlParamKey[i]];
            }
            return command;
        }
    }