Inserting into a table

[Shaan patil]

I have a table name with table name = account , And The account table has four fields namely, account number,accountname,password,balance.
I am interested in inserting only first three fileds.using the following snippet of the code.


Code snippet to insert into fisrt three fields.

PreparedStatement pst=con.prepareStatement("insert into bank values(?,?,?)");
pst.setInt(1,i);
pst.setString(2,strNme);
pst.setString(3,strPwd);
pst.execute();

But I am getting SQL exception error.What is the workaround solution for the same ?

Regards

[Paul Sturrock]

pst.execute();

try executeUpdate() instead. This may not do it, but without knowing what your SQLException says I can't suggest much more.

[Shaan patil]

Hi,

The error says that insufficient value are provided.


Regards

[kkk guptha]

Hi,

You can get the result with pst.executeUpdate(); instead of pst.execute();

--- KKKGuptha

[Shilpa Tendulkar]

Originally posted by Shaan patil:

PreparedStatement pst=con.prepareStatement("insert into bank values(?,?,?)");
Regards

Try insert query as "insert into bank (accountnumber,accountname,password)
values(?,?,?)