/*ODBC使用步驟：(ODBC數(shù)據(jù)源由微軟平臺提供)
?* 1、配置ODBC數(shù)據(jù)源(控制面板->管理工具->ODBC數(shù)據(jù)源)
?* 2、加載并注冊驅動程序,導入java.sql.*包
?* 3、創(chuàng)建連接對象
?* 4、創(chuàng)建執(zhí)行命令對象
?* 5、執(zhí)行sql語句
?* 6、獲取執(zhí)行sql語句后的結果，進行相關操作
?* 7、關閉資源
?*/
public class ODBC_Demo {

?//ODBC連接SqlServer
//?public static void main(String[] args) {
//??try {
//???//加載并注冊驅動程序
//???Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//??} catch (ClassNotFoundException e) {
//???e.printStackTrace();
//??}
//??String sql = "select * from stuinfo";
//??Connection conn = null;
//??Statement stm = null;
//??try {
//???//創(chuàng)建連接對象
//???conn = DriverManager.getConnection("jdbc:odbc:mysqlserver","sa","sasa");
//???//創(chuàng)建執(zhí)行命令對象
//???stm = conn.createStatement();
//???//執(zhí)行sql語句
//???ResultSet rs = stm.executeQuery(sql);
//???//獲取執(zhí)行sql語句后的結果，進行相關操作
//???//遍歷ResultSet
//???while(rs.next()){
//????System.out.println(rs.getInt("stuNum"));//使用列名獲取單元格中的信息
//????System.out.println(rs.getString(2));//使用列序號獲取單元格中的信息，注意：列序號從1開始
//????System.out.println(rs.getInt("stuAge"));
//???}
//??} catch (SQLException e) {
//???// TODO Auto-generated catch block
//???e.printStackTrace();
//??}finally{
//???try {
//????//關閉資源
//????if(stm!=null){
//?????stm.close();
//????}
//????if(conn!=null){
//?????conn.close();
//????}????
//???} catch (SQLException e) {
//????// TODO Auto-generated catch block
//????e.printStackTrace();
//???}
//??}
//?}

}

?

ODBC操作數(shù)據(jù)庫