会python真的可以为所欲为0(回)
347天前
这里还有人吗1(回)
532天前这里还有人吗0(回)
532天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
756天前到处都是羊，不想上班0(回)
836天前
鸽子
0(回)
840天前import groovy.sql.Sql |
import groovy.xml.MarkupBuilder |
def schema = "PROD" |
def sql = Sql.newInstance("jdbc:oracle:thin:@hostname:1526:${schema}", |
"scott", "tiger", "oracle.jdbc.driver.OracleDriver") |
|
/* Request */ |
def req = """ |
SELECT id, name, givenname, unit FROM ${schema}.people |
WHERE |
in_unit=1 |
AND visible=0 |
""" |
def out = new File('out.xml') |
def writer = new FileWriter( out ) |
def xml = new MarkupBuilder( writer ) |
|
xml.agents { |
sql.eachRow( req as String ) { |
/* For each row output detail */ |
row -> |
xml.agent(id:row.id) { |
name( row.name ) |
givenname( row.givenname ) |
unit( row.unit ) |
} |
} |
} |
by: 发表于：2017-09-20 10:13:13 顶(0) | 踩(0) 回复
？？
回复评论