Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //Registering driver type
Connection con=DriverManager.getConnection("jdbc:odbc:proj"); // Assigning drivermanager
con.setAutoCommit(true);
//String str="insert into dovetail values('"+id+"','"+a+"','"+b+"','"+res+"')";
String str="insert into dovetail values('ASDF','Raj','1234','198')";
Statement stmt=con.createStatement(); // creating statement object
int ret=stmt.executeUpdate(str);
System.out.println(ret);
if(ret==0)
{
System.out.println("Not Inserted");
}
else
{
System.out.println("Data Inserted Successfully");
}
/*str="select * from dovetail";
ResultSet resl=stmt.executeQuery(str);
boolean val=resl.next();
while(val)
{
//System.out.println(resl.getString(1));
val=resl.next();
}*/
System.out.println("Completed");
the following i used to update the ms-access. when i try to insert its not getting update but when i remove the commented code i,e when i retrieve the data it is getting updated.. can any one help me out.....