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
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