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