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

?//ODBC連接SqlServer
//?public static void main(String[] args) {
//??try {
//???//加載并注冊(cè)驅(qū)動(dòng)程序
//???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)建連接對(duì)象
//???conn = DriverManager.getConnection("jdbc:odbc:mysqlserver","sa","sasa");
//???//創(chuàng)建執(zhí)行命令對(duì)象
//???stm = conn.createStatement();
//???//執(zhí)行sql語(yǔ)句
//???ResultSet rs = stm.executeQuery(sql);
//???//獲取執(zhí)行sql語(yǔ)句后的結(jié)果，進(jìn)行相關(guān)操作
//???//遍歷ResultSet
//???while(rs.next()){
//????System.out.println(rs.getInt("stuNum"));//使用列名獲取單元格中的信息
//????System.out.println(rs.getString(2));//使用列序號(hào)獲取單元格中的信息，注意：列序號(hào)從1開(kāi)始
//????System.out.println(rs.getInt("stuAge"));
//???}
//??} catch (SQLException e) {
//???// TODO Auto-generated catch block
//???e.printStackTrace();
//??}finally{
//???try {
//????//關(guān)閉資源
//????if(stm!=null){
//?????stm.close();
//????}
//????if(conn!=null){
//?????conn.close();
//????}????
//???} catch (SQLException e) {
//????// TODO Auto-generated catch block
//????e.printStackTrace();
//???}
//??}
//?}

}

?

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