1、解压下面的压缩包,将这些jar文件设置成classpath
2、使用下面的程序访问数据库:
import java.sql.*;
public class exec
{
public static void main(String[] args)
{
Connection con;
Statement stm;
ResultSet res;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Students","sa","");
//con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Students;user=sa;password=");//也可以
stm = con.createStatement();
res = stm.executeQuery("select * from stu");
while (res.next())
{
System.out.println(res.getString(1)); //begin at 1
}
con.close();
}
catch (Exception ex)
{
System.out.println(ex.getMessage());
}
}
}
[此贴子已经被作者于2010-12-12 08:20:45编辑过]