groovy Exports all table names in database

概述In ant build file: <path id=”groovy.classpath”> <fileset dir=”${java.groovy}/lib”> <include name=”*.jar”/> </fileset> <fileset dir=”${java.groovy}/embeddable”> <include name=”*.jar”/> </fileset> <path

In ant build file:

<path ID=”groovy.classpath”>
<fileset dir=”${java.groovy}/lib”>
<include name=”*.jar”/>
</fileset>
<fileset dir=”${java.groovy}/embeddable”>
<include name=”*.jar”/>
</fileset>
<pathelement location=”${ext.libs.oracle}/classes12.zip”/>
</path>

<taskdef name=”groovy”
classname=”org.codehaus.groovy.ant.Groovy”
classpathref=”groovy.classpath”/>

<target name=”export.schema.to.file”>
<groovy src=”scripts/export.db.gy”>
<arg line=”${db.url} ${db.schema.owner} ${db.schema.password} ${filename}”/>
</groovy>
</target>

Groovy script:

import groovy.sql.sql
import oracle.jdbc.OracleDriver

println “db.url:  ” + args[0]
println “db.schema.ownver:  ” + args[1]
println “filename: ” + args[3]

sql = sql.newInstance(args[0],args[1],
args[2],“oracle.jdbc.OracleDriver”);

new file(args[3]).delete()
new file(args[3]).createNewfile()
def writer=new file(args[3]).newWriter()
sql.eachRow(”SELECT table_name FROM user_tables order by table_name asc”,{writer.writeline(it.table_name)});
writer.close();

List a =[]
new file(args[3]).eachline{ line -> a.add(line) }

println(”Total number of tables:  ” + a.size());

总结

以上是内存溢出为你收集整理的groovy Exports all table names in database全部内容，希望文章能够帮你解决groovy Exports all table names in database所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。