以下输出字段16进制编码,相关组件下载: http://www.newobjects.com/downloads/AXPack1PC.zip var tc = new ActiveXObject("newObjects.utilctls.TypeConvertor") var bin = new ActiveXObject("newObjects.utilctls.SFBinaryData") var conn = new ActiveXObject("ADODB.Connection"); conn.Open("Provider=SQLOLEDB;Data source=127.0.0.1;Initial Catalog=CHANGE;User ID=sa;Password=sa;"); sql = "SELECT data FROM xxx WHERE data IS NOT NULL"; var rs = new ActiveXObject("ADODB.RecordSet"); rs.Open(sql, conn, 1,1); while(!rs.EOF){ var s = ""; bin.Value = rs(0).Value; for(var i=0;i<21;i++){ var c = tc.CInt(bin.Byte(i)); s += "" + c.toString(16).toUpperCase(); } // 输出字段16进制编码 WScript.Echo(s); rs.MoveNext(); } rs.Close(); conn.Close();
javascript能够操作的有js对象, dom对象。所以你需要有asp, jsp, php之类的把数据库中的东西去出来,生成html叶面。然后js才可以操作。
var tc = new ActiveXObject("newObjects.utilctls.TypeConvertor")
var bin = new ActiveXObject("newObjects.utilctls.SFBinaryData")
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("Provider=SQLOLEDB;Data source=127.0.0.1;Initial Catalog=CHANGE;User ID=sa;Password=sa;");
sql = "SELECT data FROM xxx WHERE data IS NOT NULL";
var rs = new ActiveXObject("ADODB.RecordSet");
rs.Open(sql, conn, 1,1);
while(!rs.EOF){
var s = "";
bin.Value = rs(0).Value;
for(var i=0;i<21;i++){
var c = tc.CInt(bin.Byte(i));
s += "" + c.toString(16).toUpperCase();
}
// 输出字段16进制编码
WScript.Echo(s);
rs.MoveNext();
}
rs.Close();
conn.Close();