Tuesday, 1 January 2013

JDBC Program 2

import java.sql.*;
import java.io.*;

public class jdbc1 {
    public static  void main(String[] args)
    {
        Connection c=null;
        Statement s;
        ResultSet r;
        String sql;
       
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            c=DriverManager.getConnection("jdbc:odbc:stud");
           
               
        s=c.createStatement();
            r=s.executeQuery("select * from student");
            while(r.next())
            {
                System.out.println(r.getString(1)+" "+r.getString(2));
            }
            r.close();   
           
        }catch(Exception e)
       
        {
        }
        finally{
            try{c.close();}catch(Exception e){}
        }
    }
}

No comments:

Post a Comment