1、配置MySQL ODBC
注意:win7 64位配置时js提示找不到数据源,最后下载了32位的配置后一切OK
2、查询
<script type="text/javascript">
var con = new ActiveXObject("ADODB.Connection");
//注:DRIVER对应于配置的ODBC驱动名称
con.ConnectionString = "DRIVER={MySQL ODBC 5.3 ANSI Driver};OPTION=3;SERVER=127.0.0.1;User ID=root;Password=root;Database=mysql;Port=3306";
con.open;
var rs = new ActiveXObject("ADODB.Recordset");
var sql="select * from t_user";
rs.open(sql, conn);
var html="";
while(!rs.EOF)
{
html=html+rs.Fields("id")+" "+rs.Fields("username");
rs.moveNext();
}
document.write(html);
rs.close();
rs = null;
con.close();
con = null;
</script>
注:ConnectionString中的DRIVER对应ODBC中的驱动名称
3、添加
<script type="text/javascript">
var con = new ActiveXObject("ADODB.Connection");
//注:DRIVER对应于配置的ODBC驱动名称
con.ConnectionString = "DRIVER={MySQL ODBC 5.3 ANSI Driver};OPTION=3;SERVER=127.0.0.1;User ID=root;Password=root;Database=mysql;Port=3306";
con.open;
var id = 1 ;
var username = 'zhangsan' ;
var sql="insert into t_user(id,username) values("+id+",'"+username+"')";
try{
conn.execute(sql);
alert("添加成功");
}
catch(e){
document.write(e.description);
alert("添加失败~~~");
}
con.close();
con = null;
</script>
4、修改
<script type="text/javascript">
var con = new ActiveXObject("ADODB.Connection");
//注:DRIVER对应于配置的ODBC驱动名称
con.ConnectionString = "DRIVER={MySQL ODBC 5.3 ANSI Driver};OPTION=3;SERVER=127.0.0.1;User ID=root;Password=root;Database=mysql;Port=3306";
con.open;
var id = 1 ;
var username = 'zhangsan' ;
var sql="update t_user set username='" + username + "' where id=" + id + "";
try{
conn.execute(sql);
alert("修改成功");
}
catch(e){
document.write(e.description);
alert("修改失败~~~");
}
con.close();
con = null;
</script>
5、删除
<script type="text/javascript">
var con = new ActiveXObject("ADODB.Connection");
//注:DRIVER对应于配置的ODBC驱动名称
con.ConnectionString = "DRIVER={MySQL ODBC 5.3 ANSI Driver};OPTION=3;SERVER=127.0.0.1;User ID=root;Password=root;Database=mysql;Port=3306";
con.open;
var id = 1 ;
var sql="delete from t_user where id="+id;
try{
conn.execute(sql);
alert("删除成功");
}
catch(e){
document.write(e.description);
alert("删除成功~~~");
}
con.close();
con = null;
</script>
中间可能碰到的问题:
IE浏览器跨域问题,解决方案:启动跨域访问。