《JS直接访问数据Mysql.doc》由会员分享，可在线阅读，更多相关《JS直接访问数据Mysql.doc（8页珍藏版）》请在金锄头文库上搜索。
1、JavaScript DataBase ConnectorJSDBC:提供Javascript有效的连接数据库，目前支持MySQL、SQLite、ACCESS，后期会支持更多的数据库；在从事AJAX开发的工程师肯定会希望有一个通过AJAX直接连接数据库的组件，这样，可以省掉后台很多的操作步骤，比如免去了部署JAVA的运行环境，免去了写很多复杂的JDBC调用，不管出于调试的需要还是应用的需要，JSDBC都能够很好的集成到您的应用当中。/* 类说明：该脚本主要是实现与JSDBC for MySQL 连接，方便用户在js直接使用MySQL* 创建事件：2009-06-12*/Include OCX
2、Objectdocument.writeln( ); document.writeln( ); /error messagevar lasterr = ; /Exec Falgvar execFlag; /* Connecte to mysql server * provite:MySQL IP,PORT,DB Name,USER,Password,CharSet*/function connectMySQL()execFlag = mysql.connecte(127.0.0.1,3306,testdb,root,123210,GBK);if(execFlag = 1)return 1;el
3、selasterr = mysql.getLastError();return 0;/* Close already open Connection*/function closeMySQL()execFlag = mysql.close();if(execFlag = 1)return 1;elselasterr = mysql.getLastError();return 0;/* Exec Insert Into SQL statement* param Object sql*/function insertMySQL(sql)execFlag = mysql.insertData(sql
4、);if(execFlag = 1)return 1;elselasterr = mysql.getLastError();return 0;/* Exec DataBase Manager Language* param Object sql*/function execDMLMySQL(sql)execFlag = mysql.execDML(sql);if(execFlag = 1)return 0;elselasterr = mysql.getLastError();return 0;/* Exec Select Data From DataBase* param Object sql
5、* param Object cnum = Number of fields in SQL statement*/function selectMySQL(sql,cnum)var rs = mysql.selectData(sql,cnum);if(rs.length 0)var array = new Array();var DataSet = new Array();var rowsplit = ;/行间隔 ,注意，这并不是普通的-,而是0x06 转换而来的，使用时拷贝过去即可var fieldsplit =;/字段间隔,注意，这并不是普通的|,而是0x05 转换而来的，使用时拷贝过去即
6、可array = rs.split(rowsplit);for(var i = 0;i array.length; i+)var DataRow = arrayi.split(fieldsplit);DataSeti = DataRow;return DataSet;elselasterr = mysql.getLastError();return null;/* Exec Delete SQL statement* param Object sql*/function deleteMySQL(sql)execFlag = mysql.deleteData(sql);if(execFlag =
7、 1)return 1;elselasterr = mysql.getLastError();return 0;/* Exec Update SQL statement* param Object sql*/function updateMySQL(sql)execFlag = mysql.updateData(sql);if(execFlag = 1)return 1;elselasterr = mysql.getLastError();return 0;/* Exec Call Produce* param Object proname = Produce Name* param Obje
8、ct inparas = Produce IN Parameters* param Object outparas = Produce OUT Parameters* param Object cnum = Number of fields in OUT Parameters*/function callProduceMySQL(proname,inparas,outparas,cnum)var rs = mysql.execProduce(proname,inparas,outparas,cnum);if(rs.length = 0)lasterr = mysql.getLastError(
9、);return null;elsevar array = new Array();var DataSet = new Array();var rowsplit = ;/行间隔 ,注意，这并不是普通的-,而是0x06 转换而来的var fieldsplit =;/字段间隔,注意，这并不是普通的|,而是0x05 转换而来的array = rs.split(rowsplit);var DataRow = new Array();for(var i = 0;i array.length; i+)var fieldarray = arrayi.split(fieldsplit);DataSeti =
10、fieldarray;return DataSet;/* Exec Transcation* param Object sql*/function execTranscationMySQL(sql)execFlag = mysql.execTranscation(sql);if(execFlag = 1)return 1;elselasterr = mysql.getLastError();return 0;/* Get Last Error Message if exec error from js*/function getLastErrorMySQL()return lasterr;/* Get Last Error Message if exec error from ocx*/function getLastErrorFromMySQL()var lasterrmysql = mysql.getLastError();return lasterrmysql;
