Delete a row in Ms Access using java.

August 29, 2010 at 21:48:10
Specs: Windows XP
How to delete a row of a table in Ms Access which contains JTextFields, JComboboxes etc..
We have to delete it using java connectivity.

I mentioned :
try
{
String s;
s=tmid.getText();
//Here tmid is JTextField which contains mid i.e. member id. I've made it primary key in table.

String qry="Delete from sport where Mid = "+s+" ";
//sport is the name of my table.

smt.executeUpdate(qry);
}
catch(SQLException e)
{
System.out.println(e);
}


When I run this program it gives a SQLException and says "too few parameteres.".
I took tmid as String .


Plz help me.


See More: Delete a row in Ms Access using java.

Report •

#1
September 1, 2010 at 13:38:58

Report •
Related Solutions


Ask Question