java中sql server连接问题

wanlili517 2006-04-13 09:02:20

我下载了jdbc驱动程序，可是写下如下代码，总说我找不到驱动程序。请各位高手帮帮忙哦！！十分感谢！！！
import java.sql.*;

public class database {

/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub

try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String user = "wl";
String password = "wl";
Connection conn = DriverManager.getConnection(url, user, password);
user=sa&password=hbkj";
Statement sqlStatement = conn.createStatement();
String sql = "select job_id,job_desc from jobs";
ResultSet results = sqlStatement.executeQuery(sql);
while (results.next()) {
String resultDisplay = " ";
resultDisplay = resultDisplay + results.getString("job_id");
resultDisplay = resultDisplay + ","+ results.getString("job_desc");
resultDisplay = resultDisplay + "\n";
System.out.println(resultDisplay);
}
conn.close();
}
catch(ClassNotFoundException e){
System.out.println("找不到驱动程序");
}catch (SQLException e) {
} catch (Exception e) { }

}

...全文