步驟如下:
一、下載SQLSERVER2000的jdbc驅動程序并安裝。在微軟站點就有這個驅動程序:http://msdn.microsoft.com/downloads/default.asp?URL=/downloads/sample.asp?url=/msdn-files/027/001/779/msdncompositedoc.xml&FinishURL=%2Fdownloads%2Frelease%2Easp%3FReleaseID%3D38312%26area%3Dsearch%26ordinal%3D1%26redirect%3Dno
二、啟動JBuilder6.0。打開Tools-->Enterprise Setup-->DataBase Drivers-->Add--> New,然后命名"Microsoft SqlServer JDBC Driver",選擇sqlserver2000--jdbc驅動的安裝路徑,加入三個jar文件(在安裝目錄的lib下面)。確定。
三、新建project,然后在project的屬性中,選擇Paths-->Required Libraries,添加"Microsoft SqlServer JDBC Driver"。
四、在程序上面添加:
import com.microsoft.*;? // 加載類庫
下面是我調試的一段代碼,供參考:
? void jButton1_actionPerformed(ActionEvent e) {
??? try{
????? Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
????? Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;User=sa;Password=;DatabaseName=maxwell");
????? Statement stmt=conn.createStatement();
????? String sql="select * from employee";
????? ResultSet rs = stmt.executeQuery(sql);
????? while(rs.next())
????? {
??????? JOptionPane.showMessageDialog(null,rs.getString("name"),"員工名稱",JOptionPane.YES_OPTION+JOptionPane.INFORMATION_MESSAGE );
????? }
???? }
??? catch(Exception ex)
??? {
????? System.err.println(ex.getMessage());
??? }
一、下載SQLSERVER2000的jdbc驅動程序并安裝。在微軟站點就有這個驅動程序:http://msdn.microsoft.com/downloads/default.asp?URL=/downloads/sample.asp?url=/msdn-files/027/001/779/msdncompositedoc.xml&FinishURL=%2Fdownloads%2Frelease%2Easp%3FReleaseID%3D38312%26area%3Dsearch%26ordinal%3D1%26redirect%3Dno
二、啟動JBuilder6.0。打開Tools-->Enterprise Setup-->DataBase Drivers-->Add--> New,然后命名"Microsoft SqlServer JDBC Driver",選擇sqlserver2000--jdbc驅動的安裝路徑,加入三個jar文件(在安裝目錄的lib下面)。確定。
三、新建project,然后在project的屬性中,選擇Paths-->Required Libraries,添加"Microsoft SqlServer JDBC Driver"。
四、在程序上面添加:
import com.microsoft.*;? // 加載類庫
下面是我調試的一段代碼,供參考:
? void jButton1_actionPerformed(ActionEvent e) {
??? try{
????? Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
????? Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;User=sa;Password=;DatabaseName=maxwell");
????? Statement stmt=conn.createStatement();
????? String sql="select * from employee";
????? ResultSet rs = stmt.executeQuery(sql);
????? while(rs.next())
????? {
??????? JOptionPane.showMessageDialog(null,rs.getString("name"),"員工名稱",JOptionPane.YES_OPTION+JOptionPane.INFORMATION_MESSAGE );
????? }
???? }
??? catch(Exception ex)
??? {
????? System.err.println(ex.getMessage());
??? }