[转载]ColdFusion中的RecordSet Component(页 1) - 脚本程序设计{ All Kinds of Scripts } - 邪恶八进制信息安全团队技术讨论组努力为祖国的信息安全撑起一片蓝天

金州 2006-1-31 08:47

[转载]ColdFusion中的RecordSet Component

信息来源：Wayne_Deng的专栏
CF中对数据的操作都是通过CFQuery来进行的，纯粹从便利的角度上来讲远远比不上asp中的recordset object。不过在coldfusion MX里面也有对象了嘛，我们也来自己封装一个简单的recordset Component！
下面是应用示例，熟悉recordset object的不用多说也明白吧？操作起来确实方便。 
<TABLE style="BORDER-RIGHT: #cccccc 1px dotted; TABLE-LAYOUT: fixed; BORDER-TOP: #cccccc 1px dotted; BORDER-LEFT: #cccccc 1px dotted; BORDER-BOTTOM: #cccccc 1px dotted" cellSpacing=0 cellPadding=6 width="95%" align=center border=0>
<TBODY>
<TR>
<TD style="WORD-WRAP: break-word" bgColor=#fdfddf>
以下是代码： <cfscript> rs=createObject("component","CFNews.model.db.recordset"); rs.getByTable("article","article_source"); //打开recordsource为article_source中名为article的table
writeoutput(rs.getField("title") & " "); rs.MoveNext(); writeoutput(rs.getField("title") & " "); rs.MoveLast(); writeoutput(rs.getField("title") & " "); //添加一个新的记录 rs.addNew(); rs.setField("title","insert test"); rs.setField("content","This is a test"); rs.setField("artileID",8); rs.setField("img","<img src='aa'>"); rs.update();
//修改第2个记录 rs.rownum=2; rs.setField("title","update test"); rs.update(); </cfscript></TD></TR></TBODY></TABLE>

下面是recordset.cfc 
<TABLE style="BORDER-RIGHT: #cccccc 1px dotted; TABLE-LAYOUT: fixed; BORDER-TOP: #cccccc 1px dotted; BORDER-LEFT: #cccccc 1px dotted; BORDER-BOTTOM: #cccccc 1px dotted" cellSpacing=0 cellPadding=6 width="95%" align=center border=0>
<TBODY>
<TR>
<TD style="WORD-WRAP: break-word" bgColor=#fdfddf>CFNews.model.db.RecordSet Component RecordSet (Recordset class) 
<TABLE>
<TBODY>
<TR>
<TD>hierarchy:</TD>
<TD><A href="http://127.0.0.1/CFIDE/componentutils/cfcexplorer.cfc?method=getcfcinhtml&name=WEB-INF.cftags.component">WEB-INF.cftags.component</A> CFNews.model.db.RecordSet </TD></TR>
<TR>
<TD>path:</TD>
<TD>C:\Inetpub\wwwroot\CFNews\model\db\RecordSet.cfc</TD></TR>
<TR>
<TD>properties:</TD>
<TD></TD></TR>
<TR>
<TD>methods:</TD>
<TD><A href="http://127.0.0.1/CFIDE/componentutils/componentdetail.cfm?component=CFNews.model.db.RecordSet#method_addNew">addNew</A>, <A href="http://127.0.0.1/CFIDE/componentutils/componentdetail.cfm?component=CFNews.model.db.RecordSet#method_delete">delete</A>, <A href="http://127.0.0.1/CFIDE/componentutils/componentdetail.cfm?component=CFNews.model.db.RecordSet#method_edit">edit</A>, <A href="http://127.0.0.1/CFIDE/componentutils/componentdetail.cfm?component=CFNews.model.db.RecordSet#method_getBySQL">getBySQL</A>, <A href="http://127.0.0.1/CFIDE/componentutils/componentdetail.cfm?component=CFNews.model.db.RecordSet#method_getByTable">getByTable</A>, <A href="http://127.0.0.1/CFIDE/componentutils/componentdetail.cfm?component=CFNews.model.db.RecordSet#method_getField">getField</A>, <A href="http://127.0.0.1/CFIDE/componentutils/componentdetail.cfm?component=CFNews.model.db.RecordSet#method_moveFirst">moveFirst</A>, <A href="http://127.0.0.1/CFIDE/componentutils/componentdetail.cfm?component=CFNews.model.db.RecordSet#method_moveLast">moveLast</A>, <A href="http://127.0.0.1/CFIDE/componentutils/componentdetail.cfm?component=CFNews.model.db.RecordSet#method_moveNext">moveNext</A>, <A href="http://127.0.0.1/CFIDE/componentutils/componentdetail.cfm?component=CFNews.model.db.RecordSet#method_movePrev">movePrev</A>, <A href="http://127.0.0.1/CFIDE/componentutils/componentdetail.cfm?component=CFNews.model.db.RecordSet#method_setField">setField</A>, <A href="http://127.0.0.1/CFIDE/componentutils/componentdetail.cfm?component=CFNews.model.db.RecordSet#method_update">update</A></TD></TR></TBODY></TABLE>* - private method 
<TABLE>
<TBODY>
<TR>
<TH align=left><A name=method_addNew>addNew</A> </TH></TR>
<TR>
<TD><CODE>public addNew ( ) </CODE> Output: supressed </TD></TR>
<TR>
<TH align=left><A name=method_delete>delete</A> </TH></TR>
<TR>
<TD><CODE>public delete ( ) </CODE> Output: supressed </TD></TR>
<TR>
<TH align=left><A name=method_edit>edit</A> </TH></TR>
<TR>
<TD><CODE>public edit ( ) </CODE> Output: supressed </TD></TR>
<TR>
<TH align=left><A name=method_getBySQL>getBySQL</A> </TH></TR>
<TR>
<TD><CODE>public getBySQL ( required string sql, required string recordSource ) </CODE> get a Query object by a sql sentence Output: supressed Parameters: sql: string, required, sql recordSource: string, required, recordSource </TD></TR>
<TR>
<TH align=left><A name=method_getByTable>getByTable</A> </TH></TR>
<TR>
<TD><CODE>public getByTable ( required string tableName, required string recordSource ) </CODE> get a Query object by a table name Output: supressed Parameters: tableName: string, required, tableName recordSource: string, required, recordSource </TD></TR>
<TR>
<TH align=left><A name=method_getField>getField</A> </TH></TR>
<TR>
<TD><CODE>public getField ( required string fieldName ) </CODE> get field value by field name Output: supressed Parameters: fieldName: string, required, fieldName </TD></TR>
<TR>
<TH align=left><A name=method_moveFirst>moveFirst</A> </TH></TR>
<TR>
<TD><CODE>public moveFirst ( ) </CODE> Output: supressed </TD></TR>
<TR>
<TH align=left><A name=method_moveLast>moveLast</A> </TH></TR>
<TR>
<TD><CODE>public moveLast ( ) </CODE> Output: supressed </TD></TR>
<TR>
<TH align=left><A name=method_moveNext>moveNext</A> </TH></TR>
<TR>
<TD><CODE>public moveNext ( ) </CODE> Output: supressed </TD></TR>
<TR>
<TH align=left><A name=method_movePrev>movePrev</A> </TH></TR>
<TR>
<TD><CODE>public movePrev ( ) </CODE> Output: supressed </TD></TR>
<TR>
<TH align=left><A name=method_setField>setField</A> </TH></TR>
<TR>
<TD><CODE>public setField ( required string fieldName, required string value, string fieldType ) </CODE> Output: supressed Parameters: fieldName: string, required, fieldName value: string, required, value fieldType: string, optional, fieldType </TD></TR>
<TR>
<TH align=left><A name=method_update>update</A> </TH></TR>
<TR>
<TD><CODE>public update ( string IDName ) </CODE> Output: supressed Parameters: IDName: string, optional, IDName </TD></TR></TBODY></TABLE> </TD></TR></TBODY></TABLE>

<TABLE style="BORDER-RIGHT: #cccccc 1px dotted; TABLE-LAYOUT: fixed; BORDER-TOP: #cccccc 1px dotted; BORDER-LEFT: #cccccc 1px dotted; BORDER-BOTTOM: #cccccc 1px dotted" cellSpacing=0 cellPadding=6 width="95%" align=center border=0>
<TBODY>
<TR>
<TD style="WORD-WRAP: break-word" bgColor=#fdfddf>
以下是代码： <cfcomponent displayname="Recordset class"> <cfset this.fields=structNew()> <cfset this.tableName=""> <cfset this.recordSource="">
<cffunction name="getByTable" access="public" output="false" hint="get a Query object by a table name"> <cfargument name="tableName" type="string" required="yes"> <cfargument name="recordSource" type="string" required="yes"> <cfset this.tableName=arguments.tableName> <cfset this.recordSource=arguments.recordSource> <cfquery datasource="#this.recordSource#" name="recordSetSelect"> select * from #this.tableName# </cfquery> <cfset this.recordSet=recordSetSelect> <cfset this.mode="select"> <cfset this.rownum=1> </cffunction> <cffunction name="getBySQL" access="public" output="false" hint="get a Query object by a sql sentence"> <cfargument name="sql" type="string" required="yes"> <cfargument name="recordSource" type="string" required="yes"> <cfset this.sql=arguments.sql> <cfset this.recordSource=arguments.recordSource> <cfquery datasource="#this.recordSource#" name="recordSetSelect"> #PreserveSingleQuotes(this.sql)# </cfquery> <cfset this.recordSet=recordSetSelect> <cfset this.mode="select"> <cfset this.rownum=1> </cffunction> <cffunction name="getField" access="public" output="false" hint="get field value by field name"> <cfargument name="fieldName" type="string" required="yes"> <cfset value=evaluate("this.recordSet.#arguments.fieldName#[#this.rownum#]")> <cfreturn value> </cffunction> <cffunction name="setField" access="public" output="false"> <cfargument name="fieldName" type="string" required="yes"> <cfargument name="value" type="string" required="yes"> <cfargument name="fieldType" type="string" required="no"> <cfif not isdefined("this.fields.#arguments.fieldName#")><cfset tmp=Evaluate("this.fields.#arguments.fieldName#=structNew()")></cfif> <cfscript>StructInsert(Evaluate("this.fields.#arguments.fieldName#"),"value",arguments.value,"yes");</cfscript> <cfif not isdefined("arguments.fieldType")> <cfif isDate(arguments.value)> <cfset tmp=Evaluate("this.fields.#arguments.fieldName#.fieldType='date'")> <cfelseif isNumeric(arguments.value)> <cfset tmp=Evaluate("this.fields.#arguments.fieldName#.fieldType='numeric'")> <cfelse> <cfset tmp=Evaluate("this.fields.#arguments.fieldName#.fieldType='varchar'")> </cfif> <cfelse> <cfset tmp=Evaluate("this.fields.#arguments.fieldName#.fieldType='#arguments.fieldType#'")> </cfif> </cffunction> <cffunction name="moveFirst" access="public" output="false"> <cfset this.rownum=1> </cffunction> <cffunction name="moveLast" access="public" output="false"> <cfset this.rownum=this.recordSet.recordcount> </cffunction> <cffunction name="moveNext" access="public" output="false"> <cfset this.rownum=this.rownum+1> <cfif this.rownum gt this.recordSet.recordcount><cfset this.rownum=this.recordSet.recordcount></cfif> </cffunction> <cffunction name="movePrev" access="public" output="false"> <cfset this.rownum=this.rownum-1> <cfif this.rownum lt 1><cfset this.rownum=1></cfif> </cffunction> <cffunction name="addNew" access="public" output="false"> <cfset this.mode="addnew"> </cffunction> <cffunction name="edit" access="public" output="false"> <cfset this.mode="edit"> </cffunction> <cffunction name="delete" access="public" output="false"> <cfif not isdefined("arguments.IDName")><cfset arguments.IDName=ListContainsNoCase(this.recordSet.ColumnList,"id",",")></cfif> <cfif arguments.IDName eq ""><cfset arguments.IDName=ListFirst(this.recordSet.ColumnList,",")></cfif> <cfquery datasource="#this.recordSource#" name="recordSetDelete"> delete from #this.tableName# where <cfset fv=evaluate("this.recordSet.#arguments.IDName#[#this.rownum#]")> <cfif isNumeric(fv)> #arguments.IDName#=<cfqueryparam cfsqltype="cf_sql_numeric" value="#fv#"> <cfelse> #arguments.IDName#=<cfqueryparam cfsqltype="cf_sql_varchar" value="#fv#"> </cfif> </cfquery> </cffunction> <cffunction name="update" access="public" output="false"> <cfargument name="IDName" type="string" required="no"> <cfset fieldsList=StructKeyList(this.fields,",")> <cfset i=1> <cfif this.mode eq "addnew"> <cfquery datasource="#this.recordSource#" name="recordSetInsert"> insert into #this.tableName# (#fieldsList#) values( <cfloop index="f" list="#fieldsList#" delimiters=","> <cfset fv=evaluate("this.fields.#f#.value")><cfset ftype=evaluate("this.fields.#f#.fieldType")> <cfif i eq 1><cfset comma=""><cfelse><cfset comma=","></cfif><cfset i=2> #comma#<cfqueryparam cfsqltype="cf_sql_#ftype#" value="#fv#"> </cfloop>) </cfquery> <cfelseif this.mode eq "edit"> <cfif not isdefined("arguments.IDName")><cfset arguments.IDName=ListContainsNoCase(this.recordSet.ColumnList,"id",",")></cfif> <cfif arguments.IDName eq ""><cfset arguments.IDName=ListFirst(this.recordSet.ColumnList,",")></cfif> <cfquery datasource="#this.recordSource#" name="recordSetUpdate"> update #this.tableName# set <cfloop index="f" list="#fieldsList#" delimiters=","> <cfset fv=evaluate("this.fields.#f#.value")><cfset ftype=evaluate("this.fields.#f#.fieldType")> <cfif i eq 1><cfset comma=""><cfelse><cfset comma=","></cfif><cfset i=2> #comma##f#=<cfqueryparam cfsqltype="cf_sql_#ftype#" value="#fv#"> </cfloop> where <cfset fv=evaluate("this.recordSet.#arguments.IDName#[#this.rownum#]")> <cfif isNumeric(fv)> #arguments.IDName#=<cfqueryparam cfsqltype="cf_sql_numeric" value="#fv#"> <cfelse> #arguments.IDName#=<cfqueryparam cfsqltype="cf_sql_varchar" value="#fv#"> </cfif> </cfquery> </cfif> </cffunction> </cfcomponent></TD></TR></TBODY></TABLE>

页: [1]

邪恶八进制信息安全团队技术讨论组's Archiver

[转载]ColdFusion中的RecordSet Component