DAL

最新推荐文章于 2024-09-02 07:02:10 发布
最新推荐文章于 2024-09-02 07:02:10 发布
阅读量272 收藏
点赞数
文章标签： string sql dataset exception list null
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zwnboy111/article/details/5622138
版权


using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using MyOffice.Models;

namespace MyOffice.DAL
{
    /*
     *用户信息数据访问类
     * 创建人：zwn
     * 创建时间：2009-09-21
     * 说明：用于对用户表中数据进行操作
     * 修改人：tu
     * 修改时间：2009-09-22
     * 修改说明：
     * 1.在读取用户表中RealName,ImageUrl时判别是否未空
     * 2.各方法添加注释
     */
    public static partial class UserInfoService
    {
        private static string publicSql = " and UserState=(select UserStateId from UserState where UserStateName!='被屏蔽') and RoleId!=(select RoleId from RoleInfo where RoleName='超级管理员') ";
        /// <summary>
        /// 根据用户ID修改用户密码
        /// </summary>
        /// <param name="userInfo"></param>
        /// <returns></returns>
        public static bool ModifyPasswordByUserId(UserInfo userInfo)
        {
            string sql =
               "UPDATE UserInfo " +
               "SET " + "Password = @Password " +
               "WHERE UserId = @UserId";

            try
            {
                SqlParameter[] para = new SqlParameter[]
    {                   
     new SqlParameter("@Password", userInfo.Password),
                     new SqlParameter("@UserId",userInfo.UserId)
    };

                int result = DBHelper.ExecuteNonQuery(DBHelper.connString, CommandType.Text, sql, para);
                if (result > 0)
                    return true;
                return false;
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
        }
        /// <summary>
        /// 根据查询参数获取用户信息
        /// </summary>
        /// <param name="condition">查询条件</param>
        /// <param name="conditionValue">对应查询条件的值</param>
        /// <returns></returns>
        public static IList<UserInfo> GetUserInfoByParam(string condition, string conditionValue)
        {
            string sql = "select * from [UserInfo] where 1=1 ";
            if (!conditionValue.Equals("") && conditionValue.Length > 0)
            {
                if (condition.Equals("DepartId"))//当条件为“部门名称”时
                {
                    sql += "and DepartId in (select [DepartId] from dbo.DepartInfo where [DepartName] like @conditionValue)";
                }
                else if (condition.Equals("RoleId"))//当条件为“角色”时
                {
                    sql += "and RoleId in (select [RoleId] from dbo.RoleInfo where [RoleName] like @conditionValue)";
                }
                else if (condition.Equals("UserState"))//当条件为“状态”时
                {
                    sql += "and UserState in (select [UserStateId] from dbo.UserState where [UserStateName] like @conditionValue)";
                }
                else if (condition.Equals("Gender"))//当条件为“性别”时
                {
                    int Gender = 0;
                    if (conditionValue.Equals("女"))
                        Gender = 1;
                    else if (conditionValue.Equals("男"))
                        Gender = 0;
                    else
                        Gender = -1;

                    sql += " and " + condition + " =" + Gender;
                }
                else
                {
                    sql += " and " + condition + " like @conditionValue";
                }
            }
            return GetUserInfosBySql(sql + publicSql + " order by userId desc ", new SqlParameter("@conditionValue", "%" + conditionValue + "%"));
        }

        /// <summary>
        /// 检查用户名是否存在数据库
        /// </summary>
        /// <param name="userName">用户名</param>
        /// <returns></returns>
        public static UserInfo CheckUserName(string userName)
        {
            IList<UserInfo> list = GetUserInfosBySql("select * from [UserInfo] where [UserName]=@UserName", new SqlParameter("@UserName", userName));
            if (list.Count > 0)
                return list[0];
            return null;

        }
        /// <summary>
        /// 根据部门ID获取所有用户信息
        ///  </summary>
        /// <param name="departId">部门ID</param>
        /// <returns></returns>
        public static IList<UserInfo> GetAllUserInfoByDepartId(int departId)
        {
            string sql = "select * from [UserInfo] where DepartId=@DepartId";
            return GetUserInfosBySql(sql, new SqlParameter("@DepartId", departId));
        }

        /// <summary>
        /// 根据部门ID获取所有用户信息,除了自己
        ///  </summary>
        /// <param name="departId">部门ID</param>
        /// <returns></returns>
        public static IList<UserInfo> GetAllUserInfoByDepartId(int departId, int UserId)
        {
            string sql = "select * from [UserInfo] where DepartId=@DepartId and UserId != @UserId";
            SqlParameter[] para = new SqlParameter[] { new SqlParameter("@DepartId", departId), new SqlParameter("@UserId", UserId) };
            return GetUserInfosBySql(sql, para);
        }
        /// <summary>
        /// 添加用户信息
        /// </summary>
        /// <param name="userInfo">用户对象</param>
        /// <returns>添加的用户信息</returns>
        public static UserInfo AddUserInfo(UserInfo userInfo)
        {
            string sql =
                "INSERT into UserInfo " +
                "VALUES (@UserName, @Password, @DepartId, @Gender, @RoleId, @UserState,@RealName,@ImageURL)";

            sql += " SELECT @@IDENTITY";

            try
            {
                SqlParameter[] para = new SqlParameter[]
    {
     new SqlParameter("@DepartId", userInfo.Depart.DepartId), //FK
     new SqlParameter("@RoleId", userInfo.Role.RoleId), //FK
     new SqlParameter("@UserState", userInfo.UserState.UserStateId), //FK
     new SqlParameter("@UserName", userInfo.UserName),
     new SqlParameter("@Password", userInfo.Password),
     new SqlParameter("@Gender", userInfo.Gender),
                    new SqlParameter("@RealName",userInfo.RealName),
                    new SqlParameter("@ImageURL",userInfo.ImageURL)
    };

                int newId = Convert.ToInt32(DBHelper.ExecuteScalar(DBHelper.connString, CommandType.Text, sql, para));
                return GetUserInfoByUserId(newId);
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
        }
        /// <summary>
        /// 删除用户信息
        /// </summary>
        /// <param name="userInfo"></param>
        /// <returns></returns>
        public static bool DeleteUserInfo(UserInfo userInfo)
        {
            return DeleteUserInfoByUserId(userInfo.UserId);
        }
        /// <summary>
        /// 根据用户ID删除用户信息
        /// </summary>
        /// <param name="userId"></param>
        /// <returns></returns>
        public static bool DeleteUserInfoByUserId(int userId)
        {
            //string sql = "DELETE UserInfo WHERE UserId = @UserId";
            string sql = "update UserInfo set UserState=(select UserStateId from UserState where UserStateName='被屏蔽') where userId=@UserId";
            int result = DBHelper.ExecuteNonQuery(DBHelper.connString, CommandType.Text, sql, new SqlParameter("@UserId", userId));
            if (result > 0)
                return true;
            return false;
        }
        /// <summary>
        /// 修改用户信息
        /// </summary>
        /// <param name="userInfo"></param>
        /// <returns></returns>
        public static bool ModifyUserInfo(UserInfo userInfo)
        {
            string sql =
                "UPDATE UserInfo " +
                "SET " +
                    "DepartId = @DepartId, " + //FK
                    "RoleId = @RoleId, " + //FK
                    "UserState = @UserState, " + //FK
                    "UserName = @UserName, " +
                    "Gender = @Gender, " +
                    "RealName=@RealName, " +
                    "ImageURL=@ImageURL " +
                "WHERE UserId = @UserId";


            try
            {
                SqlParameter[] para = new SqlParameter[]
    {                   
     new SqlParameter("@DepartId", userInfo.Depart.DepartId), //FK
     new SqlParameter("@RoleId", userInfo.Role.RoleId), //FK
     new SqlParameter("@UserState", userInfo.UserState.UserStateId), //FK
     new SqlParameter("@UserName", userInfo.UserName),
     new SqlParameter("@Gender", userInfo.Gender),
                    new SqlParameter("@RealName",userInfo.RealName),
                    new SqlParameter("@ImageURL",userInfo.ImageURL),
                     new SqlParameter("@UserId",userInfo.UserId)
    };

                int result = DBHelper.ExecuteNonQuery(DBHelper.connString, CommandType.Text, sql, para);
                if (result > 0)
                    return true;
                else
                    return false;
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }

        }
        /// <summary>
        /// 得到全部用户信息信息
        /// </summary>
        /// <returns></returns>
        public static IList<UserInfo> GetAllUserInfos()
        {
            string sqlAll = "SELECT * FROM UserInfo where 1=1" + publicSql + " order by userId desc ";//除超级管理员,全部查询
            return GetUserInfosBySql(sqlAll);
        }

        /// <summary>
        /// 根据用户ID得到用户信息
        /// </summary>
        /// <param name="userId"></param>
        /// <returns></returns>
        public static UserInfo GetUserInfoByUserId(int userId)
        {
            string sql = "SELECT * FROM UserInfo WHERE UserId = @UserId";

            int departId = 0;
            int roleId;
            int userState;

            try
            {
                SqlDataReader reader = DBHelper.ExecuteReader(DBHelper.connString, CommandType.Text, sql, new SqlParameter("@UserId", userId));
                if (reader.Read())
                {
                    UserInfo userInfo = new UserInfo();

                    userInfo.UserId = (int)reader["UserId"];
                    userInfo.UserName = (string)reader["UserName"];
                    userInfo.Password = (string)reader["Password"];
                    userInfo.Gender = (int)reader["Gender"];
                    if (reader["RealName"].GetType().FullName != "System.DBNull")
                        userInfo.RealName = (string)reader["RealName"];
                    if (reader["ImageURL"].GetType().FullName != "System.DBNull")
                        userInfo.ImageURL = (string)reader["ImageURL"];
                    if (reader["DepartId"].GetType().FullName != "System.DBNull")
                        departId = Convert.ToInt32(reader["DepartId"]);
                    roleId = (int)reader["RoleId"]; //FK
                    userState = (int)reader["UserState"]; //FK

                    reader.Close();
                    if (departId != 0)
                        userInfo.Depart = DepartInfoService.GetDepartInfoByDepartId(departId);
                    userInfo.Role = RoleInfoService.GetRoleInfoByRoleId(roleId);
                    userInfo.UserState = UserStateService.GetUserStateByUserStateId(userState);

                    return userInfo;
                }
                else
                {
                    reader.Close();
                    return null;
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
        }


        /// <summary>
        /// 使用sql语句对用户表进行操作(集合)
        /// </summary>
        /// <param name="sql">sql语句</param>
        /// <param name="values"></param>
        /// <returns></returns>
        private static IList<UserInfo> GetUserInfosBySql(string safeSql)
        {
            List<UserInfo> list = new List<UserInfo>();

            try
            {
                DataSet ds = new DataSet();
                DBHelper.FillDataset(DBHelper.connString, CommandType.Text, safeSql, ds, new string[] { "UserInfo" });
                DataTable table = ds.Tables[0];

                foreach (DataRow row in table.Rows)
                {
                    UserInfo userInfo = new UserInfo();

                    userInfo.UserId = Convert.ToInt32(row["UserId"]);
                    userInfo.UserName = (string)row["UserName"];
                    userInfo.Password = (string)row["Password"];
                    userInfo.Gender = (int)row["Gender"];
                    if (row["RealName"].GetType().FullName != "System.DBNull")
                        userInfo.RealName = (string)row["RealName"];
                    if (row["ImageURL"].GetType().FullName != "System.DBNull")
                        userInfo.ImageURL = (string)row["ImageURL"];
                    if (row["DepartId"].GetType().FullName != "System.DBNull")
                        userInfo.Depart = DepartInfoService.GetDepartInfoByDepartId(Convert.ToInt32(row["DepartId"])); //FK
                    userInfo.Role = RoleInfoService.GetRoleInfoByRoleId(Convert.ToInt32(row["RoleId"])); //FK
                    userInfo.UserState = UserStateService.GetUserStateByUserStateId(Convert.ToInt32(row["UserState"])); //FK

                    list.Add(userInfo);
                }

                return list;
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }

        }
        /// <summary>
        /// 根据角色id查询用户
        /// </summary>
        /// <param name="roleId">角色id</param>
        /// <returns>用户集合</returns>
        public static IList<UserInfo> GetUserByRoleId(int roleId)
        {
            IList<UserInfo> list = new List<UserInfo>();
            string sql = "select * from userInfo where roleId=@roleId";
            try
            {
                DataSet ds = new DataSet();
                DBHelper.FillDataset(DBHelper.connString, CommandType.Text, sql + publicSql, ds, new string[] { "UserInfo" }, new SqlParameter[] { new SqlParameter("@roleId", roleId) });
                DataTable table = ds.Tables[0];

                foreach (DataRow row in table.Rows)
                {
                    UserInfo userInfo = new UserInfo();

                    userInfo.UserId = Convert.ToInt32(row["UserId"]);
                    userInfo.UserName = (string)row["UserName"];
                    userInfo.Password = (string)row["Password"];
                    userInfo.Gender = (int)row["Gender"];
                    if (row["RealName"].GetType().FullName != "System.DBNull")
                        userInfo.RealName = (string)row["RealName"];
                    if (row["ImageURL"].GetType().FullName != "System.DBNull")
                        userInfo.ImageURL = (string)row["ImageURL"];
                    if (row["DepartId"].GetType().FullName != "System.DBNull")
                        userInfo.Depart = DepartInfoService.GetDepartInfoByDepartId((int)row["DepartId"]); //FK
                    userInfo.Role = RoleInfoService.GetRoleInfoByRoleId((int)row["RoleId"]); //FK
                    userInfo.UserState = UserStateService.GetUserStateByUserStateId((int)row["UserState"]); //FK

                    list.Add(userInfo);
                }
                return list;
            }
            catch (Exception)
            {

                throw;
            }

        }
        /// <summary>
        /// 检查用户是否存在
        /// </summary>
        /// <param name="userInfo">用户信息</param>
        /// <returns></returns>
        public static UserInfo CheckUserInfo(UserInfo userInfo)
        {
            string sql = "select * from userInfo where userName=@name and password =@pass and UserState=(select UserStateId from UserState where UserStateName!='被屏蔽')";
            SqlParameter[] paramItem = new SqlParameter[]{
              new SqlParameter("@name",userInfo.UserName),
              new SqlParameter("@pass",userInfo.Password)
            };
            int departId = 0;
            int roleId;
            int userState;
            SqlDataReader reader = DBHelper.ExecuteReader(DBHelper.connString, CommandType.Text, sql, paramItem);
            if (reader.Read())
            {
                userInfo.UserId = (int)reader["UserId"];
                userInfo.UserName = (string)reader["UserName"];
                userInfo.Password = (string)reader["Password"];
                userInfo.Gender = (int)reader["Gender"];
                if (reader["RealName"].GetType().FullName != "System.DBNull")
                    userInfo.RealName = (string)reader["RealName"];
                if (reader["ImageURL"].GetType().FullName != "System.DBNull")
                    userInfo.ImageURL = (string)reader["ImageURL"];
                if (reader["DepartId"].GetType().FullName != "System.DBNull")
                    departId = Convert.ToInt32(reader["DepartId"]);
                roleId = (int)reader["RoleId"]; //FK
                userState = (int)reader["UserState"]; //FK

                reader.Close();
                if (departId != 0)
                    userInfo.Depart = DepartInfoService.GetDepartInfoByDepartId(departId);
                userInfo.Role = RoleInfoService.GetRoleInfoByRoleId(roleId);
                userInfo.UserState = UserStateService.GetUserStateByUserStateId(userState);
            }
            else
                return null;
            return userInfo;

        }
        /// <summary>
        /// 使用sql语句对用户表进行操作
        /// </summary>
        /// <param name="sql">sql语句</param>
        /// <param name="values"></param>
        /// <returns></returns>
        private static IList<UserInfo> GetUserInfosBySql(string sql, params SqlParameter[] values)
        {
            List<UserInfo> list = new List<UserInfo>();

            try
            {
                DataSet ds = new DataSet();
                DBHelper.FillDataset(DBHelper.connString, CommandType.Text, sql, ds, new string[] { "UserInfo" }, values);
                DataTable table = ds.Tables[0];

                foreach (DataRow row in table.Rows)
                {
                    UserInfo userInfo = new UserInfo();

                    userInfo.UserId = Convert.ToInt32(row["UserId"]);
                    userInfo.UserName = (string)row["UserName"];
                    userInfo.Password = (string)row["Password"];
                    userInfo.Gender = (int)row["Gender"];
                    if (row["RealName"].GetType().FullName != "System.DBNull")
                        userInfo.RealName = (string)row["RealName"];
                    if (row["ImageURL"].GetType().FullName != "System.DBNull")
                        userInfo.ImageURL = (string)row["ImageURL"];
                    if (row["DepartId"].GetType().FullName != "System.DBNull")
                        userInfo.Depart = DepartInfoService.GetDepartInfoByDepartId((int)row["DepartId"]); //FK
                    userInfo.Role = RoleInfoService.GetRoleInfoByRoleId((int)row["RoleId"]); //FK
                    userInfo.UserState = UserStateService.GetUserStateByUserStateId((int)row["UserState"]); //FK

                    list.Add(userInfo);
                }

                return list;
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }

        }
        /// <summary>
        /// 根据 部门 机构 登录ID 用户名 查询用户
        /// </summary>
        /// <param name="dId">部门ID</param>
        /// <param name="loginId">登录ID(userName)</param>
        /// <param name="userName">用户名(realName)</param>
        /// <param name="bid">机构ID</param>
        /// <returns></returns>
        public static List<UserInfo> GetUserInfoBySerach(int dId, string loginId, string userName, int bid)
        {
            List<SqlParameter> paramItem = new List<SqlParameter>();
            string sql = "select Distinct u.* from userInfo u,DepartInfo d where u.departId = d.departId";
            if (dId != 0)
            {
                sql += " and  d.departId =" + dId;
            }
            if (bid != 0)
            {
                sql += " and d.branchId =" + bid;
            }
            if (loginId != "")
            {
                sql += " and userName =@userName";
                paramItem.Add(new SqlParameter("@userName", loginId));
            }
            if (userName != "")
            {
                sql += " and realName like @realName";
                paramItem.Add(new SqlParameter("@realName", "%" + userName + "%"));
            }
            return (List<UserInfo>)GetUserInfosBySql(sql, paramItem.ToArray());
        }

        /// <summary>
        /// 根据用户ID得到用户信息     (王浩)
        /// </summary>
        /// <param name="userId"></param>
        /// <returns></returns>
        public static UserInfo GetUserInfoByRealName(string realName)
        {
            string sql = "SELECT * FROM UserInfo WHERE RealName like @RealName";
            SqlParameter[] para = new SqlParameter[]
            {
                new SqlParameter("@RealName", "%"+realName+"%"),
            };
            IList<UserInfo> list = GetUserInfosBySql(sql, para);
            if (list.Count > 0)
                return list[0];
            return null;
        }
        /// <summary>
        /// 根据机构、部门查询用户
        /// </summary>
        /// <param name="branchId"></param>
        /// <param name="departId"></param>
        /// <returns></returns>
        public static IList<UserInfo> GetUserByBranchIdOrDepartId(int branchId, int departId)
        {
            string sql = "select * from userInfo where 1=1 and userId!=(select userid from userInfo where userName='admin')  ";
            if (branchId > 0)
                sql += "  and DepartId in(select departId from DepartInfo where BranchID in(select branchId from branchInfo where branchid=" + branchId + "))  ";
            if (departId > 0)
                sql += "  and DepartId in(select departId from DepartInfo where departId=" + departId + ") ";
            return GetUserInfosBySql(sql);
        }

    }
}

zwnboy111
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
DAL数据库查询
Mu_Cloud的博客
06-08 399
namespace DAL { public class DALMethod { //1.连接数据库 /*Sqlserver数据库连接方式有多种，这里只介绍最常用的通过SqlConnection和Sqlserver数据库用户名和密码验证来进行操作数据库。 这里data source 是指数据库地址和端口号，需要注意的是地址和端口号之间是用","进行分隔的；initial catalog 是数据库名字 ；user id和pwd分别指用户名和密码。
解决 MSB3541 Files 的值“＜＜＜＜＜＜＜ HEAD”无效。路径中具有非法字符。yishaadmin开源框架 VS调试报错
gold_su的博客
08-16 3175
yishaadmin启动调试时报错：错误 MSB3541 Files 的值“<<<<<<< HEAD”无效。路径中具有非法字符， 这个错误是在Git的版本控制的时候，合并代码冲突而产生的错误； 可在本地项目文件中删除obj文件夹， 路径：YiShaAdmin-master\YiSha.Web\YiSha.Admin.Web\obj， 将整个obj文件夹删除，然后再启动调试。 可以先剪切到其他目录，失败后还可以还原 ...
VS报错：MSB3541
Chester_ieee的博客
09-05 722
error MSB3541: Files 的值“XXXX”无效 的解决方案
MSB3541 Files 的值“＜＜＜＜＜＜＜ HEAD”无效。路径中具有非法字符。
你要明白，任何问题都不是孤立存在的，一定有人曾经遇到过，并且已经有更好的解决办法了，只是我还不知道。我不应该在黑暗中独自前行，去重新发明轮子，也许我的顿悟，只是别人的基本功！我应该要站在巨人的肩膀上，学习更成熟的经验和方法，然后再来解决这个问题
11-28 777
MSB3541 Files 的值“
Microsoft.Common.targets(4171,5): error MSB3541 【ASP.NET错误笔记】
测试
04-26 2330
在做项目的过程中，出现了这样的问题 问题描述：1>C:WindowsMicrosoft.NETFrameworkv4.0.30319Microsoft.Common.targets(4171,5): error MSB3541: Files 的值“F========== 全...
mysql dal层_MySQL读写分离的DAL层策略设计
weixin_42295859的博客
02-07 246
MySQL读写分离的DAL层策略设计 MySQL读写分离的DAL层策略设计 一 、MySQL集群简介 所谓的mysql集群，是指多台机器完成一个工作，最主要的场景是数据库服务器和Web服务器，但是集群环境不适合 大规模计算。前面我们有提到MySQL AB复制，因为MySQL AB复制不适合大规模运用，要解决这个问题，我们可以使用MySQL集群。 MySQL集群分为三类节点：管理节点、SQL节点、存...
java dal_DALFactory与IDAL的区别（花了一个多小时找到的）
weixin_39745724的博客
02-21 269
业务逻辑层调用IDAL接口是对的，但说这里体现不了接口的优势是错的，这里正是体现接口优势的地方！因为有了DAL层，软件可以轻易移植到不同种类的数据库上运行。不同种类数据库的具体编码不同，所以要分开实现，但无论数据库编码写么编，对于业务逻辑层来说，就是一个作用，保存数据！所以不同种类数据库DAL层都继承自IDAL，这样业务层就不用考虑调用的到底是哪种数据库来保存数据，只要按IDAL规定的方法存了就行...
DAL,BLL,UI,三层架构的影响
m0_37939000的博客
04-29 458
这位博主对于三层结构的理解很棒，对新手很友好 https://blog.csdn.net/hanxuemin12345/article/details/8544957/ UI(表现层):主要是指与用户交互的界面。用于接收用户输入的数据和显示处理后用户需要的数据 BLL:(业务逻辑层):UI层和DAL层之间的桥梁。实现业务逻辑。业务逻辑具体包含：验证、计算、业务规则等等 DAL:(数据访问层...
C#代码模板生成器;Model层;DAL层;BLL层代码自动生成
02-25
本文将深入探讨"C#代码模板生成器"，特别是针对Model层、DAL（数据访问层）层和BLL（业务逻辑层）层的代码自动生成。 首先，我们来理解Model层。在C#应用中，Model层是业务对象的容器，它代表了应用程序的数据模型...
DAL.zip_E9A_SQLHelper_dal库_dbhelper_oracle
09-15
《ASP.NET程序与Oracle数据库交互：SQLHelper与DAL库的深度解析》 在现代Web应用程序开发中，数据库的高效管理是至关重要的。本资源“DAL.zip_E9A_SQLHelper_dal库_dbhelper_oracle”提供了一种针对Oracle数据库的...
db:Go语言中的数据库抽象层（DAL）
05-10
Go语言中的数据库抽象层（DAL） 该软件包有4个主要用途： 为了抽象化数据存储，可以更改基础存储引擎。 允许编写更少的代码，使其更具可读性。 为了允许在整个应用程序中为tx/insert/get/query/update/delete...
生成C#中的Model，BLL，DAL文件
11-27
本工具正是针对这种架构，帮助开发者快速生成C#代码中的关键组件：Model、BLL和DAL。 **Model层**（模型层）是业务对象的定义，包含了应用程序中使用的数据结构和实体。在C#中，Model通常包含一系列的类，这些类...
Files 的值“ < < < < < < < .mine”无效。路径中具有非法字符。
leejin_521的专栏
12-16 1593
Files 的值“    使用SVN进行更新的时候，出现了这样的问题    Files 的值“   解决方法： 解决冲突，告诉SVN这个问题已解决（Resolved）。一般更简单些：在你的工程OBJ/DEBUG目录下，找到 工程名.csproj.FileListAbsolute.txt的文件打开并删除含有
MySQL数据库增删查改（基础）CRUD
最新发布
chendemingxxx的博客
09-02 859
比如说：创建一张学生表，有姓名，学号。插入两个学生。可能有点草率看看例子： 顺序不是问题，后面参数和前面括号参数对等就行。比如说上面的例子：把id和name参数倒过来了，后面参数一一对应也可以。不推荐使用全列查询原因：比如说上面例子我只要id或者说只要name；当然也可以查询多个列： 比如说我们创建一个这样的表命令：第一个 效果：第三个总分效果：拓展一个现象： 拓展：语法：比较运算符：逻辑运算符：解释：%在mysql这里代表的是多个任意字符，_代表的是 一个任意字符。揭晓来才是修改硬盘里面的内容。案例：
PostgreSQL遍历所有的表并为其创建基于某个字段的索引
致力于互联网、物联网领域知识内容分享
08-29 577
以下以"collect_time"字段为例，其他字段请自行全局替换。
ASP.NET 2.0 3层架构 DAL开发教程：从基础到实践
".NET 3层架构开发(数据访问层，DAL)详解" 在ASP.NET 2.0环境下，开发人员面临的主要任务之一是有效地管理和操作数据。三层架构，即数据访问层(DAL)、业务逻辑层(BLL)和表现层，是现代Web应用程序设计的一种常见...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值