hello friends

can anybody let me know taht how to insert data in table through jdbc. I have tried for this but it is not working ..

Statement st = dbConnection.executeStatement("INSERT INTO tab (capital) VALUES (2000)");

thanks

HumaMunir

__________________
HumaMunir

Hi,

Try this...

Statement stmt = dbConnection.createStatement();
stmt.executeUpdate("INSERT INTO tab (capital) VALUES (2000)");

In case this doesn't work, I am interested in the error message you are receiving. Also, mention the Database you are working with.

eNJay.

hello
thx for the help but its still not working ..
..i have not used any specific database its just for trial, only with student names.
.. i am sure i am doing any silly mistake, well check this out :)

import java.sql.*;

public class Accounts
{
    public static void main(String[] args)
    {
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String source = "jdbc:odbc:database";
            Connection dbConnection = DriverManager.getConnection(source);

            Statement stmt = dbConnection.createStatement();
            stmt.executeUpdate("INSERT INTO name (students) VALUES (zia)");



         }
        catch(ClassNotFoundException cnfe)
        {
            System.err.println(cnfe);

        }
        catch(SQLException sqle)
        {
            System.err.println(sqle);

        }

    }
}

and here is the exception when i run the program.
 java.sql.SQLEXCEPTION: [MICROSOFT][ODBC MICROSOFT ACCESS DRIVER] Too few parameters. Expected 1.

regards

HumaMunir

hello friends

i have found that the string for update the database in my program should be written in inverted commas i.e
stmt.executeUpdate("INSERT INTO name " + "VALUES ('1','Abdul Allah')");
 may be that was the problem with my program bc now it is running without any error or exception but still there is no change in database and no item is added.

i donot know why please help me in this matter

thanking in advance

regards

HumaMunir