out of range

[D Ravi Kumar]

package com.izmocars.inventory.homenet;
 
import java.io.File;
import java.io.FileReader;
import java.io.BufferedReader;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
 
public class Test {
static IzmoStageConnection izmoStageConnection = new IzmoStageConnection();
static String dealerid, location, certified, stock, type, year, make, model, body, exteriorcolor,
interiorcolor, enginecylinders, enginedisplacement, trim, doors, transmission, vin, sellingprice,
msrp, miles, comment1, comment2, dateinstock, options, imageurl;
public static void main(String args[])throws Exception {
Connection connection;
PreparedStatement statement;
ArrayList v =  null;
try{
connection = izmoStageConnection.getDataBaseConnection();
statement = connection.prepareStatement("delete from izmostaging.izmomedia_homenetfeed");
statement.executeUpdate();

File filename = new File("E:\\Homenet\\homenet.txt");
System.out.println("filename:::::>>>>"+filename.exists());

BufferedReader in = new BufferedReader( new FileReader(filename));
String line = null;
int count = 0;
while ( (line = in.readLine()) != null ) 
{
if( count != 0)
{
String[] source = line.split("\t");
List l = Arrays.asList(source);
v =  new ArrayList(l);
for(int i = v.size(); i <= 24; i++ )
v.add("");
dealerid = (v.get(0) != null && !v.get(0).toString().equals(""))? v.get(0).toString():"";
location = v.get(1).toString();
certified = v.get(2).toString();
stock = v.get(3).toString();
type = v.get(4).toString();
year = v.get(5).toString();
make = v.get(6).toString();
model = v.get(7).toString();
body = v.get(8).toString();
exteriorcolor = v.get(9).toString();
interiorcolor = v.get(10).toString();
enginecylinders = v.get(11).toString();
enginedisplacement = v.get(12).toString();
trim = v.get(13).toString();
doors = v.get(14).toString();
transmission = v.get(15).toString();
vin = v.get(16).toString();
sellingprice = v.get(17).toString();
msrp = v.get(18).toString();
miles = v.get(19).toString();
comment1 = v.get(20).toString();
comment2= v.get(21).toString();
dateinstock = v.get(22).toString();
options = v.get(23).toString();
imageurl = v.get(24).toString();


String query = "insert into izmostaging.izmomedia_homenetfeed(dealerid,location,certified,stock,
type,year,make,model,body,exteriorcolor,interiorcolor,enginecylinders,enginedisplacement,
trim,doors,transmission,vin,sellingprice,msrp,miles,comment1,comment2,dateinstock,options,imageurl)"+
"values('?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?')";
statement = connection.prepareStatement(query);
statement.setString(1, dealerid);
statement.setString(2, location);
statement.setString(3, certified);
statement.setString(4, stock);
statement.setString(5, type);
statement.setString(6, year);
statement.setString(7, make);
statement.setString(8, model);
statement.setString(9, body);
statement.setString(10, exteriorcolor);
statement.setString(11, interiorcolor);
statement.setString(12, enginecylinders);
statement.setString(13, enginedisplacement);
statement.setString(14, trim);
statement.setString(15, doors);
statement.setString(16, transmission);
statement.setString(17, vin);
statement.setString(18, sellingprice);
statement.setString(19, msrp);
statement.setString(20, miles);
statement.setString(21, comment1);
statement.setString(22, comment2);
statement.setString(23, dateinstock);
statement.setString(24, options);
statement.setString(25, imageurl);
statement.executeUpdate(query);
System.out.println("Records are Inserted::::"); 
}
count++;
}
in.close();
}catch(Exception e){
e.printStackTrace();
}

}
 
}
 

i got the these error


filename:::::>>>>true
java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:2085)
at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:1182)
at com.izmocars.inventory.homenet.Test.main(Test.java:69)


give me solution

Regards
Ravi Kumar
[ December 11, 2008: Message edited by: Ulf Dittmer ]

[Ulf Dittmer]

Welcome to JavaRanch.

You need to remove the quotation marks from the parameters. JDBC will automatically add those where necessary.

In the future, please UseCodeTags when posting code of any length. As it was, the code was basically unreadable.

(As an aside, I think you meant to say "please give me a solution".)

[D Ravi Kumar]

Simply change the below statement

statement.executeUpdate();

your statement is
statement.executeUpdate(query);

remove the "query"