hello friends

can anybody let me know that how to insert the data into the table.I have tried for this but it is not working...

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

thanks

HumaMunir

__________________
HumaMunir

Is your column type? Is it a number or is it string type? If it is string tupe you have to wrap the value with ''. Example '2000'

John Dirk
Programming Consulant
http://www.programminghelp4u.com - Programming (Assignment/Project) Help

thx for the idea but its still not working. the program runs well but it does not show any change in database.

here is my program plz check it out and tell me what mistake i am doing here.

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 ('Abdul Allah')");




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

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

        }

    }
}

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

HumaMunir

you use try....catch block for error and try to get more error message.




Gokulan Ethiraj

Use PreparedStatement.

That will automatically do the conversions internally.
That's the power of JDBC.

you could try this:
 ...
String sql="insert into name (students)"+"values('"+Allah+"')";
int result=stmt.Update(sql);
if it success result returns 1.

thanks :)

HumaMunir

hello ,

 try this

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:userDSN name","scott","tiger");
Statement st=con.createStatement();


Here Dsn name: go to CONTROL Panel and open ADMINISTRATIVE TOOLS
and then open DATA SOURCE(ODBC).
 it opens a window,in that 7 tabs are there.
chose userDSN(Default it open).
and PRESS the ADD button.it shows the some default and inistalled Database choose (ORACLE database)then click Finish.
 and it asks the name(dsn )then ok.


int n=st.ececuteUpdate("insert into tabs"+"values('"+name+"')");

do this
.

Thanks for giving me such a great detailed reply. well the problem has solved already but i must oblige for your help.

Thanks once again

Take care

HumaMunir