Working with DML and DDL using NetBeans IDE

Once you have completed all the steps in the previous section, you need to copy the following code into your button “actionperformed” event:

private void btnConnectActionPerformed(java.awt.event.ActionEvent
evt) {                                        

// TODO add your handling code here:
        try {
           Class.forName
("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            Connection conn = DriverManager.getConnection
("jdbc:microsoft:sqlserver://serverjag:1433","sa","");
            PreparedStatement stmt = conn.prepareStatement
("UPDATE Northwind..emp " +
                        "SET sal = ? " +
                        "WHERE empno = ?");
            stmt.setInt(1, 5000);
            stmt.setInt(2, 1002);
            stmt.executeUpdate( );
            //stmt.clearParameters( );
            //conn.commit( );
            conn.close();
            this.txtMsg.setText("updated successfully");
        }
        catch(Exception e) {
            this.txtMsg.setText("Error: Please view Stack
Trace");
            e.printStackTrace();
        }
    }                                          

Please be aware that you need to modify the driver and connection information according to your requirements.  You can press F5 to execute your application.  Once it completes successfully, you must see that a new text file exists named “query1.lst” with exactly the same information you find in the table.

If you receive any errors in connecting to Microsoft SQL Server, please refer to my first article in this series.

The next section will explain the above code.