本程序需要建立一個ODBC，名為“Northwind”的系統(tǒng)DSN，連接到SQL Server的Northwind數(shù)據(jù)庫，
并查詢Employees表中所有員工的姓名，程序如下：
package db2mssql;
import java.sql.*;
public class Main
{
public static void main(String args[])
{
Connection con;
Statement sql; //聲明Statement對象
ResultSet rs;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
System.out.println(""+e);
}
try
{
con=DriverManager.getConnection("jdbc:odbc:Northwind","sa","sa");
sql=con.createStatement();
rs=sql.executeQuery("Select FirstName, LastName FROM Employees");
int i=0;
while(rs.next())
{
String FirstName=rs.getString(1); //獲得數(shù)據(jù)庫第一列
String LastName=rs.getString(2);
System.out.println("Name" + i++ +": "+ FirstName + " " + LastName); //輸出信息
}
con.close();
}
catch(SQLException el){}
}
}