import java.sql.*;

public class test
{
   public static void main(String[] args) throws Exception
   {
      String URL = "jdbc:mysql://localhost/test3";
      String USER = "root";
      String PASS = "";
      String DRIVER = "com.mysql.jdbc.Driver";

      DriverManager.registerDriver((Driver) Class.forName(DRIVER).newInstance());
      
      Connection con = DriverManager.getConnection(URL, USER, PASS);      

      PreparedStatement ST = con.prepareStatement(
        "SELECT T0.instrument AS F0, T0.sentToInstrument AS F1, T0.releasedToInstrument AS F3, T0.dilution AS F2, T0.position AS F4, T0.workOrderReleaseList AS F6, T0.instrumentReplyRecipientId AS F5, T0.sampleAnalysisId AS F7, T0.id AS F8, T0.version AS F9, T0.instrumentTest AS F10, T0.workOrder AS F11, T0.standingOrder AS F12, T0.measurementReceived AS F13, T0.activated AS F15, T0.priority AS F14 " +
        "FROM SampleAnalysis T0 "+
        "LEFT OUTER JOIN WorkOrder T1 ON T0.workOrder=T1.id "+
        "LEFT OUTER JOIN Instrument T2 ON T1.instrument=T2.id "+
        "LEFT OUTER JOIN Sample T3 ON T1.sample=T3.id "+
        "WHERE ( ( ( ( T0.standingOrder = ? ) AND (  1=1) ) AND ( T0.releasedToInstrument = ?) ) AND ( T3.sampleCollectionDateTime >= ?) ) AND ( T3.sampleCollectionDateTime <= ?)");

      ST.setBoolean(1,false);
      ST.setBoolean(2,false);
      ST.setString(3,"2005-06-20 00:00:00.0");
      ST.setString(4,"2005-06-30 00:01:00.0");
      
      ResultSet rs = ST.executeQuery();;
      while (rs.next())
      {
        System.out.print(rs.getInt(1)); 
        System.out.print(" "+rs.getInt(2)); 
        System.out.print(" "+rs.getInt(3)); 
        System.out.print(" "+rs.getFloat(4)); 
        System.out.print(" "+rs.getString(5)); 
        System.out.print(" "+rs.getString(6)); 
        System.out.print(" "+rs.getInt(7)); 
        System.out.print(" "+rs.getInt(8)); 
        System.out.print(" "+rs.getInt(9)); 
        System.out.print(" "+rs.getInt(10)); 
        System.out.print(" "+rs.getString(11)); 
        System.out.print(" "+rs.getInt(12)); 
        System.out.print(" "+rs.getInt(13)); 
        System.out.print(" "+rs.getInt(14)); 
        System.out.print(" "+rs.getInt(15)); 
        System.out.print(" "+rs.getString(16)); 
        System.out.println(""); 
      }

      ST.close();
      con.close();
   }
}