Using File Reader

[simdan42]

How can I use file reader to read a file line by line and delimited by "|" into variables in the program?

 

[smilyface]

You can develop your own class that extends the any reader class and then override the methods that you wnat to use.
But u will have to develop your own class.

 

[FredrikN]

Lets say your file looks like this

a|aa|aaa
b|bb|bbb
c|cc|ccc

then the output will be like

aaaaaa
bbbbbb
cccccc

or was it something else you wanted ?


import java.io.*;
import java.util.*;

public class Driver
{
public static void main(String[] arg) throws IOException
{

StringBuffer data = new StringBuffer();

BufferedReader reader = new BufferedReader(new FileReader(new File("data.txt&quot));

String tmp = reader.readLine();

while(tmp != null)
{
StringTokenizer strTok = new StringTokenizer(tmp,"|"

//Saving the data into the StringBuffer
//You don't have to do this, it dependes
//on what you want to to with your data
while(strTok.hasMoreTokens())
{
data.append(strTok.nextToken());
}
data.append("\n"
tmp = reader.readLine();
}

//Print the result
System.out.print(data);

}

}Ø

 

[simdan42]

This is what I have but it is not reading the file. If I hard code a value for tmp it works perfectly!

public void TextToDB() throws Exception
{
//Create text file objects.


String ProductId_Hold;
String ProductDesc_Hold;
String QtyOnHand_Hold;
String QtyOrd_Hold;
String ExtPrice_Hold;
String UnitPrice_Hold;


ProductId_Hold = "";
ProductDesc_Hold= "";
QtyOnHand_Hold= "";
QtyOrd_Hold= "";
ExtPrice_Hold= "";
UnitPrice_Hold= "";

lblMessage.setText("Before Try"

try
{

StringBuffer data = new StringBuffer();


BufferedReader reader = new BufferedReader(new FileReader(new File("DBFile.dat&quot));

String tmp = reader.readLine();

while(tmp != null)
{

lblMessage.setText("1St While"

StringTokenizer strTok = new StringTokenizer(tmp,"|"

//Saving the data into the StringBuffer
//You don't have to do this, it dependes
//on what you want to to with your data
while(strTok.hasMoreTokens())
{
lblMessage.setText("2nd While"

ProductId_Hold = strTok.nextToken();
ProductDesc_Hold= strTok.nextToken();
QtyOnHand_Hold= strTok.nextToken();
QtyOrd_Hold= strTok.nextToken();
UnitPrice_Hold= strTok.nextToken();
ExtPrice_Hold= strTok.nextToken();

cmdProduct.executeUpdate("Insert Into Product "
+ "([ProductID], [ProductDesc], [QtyOnHand], [QtyOrd], [UnitPrice], [extPrice] ) "
+ "Values('"
+ ProductId_Hold + "', '"
+ ProductDesc_Hold + "', '"
+ QtyOnHand_Hold + "', '"
+ QtyOrd_Hold + "', '"
+ UnitPrice_Hold + "', '"
+ ExtPrice_Hold + "')"

//Add to name list
lblMessage.setText("Import Sucessful"
}
tmp = reader.readLine();
lblMessage.setText("TMP"
}


}

catch(SQLException error)
{
lblMessage.setText("Error during Edit. " + "Error: " + error.toString());
}

catch(Exception error)
{
lblMessage.setText("Error during Edit. " + "Error: " + error.toString());
}

}

 

[palbano]

So what is the difference between the two values of tmp when you hard code it and when you use readLine()?

-pete

 

[FredrikN]

Well simdan42.

Do you get any errors or something ?

 

[simdan42]

No errors, It is as thought it is not reading from the file. I put a line of code in there to display the value of tmp, but it was null.

 

[simdan42]

OK Guys, and Girls I got it.

I had

BufferedReader reader = new BufferedReader(new FileReader(new File("DBFile.dat&quot));

And changed it to

BufferedReader reader = new BufferedReader(new FileReader(new File("C:\\DBFile.dat&quot));

And It worked! Thank you for all your help!!