java连接sql2000_Java连接Sql server 2000示例

import java.sql.*;

public class SqlConnectionTest

{

private static String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

// private static String dbURL="jdbc:odbc:sqlTest"; //数据源连接方式 DSN：sqlTest

private static String dbURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";

private static Connection dbConn = null;

/**

* @param args

*/

public static void main(String[] args)

{

try

{

Class.forName(driverName);

dbConn = DriverManager.getConnection(dbURL,"sa","");

Statement sql = dbConn.createStatement();

ResultSet set = sql.executeQuery("select * from jobs");

while(set.next())

{

System.out.println(set.getString("job_id")+"\t"+

set.getString("job_desc"));

}

System.out.println("Success");

dbConn.close();

} catch (ClassNotFoundException e)

{

e.printStackTrace();

} catch (SQLException e)

{

e.printStackTrace();

}

}

}