Java連接Sqlserver

/**
 * AWT Sample application
 *
 * @author
 * @version 1.00 05/07/07
 */

import java.sql.*;
 
public class Demo {
  
  public static void main(String args[]) throws Exception
    {
 
       
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    
     Connection con=DriverManager.getConnection("jdbc:odbc:JavaTest","sa","888");//JavaTest為ODBC建立的連接名稱
     

     Statement st=con.createStatement();

        ResultSet result=st.executeQuery("SELECT ColA,ColB,ColC FROM TblName");
  
     while(result.next())
     {
 
       System.out.println(result.getString(1));//ColA

       System.out.println(result.getString(2));//ColB

       System.out.println(result.getString(3));//ColC
       } 
    
    }

 }