博客

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浏览器跨域问题，解决方案：启动跨域访问。