Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.programmer > #19092

problem in inserting record in ms access.

Show all headers | View raw

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();
    }
}

Back to comp.lang.java.programmer | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

problem in inserting record in ms access. Navnath Gadakh <navnathgadakh@gmail.com> - 2012-10-03 21:47 -0700
  Re: problem in inserting record in ms access. Martin Gregorie <martin@address-in-sig.invalid> - 2012-10-04 19:39 +0000
  Re: problem in inserting record in ms access. Arne Vajhøj <arne@vajhoej.dk> - 2012-10-04 17:35 -0400
    Re: problem in inserting record in ms access. Martin Gregorie <martin@address-in-sig.invalid> - 2012-10-04 23:24 +0000
      Re: problem in inserting record in ms access. Arne Vajhøj <arne@vajhoej.dk> - 2012-10-05 20:27 -0400
        Re: problem in inserting record in ms access. Martin Gregorie <martin@address-in-sig.invalid> - 2012-10-06 11:36 +0000
          Re: problem in inserting record in ms access. Arne Vajhøj <arne@vajhoej.dk> - 2012-10-06 09:08 -0400
  Re: problem in inserting record in ms access. Roedy Green <see_website@mindprod.com.invalid> - 2012-10-04 20:33 -0700
    Re: problem in inserting record in ms access. Lew <lewbloch@gmail.com> - 2012-10-05 10:48 -0700

csiph-web