个人资料

跳过导航链接首页 > 博客列表 > 博客正文

更优雅的写代码,sql语句组合工具

分类:

新制作了一个Sql语句组合工具,主要是稍微简化或者说规范化了sql语句拼接的流程,

应该就不太用易出错了,后续自己使用有错误再更正

Nuget包:

PM>Install-Package SqlWriter -Version 1.0.0

用法如下:


//insert itemlist valuelist
var insertSql = new SqlString();
insertSql.Insert("userlist", new string[] { "username", "password","enable","time"}, new object[] { "admin", "a_secret",false,DateTime.Now});
Console.WriteLine(insertSql.result + "\n\r");
		

//delete
var deleteSql = new SqlString();
deleteSql.Delete("userlist");
deleteSql.Where("username", "hacker");
deleteSql.WhereAnd("password", "<script..");
Console.WriteLine(deleteSql.result + "\n\r");
	
//update
var updateSql = new SqlString();
updateSql.Update("userlist", new string[] { "username", "password", "enable", "time" }, new object[] { "admin", "a_secret", false, DateTime.Now });
updateSql.Where("username", "godman");
updateSql.WhereAnd("password", "bequiet0123");
Console.WriteLine(updateSql.result + "\n\r");

//select -> where ->whereand -> order
var selectSql0 = new SqlString();
selectSql0.Select(null, "userlist");
selectSql0.Where("username", "admin");
selectSql0.WhereAnd("password", "sercetX");
selectSql0.WhereAnd("isreal", true);
selectSql0.OrderBy(new OrderBy[] { new OrderBy("SignUpTime", Order.ASC), new OrderBy("followers", Order.DESC) });

Console.WriteLine(selectSql0.result + "\n\r");
	
//select -> where ->whereand -> order
var selectSql = new SqlString();
selectSql.Select(new string[] { "sex", "age" }, "userlist");
selectSql.Where("username", "admin");
selectSql.WhereAnd("password", "sercetX");
selectSql.WhereAnd("isreal", true);
selectSql.OrderBy(new OrderBy[] { new OrderBy("SignUpTime", Order.ASC), new OrderBy("followers", Order.DESC) });

Console.WriteLine(selectSql.result+ "\n\r");
	

//select -> where ->whereand -> order
var selectSql2 = new SqlString();
selectSql2.SelectTop(10,new string[] { "sex", "age" }, "userlist");
selectSql2.Where("username", "admin");
selectSql2.WhereAnd("password", "sercetX");
selectSql2.WhereAnd("isreal", true);
selectSql2.OrderBy(new OrderBy[] { new OrderBy("SignUpTime", Order.ASC), new OrderBy("followers", Order.DESC) });

Console.WriteLine(selectSql2.result + "\n\r");


Console.Read();


测试运行结果:


admin
最初发表2019/9/23 22:38:58 最近更新2019/9/23 23:40:04 63
为此篇作品打分
10
   评论