Day 26 query methods

package projectSamples;
import java.sql.*;

public class Day26Emp {
    public int addNewEmployee(String fName, String lName, String dept
        ,String phone, String sex, double salary, String bday){
        int rowsAffected = 0;
        String address = "jdbc:mysql://localhost:3306/db_mng_b2";
        String userName = "root";
        String passWord = "";
        String sqlQuery = "INSERT INTO tbl_employee " +
                "(fld_fname ,fld_lname ,fld_work_dept"
                + ",fld_phone ,fld_sex ,fld_salary ,fld_birthday)" +
                "VALUES (? ,? ,? ,? ,? ,? ,?)";

        try {
            Connection conn = DriverManager.getConnection(
                    address,userName,passWord);
            PreparedStatement stmt = conn.prepareStatement(sqlQuery);

            stmt.setString(1, fName);
            stmt.setString(2, lName);
            stmt.setString(3, dept);
            stmt.setString(4, phone);
            stmt.setString(5, sex);
            stmt.setDouble(6, salary);
            stmt.setString(7, bday);

            rowsAffected = stmt.executeUpdate();

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

        return rowsAffected;
    }

    public void getRows() {
        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";
        try {
            Connection conn = DriverManager.getConnection(
                    address,userName,passWord);
            PreparedStatement stmt = conn.prepareStatement(sqlQuery);

            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());
        }
    }

    public void getRows(String searchDept) {
        //method override, select where by fld_work_dept
        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_work_dept = ?";
        try {
            Connection conn = DriverManager.getConnection(
                    address,userName,passWord);
            PreparedStatement stmt = conn.prepareStatement(sqlQuery);

            stmt.setString(1, searchDept);

            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());
        }
    }

    public void getRows(String searchParam, String searchField) {
        //method override, select where by fld_work_dept
        String fieldName = "fld_fname";
        switch (searchField) {
            case "1":
                fieldName = "fld_fname";
                break;
            case "2":
                fieldName = "fld_lname";
                break;
            case "3":
                fieldName = "fld_work_dept";
                break;
            case "4":
                fieldName = "fld_sex";
                break;
        }
        searchParam = "%" + searchParam + "%";

        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 " + fieldName +" LIKE ?";
        try {
            Connection conn = DriverManager.getConnection(
                    address,userName,passWord);
            PreparedStatement stmt = conn.prepareStatement(sqlQuery);

            stmt.setString(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());
        }
    }
}