使用IE浏览器
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<label id="w">label</label>
</body>
<script type="text/javascript">
var conn = new ActiveXObject("ADODB.Connection");
var rs = new ActiveXObject("ADODB.Recordset");
try{
var connectionstring = "Driver={SQL Server};Server=DESKTOP-RC9JFD5;Database=websites;User=sa; Password=123456;Option=3;Port=3306";
conn.open(connectionstring);
var sql = " select * from web ";
rs.open(sql,conn);
while(!rs.eof){
console.log(rs.Fields("id") + "\t" + rs.Fields("name"));
//下一条记录
rs.moveNext();
}
rs.close();
conn.close();
} catch(e){
} finally{
//
}
</script>
</html>
更多推荐
js连接mysql数据库
发布评论