javascript 连接数据库

wangdetian168 · 发表于 2013-2-7 20:17:13

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<script language=javascript>
var conn = new ActiveXObject("adodb.connection");
conn.open("provider=sqloledb;data source=.;initial catalog=pubs;user id=sa;password=;");
function getData()
{
var sql ="select * from titles";
var rs = conn.execute(sql);
var content = "";
var content1 ="";
while(!rs.EOF)
{
content = content+"<a href='show.html?id="+rs("title_id")+"'>"+rs("title")+"</a>"+"<br>";
content1 = content1+"<a href='img/"+rs("img")+"'><img src='img/"+rs("img")+"' width=20 height=50/><a>"
rs.moveNext;
}
//document.write(content);
document.getElementById("content").innerHTML=content;
document.getElementById("content1").innerHTML=content1;
}
function checkUser()
{
var user,pass;
user = document.getElementById("user").value;
pass = document.getElementById("pass").value;
var sql = "select * from titles where title_id='"+user+"' and title='"+pass+"'";
var rs = conn.execute(sql);
if(!rs.EOF)
{
alert("存在此人");
}
else
{
alert("没有人");
}
}
function addUser()
{
var user,pass;
user = document.getElementById("user").value;
pass = document.getElementById("pass").value;
var sql = "insert into titles(title_id,title) values('"+user+"','"+pass+"')";
try
{
conn.execute(sql)
alert(" succcess");
//window.reload();
//document.location.href="D:\web\index.html";
}
catch(e)
{
alert("fail");
}
/*if()
{
}
else
{
}*/

}
//for(int i=0;i<10;i++)
//{
//document.write(rs("title"));
//rs.movenext;
//}
</script>
</head>
<body>
<span id="content1">content</span>
<table width="763" border="1">
<tr>
<td width="266" colspan="3"><span id="content">content</span></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>用户名</td>
<td><input name="user" type="text" id="user"></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>密码</td>
<td><input name="pass" type="text" id="pass"></td>
</tr>
<tr>
<td><input type="submit" name="Submit3" value="添加用户 " ></td>
<td><input type="submit" name="Submit2" value="获取数据" ></td>
<td><input type="submit" name="Submit" value="验证用户" ></td>
</tr>
</table>
</body>
</html>

		自动登录	找回密码
密码			立即注册

javascript 连接数据库

浏览过的版块