|
本帖最后由 atchek 于 25-2-2010 11:29 PM 编辑
http://freshmeat.net/projects/sql2xml
SQL2XML 是本 教主 开发的软件
英语介绍
Sql2xml is a CGI program that lets you request a SQL query and convert it to JSON, CSV, XML or INI through a Web server. Sql2xml supports requests from multiple users and for multiple databases. It is intended for developers who do not have direct access to database servers due to firewalls or other restrictions.
华语介绍
SQL2XML 是个 PERL CGI 软件, 可以让你通过WEB 服务器把你的SQL QUERY  转换成  JSON, CSV, XML or INI 格式。这个程式可以支持多用户,多资料库。 主要是给开发者制造一个直接的途径 来接触 资料库
安装条件:
Perl Module
libdbi-perl
libxml-simple-perl
libconfig-ini-simple-perl
libjson-perl
Option Perl Module
libdbd-mysql-perl
libdbd-pg-perl
libdbd-oracle-perl
libdbd-*
用法:
下载SQL2XML 后,  把 SQL2XML 安装在CGI-BIN 目录里, 修改 sql2xml.ini 或建立类似文件
Sample sql2xml.ini
- [report_1]
- type=1 //0 for select query , 1 for update,insert, delete query
- query=update mydb set name='#param1' adderss='#param2' where param3='#param3'
- host=hostname/ip address
- database=data
- username=user1
- password=
- format=xml //xml = xml format, ini = ini format
- db=mysql //mysql,pg=postgresql,oracle,db2
- key=newkey //(optional) key can be any series of characters, if key is defined and doesnt match, the query will not be executed
复制代码
Usage Example
- http://localhost/cgi-bin/sql2xml.pl?report=report_1¶m1=myname¶m2=myaddress¶m3=myid&key=password
复制代码 |
|