import java.*;
import java.sql.*;
import java.util.*;
import com.ms.jdbc.odbc.JdbcOdbcDriver;
public class Connect{
private java.sql.Connection con = null;
private ResultSet rs;
// Constructor:
public Connect(){}
private void FindEmployee() throws SQLException, ClassNotFoundException
{
try
{
Class.forName("com.ms.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:JDBCdsn";
con = DriverManager.getConnection(url, "", "");
Statement stmt = con.createStatement();
rs = stmt.executeQuery("Select EmployeeID, LastName, Title from Employees");
while (rs.next())
{
//Column names:
System.out.println(rs.getInt("EmployeeID") + " " + rs.getString("LastName") + " " + rs.getString("Title"));
}
if(con != null)
con.close();
con = null;
}
catch (SQLException ex)
{
throw ex;
}
catch (ClassNotFoundException clex)
{
throw clex;
}
}
private void closeConnection(){
try{
if(con != null)
con.close();
con = null;
}catch(Exception ex){
ex.printStackTrace();
}
}
public static void main(String[] args) throws Exception
{
Connect myDbTest = new Connect();
try
{
myDbTest.FindEmployee();
}
catch (Exception ex)
{
ex.printStackTrace();
System.out.println("Error Trace in getConnection() : " + ex.getMessage());
}
}
}
Sunday, May 4, 2014
Use of JDBC:ODBC in JAVA
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment