G
gbattine
Hi guys,
i'm a new JSF user and i have a big problem with my application,i hope
you help me.
I'm developing a JSF application that allow user to upload a txt file
in a standard format.
As columns and rows number are variable ,i've developed a simple java
application that counts them.
The first row of the txt file is like
string string string......................string
The second row is like
string double double.................double
the third row is like
string double double....................double
etc...that is the first row has a format and the others another one.
My purpouse is to store this file,that contains the results of some
experiments, in a blob field of a mysql database.
Then i have to store this txt file in a byte array to put it in the
blob.
The problem is i have to execute some queries on this database in a
second moment,so i have to rebuild original format of the file to
execute the query.
How can i do it?
I've begun developing a java class that receive in input the uploaded
file and counts row and columns number.
I know that storing row with different data types needs an object use,
so i have a lot of solutions.
I've selected Map solution that i post below, but my problem is that my
soluction works only from the second line, because the first has a
different format.
My questions are:
1) How can i integrate code for first row?
I've used an array of double,but my first row contains only string.
I need to create another object?How?
2) How can i convert my new HashMap into an array of byte with a known
format?
I've used Map solution because the first column will be the primary key
of the database.
My code is
public String processMyFile() throws IOException {
BufferedReader br = new BufferedReader(new
InputStreamReader(myFile.getInputStream()));
String line = null;
while ((line = br.readLine()) != null) {
line = line.replace (',', '.');
row++;
// Create a tokenizer for the line.
StringTokenizer st = new StringTokenizer(line);
// Assuming that the first column of every row is a String
and
//the remaining columns are numbers, count the number of
numeric columns.
numberOfNumericColumns = (st.countTokens()-1);
col=(numberOfNumericColumns+1);
// Get the first token from the line. It will be a String
and
//its value will be a unique key for the rest of the row.
this.dataMap = new HashMap<String, double[]>();
// Store each line of the input file as a separate key and
entry in the Map.
String key = st.nextToken().trim();
// Create the array for the numbers which make up the rest
of the line.
double[] array = new double[numberOfNumericColumns];
// Populate the array by parsing the rest of the line.
for (int column = 0; column < numberOfNumericColumns;
column++){
array[column] =
Double.parseDouble(st.nextToken().trim());
}
// Store the first column as the key and the array as the
entry.
this.dataMap.put(key, array); //Associates the specified
value with
//the specified key in this map.
}
return "success";
}
i'm a new JSF user and i have a big problem with my application,i hope
you help me.
I'm developing a JSF application that allow user to upload a txt file
in a standard format.
As columns and rows number are variable ,i've developed a simple java
application that counts them.
The first row of the txt file is like
string string string......................string
The second row is like
string double double.................double
the third row is like
string double double....................double
etc...that is the first row has a format and the others another one.
My purpouse is to store this file,that contains the results of some
experiments, in a blob field of a mysql database.
Then i have to store this txt file in a byte array to put it in the
blob.
The problem is i have to execute some queries on this database in a
second moment,so i have to rebuild original format of the file to
execute the query.
How can i do it?
I've begun developing a java class that receive in input the uploaded
file and counts row and columns number.
I know that storing row with different data types needs an object use,
so i have a lot of solutions.
I've selected Map solution that i post below, but my problem is that my
soluction works only from the second line, because the first has a
different format.
My questions are:
1) How can i integrate code for first row?
I've used an array of double,but my first row contains only string.
I need to create another object?How?
2) How can i convert my new HashMap into an array of byte with a known
format?
I've used Map solution because the first column will be the primary key
of the database.
My code is
public String processMyFile() throws IOException {
BufferedReader br = new BufferedReader(new
InputStreamReader(myFile.getInputStream()));
String line = null;
while ((line = br.readLine()) != null) {
line = line.replace (',', '.');
row++;
// Create a tokenizer for the line.
StringTokenizer st = new StringTokenizer(line);
// Assuming that the first column of every row is a String
and
//the remaining columns are numbers, count the number of
numeric columns.
numberOfNumericColumns = (st.countTokens()-1);
col=(numberOfNumericColumns+1);
// Get the first token from the line. It will be a String
and
//its value will be a unique key for the rest of the row.
this.dataMap = new HashMap<String, double[]>();
// Store each line of the input file as a separate key and
entry in the Map.
String key = st.nextToken().trim();
// Create the array for the numbers which make up the rest
of the line.
double[] array = new double[numberOfNumericColumns];
// Populate the array by parsing the rest of the line.
for (int column = 0; column < numberOfNumericColumns;
column++){
array[column] =
Double.parseDouble(st.nextToken().trim());
}
// Store the first column as the key and the array as the
entry.
this.dataMap.put(key, array); //Associates the specified
value with
//the specified key in this map.
}
return "success";
}