Developing SQL Server based Java Apps using NetBeans IDE

After completing all the steps in previous section, we need to add Microsoft SQL Server related JDBC drivers to our application.  This can be achieved with the following steps:

• Within the “Projects” view, right-click on “Libraries” and go to “Add Jar/Folder” (Fig 03).
  
  
  
• Move to your JDBC driver path (in my case, it is at “C:Program FilesMicrosoft SQL Server 2000 Driver for JDBClib”), and select all of the “.jar” files available (Fig 04).
  
  

  

  
  
• After selecting “.jar” files, click “open” and your “Projects” view should look something like the following (Fig 05).
  
  

Once you complete all the above steps, you can copy the following code in to your “btnConnectActionPerformed” event:

  try {
            //Load and register SQL Server driver
            Class.forName("
               com.microsoft.jdbc.sqlserver.SQLServerDriver");
            //Establish a connection
            Connection conn = DriverManager.getConnection("
               jdbc:microsoft:sqlserver://serverjag:1433","sa","");
            //Create a Statement object
            Statement sql_stmt = conn.createStatement();
            //Create a ResultSet object, execute the query and return a
            // resultset
            ResultSet rset = sql_stmt.executeQuery("SELECT * FROM
Northwind..orders ");
            int i=0;
            while (rset.next()){
                i++;
            }
            //Close the ResultSet and Statement
            rset.close();
            sql_stmt.close();
            //Close the database connection
            conn.close();
            this.txtMsg.setText(Integer.toString(i) + " rows found");
        }
        catch(Exception e) {
            this.txtMsg.setText("Failed to connect; Please view Stack
Trace");
            e.printStackTrace();
        }

You can hit F5 to execute your solution and click on the button to show you the number of rows available in “Orders” table.

Any doubts, bugs, errors, suggestions, feedback etc. are highly appreciated at jag_chat@yahoo.com.