1. Write a JAVA Program to insert data into Student DATA BASE and retrieve info based on particular queries (queries can be given which covers all the topics of 2nd UNIT).

1:  import java.sql.*;  
2:  public class prg1   
3:  {  
4:    public static void main(String[] args)   
5:    {  
6:     try  
7:     {   
8:      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
9:      Connection con=DriverManager.getConnection("jdbc:odbc:student_ds");  
10:      Statement st=con.createStatement();    
11:      String s1="insert into student_tab values('01REMCA05','Geetha')";  
12:      st.execute(s1);  
13:      System.out.println("RECORD INSERTED");      
14:      String s2="Update student_tab set student_name='John' where usn='01REMCA05'";  
15:      st.execute(s2);  
16:      System.out.println("RECORD UPDATED");   
17:      String s3="select * from student_tab";  
18:      ResultSet rs=st.executeQuery(s3);   
19:      while(rs.next())  
20:      {  
21:        System.out.println(rs.getString(1)+"\t"+rs.getString(2));  
22:      }  
23:     }catch(Exception e){System.out.println("Error "+e);}  
24:    }  
25:  }