JavaScript DataBase ConnectorJSDBC:提供Javascript有效的连接数据库,目前支持MySQL、SQLite、ACCESS,后期会支持更多的数据库;在从事AJAX开发的工程师肯定会希望有一个通过AJAX直接连接数据库的组件,这样,可以省掉后台很多的操作步骤,比如免去了部署JAVA的运行环境,免去了写很多复杂的JDBC调用,不管出于调试的需要还是应用的需要,JSDBC都能够很好的集成到您的应用当中。
/**
* 类说明:该脚本主要是实现与JSDBC for ACCESS 连接,方便用户在js直接使用ACCESS
* 创建事件:2009-06-16
*/
//Include OCX Object
document.writeln(" <OBJECT id='Access' classid='clsid:75BF468E-4AE7-4152-A6FD-1F307D96C65F'");
document.writeln(" codebase='JSDBC_Access.ocx#Version=1,0,0,000'");
document.writeln(" WIDTH='0' HEIGHT='0'>");
document.writeln(" </OBJECT>");
//error message
var lasterr = "";
//Exec Falg
var execFlag;
/**
* Connecte to access
* provite:Access IP,PORT,DB Name,USER,Password,CharSet
*/
function connectAccess()
{
execFlag = Access.connecte("D://PersonalDocs//ourSoft//JSDBC//test_access.mdb","sa","");
if(execFlag == 1)
return 1;
else
{
lasterr = execFlag;
return 0;
}
}
/**
* Close already open Connection
*/
function closeAccess()
{
execFlag = Access.close();
if(execFlag == 1)
return 1;
else
{
lasterr = execFlag;
return 0;
}
}
/**
* Exec Insert Into SQL statement
* @param {Object} sql
*/
function insertAccess(sql)
{
execFlag = Access.insertData(sql);
if(execFlag == 1)
return 1;
else
{
lasterr = execFlag;
return 0;
}
}
/**
* Exec DataBase Manager Language
* @param {Object} sql
*/
function execDMLAccess(sql)
{
execFlag = Access.execDML(sql);
if(execFlag == 1)
return 1;
else
{
lasterr = execFlag;
return 0;
}
}
/**
* Exec Select Data From DataBase
* @param {Object} sql
* @param {Object} cnum == Number of fields in SQL statement
*/
function selectAccess(sql,cnum)
{
var rs = Access.selectData(sql,cnum);
if(rs.length > 0)
{
var array = new Array();
var DataSet = new Array();
var rowsplit = '';//行间隔 ,注意,这并不是普通的'-',而是0x06 转换而来的,使用时拷贝过去即可
var fieldsplit ='';//字段间隔,注意,这并不是普通的'|',而是0x05 转换而来的,使用时拷贝过去即可
array = rs.split(rowsplit);
for(var i = 0;i < array.length; i++)
{
var DataRow = array[i].split(fieldsplit);
DataSet[i] = DataRow;
}
return DataSet;
}
else
{
lasterr = execFlag;
return null;
}
}
/**
* Exec Delete SQL statement
* @param {Object} sql
*/
function deleteAccess(sql)
{
execFlag = Access.deleteData(sql);
if(execFlag == 1)
return 1;
else
{
lasterr = execFlag;
return 0;
}
}
/**
* Exec Update SQL statement
* @param {Object} sql
*/
function updateAccess(sql)
{
execFlag = Access.updateData(sql);
if(execFlag == 1)
return 1;
else
{
lasterr = execFlag;
return 0;
}
}
/**
* Exec Transcation
* @param {Object} sql
*/
function execTranscationAccess(sql)
{
execFlag = Access.execTranscation(sql);
if(execFlag == 1)
return 1;
else
{
lasterr = execFlag;
return 0;
}
}
/**
* Get Last Error Message if exec error from js
*/
function getLastErrorAccess()
{
return lasterr;
}