AAuto DB Demo

最新推荐文章于 2024-09-27 20:43:28 发布

crz03128

最新推荐文章于 2024-09-27 20:43:28 发布

阅读量631

点赞数

文章标签： books mysql function import 数据库 null

本文链接：https://blog.csdn.net/crz03128/article/details/7998261

版权

import mysql;


conn_mysql = function (){
	var link = null;
	var error_msg = null;

	try{
		link = mysql("127.0.0.1","root","123456");
		if(! link.handle)
     	{
    		error("连接数据库失败..");
  		}
  		
  		link.set_charset("UTF8");
  		
  		if (!link.select_db("books")) {
         error("选择库失败: " + link.error);
        }
       
	}
	catch(e){
		if(link != null)
		    link.close();
		    
		  error_msg = e;	
	}
	 
	 return link,error_msg;
}
io.open();
try{
     var link,error_error_msg = conn_mysql();
     if(#error_){
        error(error_error_msg);
     }   
       
     var result = link.query("select * from books");
      if (!result) {
        error("读取数据失败: " + link.error);
    }
     var row = result.fetch_array();
     while(row){
     
         io.print(row.isbn,row.author,row.title);
         row = result.fetch_array();
     }
     
    
  
  link.close();
  io.print(link.get_info())
  
 execute("pause");
 io.close();
	
}
catch(e){
    io.print('error...\n',e);
	execute("pause");
    io.close();
	
}