無須進入Admin設定DSN直接連資料庫進行查詢

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沒有公開的函數，更多訪問這裡