Insert data in to oracle table using netbeans

Question

I want to insert data into my oracle table using netbeans text fields and there is a problem with this code. When this screen execute it gives me an exception:

java.sql.SQLException:Invalid column index

Please help me as soon as possible.

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt)
{
    conn = javadb.ConnectDb();

    try{
        String sql = "insert into addbook (id, title, isbn, author)"
                + " values(null,'','','');";
        pst = (OraclePreparedStatement) conn.prepareStatement(sql);
        pst.setString(1, title.getText());
        pst.setString(2, isbn.getText());
        pst.setString(3, author.getText());
        rs = (OracleResultSet) pst.executeQuery();

    }catch(SQLException | HeadlessException e){
        JOptionPane.showMessageDialog(null, e);
    }
}

Because you are setting parameters, but have no placeholders in the values clause. Remove the literals and replace with ? — OldProgrammer
– OldProgrammer, Commented Dec 12, 2013 at 2:06

zain · Accepted Answer · 2018-05-04 02:41:12Z

1

conn = JavaDbCon.ConnecrDb();

try{
    String sql = "insert into Balance (ecode,ltype,rol,ldate) values(?,?,?,?)";" // there he show me error

    pst = (OraclePreparedStatement) conn.prepareStatement(sql);
    pst.setString(1,'NULL'); // also here
    pst.setString(2, ltype.getText());
    pst.setString(3, rol.getText());
    pst.setString(4, ldate.getText());
    rs = (OracleResultSet) pst.executeQuery();

}catch(SQLException | HeadlessException e){ // here also
    JOptionPane.showMessageDialog(null, e);
}

answered May 4, 2018 at 2:41

zain

111 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

zain Over a year ago

i coment on those lines where he show me errors plz reply as soon as possible

Aditya · Accepted Answer · 2013-12-12 04:00:47Z

0

This should work, try this.

   conn = javadb.ConnectDb();

        try{
            String sql = "insert into addbook (id, title, isbn, author) values(?,?,?,?)";
            pst = (OraclePreparedStatement) conn.prepareStatement(sql);

            pst.setString(1,'NULL');
            pst.setString(2, title.getText());
            pst.setString(3, isbn.getText());
            pst.setString(4, author.getText());
            rs = (OracleResultSet) pst.executeUpdate(sql);

        }catch(SQLException | HeadlessException e){
        JOptionPane.showMessageDialog(null, e);
        }
    }

answered Dec 12, 2013 at 4:00

Aditya

2,3198 gold badges40 silver badges58 bronze badges

4 Comments

ZIA JAPPA Over a year ago

I try this but it is giving me error on this line rs = (OracleResultSet) pst.executeUpdate(sql); Inconvertible types Required OracleResultSet found int

ZIA JAPPA Over a year ago

Hats off man. I was doing wrong by using semicolon at values(?,?,?,?);"; I pasted your code and problem has solved.

BillRobertson42 Over a year ago

You can probably just leave out the first setString if the id is automatically generated.

Aditya Over a year ago

@Bill, its just for understanding. Thanks.

Collectives™ on Stack Overflow

Insert data in to oracle table using netbeans

2 Answers 2

1 Comment

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related