Saturday, August 22, 2015

jdbc program retrirving data from text file

jdbc program retrieving data from text file

// prg to read data from DB table
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;

public class TxtTest
{
    public static void main(String args[])throws Exception
    {
        Connection con=null;
        Statement st=null;
        ResultSet rs=null;
        try
        {
        DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
        System.out.println("Driver Loaded");
         con=DriverManager.getConnection("jdbc:odbc:txtdsn");
            System.out.println("connection established");
            st=con.createStatement();
            System.out.println("statement prepared");
            rs=st.executeQuery("select * from test.tab");
            System.out.println("query executed");
            while(rs.next())
            {
            System.out.print(rs.getString("SNO")+"\t");
            System.out.print(rs.getString(2)+"\t");
            System.out.print(rs.getString(3)+"\t\n");
            }//while

            System.out.println("Resultset is processed");
            rs.close();
            st.close();
            con.close();
        }//try
        catch(SQLException se)
        {
            se.printStackTrace();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
    }//main
}//class

No comments:

Post a Comment