我也想用js直接连接数据库取东西啊,在网上搜了很多东西。给你粘一段代码:JavaScript连接SQLServer <script language="javascript"> var conn = new ActiveXObject("ADODB.Connection"); conn.Open("Provider=SQLOLEDB.1; Data Source=localhost; User ID=***; " +"Password=***; Initial Catalog=MyBulletin"); var rs = new ActiveXObject("ADODB.Recordset"); var sql="select stuid,stuname from stu"; rs.open(sql, conn); alert(rs(0));//取出第一个来 rs.close(); rs = null; conn.close(); conn = null; </script>
<script language="javascript">
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("Provider=SQLOLEDB.1; Data Source=localhost; User ID=***; "
+"Password=***; Initial Catalog=MyBulletin");
var rs = new ActiveXObject("ADODB.Recordset");
var sql="select stuid,stuname from stu";
rs.open(sql, conn);
alert(rs(0));//取出第一个来
rs.close();
rs = null;
conn.close();
conn = null;
</script>
$.ajax({
type: "POST",
url: "some.action",
data: "name=John&location=Boston",
success: function(msg){
alert( "Data Saved: " + msg );
}
});