Received: by 10.66.72.73 with SMTP id b9mr1294096pav.9.1349326054307; Wed, 03 Oct 2012 21:47:34 -0700 (PDT)
Received: by 10.68.212.99 with SMTP id nj3mr1909236pbc.20.1349326054293; Wed, 03 Oct 2012 21:47:34 -0700 (PDT)
Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!nntp.club.cc.cmu.edu!newsfeed.news.ucla.edu!usenet.stanford.edu!kr7no3836755pbb.0!news-out.google.com!t10ni23609125pbh.0!nntp.google.com!kt20no9058317pbb.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.lang.java.programmer
Date: Wed, 3 Oct 2012 21:47:34 -0700 (PDT)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=117.195.44.25; posting-account=kTEePAoAAACEMTLiFklf7VDluCvVE8iQ
NNTP-Posting-Host: 117.195.44.25
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <110ed4b2-e29a-4c6d-81df-3eee8e532a7c@googlegroups.com>
Subject: problem in inserting record in ms access.
From: Navnath Gadakh <navnathgadakh@gmail.com>
Injection-Date: Thu, 04 Oct 2012 04:47:34 +0000
Content-Type: text/plain; charset=ISO-8859-1
Xref: csiph.com comp.lang.java.programmer:19092


package javaapplication3;
import java.sql.*;

public class JavaApplication3 {
    Connection con;
    Statement st;
    ResultSet rs;
    
    public JavaApplication3()
    {
        connect();
    }
    
    public void connect()
    {
        try
        {
            String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
            Class.forName(driver);
            
            String db = "jdbc:odbc:db1";
            con = DriverManager.getConnection(db);
            st = con.createStatement();
            String sql = "select * from Table1";
            rs = st.executeQuery(sql);
            
            while(rs.next())
            {
                String fname = rs.getString("fname");
                String lname = rs.getString("lname");
                String address = rs.getString("address");
                String email = rs.getString("email");
                String mobile = rs.getString("mobile");
                
                System.out.println(fname+lname+address+email+mobile);
            }
            
        }catch(Exception ex)
        {
            
        }
        
        try
    {
            rs.moveToInsertRow();
            rs.updateString("fname","abc");
            rs.updateString("lname","xyz");
            rs.updateString("address","mubmai");
            rs.updateString("email","abc@gmail.com");
            rs.updateString("mobile","99854874154");
            rs.insertRow();
            
            st.close();
            rs.close();
        
    }
    catch(Exception err)
    {
        System.out.println("Error!!!");
    }
        
        
    }
    public static void main(String[] args) {
        // TODO code application logic here
        new JavaApplication3();
    }
}