Day 27 Where for number value field

    public void getRows(double searchParam, String searchOp) {
        String op = ">";
        switch (searchOp) {
            case ">":
                op = ">=";
                break;
            case "<":
                op = "<=";
                break;
        }

        String address = "jdbc:mysql://localhost:3306/db_mng_b2";
        String userName = "root";
        String passWord = "";
        String sqlQuery = "SELECT fld_enum"
                + ", fld_fname, fld_lname"
                + ", fld_work_dept, fld_phone"
                + ", fld_sex, fld_salary, fld_birthday"
                + " FROM tbl_employee"
                + " WHERE fld_salary " + op + " ?";
        try {
            Connection conn = DriverManager.getConnection(
                    address,userName,passWord);
            PreparedStatement stmt = conn.prepareStatement(sqlQuery);

            stmt.setDouble(1, searchParam);

            ResultSet rs = stmt.executeQuery();
            while (rs.next()) {
                System.out.println(String.format(
                    "%-3d | %-18s | %-18s | %-3s | %-18s | %1s | %9.4f | %-10s"
                    ,rs.getInt(1)
                    ,rs.getString(2)
                    ,rs.getString(3)
                    ,rs.getString(4)
                    ,rs.getString(5)
                    ,rs.getString(6)
                    ,rs.getDouble(7)
                    ,rs.getString(8)
                ));
            }

            conn.close();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }