使用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数据库