利用反射动态构成sql语句

最新推荐文章于 2022-04-26 16:36:30 发布

mx5721

最新推荐文章于 2022-04-26 16:36:30 发布

阅读量1.1k

点赞数

分类专栏： C#

本文链接：https://blog.csdn.net/mx5721/article/details/9621031

版权

C# 专栏收录该内容

25 篇文章 0 订阅

订阅专栏

class Program
    {
        static void Main(string[] args)
        {
            People p = new People();
            Insert(p);
        }

        public static bool Insert(object obj)
        {
            Type type = obj.GetType();
            string tableName = "tb_" + type.Name;
            string sql = "insert into " + tableName + "(";
            PropertyInfo[] properties = type.GetProperties();
            foreach (PropertyInfo pInfo in properties)
            {
                sql += pInfo.Name + ",";
            }
            sql = sql.Substring(0, sql.LastIndexOf(','));
            sql += ") values(";
            foreach (PropertyInfo pInfo in properties)
            {
                sql += "'" + pInfo.GetValue(obj, null) + "',";
            }
            sql = sql.Substring(0, sql.LastIndexOf(','));
            sql += ")";

            return true;
        }
    }
    class People
    {
        public string Name { set; get; }
        public string Age { set; get; }
        public string Sex { set; get; }
    }