关于数据库script

[chengliang80]

我的程序中有这么一段话
<script language=javascript>
function gologin(){
set dbconnInfo=CreateObject("ADODB.Connection")
dbconnInfo.Open "Driver={Sql Server};Server=10.13.94.123;UID=sa;pwd=;Database=JiXiaoKaoHe"
sql="SELECT * from 三级经理表 where 人员编号='" & session("kaoheID") & "';"
Set RS=dbconnInfo.Execute(sql);
if (rs is null)
alert("输错了");
else
{
form1.action="g31pj.asp";
form1.submit();
}
}
</script>
但总有语法错误，不知如何改正，请指点。

[chengliang80]

??

[zyhowe]

<script language=javascript>
function gologin(){
<%
set dbconnInfo=CreateObject("ADODB.Connection")
dbconnInfo.Open "Driver={Sql Server};Server=10.13.94.123;UID=sa;pwd=;Database=JiXiaoKaoHe"
sql="SELECT * from 三级经理表 where 人员编号='" & session("kaoheID") & "'"
Set RS=dbconnInfo.Execute(sql)
if rs.eof then
%>
alert("输错了");
<%
else
%>
form1.action="g31pj.asp";
form1.submit();
<%end if%>

</script>

[tonnycncn]

楼主的意思是不是用javascript写Asp程序/
先加上runat=server这个属性.
<script language=javascript runat=server>

var signalCode=Request.Form("signalCode");
dbConn = Server.CreateObject("ADODB.Connection");
dbConn.open("DSN=HT;UID=client;PWD=passwd");
rs = Server.CreateObject("ADODB.RecordSet");

var sqlStr = "select * from signaltab order by code";
rs.open(sqlStr,dbConn,1);


if(rs.RecordCount < 1) {
Response.write("<p>      无符合条件记录</p>");
Response.write("<p><form>       <input type='button' value=' 返回' onclick='window.history.back()' name='b1'></form></p>");
}
else {

Response.write("<P><center><B>数据查询结果</B></center></P>");

Response.write("<tr><td><b>代码</b></td><td><b>分类</b></td><td><b>备注</b></td>");

for(var i = 1;i <= rs.Pagesize;i++) {
if(!rs.Eof) {
Response.write("<td><span style='font-size:9t'>"+rs("code")+"</span></td>");
Response.write("<td><span style='font-size:9t'>"+rs("class")+"</span></td>");
Response.write("<td><span style='font-size:9t'>"+rs("memo")+"</span></td>");
Response.write("</tr>");

rs.MoveNext();
}
else break;
}

Response.write("</table></form>");

rs.close();
dbConn.close();
}

</script>

[Andyken]

<!--#include file="ConnectDB.inc"-->
<script language=javascript>
function replace(v){
var sql = "select * from Dictionary where MainID='" + v + "'"
var rs = new ActiveXObject("ADODB.Recordset");''''''''''''''''''''关键
var ConnDB = new ActiveXObject("adodb.connection");'''''''''''''''关键
ConnDB.ConnectionString="server="+Dbname+";uid="+username+";pwd="+password;

ConnDB.open

rs.open(sql,ConnDB,1,1);

if (rs.RecordCount>0){
if (v==parseInt(rs("MainID"))){
document.all('txt').value = v + rs("MainValue");
document.body.style.cursor="default";
return;
}
}

else {
var sql=null;
var CodeLength = parseInt(v);
if (CodeLength.length>3){ ;}
alert("没有此代号！");
txt.select();
txt.focus();
}




}
</script>
<input type=text id=txt name=txt onblur="replace(this.value)">
以上是客户端javascript连接数据库的例子。
相关文章还有：
http://expert.csdn.net/Expert/topic/1531/1531826.xml?temp=.7685205
http://expert.csdn.net/Expert/topic/1586/1586716.xml?temp=.5488855

[chengliang80]

不行呀