Java Doc for JDBCTask.java in  » Build » ANT » org » apache » tools » ant » taskdefs » Java Source Code / Java DocumentationJava Source Code and Java Documentation

 package examples;
 import java.sql.Connection;
 import java.sql.ResultSet;
 import java.sql.SQLException;
 import java.sql.Statement;
 import org.apache.tools.ant.BuildException;
 import org.apache.tools.ant.taskdefs.JDBCTask;
 public class SQLExampleTask extends JDBCTask {
 private String tableName;
 public void execute() throws BuildException {
 Connection conn = getConnection();
 Statement stmt=null;
 try {
 if (tableName == null) {
 throw new BuildException("TableName must be specified",location);
 }
 String sql = "SELECT * FROM "+tableName;
 stmt= conn.createStatement();
 ResultSet rs = stmt.executeQuery(sql);
 while (rs.next()) {
 log(rs.getObject(1).toString());
 }
 } catch (SQLException e) {
 } finally {
 if (stmt != null) {
 try {stmt.close();}catch (SQLException ingore) {}
 }
 if (conn != null) {
 try {conn.close();}catch (SQLException ingore) {}
 }
 }
 }
 public void setTableName(String tableName) {
 this.tableName = tableName;
 }
 }