Finding and Traversing Rows using NetBeans IDE

This section shows you the code to search for the rows in the table.  Copy the following code into the "buttonActionPerformed" event:

private void btnSearchActionPerformed(java.awt.event.ActionEvent
evt) {
TODO add your handling code here:
        try {
           
            if (this.txtEmpno.getText().trim().length()==0) {
                this.lblMsg.setText("Provide Employee Number");
                return;
            }               

           Class.forName
("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 
           Connection conn = DriverManager.getConnection
("jdbc:microsoft:sqlserver://serverjag:1433","sa","");       

            Statement sql_stmt = conn.createStatement();
            ResultSet rset = sql_stmt.executeQuery( "SELECT
ename, sal, deptno " +
                                  " FROM Northwind..emp " +
                                  " WHERE empno=" +
this.txtEmpno.getText() +
                                  " ORDER BY ename");
            String str = "";
            if (rset.next()) {
                this.txtEname.setText(rset.getString(1));
                this.txtSal.setText(rset.getString(2));
                this.txtDeptno.setText(rset.getString(3));
                this.lblMsg.setText("");
            }
            else {
                this.lblMsg.setText("Not Found");
            }
            rset.close();
            sql_stmt.close();
            conn.close();
        }
        catch(Exception e) {
            this.lblMsg.setText("Error: Please view Stack
Trace");
            e.printStackTrace();
        }
    }                  

The above code works only for one row. If we want to work with more than one row, we need to use "jTable" or some other, better strategy.  My upcoming articles will give you the information you need to work with more than one row at any time.

The next section will explain the above code.