论坛 › Web开发 › 我的框架:模型

蓝冰大侠 发表于 2011-12-21 08:44

我的框架:模型

                &lt;?php<br>final class MBizLog extends SModel {<br>&nbsp;&nbsp;&nbsp; protected static $handle; //单例句柄<br><br><br>&nbsp;&nbsp;&nbsp; protected $table;<br><br>&nbsp;&nbsp;&nbsp; protected function __construct() {<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $this-&gt;table = $this-&gt;_table('biz_log');<br>&nbsp;&nbsp;&nbsp; }<br><br>&nbsp;&nbsp;&nbsp; /**<br>&nbsp;&nbsp;&nbsp; &nbsp;* 获取本类单例的方法,公开<br>&nbsp;&nbsp;&nbsp; &nbsp;*<br>&nbsp;&nbsp;&nbsp; &nbsp;* @return MBizLog<br>&nbsp;&nbsp;&nbsp; &nbsp;*/<br>&nbsp;&nbsp;&nbsp; public static function instance() {<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; if(self::$handle){<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; return self::$handle;<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; }<br><br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $class = __CLASS__;<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; self::$handle = new $class();<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; return self::$handle;<br>&nbsp;&nbsp;&nbsp; }<br><br>&nbsp;&nbsp;&nbsp; /**<br>&nbsp;&nbsp;&nbsp; &nbsp;* 商家管理时调用的日志插入<br>&nbsp;&nbsp;&nbsp; &nbsp;*<br>&nbsp;&nbsp;&nbsp; &nbsp;*/<br>&nbsp;&nbsp;&nbsp; static public function addLog($msg) {<br>

<p style="margin:0in">&nbsp;</p>

<p style="margin:0in;font-size:10.0pt"><span style="font-family:SimSun" lang="zh-CN">所有模型都继承</span><span style="font-family:Calibri" lang="en-US">SModel</span><span style="font-family:SimSun" lang="zh-CN">类</span></p>

<p style="margin:0in;font-family:SimSun;font-size:10.0pt">&nbsp;</p>

<p style="margin:0in;font-size:10.0pt"><span style="font-family:SimSun" lang="zh-CN">模型类名</span><span style="font-family:Calibri" lang="en-US"> </span><span style="font-family:SimSun" lang="zh-CN">以</span><span style="font-family:Calibri" lang="en-US">M</span><span style="font-family:SimSun" lang="zh-CN">开头</span></p>

<p style="margin:0in;font-family:SimSun;font-size:10.0pt">&nbsp;</p>

<p style="margin:0in;font-size:10.0pt"><span style="font-family:SimSun" lang="zh-CN">前两个属性与前两个方法是固定写法</span><span style="font-family:Calibri" lang="en-US"><span style="mso-spacerun:yes">&nbsp; </span>, </span><span style="font-family:SimSun" lang="zh-CN">请修改其中</span><span style="font-family:Calibri" lang="en-US"> </span><span style="font-family:SimSun" lang="zh-CN">与</span><span style="font-family:Calibri" lang="en-US"> </span><span style="font-family:SimSun" lang="zh-CN">具体表相关的词</span><span style="font-family:Calibri" lang="en-US">(</span><span style="font-family:SimSun" lang="zh-CN">包括注释中</span><span style="font-family:Calibri" lang="en-US">)</span></p>

<p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">&nbsp;</p>

<p style="margin:0in;font-family:宋体;font-size:10.0pt">之后是各种模型方法</p>

<p style="margin:0in;font-family:宋体;font-size:10.0pt">&nbsp;</p>

<p style="margin:0in;font-size:10.0pt"><span style="font-family:宋体" lang="zh-CN">注意</span><span style="font-family:Calibri" lang="en-US">,</span><span style="font-family:宋体" lang="zh-CN">模型是单例的</span><span style="font-family:Calibri" lang="en-US">,</span><span style="font-family:宋体" lang="zh-CN">调用时需要</span><span style="font-family:Calibri" lang="en-US"> MProduct::instance()-&gt;xxx()</span></p>

<p style="margin:0in">&nbsp;</p>

<ul style="margin-left:.0743in;direction:ltr;unicode-bidi:embed;margin-top:
0in;margin-bottom:0in"><p style="margin:0in;font-family:SimSun;font-size:10.0pt">基类已经实现的模型方法</p><div style="direction:ltr">
<table valign="top" style="direction:ltr;
border-collapse:collapse;border-style:solid;border-color:#A3A3A3;border-width:
1pt" border="1" cellpadding="0" cellspacing="0">
<tbody><tr>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">1</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">get</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:2.0527in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:SimSun;font-size:10.0pt">获取单值</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.7166in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:SimSun;font-size:10.0pt">&nbsp;</p>
   </td>
</tr>
<tr>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">2</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">row</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:2.0527in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:SimSun;font-size:10.0pt">获取一条记录</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.7166in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:SimSun;font-size:10.0pt">&nbsp;</p>
   </td>
</tr>
<tr>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">3</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">col</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:2.0527in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:SimSun;font-size:10.0pt">获取一列</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.7166in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:SimSun;font-size:10.0pt">&nbsp;</p>
   </td>
</tr>
<tr>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">4</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">select</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:2.0527in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:SimSun;font-size:10.0pt">获取多条记录</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.7166in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:SimSun;font-size:10.0pt">&nbsp;</p>
   </td>
</tr>
<tr>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">5</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">update</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:2.0527in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:SimSun;font-size:10.0pt">&nbsp;</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.7166in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:SimSun;font-size:10.0pt">&nbsp;</p>
   </td>
</tr>
<tr>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">6</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">insert</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:2.0527in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:SimSun;font-size:10.0pt">&nbsp;</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.7166in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:SimSun;font-size:10.0pt">&nbsp;</p>
   </td>
</tr>
<tr>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">7</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">delete</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:2.0527in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:SimSun;font-size:10.0pt">&nbsp;</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.7166in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:SimSun;font-size:10.0pt">&nbsp;</p>
   </td>
</tr>
<tr>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">8</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">exist</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:2.0527in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:SimSun;font-size:10.0pt">判断是否存在满足条件的记录</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.7166in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:SimSun;font-size:10.0pt">&nbsp;</p>
   </td>
</tr>
<tr>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">9</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">immit</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:2.0527in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-size:10.0pt"><span style="font-family:SimSun" lang="zh-CN">处理字符串</span><span style="font-family:Calibri" lang="en-US">,</span><span style="font-family:SimSun" lang="zh-CN">防注入</span></p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.7166in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:SimSun;font-size:10.0pt">&nbsp;</p>
   </td>
</tr>
<tr>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">10</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">count</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:2.0527in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-size:10.0pt"><span style="font-family:SimSun" lang="zh-CN">计数</span><span style="font-family:Calibri" lang="en-US"> </span></p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.7166in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:SimSun;font-size:10.0pt">&nbsp;</p>
   </td>
</tr>
</tbody></table>
</div><p style="margin:0in;font-family:SimSun;font-size:10.0pt">&nbsp;</p><p style="margin:0in;font-family:SimSun;font-size:10.0pt">&nbsp;</p><p style="margin:0in;font-size:10.0pt"><span style="font-family:Calibri" lang="en-US">table</span><span style="font-family:SimSun" lang="zh-CN">属性的常用方法</span></p><div style="direction:ltr">
<table valign="top" style="direction:ltr;
border-collapse:collapse;border-style:solid;border-color:#A3A3A3;border-width:
1pt" border="1" cellpadding="0" cellspacing="0">
<tbody><tr>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">1</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6881in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">query</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:1.4847in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-size:10.0pt"><span style="font-family:SimSun" lang="zh-CN">复杂</span><span style="font-family:Calibri" lang="en-US">SQL</span><span style="font-family:SimSun" lang="zh-CN">语句的查询</span></p>
   </td>
</tr>
<tr>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6673in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">2</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:.6881in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-family:Calibri;font-size:10.0pt" lang="en-US">execute</p>
   </td>
   <td style="border-style:solid;border-color:#A3A3A3;border-width:1pt;
   vertical-align:top;width:1.4847in;padding:4pt 4pt 4pt 4pt">
   <p style="margin:0in;font-size:10.0pt"><span style="font-family:SimSun" lang="zh-CN">复杂</span><span style="font-family:Calibri" lang="en-US">SQL</span><span style="font-family:SimSun" lang="zh-CN">语句的执行</span></p>
   </td>
</tr>
</tbody></table>
</div></ul>


               
               
               
               
               
               
               

查看完整版本: 我的框架:模型