DBLayer，我最近开源的数据库轻量级orm框架，目前支持sqlserver、mysql、oracle, 特别做了分页的封装。
这个框架从七八年前开始逐渐升级而来，也经历了不少项目，希望可以将大家从sql字符串中解放出来。
开源地址
https://github.com/wutao0315/DBLayer
访问代码案例
/// <summary>
/// 分页查询 /// </summary>
/// <param name="condition">查询条件</param>
/// <returns></returns>
public IEnumerable<SysUser> Seach(SysUserCondition.Search condition)
{ var page = new Pager<SysUserCondition.Search>()
{
Condition = condition,
Table = "sys_user",
Key = "user_id",
Order = string.Empty,
Field = "*",
WhereAction = (Condition, Where, Paramters) =>
{ if (!string.IsNullOrEmpty(Condition.UserName))
{
Where.Append("AND user_name LIKE @user_name ");
Paramters.Add(base.CreateParameter("@user_name", string.Concat("%", Condition.UserName, "%")));
} if (!string.IsNullOrEmpty(Condition.UserEmail))
{
Where.Append("AND user_email LIKE @user_email ");
Paramters.Add(base.CreateParameter("@user_email", string.Concat("%", Condition.UserEmail, "%")));
} if (!string.IsNullOrEmpty(Condition.UserMobile))
{
Where.Append("AND user_mobile LIKE @user_mobile ");
Paramters.Add(base.CreateParameter("@user_mobile", string.Concat("%", Condition.UserMobile, "%")));
}
}
}; var result = base.GetResultByPager<SysUser, SysUserCondition.Search>(page); return result;
}
分页操作
/// <summary>
/// 分页查询 /// </summary>
/// <param name="condition">查询条件</param>
/// <returns></returns>
public IEnumerable<SysUser> Seach(SysUserCondition.Search condition)
{ var page = new Pager<SysUserCondition.Search>()
{
Condition = condition,
Table = "sys_user",
Key = "user_id",
Order = string.Empty,
Field = "*",
WhereAction = (Condition, Where, Paramters) =>
{ if (!string.IsNullOrEmpty(Condition.UserName))
{
Where.Append("AND user_name LIKE @user_name ");
Paramters.Add(base.CreateParameter("@user_name", string.Concat("%", Condition.UserName, "%")));
} if (!string.IsNullOrEmpty(Condition.UserEmail))
{
Where.Append("AND user_email LIKE @user_email ");
Paramters.Add(base.CreateParameter("@user_email", string.Concat("%", Condition.UserEmail, "%")));
} if (!string.IsNullOrEmpty(Condition.UserMobile))
{
Where.Append("AND user_mobile LIKE @user_mobile ");
Paramters.Add(base.CreateParameter("@user_mobile", string.Concat("%", Condition.UserMobile, "%")));
}
}
}; var result = base.GetResultByPager<SysUser, SysUserCondition.Search>(page); return result;
}
推荐和spring 配合使用，具体配置代码请进入源码查看。
同时在spring 配置多个数据库连接，支持数据库连接字符串密码加密。只需要在 passwordKey加入密钥
<object id="sql_wxius_string_server" type="DBLayer.Core.ConnectionString, DBLayer.Core" singleton="true">
<property name="Properties">
<name-values>
<add key="userid" value="sa" />
<add key="password" value="***" />
<add key="passwordKey" value="" />
<add key="database" value="wxius" />
<add key="datasource" value="." />
</name-values>
</property>
<property name="ConnectionToken" value="Password=${password};Persist Security Info=True;User ID=${userid};Initial Catalog=${database};Data Source=${datasource};pooling=true;min pool size=5;max pool size=10" />
</object>
数据库唯一标识除了可以数据自动编码，还支持在代码端自动 生成 GUID 和 时间点。下面代码是uuid,时间点并按照顺序生成的自动编号
<object id="uuidGenerator" type="DBLayer.Persistence.UUIDGenerator, DBLayer.Persistence" singleton="true" > <!--workerId:区域(机房):3 bits--> <constructor-arg name="workerId" value="1"/> <!--regionId:机器编号:10 bits--> <constructor-arg name="regionId" value="1"/> <!--twepoch:基准时间:Thu, 04 Nov 2010 01:42:54 GMT--> <!--(long)(DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc)).TotalMilliseconds--> <constructor-arg name="twepoch" value="1288834974657"/> </object>
http://www.cnblogs.com/jweiswu/p/dblayer.html
延伸阅读
- 程序员不是码农那么简单 2019-05-13 17:11:31.817
- 学习可以使我们的人生变得更加美满充实 2017-11-29 14:42:23.623
- 没有什么不是一个好的团队不可以解决的—由*潮 2017-10-27 14:41:00.813
- kotlin的一些特性介绍和与java C#的简单对比 2017-07-26 16:11:29.443
- MySQL数据库Raid存储方案 2017-07-26 16:08:11.787
- runtime实现对象存储型数据库——LHDB 2017-07-26 15:38:40.013
- 开源个.NetCore写的 - 并发请求工具PressureTool 2017-07-26 14:23:18.507
- Java开源博客My-Blog之mysql容器重复初始化的严重bug修复过程 2017-07-26 14:06:28.98
- 简单谈谈js中的MVC 2017-07-25 10:03:45.287
- 让 Python 带你进入开源的世界——Git 从入门到与他人协作开发 2017-07-25 09:45:56.143
程序员不是码农那么简单