Hi Friend,

Try the following code:

import java.sql.*;
import java.util.*;
public class Example1{
public static void main(String[]args){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:access");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("Select * from Student where Course='BCA' and Class='1'");
Statement st1=con.createStatement();
while(rs.next()){
String roll=rs.getString(1);
String name=rs.getString(2);
String add=rs.getString(3);
String age=rs.getString(4);
String course=rs.getString(5);
String cla=rs.getString(6);
String sex=rs.getString(7);
String hostel=rs.getString(8);
System.out.println("insert into Del(Roll,Name,Add,Age,Course,Class,Sex,Hostel) values('"+roll+"','"+name+"','"+add+"','"+age+"','"+course+"','"+cla+"','"+sex+"','"+hostel+"')");
st1.executeUpdate("insert into Del(Roll,Name,Add,Age,Course,Class,Sex,Hostel) values('"+roll+"','"+name+"','"+add+"','"+age+"','"+course+"','"+cla+"','"+sex+"','"+hostel+"')");
}
}
catch(Exception e){
System.out.println(e);
e.printStackTrace();
}
}
}

Thanks