| 個人檔案温柔的星空部落格清單 | 說明 |
|
5月6日 用代码操作Administrator资料<cfscript>
adminObj = createObject("component","cfide.adminapi.administrator"); adminObj.login("您administrator的密码"); // Instantiate the data source object. myObj = createObject("component","cfide.adminapi.datasource"); // Create a DSN. myObj.setMSAccessUnicode (driver="MSAccessJet", name="数据源名字", databasefile = "数据库path", class="com.inzoom.jdbcado.Driver", login_timeout = 29, timeout = 23, interval = 6, buffer = "64000", blob_buffer = "64000", setStringParameterAsUnicode = "false", description = "数据库描述", enableMaxConnections = "true", maxConnections = "299", disable = false, storedProc = true, alter = false, grant = true, select = true, update = true, create = true, delete = true, drop = false, revoke = false ); </cfscript> <!--- 下面是在cf6以下版本中实现代码 ---> <cfset dbq="e:\coldfusion.mdb">//数据库path <cfset driver="{MicroSoft Access Driver (*.mdb)}">//事件驱动 <cfset initDriver=createObject("java","java.lang.Class").forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance()> <cfset strURL = "jdbc:odbc:Driver=#driver#;DBQ=#dbq#"> <cfset conn=createObject("java","java.sql.DriverManager").getConnection(strURL)> <cfset stmt = conn.createStatement()> <cfset query = stmt.executeQuery("select * from blog_article")> <cfloop condition="query.next()"> <cfoutput> #query.getString("Log_ID")# - #query.getString("Log_title")# - #query.getString("Log_intro")#<br> </cfoutput> </cfloop> <cfset query.close()> 引用通告此內容的引用通告是: http://jinxuefan.spaces.live.com/blog/cns!F4CC982F1B2F01EF!112.trak 引述這則內容的部落格
|
|
|