jdbc (JavaRanch forum at JavaRanch)

Sir
Here with i am sending the code in which i am trying to insert a record in the table "deep"(oracle 7.3), the dsn name is mukesh and the user name and password to access the database are also written,
the problem is i am unable to insert a record into it.
===========program==============================================

import java.awt.event.*;
import java.applet.*;
import java.awt.*;
import java.sql.*;
import java.applet.*;
import java.awt.event.*;
/*
< applet code="insertrecord.class" height=350 width=350>
< /applet code>
*/
public class insertrecord extends Applet implements ActionListener
{
        int s1;
        String s2;
        Label l1,l2;
        TextField eno,ename;
        Button b;
        public void init()
        {
                l1=new Label("Eno");
                add(l1);
                eno = new TextField(10);
                add(eno);                        
                l2=new Label("Ename");
                add(l2);
                ename = new TextField(10);
                add(ename);
                b = new Button("Save");
                add(b);
                b.addActionListener(this);
        }
        public void actionPerformed(ActionEvent ae)
        {
                if(ae.getSource()==b)
                {
                        try
                        {
                        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                        Connection con = DriverManager.getConnection("jdbc   :odbc:mukesh","scott","tiger");
                        Statement st = con.createStatement();
                        ResultSet rs;
                        s1=Integer.parseInt(eno.getText());
                        s2=ename.getText();
                        st.executeUpdate("insert into deep values(s1,s2)");
                        }catch(Exception e)
                        {
                                System.out.println("Error at "+e);
                        }
                }
        }
}

=======================end of program===========================

Mukesh Jain
(Marilyn inserted spaces so code appears and code tags to preserve indentation)

[This message has been edited by Marilyn deQueiroz (edited February 24, 2001).]

Perhaps if you put this in the JDBC forum you might get a better response.

Also you need to put spaces in your HTML tags so that the code displays instead of executing. You might want to turn smilies off or put a space in you code also.

I'm moving this to the jdbc forum.