try {
            Class.forName("com.mysql.jdbc.Driver");
            Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/employee", "root", "");
            Statement st = connect.createStatement();

            rs = st.executeQuery("SELECT * FROM employee where (firstname like '" + searchField.getText() + "%' or empno like '" + searchField.getText() + "%' or lastname like '" + searchField.getText() + "%' )");

            model = (DefaultTableModel) empTable.getModel();

            model.setRowCount(0);
            while (rs.next()) {
                String row[] = {rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getString(5)};
                model.addRow(row);
            }

            connect.close();

        } catch (SQLException sqe) {
            System.out.println("SQL error: " + sqe.toString());
        } catch (ClassNotFoundException cnf) {
            System.out.println("Class not found error : " + cnf.toString());
        }