/**
* 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
}
}
}