gistfile1.java

public class ProductMain {
  public boolean executeMain(ResourceHolder resourceholder) {
    Log log = BCLogFactory.getLog(ProductMain.class);
    CommonPrinter commonPrinter = null;
    Statement statement = null;
    ResultSet resultSet = null;
    try {
      String outputileName = resourceHolder.getOutputFileName();
      commonPrinter = new CommonPrinter(outputFileName, "UTF-8");
      Connection connection = resourceHolder.getConnection();
      statement = connection.createStatement();
      resultSet = statement.executeQuery("Select SYA_NM From syainjhsample ");
      while(resultSet.next()){
        String syaNm = resultSet.getString(1);
        commonPrinter.writeLine(syaNm);
      }
    }
  }
}