looking for advice on the next step of my project

[matpj]

Hi all,

I need to write a program in Java that will read from an Oracle database and write the results to a text file in a specified location.

I have managed to create a class that will connect to my database, read from a table and return the results to the NetBeans console.

import java.sql.*;
import java.io.*;


class SimpleOraJava {
  public static void main(String args[]) throws SQLException {
    DriverManager.registerDriver(
      new oracle.jdbc.driver.OracleDriver()
    );
    
    String serverName = "server";
    int port = 1521;
    String user = "niku";
    String password = "nottelling";
    String SID = "mindyourown";
    String URL = "jdbc:oracle:thin:@" + serverName + ":" + port + ":" + SID;
    
    Connection conn = DriverManager.getConnection(URL, user, password);
    String SQL = "SELECT DSTI_PROJ_REF, id FROM NIKU.ODF_CA_PROJECT";
    Statement stat = conn.createStatement();
    ResultSet rs = stat.executeQuery(SQL);
    while (rs.next()) {
      System.out.println(
       
        rs.getString(1) + "\t"
        + rs.getInt(2)

      );
    }
    stat.close();
    conn.close();
  }
}

I am very new to Java programming, so didn;t know the right way of doing things.
I'm not sure what different classes I need.
Do I write it all in one class (not sure when to seperare classes)

My next stage on the above is to write the results to a text file.
I have no idea how to do that, although I have included the java.io.* library into the above already.

Can anybody offer some advice about creating my 'program'. How do I know what bits to put in different classes? and how do I write to the text file (I am currently looping through the restults)

thanks in advance,
Matt

[xcallmejudasx]

BufferedWriter and FileWriter are the classes you want. These will allow you to write your output to a text file directly.

Also BufferedReader and FileReader will do the opposite in case you need to retrieve the information later.

[matpj]

Hi,
thanks for the response.
Do I just include these in the same class and do all coding in there?
i'm not sure of the 'right' way of coding in Java!