查询姓“李”的学生的个数

2014-10-25 16:56:52 访问(1833) 赞(0) 踩(0)

提示：
UTB_EXAM_STUDENT
查询条件like的使用

select count(1) from
UTB_EXAM_STUDENT s
where
s.TheName like '李%'


    /// <summary>
    /// 
    /// </summary>
    /// <param name="xdbHelper"></param>
    protected void DataBindTheContorls(DBHelper xdbHelper)
    {
        string theResult=null;
        bool bIsCreate = true;

        if (xdbHelper == null)
        {
            xdbHelper = SlowX.DAL.Helpers.DBHelper.CreateDBHelper();
        }
        else
        {
            // 没有打开链接 //
            bIsCreate = xdbHelper.IsNotOpen();
        }

        try
        {
            if (bIsCreate)
                xdbHelper.OpenDBHelper();

            // 查询姓“李”的学生的个数 
            SlowX.ExamLib.Business.UTB_EXAM_STUDENT
                bll
                =
                SlowX.ExamLib.Business.UTB_EXAM_STUDENT.instance;

            SlowX.ExamLib.Entity.UTB_EXAM_STUDENT
                entity
                =
                new SlowX.ExamLib.Entity.UTB_EXAM_STUDENT();

             
            IQueryDriver iq = entity;
            iq.AddIQueryItemWithEntityFieldInfo(entity._TheName, SlowX.Core.Enums.SqlLink.EmSqlLink.Like_, "李");

            theResult = bll.Count(entity, xdbHelper).ToString();

            if (bIsCreate)
                xdbHelper.EndDBHelper();

        }
        catch (Exception err)
        {
            if (bIsCreate)
                xdbHelper.TranDBHelper();

            throw err;
        }
        finally
        {
            if (bIsCreate)
                xdbHelper.FinallyDBHelper();
        }

        strResult = theResult;
    }


select count(1) from UTB_EXAM_STUDENT t where t.TheName like '李'+'%' 

@tp1 = '李'


select count(1) from UTB_EXAM_STUDENT t where t.TheName like @tp1+'%' 

@tp1 	 李 	 String 	 Input 	 SqlParameter