MYSQL Problem

[nrip]

Dear All,

I am facing a very peculiar problem. I am reading a CSV file from my JSP code and trying to insert them into MYSQL database. the program first reads a line and then splits it into words using the split function and then inserts them into different fields of the database. But the problem is that the JSP [age shows that the records have been inserted but actually when we look into the database althugh the records have been inserted but they are empty that is without values.

This is the code that i have written


<%@ page import= "java.io.*" %>
<%@ page import="java.ut il.StringTokeni zer"%>
<%@ page import="java.ut il.*"%>
<%@ page import= "java.util.Date " %>
<%@ page import= "java.text.Date Format" %>
<%@ page import= "java.text.Simp leDateFormat" %>
<%@ page language="java" %>
<%@ page import="java.la ng.*"%>
<%@ page import="javax.s ervlet.*"%>
<%@ page import="javax.s ervlet.http.*"% >
<%@ page import= "java.io.File"% >
<%@ page import ="java.io.*" %>
<%@ page import ="java.awt.* "%>
<%@ page import ="java.awt.Comp onent.*"%>
<%@ page import ="java.awt.even t.*"%>
<%@ page import ="javax.swing.* "%>
<%@ page import ="java.sql.Resu ltSet.*"%>
<%@ page import ="java.sql.Stat ement"%>

<%@ page import="java.te xt.*,java.io.*, java.util.*,jav a.util.StringTo kenizer,java.io .BufferedReader ,java.io.FileRe ader,java.sql.* ,java.util.Stri ngTokenizer,jav a.io.BufferedRe ader,java.io.Fi leReader"%>

<%


File file = new File("C:\\Docum ents and Settings\\nripr aj.INFOBASE\\De sktop\\Earnings _110600_0_0_200 702.csv");
FileInputStream fis = null;
BufferedInputSt ream bis = null;
DataInputStream dis = null;

try {



fis = new FileInputStream (file);

// Here BufferedInputSt ream is added for fast reading.
bis = new BufferedInputSt ream(fis);
dis = new DataInputStream (bis);

// dis.available() returns 0 if the file does not have more lines.

while (dis.available( ) != 0) {

// this statement reads the line from the file and print it to
// the console.
String line = dis.readLine();
out.println("Da ta is:"+line);
//int n = line.indexOf("" ,0);
String token[];

token=line.spli t(" ");




DateFormat dateFormat = new SimpleDateForma t("yyyy-MM-dd");
Date curdate = new Date();


Class.forName(" org.gjt.mm.mysq l.Driver").newI nstance(); //driver for mysql database.


Connection con= null;

ResultSet rs = null;

con = DriverManager.g etConnection("j dbc:mysql://localhost/rptgenerator"," generator", "generator" );

String dt = dateFormat.form at(new Date());
String field1="";
String field2="";
String field3="";
String field4="";
String field5="";
String field6="";

for (int i=0;i<token.len gth;i++)
{
if (i==0)
{
field1=token[i] ;
out.println(fie ld1);
}
else if (i==1)
{
field2=token[i] ;
out.println(fie ld2);
}
else if (i==2)
{
field3=token[i] ;
out.println(fie ld3);
}
else if (i==3)
{
field4=token[i] ;
out.println(fie ld4);
}
else if (i==4)
{
field5=token[i] ;
out.println(fie ld5);
}
else if (i==5)
{
field6=token[i] ;
out.println(fie ld6);
}

}


String query = "insert into xyz values(?,?)";
PreparedStateme nt pstmt = con.prepareStat ement(query);
pstmt.setString (1, dt);
pstmt.setString (2, field1);
pstmt.setString (3, field2);
pstmt.setString (4, field3);
pstmt.setString (5, field4);
pstmt.setString (6, field5);
pstmt.setString (7, field6);*/
pstmt.setString (1, token[1]);
pstmt.setString (2, "Compare");

int l = pstmt.executeUp date();
out.println("Up dated Records:"+l);


%>
<br><br><br>
<%

}
out.println("In put Successful");
// dispose all the resources after using them.

fis.close();
bis.close();
dis.close();

} catch (FileNotFoundEx ception e) {
e.printStackTra ce();
} catch (IOException e) {
e.printStackTra ce();
}catch (Exception e) {

out.println(e);
e.printStackTra ce();
}

%>


Any help will be appreciated..



Thanks & Regards
Nrip Raj Jain