ASP 三层架构 Convert类实现代码

这个类主要解决在类型转换时,如果直接使用类型转换函数,会因为变量为空或者格式不对而导致程序报错,而这种报错在大多数情况下是允许的.例如要转换一个字符串变量为数字,如果变量为空,则一般需要自动返回0.
另外一个重要功能就是封装变量格式化操作,可以保持整个网站的输出格式统一,例如时间格式,货币格式等等. 日期和货币格式化的时候,极易遇到因空值报错的情况,一般都不得不写个预判断空值的逻辑,再格式化变量. 使用这个类负责类型转换和格式化输出后,就不用操心这些琐碎的细节了,可以让编程的心情得到大大改善啊.
还有些其他格式化功能,也加了进去,例如Convert.ToPer()是用来转换数字成百分数,Convert.FirstUppercase()用来做首字母大写…… 你可以根据自己的需要,随时扩展这个类,不要忘记了和大家分享哦.
有些基本的函数,如果随便写一写,基本可以凑合着用,但是遇到特殊情况,就要重新改写.比如我写的Convert.ToInt()方法,将变量转换为Integer. 最基本的操作,是判断一下是否为空,不为空就直接用Cint()就可以了. 但是遇到变量超出了范围,又得判断是否在Integer范围内,所以又写了一个私有方法IsOverflowInteger(),用于判断变量值是否为某一个范围内的数字.经过这样的处理,相信基本可以处理所有的情况了.
所以我想,Convert类中的已有方法还是会有不少需要改善的,大家如果有更好更完善的函数请发上来分享,让它形成ASP中最标准的变量处理的类,再不用依赖ASP中那些有限的功能了.
如下列举一些比较主要的方法,具体细节请看代码.
类型判断:
Convert.IsInteger(ByVal Value) 判断是否整数,只允许0~9和-号
Convert.IsInt(ByVal Value) 判断是否int型,其下类似,不用解释了.
Convert.IsLng(ByVal Value)
Convert.IsDecimal(ByVal Value)
Convert.IsSng(ByVal Value)
Convert.IsDbl(ByVal Value)
Convert.IsCur(ByVal Value)
Convert.IsBln(ByVal Value)
Convert.IsDat(ByVal Value)
Convert.IsArr(ByVal Value)
类型转换:
Convert.ToStr(ByVal Value)
Convert.ToInt(ByVal Value)
Convert.ToLng(ByVal Value)
Convert.ToSng(ByVal Value)
Convert.ToDbl(ByVal Value)
Convert.ToBln(ByVal Value)
Convert.ToCur(ByVal Value)
Convert.ToDat(ByVal Value)
格式化:
Convert.FormatDat(ByVal Value, ByVal vStyle) 日期格式化
Convert.FormatCur(ByVal Value,ByVal vDecimal) 货币格式化
Convert.FormatNum(ByVal Value,ByVal vDecimal) 数字格式化
其他格式化:
Convert.ToPer(Byval value,Byval value0) 百分数,带%
Convert.FirstUppercase(ByVal value) 首字母大写
Convert.SafeSql(ByVal value) 替换sql中的’为”
代码如下: (我不会插入代码,不知道CSDN是怎么操作的,点插入代码就是一个,而不是可以折叠代码的风格,向了解的朋友请教.) <BR><span><a class="copybut" id="copybut43296"><U>复制代码</U></a></span> 代码如下: <BR>Class Con_Convert <BR>‘ ******global message <BR>private i,j,value0,value1,value2 <BR>Private Sub Class_Initialize <BR>End Sub <BR>Private Sub Class_Terminate <BR>End Sub <BR>‘ ============================================================================== <BR>‘ Check Type, Return ture/false <BR>‘ ============================================================================== <BR>Public Function IsStr(ByVal Value) <BR>IsStr=true <BR>End Function <BR>‘ ****** check string if is Integer <BR>Public Function IsInteger(ByVal Value) <BR>if Trim(Value)=”” or IsNull(Value) or IsEmpty(Value) then <BR>IsInteger=false <BR>else <BR>IsInteger = True <BR>value0=Trim(Value) <BR>For i = 1 To len(value0) <BR>If Asc(Mid(value0, i, 1))>= Asc(“0”) and Asc(Mid(value0, i, 1)) <= Asc("9") Then <BR>Else <BR>if Asc(Mid(value0, i, 1))= Asc(“-“) and i=1 then <BR>else <BR>IsInteger = false <BR>Exit For <BR>end if <BR>End If <BR>Next <BR>end if <BR>End Function <BR>‘ ****** check if Value is in range of integer <BR>‘ Only use in this class <BR>‘ Value : <BR>‘ vBound : max <BR>Private Function IsOverflowInteger(ByVal Value,ByVal vBound) <BR>if IsInteger(Value) and IsInteger(vBound) then <BR>IsOverflowInteger=false <BR>value0=trim(value) <BR>value1=trim(vBound) <BR>if IsOverflowInteger=false then <BR>‘delete 0 from left <BR>do while ( left(value0,1)=”0″ or left(value0,1)=”-” ) <BR>value0=right(value0,len(value0)-1) <BR>loop <BR>do while ( left(value1,1)=”0″ or left(value1,1)=”-” ) <BR>value1=right(value1,len(value1)-1) <BR>loop <BR>if len(value0)=len(value1) then <BR>for i=1 to len(value0) <BR>if Asc(mid(value0,i,1)) > Asc(mid(value1,i,1)) or Asc(mid(value0,i,1)) > Asc(“9”) or Asc(mid(value0,i,1)) < Asc("0") then <BR>IsOverflowInteger=true <BR>exit for <BR>end if <BR>next <BR>else <BR>if len(value0)>len(value1) then <BR>IsOverflowInteger=true <BR>end if <BR>end if <BR>end if <BR>else <BR>IsOverflowInteger=true <BR>end if <BR>End Function <BR>Public Function IsInt(ByVal Value) <BR>IsInt=true <BR>if left(trim(value),1)=”-” then <BR>if IsOverflowInteger(trim(value),”-32768″) then <BR>IsInt=false <BR>end if <BR>else <BR>if IsOverflowInteger(trim(value),”32767″) then <BR>IsInt=false <BR>end if <BR>end if <BR>end function <BR>Public Function IsLng(ByVal Value) <BR>IsLng=true <BR>if left(trim(value),1)=”-” then <BR>if IsOverflowInteger(trim(value),”-2147483648″) then <BR>IsLng=false <BR>end if <BR>else <BR>if IsOverflowInteger(trim(value),”2147483647″) then <BR>IsLng=false <BR>end if <BR>end if <BR>End Function <BR>‘ ************************************** <BR>‘ Decimal <BR>‘ ************************************** <BR>‘ ****** check string if is Decimal <BR>Private Function IsDecimal(ByVal Value) <BR>dim intDecimalCount <BR>intDecimalCount=0 <BR>if Trim(Value)=”” or IsNull(Value) or IsEmpty(Value) then <BR>IsDecimal=false <BR>else <BR>IsDecimal = True <BR>value0=Trim(Value) <BR>For i = 1 To len(value0) <BR>If Asc(Mid(value0, i, 1))>= Asc(“0”) and Asc(Mid(value0, i, 1)) <= Asc("9") Then <BR>Else <BR>select case Asc(Mid(value0, i, 1)) <BR>case Asc(“-“) <BR>if i=1 then <BR>else <BR>IsDecimal = false <BR>Exit For <BR>end if <BR>case Asc(“.”) <BR>if intDecimalCount<2 then <BR>intDecimalCount=intDecimalCount + 1 <BR>else <BR>IsDecimal = false <BR>Exit For <BR>end if <BR>case else <BR>IsDecimal = false <BR>Exit For <BR>end select <BR>End If <BR>Next <BR>end if <BR>End Function <BR>‘ ****** check if Value is in range of Decimal <BR>‘ Only use in this class <BR>‘ Value : <BR>‘ vBound : <BR>Private Function IsOverflowDecimal(ByVal Value,ByVal vBound) <BR>if Trim(Value)=”” or IsNull(Value) or IsEmpty(Value) or Trim(vBound)=”” or IsNull(vBound) or IsEmpty(vBound) then <BR>IsOverflowDecimal=true <BR>else <BR>end if <BR>End Function <BR>Public Function IsSng(ByVal Value) <BR>IsSng=IsDecimal(value) <BR>‘ -340282300000000000000000000000000000000 ~ -0.000000000000000000000000000000000000000000001401298 <BR>‘ 0.000000000000000000000000000000000000000000001401298 ~ 340282300000000000000000000000000000000 <BR>‘ -3.402823 E38 ~ -1.401298 E-45 <BR>‘ 1.401298 E-45 ~ 3.402823 E38 <BR>End Function <BR>Public Function IsDbl(ByVal Value) <BR>IsDbl=IsDecimal(value) <BR>‘ -1.79769313486232 E308 ~ -4.94065645841247 E-324 <BR>‘ 4.94065645841247 E-324 ~ 1.7976931348623 E308 <BR>End Function <BR>Public Function IsCur(ByVal Value) <BR>IsCur=IsDecimal(value) <BR>‘-922337203685477.5808 ~ 922337203685477.5807 <BR>End Function <BR>Public Function IsBln(ByVal Value) <BR>if Value=true or Value=false or trim(Value)=”1″ or trim(Value)=”0″ then <BR>IsBln=true <BR>else <BR>IsBln=false <BR>end if <BR>End Function <BR>Public Function IsDat(ByVal Value) <BR>if Trim(Value)=”” or IsNull(Value) or IsEmpty(Value) then <BR>IsDat=false <BR>else <BR>IsDat=IsDate(Value) <BR>end if <BR>End Function <BR>Public Function IsArr(ByVal Value) <BR>if Trim(Value)=”” or IsNull(Value) or IsEmpty(Value) then <BR>IsArr=false <BR>else <BR>IsArr=IsArray(Value) <BR>end if <BR>End Function <BR>‘ ============================================================================== <BR>‘ Convert Type, Return value/initial value <BR>‘ ============================================================================== <BR>Public Function ToStr(ByVal Value) <BR>ToStr=trim(Value) <BR>End Function <BR>Public Function ToInt(ByVal Value) <BR>if IsInt(Value) then <BR>ToInt=Cint(Value) <BR>else <BR>ToInt=0 <BR>end if <BR>End Function <BR>Public Function ToLng(ByVal Value) <BR>if IsLng(Value) then <BR>ToLng=clng(Value) <BR>else <BR>ToLng=0 <BR>end if <BR>End Function <BR>Public Function ToSng(ByVal Value) <BR>if IsSng(Value) then <BR>ToSng=cSng(Value) <BR>else <BR>ToSng=0 <BR>end if <BR>End Function <BR>Public Function ToDbl(ByVal Value) <BR>if IsDbl(Value) then <BR>ToDbl=cDbl(Value) <BR>else <BR>ToDbl=0 <BR>end if <BR>End Function <BR>Public Function ToBln(ByVal Value) <BR>if IsBln(Value) then <BR>ToBln=cbool(Value) <BR>else <BR>ToBln=false <BR>end if <BR>End Function <BR>‘ ****** vDecimal : number of decimal places <BR>Public Function ToCur(ByVal Value) <BR>if IsCur(Value) then <BR>ToCur=ccur(Value) <BR>else <BR>ToCur=0 <BR>end if <BR>End Function <BR>‘ ****** vType : format of date <BR>Public Function ToDat(ByVal Value) <BR>if IsDat(Value) then <BR>ToDat=cdate(value) <BR>else <BR>ToDat=”” <BR>end if <BR>End Function <BR>‘ ============================================================================== <BR>‘ Format <BR>‘ ============================================================================== <BR>‘ ******************************************************* <BR>‘FormatDat <BR>‘vdate <BR>‘vStyle 0:2008-1-30 1:2008/1/30 2:1/30/2008 3:30/1/2008 4:30-JAN-2008 <BR>‘ 10:2008-1 11:2008/1 12:1/2008 <BR>‘ 22:JAN-2008 <BR>‘ 30:2008-1-30 11:20:20 <BR>‘ 40:2008-01-09 <BR>Public Function FormatDat(ByVal Value, ByVal vStyle) <BR>dim dateThis,intStyle <BR>dateThis=ToDat(Value) <BR>intStyle=ToInt(vStyle) <BR>if dateThis=”” or isnull(dateThis) then <BR>FormatDat = “” <BR>else <BR>Dim arrMonthArray(12) <BR>arrMonthArray(1)=”JAN” <BR>arrMonthArray(2)=”FEB” <BR>arrMonthArray(3)=”MAR” <BR>arrMonthArray(4)=”APR” <BR>arrMonthArray(5)=”MAY” <BR>arrMonthArray(6)=”JUN” <BR>arrMonthArray(7)=”JUL” <BR>arrMonthArray(8)=”AUG” <BR>arrMonthArray(9)=”SEP” <BR>arrMonthArray(10)=”OCT” <BR>arrMonthArray(11)=”NOV” <BR>arrMonthArray(12)=”DEC” <BR>select case intStyle <BR>case 1 <BR>FormatDat=cstr(year(dateThis)) &”/”& cstr(month(dateThis)) &”/”& cstr(day(dateThis)) <BR>case 2 <BR>FormatDat= cstr(month(dateThis)) &”/”& cstr(day(dateThis)) &”/”& cstr(year(dateThis)) <BR>case 3 <BR>FormatDat= cstr(day(dateThis)) &”/”& cstr(month(dateThis)) &”/”& cstr(year(dateThis)) <BR>case 4 <BR>FormatDat= cstr(day(dateThis)) &”-“& arrMonthArray(month(dateThis)) &”-“& cstr(year(dateThis)) <BR>case 10 <BR>FormatDat=cstr(year(dateThis)) &”-“& cstr(month(dateThis)) <BR>case 11 <BR>FormatDat=cstr(year(dateThis)) &”/”& cstr(month(dateThis)) <BR>case 12 <BR>FormatDat= cstr(month(dateThis)) &”/”& cstr(year(dateThis)) <BR>case 22 <BR>FormatDat= arrMonthArray(month(dateThis)) &”-“& cstr(year(dateThis)) <BR>case 30 <BR>FormatDat= cstr(year(dateThis)) &”-“& cstr(month(dateThis)) &”-“& cstr(day(dateThis)) &” “& hour(dateThis) &”:”& minute(dateThis) &”:”& second(dateThis) <BR>case 40 <BR>FormatDat=cstr(year(dateThis)) &”-“& ZeroPad(cstr(month(dateThis)),2) &”-“& ZeroPad(cstr(day(dateThis)),2) <BR>case else <BR>FormatDat=cstr(year(dateThis)) &”-“& cstr(month(dateThis)) &”-“& cstr(day(dateThis)) <BR>end select <BR>end if <BR>End Function <BR>‘ ************** <BR>‘FormatCur <BR>‘ ************** <BR>Public Function FormatCur(ByVal Value,ByVal vDecimal) <BR>FormatCur=Formatcurrency(ToCur(Value),ToInt(vDecimal)) <BR>End Function <BR>Public Function FormatNum(ByVal Value,ByVal vDecimal) <BR>FormatNum=FormatNumber(ToDbl(Value),ToInt(vDecimal)) <BR>End Function <BR>‘ ============================================================================== <BR>‘ other format <BR>‘ ============================================================================== <BR>Public Function ToPer(Byval value,Byval value0) <BR>if Convert.ToDbl(value0)0 then <BR>ToPer = me.FormatNum( Convert.ToDbl(value) / Convert.ToDbl(value0) * 100,2 ) & “% ” <BR>else <BR>ToPer = “0.00%” <BR>end if <BR>End Function <BR>‘ ****** value -> Value first code change to uppercase <BR>Public Function FirstUppercase(ByVal value) <BR>value0 = trim(value) <BR>if len(value0)=0 then <BR>FirstUppercase = “” <BR>else <BR>FirstUppercase = UCase(left(value0,1)) & right(value0,len(value0)-1) <BR>end if <BR>End Function <BR>Public Function SafeSql(ByVal value) <BR>SafeSql = replace(value,”‘”,”””) <BR>End Function <BR>End Class <BR></p></article></div><div class="related-posts"><h2 class="related-posts-title"><i class="fab fa-hive me-1"></i>相关文章</h2><div class="row g-2 g-md-3 row-cols-2 row-cols-md-3 row-cols-lg-4"><div class="col"><article class="post-item item-grid"><div class="tips-badge position-absolute top-0 start-0 z-1 m-2"></div><div class="entry-media ratio ratio-3x2"> <a target="" class="media-img lazy bg-cover bg-center" href="https://www.maxssl.com/article/19192/" title="数据库——冲突可串行化调度" data-bg="https://img.maxssl.com/uploads/?url=https://img.maxssl.com/uploads/?url=https://csdnimg.cn/release/blog_editor_html/release2.1.3/ckeditor/plugins/CsdnLink/icons/icon-default.png"> </a></div><div class="entry-wrapper"><h2 class="entry-title"> <a target="" href="https://www.maxssl.com/article/19192/" title="数据库——冲突可串行化调度">数据库——冲突可串行化调度</a></h2></div></article></div><div class="col"><article class="post-item item-grid"><div class="tips-badge position-absolute top-0 start-0 z-1 m-2"></div><div class="entry-media ratio ratio-3x2"> <a target="" class="media-img lazy bg-cover bg-center" href="https://www.maxssl.com/article/38781/" title="解读Amazon Q | 用AI聊天机器人连接你与未来的无限可能" data-bg="https://img.maxssl.com/uploads/?url=https://img-blog.csdnimg.cn/direct/40ffcaebc560452ab09a53f27d94a2d6.png"> </a></div><div class="entry-wrapper"><h2 class="entry-title"> <a target="" href="https://www.maxssl.com/article/38781/" title="解读Amazon Q | 用AI聊天机器人连接你与未来的无限可能">解读Amazon Q | 用AI聊天机器人连接你与未来的无限可能</a></h2></div></article></div><div class="col"><article class="post-item item-grid"><div class="tips-badge position-absolute top-0 start-0 z-1 m-2"></div><div class="entry-media ratio ratio-3x2"> <a target="" class="media-img lazy bg-cover bg-center" href="https://www.maxssl.com/article/29244/" title="SpringBoot全局异常处理源码" data-bg="https://img.maxssl.com/uploads/?url=https://img-blog.csdnimg.cn/323a266271d14c8c85dc7e44582230dc.png"> </a></div><div class="entry-wrapper"><h2 class="entry-title"> <a target="" href="https://www.maxssl.com/article/29244/" title="SpringBoot全局异常处理源码">SpringBoot全局异常处理源码</a></h2></div></article></div><div class="col"><article class="post-item item-grid"><div class="tips-badge position-absolute top-0 start-0 z-1 m-2"></div><div class="entry-media ratio ratio-3x2"> <a target="" class="media-img lazy bg-cover bg-center" href="https://www.maxssl.com/article/13940/" title="java多线程（超详细）" data-bg="https://img.maxssl.com/uploads/?url=https://img-blog.csdnimg.cn/d2155be7383a440298762feb3493ad21.jpeg"> </a></div><div class="entry-wrapper"><h2 class="entry-title"> <a target="" href="https://www.maxssl.com/article/13940/" title="java多线程（超详细）">java多线程（超详细）</a></h2></div></article></div><div class="col"><article class="post-item item-grid"><div class="tips-badge position-absolute top-0 start-0 z-1 m-2"></div><div class="entry-media ratio ratio-3x2"> <a target="" class="media-img lazy bg-cover bg-center" href="https://www.maxssl.com/article/43529/" title="AI短视频生成与制作从入门到精通" data-bg="https://img.maxssl.com/uploads/?url=https://img-blog.csdnimg.cn/direct/0b02a875a0104402888a4edf7a6b8377.png"> </a></div><div class="entry-wrapper"><h2 class="entry-title"> <a target="" href="https://www.maxssl.com/article/43529/" title="AI短视频生成与制作从入门到精通">AI短视频生成与制作从入门到精通</a></h2></div></article></div><div class="col"><article class="post-item item-grid"><div class="tips-badge position-absolute top-0 start-0 z-1 m-2"></div><div class="entry-media ratio ratio-3x2"> <a target="" class="media-img lazy bg-cover bg-center" href="https://www.maxssl.com/article/10554/" title="C语言default精解" data-bg="https://img.maxssl.com/uploads/?url=https://img-blog.csdnimg.cn/36a521a7dc554608894bd6d2ddd38dea.png"> </a></div><div class="entry-wrapper"><h2 class="entry-title"> <a target="" href="https://www.maxssl.com/article/10554/" title="C语言default精解">C语言default精解</a></h2></div></article></div><div class="col"><article class="post-item item-grid"><div class="tips-badge position-absolute top-0 start-0 z-1 m-2"></div><div class="entry-media ratio ratio-3x2"> <a target="" class="media-img lazy bg-cover bg-center" href="https://www.maxssl.com/article/53370/" title="普通人也能做空A股？期权如何应对大盘下跌？" data-bg="https://img.maxssl.com/uploads/?url=https://img-blog.csdnimg.cn/img_convert/972ec0887089e5e6b90b404aa6b591da.png"> </a></div><div class="entry-wrapper"><h2 class="entry-title"> <a target="" href="https://www.maxssl.com/article/53370/" title="普通人也能做空A股？期权如何应对大盘下跌？">普通人也能做空A股？期权如何应对大盘下跌？</a></h2></div></article></div><div class="col"><article class="post-item item-grid"><div class="tips-badge position-absolute top-0 start-0 z-1 m-2"></div><div class="entry-media ratio ratio-3x2"> <a target="" class="media-img lazy bg-cover bg-center" href="https://www.maxssl.com/article/11763/" title="普通学生如何面对ACM，算法金奖得主带你领略" data-bg="https://img.maxssl.com/uploads/?url=https://img-blog.csdnimg.cn/327e8150c17a41889e4a52528dea0aa4.png"> </a></div><div class="entry-wrapper"><h2 class="entry-title"> <a target="" href="https://www.maxssl.com/article/11763/" title="普通学生如何面对ACM，算法金奖得主带你领略">普通学生如何面对ACM，算法金奖得主带你领略</a></h2></div></article></div></div></div></div><div class="sidebar-wrapper col-md-12 col-lg-3 h-100" data-sticky><div class="sidebar"><div id="recent-posts-4" class="widget widget_recent_entries"><h5 class="widget-title">最新关注</h5><ul><li> <a href="https://www.maxssl.com/article/57859/">【MySQL】InnoDB存储引擎</a></li><li> <a href="https://www.maxssl.com/article/57858/">DB-GPT：强强联合Langchain-Vicuna的应用实战开源项目，彻底改变与数据库的交互方式</a></li><li> <a href="https://www.maxssl.com/article/57857/">TigerBeetle：世界上最快的会计数据库</a></li><li> <a href="https://www.maxssl.com/article/57856/">【SQL server】玩转SQL server数据库：第三章 关系数据库标准语言SQL（二）数据查询</a></li><li> <a href="https://www.maxssl.com/article/57855/">马斯克400条聊天记录被法院公开，原来推特收购是在短信上谈崩的</a></li><li> <a href="https://www.maxssl.com/article/57854/">戏精摩根大通：从唱空比特币到牵手贝莱德</a></li></ul></div><div id="ri_sidebar_posts_widget-2" class="widget sidebar-posts-list"><h5 class="widget-title">热文推荐</h5><div class="row g-3 row-cols-1"><div class="col"><article class="post-item item-list"><div class="entry-media ratio ratio-3x2 col-auto"> <a target="" class="media-img lazy" href="https://www.maxssl.com/article/14881/" title="开发复杂软件的系统方法(二)之软件建模" data-bg="https://img.maxssl.com/uploads/?url=https://img2023.cnblogs.com/other/371367/202305/371367-20230503140012586-628366596.png"></a></div><div class="entry-wrapper"><div class="entry-body"><h2 class="entry-title"> <a target="" href="https://www.maxssl.com/article/14881/" title="开发复杂软件的系统方法(二)之软件建模">开发复杂软件的系统方法(二)之软件建模</a></h2></div></div></article></div><div class="col"><article class="post-item item-list"><div class="entry-media ratio ratio-3x2 col-auto"> <a target="" class="media-img lazy" href="https://www.maxssl.com/article/24281/" title="android mvvm实例解析" data-bg="https://img.maxssl.com/uploads/?url=https://img2023.cnblogs.com/blog/258344/202308/258344-20230804224619574-648189351.png"></a></div><div class="entry-wrapper"><div class="entry-body"><h2 class="entry-title"> <a target="" href="https://www.maxssl.com/article/24281/" title="android mvvm实例解析">android mvvm实例解析</a></h2></div></div></article></div><div class="col"><article class="post-item item-list"><div class="entry-media ratio ratio-3x2 col-auto"> <a target="" class="media-img lazy" href="https://www.maxssl.com/article/39015/" title="【数据库——MySQL（实战项目1）】（4）图书借阅系统——触发器" data-bg="https://img.maxssl.com/uploads/?url=https://img-blog.csdnimg.cn/0963a8126fd646f6aa5f8503d4d1abdc.png"></a></div><div class="entry-wrapper"><div class="entry-body"><h2 class="entry-title"> <a target="" href="https://www.maxssl.com/article/39015/" title="【数据库——MySQL（实战项目1）】（4）图书借阅系统——触发器">【数据库——MySQL（实战项目1）】（4）图书借阅系统——触发器</a></h2></div></div></article></div><div class="col"><article class="post-item item-list"><div class="entry-media ratio ratio-3x2 col-auto"> <a target="" class="media-img lazy" href="https://www.maxssl.com/article/26549/" title="数据仓库总结" data-bg="https://img.maxssl.com/uploads/?url=https://img-blog.csdnimg.cn/img_convert/8d03da9bf7c4751fc8a12d24e1b45f44.png"></a></div><div class="entry-wrapper"><div class="entry-body"><h2 class="entry-title"> <a target="" href="https://www.maxssl.com/article/26549/" title="数据仓库总结">数据仓库总结</a></h2></div></div></article></div><div class="col"><article class="post-item item-list"><div class="entry-media ratio ratio-3x2 col-auto"> <a target="" class="media-img lazy" href="https://www.maxssl.com/article/34969/" title="聊聊最近chatGPT对程序员的焦虑攻击" data-bg="https://img.maxssl.com/uploads/?url=https://img-blog.csdnimg.cn/916d36aabbcd4752a5ca47a144de943c.PNG"></a></div><div class="entry-wrapper"><div class="entry-body"><h2 class="entry-title"> <a target="" href="https://www.maxssl.com/article/34969/" title="聊聊最近chatGPT对程序员的焦虑攻击">聊聊最近chatGPT对程序员的焦虑攻击</a></h2></div></div></article></div><div class="col"><article class="post-item item-list"><div class="entry-media ratio ratio-3x2 col-auto"> <a target="" class="media-img lazy" href="https://www.maxssl.com/article/11699/" title="手把手教你如何免费Midjourney Adobe FireFly AI绘图—Window本地快速部署stable diffusion AI绘图及使用指南（小白也能学会）" data-bg="https://img.maxssl.com/uploads/?url=https://img2023.cnblogs.com/blog/2001208/202304/2001208-20230413113351778-2027894552.png"></a></div><div class="entry-wrapper"><div class="entry-body"><h2 class="entry-title"> <a target="" href="https://www.maxssl.com/article/11699/" title="手把手教你如何免费Midjourney Adobe FireFly AI绘图—Window本地快速部署stable diffusion AI绘图及使用指南（小白也能学会）">手把手教你如何免费Midjourney Adobe FireFly AI绘图—Window本地快速部署stable diffusion AI绘图及使用指南（小白也能学会）</a></h2></div></div></article></div></div></div></div></div></div></div></main><footer class="site-footer py-md-4 py-2 mt-2 mt-md-4"><div class="container"><div class="text-center small w-100"><div>Copyright © <script>today=new Date();document.write(today.getFullYear());</script> maxssl.com 版权所有 <a href="https://beian.miit.gov.cn/" target="_blank" rel="nofollow noopener">浙ICP备2022011180号</a></div><div class=""><script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-7656930379472324" crossorigin="anonymous"></script></div></div></div></footer><div class="rollbar"><ul class="actions"><li><a target="" href="https://www.maxssl.com/" rel="nofollow noopener noreferrer"><i class="fas fa-home"></i><span></span></a></li><li><a target="" href="http://wpa.qq.com/msgrd?v=3&uin=6666666&site=qq&menu=yes" rel="nofollow noopener noreferrer"><i class="fab fa-qq"></i><span></span></a></li></ul></div><div class="back-top"><i class="fas fa-caret-up"></i></div><div class="dimmer"></div><div class="off-canvas"><div class="canvas-close"><i class="fas fa-times"></i></div><div class="logo-wrapper"> <a class="logo text" href="https://www.maxssl.com/">MaxSSL</a></div><div class="mobile-menu d-block d-lg-none"></div></div> <script></script><noscript><style>.lazyload{display:none}</style></noscript><script data-noptimize="1">window.lazySizesConfig=window.lazySizesConfig||{};window.lazySizesConfig.loadMode=1;</script><script async data-noptimize="1" src='https://www.maxssl.com/wp-content/plugins/autoptimize/classes/external/js/lazysizes.min.js'></script><script src='//cdn.bootcdn.net/ajax/libs/jquery/3.6.0/jquery.min.js' id='jquery-js'></script> <script src='//cdn.bootcdn.net/ajax/libs/highlight.js/11.7.0/highlight.min.js' id='highlight-js'></script> <script src='https://www.maxssl.com/wp-content/themes/ripro-v5/assets/js/vendor.min.js' id='vendor-js'></script> <script id='main-js-extra'>var zb={"home_url":"https:\/\/www.maxssl.com","ajax_url":"https:\/\/www.maxssl.com\/wp-admin\/admin-ajax.php","theme_url":"https:\/\/www.maxssl.com\/wp-content\/themes\/ripro-v5","singular_id":"2967","post_content_nav":"0","site_notify_auto":"0","current_user_id":"0","ajax_nonce":"103c76412b","gettext":{"__copypwd":"\u5bc6\u7801\u5df2\u590d\u5236\u526a\u8d34\u677f","__copybtn":"\u590d\u5236","__copy_succes":"\u590d\u5236\u6210\u529f","__comment_be":"\u63d0\u4ea4\u4e2d...","__comment_succes":"\u8bc4\u8bba\u6210\u529f","__comment_succes_n":"\u8bc4\u8bba\u6210\u529f\uff0c\u5373\u5c06\u5237\u65b0\u9875\u9762","__buy_be_n":"\u8bf7\u6c42\u652f\u4ed8\u4e2d\u00b7\u00b7\u00b7","__buy_no_n":"\u652f\u4ed8\u5df2\u53d6\u6d88","__is_delete_n":"\u786e\u5b9a\u5220\u9664\u6b64\u8bb0\u5f55\uff1f"}};</script> <script src='https://www.maxssl.com/wp-content/themes/ripro-v5/assets/js/main.min.js' id='main-js'></script> </body></html>