package com.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class TestOdbc {

	public static void main(String[] args) throws Exception {
		new TestOdbc().test();
	}
	
	private void test() throws Exception{
		 Connection conn = null;
		 PreparedStatement pstmt = null;
		 ResultSet rs = null;
		 try {
			 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			 conn = DriverManager.getConnection("jdbc:odbc:testSql", "sa", "dingjiansoft");
			 pstmt = conn.prepareStatement("SELECT * from bbs.course");
			 rs = pstmt.executeQuery();
			 while(rs.next()){
				 System.out.println(rs.getString(2));
			 }
		 } finally {
			 if(rs != null){
				 try {
					rs.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				 rs = null;
			 }
			 
			 if(pstmt != null){
				 try {
					pstmt.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				 pstmt = null;
			 }
			 
			 if(conn != null){
				 try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				 conn = null;
			 }
		 }
	}
}