Via MMUG
<!--- --->
<cfset initDriver=createObject("java","java.lang.Class").forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance()>
<cfset strURL = "jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=C:\CFusionMX\db\company.mdb">
<cfset conn=createObject("java","java.sql.DriverManager").getConnection(strURL)>
<cfset stmt = conn.createStatement()>
<!--- --->
<cfset query = stmt.executeQuery("select * from Employee")>
<cfloop condition="query.next()">
<cfoutput>
#query.getString("FirstName")# | #query.getString("LastName")# | #query.getString("StartDate")#<br />
</cfoutput>
</cfloop>
<cfset query.close()>
query.next()?这是MM没有公开的函数,更多访问这里