ResultMap\u304c\u89e3\u6c7a\u3059\u308b3\u3064\u306e\u8ab2\u984c<\/span><\/strong><\/p>\n\n\n\n MyBatis ResultMap\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u691c\u7d22\u7d50\u679c\u3092Java\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u30de\u30c3\u30d4\u30f3\u30b0\u3059\u308b\u969b\u306e\u5f37\u529b\u306a\u6a5f\u80fd\u3067\u3059\u3002\u4ee5\u4e0b\u306e3\u3064\u306e\u4e3b\u8981\u306a\u8ab2\u984c\u3092\u52b9\u679c\u7684\u306b\u89e3\u6c7a\u3057\u307e\u3059\uff1a<\/p>\n\n\n\n \u76ee\u6b21 <\/p>\n \u4ee5\u4e0b\u306b\u30de\u30c3\u30d4\u30f3\u30b0\u306e\u69cb\u6587\u306e\u4f8b\u3092\u793a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n \u30de\u30c3\u30d4\u30f3\u30b0\u69cb\u6587\u306e\u91cd\u8981\u306a\u30dd\u30a4\u30f3\u30c8<\/span><\/strong><\/p>\n\n\n\n \u3053\u306e\u3088\u3046\u306b\u3001MyBatis ResultMap\u306f\u67d4\u8edf\u3067\u5f37\u529b\u306a\u30de\u30c3\u30d4\u30f3\u30b0\u6a5f\u80fd\u3092\u63d0\u4f9b\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068Java\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u9593\u306e\u30ae\u30e3\u30c3\u30d7\u3092\u52b9\u679c\u7684\u306b\u57cb\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u57fa\u672c\u7684\u306a\u69cb\u6587\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u3067\u3001\u3088\u308a\u8907\u96d1\u306a\u30de\u30c3\u30d4\u30f3\u30b0\u306b\u3082\u5bfe\u5fdc\u3067\u304d\u308b\u57fa\u790e\u304c\u7bc9\u3051\u307e\u3059\u3002<\/p>\n\n\n\n \u3053\u306e\u8a2d\u5b9a\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u7c21\u7565\u5316\u3067\u304d\u307e\u3059\uff1a<\/p>\n\n\n\n \u3053\u306e\u3088\u3046\u306a\u57fa\u672c\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3\u3092\u7406\u89e3\u3057\u3001\u9069\u5207\u306b\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u4fdd\u5b88\u6027\u304c\u9ad8\u304f\u3001\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30a2\u30af\u30bb\u30b9\u5c64\u3092\u69cb\u7bc9\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n\n
\n
user_id<\/code>, first_name<\/code>, last_name<\/code><\/li>\n\n\n\nuserId<\/code>, firstName<\/code>, lastName<\/code><\/li>\n<\/ul>\n\n\n\n <resultMap id=\"userResultMap\" type=\"com.example.User\">\n <id column=\"user_id\" property=\"userId\"\/>\n <result column=\"first_name\" property=\"firstName\"\/>\n <result column=\"last_name\" property=\"lastName\"\/>\n <\/resultMap><\/pre>\n\n\n\n
\n
\n
\n
\nWarning<\/b>: Undefined array key \"is_admin\" in \/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line 116<\/b>
\n
\nWarning<\/b>: Undefined array key \"is_category_top\" in \/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line 121<\/b>
\n
\nWarning<\/b>: Undefined array key \"is_top\" in \/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line 128<\/b>
\n
\u57fa\u672c\u7684\u306a\u30de\u30c3\u30d4\u30f3\u30b0\u69cb\u6587<\/h2>\n\n\n\n
1. \u57fa\u672c\u7684\u306aResultMap\u5b9a\u7fa9<\/h3>\n\n\n\n
<resultMap id=\"baseResultMap\" type=\"com.example.entity.User\">\n <!-- \u4e3b\u30ad\u30fc\u306e\u30de\u30c3\u30d4\u30f3\u30b0 -->\n <id column=\"id\" property=\"id\"\/>\n\n <!-- \u901a\u5e38\u306e\u30ab\u30e9\u30e0\u306e\u30de\u30c3\u30d4\u30f3\u30b0 -->\n <result column=\"name\" property=\"name\"\/>\n <result column=\"email\" property=\"email\"\/>\n <result column=\"created_at\" property=\"createdAt\"\/>\n<\/resultMap><\/pre>\n\n\n\n
2. \u95a2\u9023\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30de\u30c3\u30d4\u30f3\u30b0<\/h3>\n\n\n\n
<resultMap id=\"userWithProfileMap\" type=\"com.example.entity.User\">\n <!-- \u57fa\u672c\u30d7\u30ed\u30d1\u30c6\u30a3 -->\n <id column=\"user_id\" property=\"id\"\/>\n <result column=\"user_name\" property=\"name\"\/>\n\n <!-- \u95a2\u9023\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\uff081\u5bfe1\uff09 -->\n <association property=\"profile\" javaType=\"com.example.entity.Profile\">\n <id column=\"profile_id\" property=\"id\"\/>\n <result column=\"bio\" property=\"bio\"\/>\n <\/association>\n<\/resultMap><\/pre>\n\n\n\n
3. \u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306e\u30de\u30c3\u30d4\u30f3\u30b0<\/h3>\n\n\n\n
<resultMap id=\"userWithOrdersMap\" type=\"com.example.entity.User\">\n <!-- \u57fa\u672c\u30d7\u30ed\u30d1\u30c6\u30a3 -->\n <id column=\"user_id\" property=\"id\"\/>\n <result column=\"user_name\" property=\"name\"\/>\n\n <!-- \u95a2\u9023\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\uff081\u5bfe\u591a\uff09 -->\n <collection property=\"orders\" ofType=\"com.example.entity.Order\">\n <id column=\"order_id\" property=\"id\"\/>\n <result column=\"order_date\" property=\"orderDate\"\/>\n <result column=\"total_amount\" property=\"totalAmount\"\/>\n <\/collection>\n<\/resultMap><\/pre>\n\n\n\n
\n
\n
<id><\/code> \u30bf\u30b0\u306f\u4e3b\u30ad\u30fc\u306e\u30de\u30c3\u30d4\u30f3\u30b0\u306b\u4f7f\u7528<\/li>\n\n\n\n\u30de\u30c3\u30d4\u30f3\u30b0\u8981\u7d20<\/strong><\/td> \u7528\u9014 <\/strong><\/td> \u4e3b\u306a\u5c5e\u6027<\/strong><\/td><\/tr> <id><\/code> <\/td>\u4e3b\u30ad\u30fc\u306e\u30de\u30c3\u30d4\u30f3\u30b0<\/td> column, property <\/td><\/tr> <result><\/code> <\/td>\u901a\u5e38\u306e\u30ab\u30e9\u30e0\u30de\u30c3\u30d4\u30f3\u30b0 <\/td> column, property, jdbcType <\/td><\/tr> <association><\/code> <\/td>1\u5bfe1\u306e\u95a2\u9023<\/td> property, javaType<\/td><\/tr> <collection><\/code> <\/td>1\u5bfe\u591a\u306e\u95a2\u9023<\/td> property, ofType<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n \n
\n
jdbcType<\/code>\u5c5e\u6027\u306b\u3088\u308b\u660e\u793a\u7684\u306a\u578b\u6307\u5b9a<\/li>\n\n\n\ntypeHandler<\/code>\u306b\u3088\u308b\u72ec\u81ea\u306e\u578b\u5909\u63db<\/li>\n\n\n\n\u5b9f\u88c5\u306e\u57fa\u672c\u30b9\u30c6\u30c3\u30d7<\/h3>\n\n\n\n
\n
public class User {\n private Long id;\n private String name;\n private String email;\n private LocalDateTime createdAt;\n \/\/ getter\/setter\n}<\/pre>\n\n\n\n\n
<resultMap id=\"userMap\" type=\"com.example.User\">\n <id column=\"id\" property=\"id\"\/>\n <result column=\"name\" property=\"name\"\/>\n <result column=\"email\" property=\"email\"\/>\n <result column=\"created_at\" property=\"createdAt\"\/>\n<\/resultMap><\/pre>\n\n\n\n
\n
<select id=\"getUser\" resultMap=\"userMap\">\n SELECT id, name, email, created_at\n FROM users\n WHERE id = #{id}\n<\/select><\/pre>\n\n\n\n2. ResultMap\u306e\u57fa\u672c\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3<\/h1>\n\n\n\n
\u30b7\u30f3\u30d7\u30eb\u306a1\u5bfe1\u30de\u30c3\u30d4\u30f3\u30b0\u306e\u5b9f\u88c5\u65b9\u6cd5<\/h2>\n\n\n\n
\u57fa\u672c\u7684\u306a\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u30de\u30c3\u30d4\u30f3\u30b0<\/h3>\n\n\n\n
\n
public class Employee {\n private Long id;\n private String firstName;\n private String lastName;\n private String email;\n private BigDecimal salary;\n private LocalDate hireDate;\n\n \/\/ getter\/setter\u306f\u7701\u7565\n}<\/pre>\n\n\n\n\n
<resultMap id=\"employeeMap\" type=\"com.example.Employee\">\n <id column=\"employee_id\" property=\"id\"\/>\n <result column=\"first_name\" property=\"firstName\"\/>\n <result column=\"last_name\" property=\"lastName\"\/>\n <result column=\"email\" property=\"email\"\/>\n <result column=\"salary\" property=\"salary\"\/>\n <result column=\"hire_date\" property=\"hireDate\"\/>\n<\/resultMap><\/pre>\n\n\n\n
\n
public interface EmployeeMapper {\n @Select(\"SELECT * FROM employees WHERE employee_id = #{id}\")\n @ResultMap(\"employeeMap\")\n Employee findById(Long id);\n}<\/pre>\n\n\n\n\u30ab\u30e9\u30e0\u540d\u3068\u5909\u6570\u540d\u304c\u7570\u306a\u308b\u5834\u5408\u306e\u5bfe\u5fdc<\/h2>\n\n\n\n
1. \u547d\u540d\u898f\u5247\u306e\u9055\u3044\u3078\u306e\u5bfe\u5fdc<\/h3>\n\n\n\n
\u30b9\u30cd\u30fc\u30af\u30b1\u30fc\u30b9\u304b\u3089\u30ad\u30e3\u30e1\u30eb\u30b1\u30fc\u30b9\u3078\u306e\u5909\u63db<\/h4>\n\n\n\n
<resultMap id=\"productMap\" type=\"com.example.Product\">\n <id column=\"product_id\" property=\"productId\"\/>\n <result column=\"product_name\" property=\"productName\"\/>\n <result column=\"unit_price\" property=\"unitPrice\"\/>\n <result column=\"created_at\" property=\"createdAt\"\/>\n <result column=\"last_updated_at\" property=\"lastUpdatedAt\"\/>\n<\/resultMap><\/pre>\n\n\n\n
\u5168\u304f\u7570\u306a\u308b\u547d\u540d\u30d1\u30bf\u30fc\u30f3\u306e\u5bfe\u5fdc<\/h4>\n\n\n\n
<resultMap id=\"orderMap\" type=\"com.example.Order\">\n <id column=\"ord_no\" property=\"orderNumber\"\/>\n <result column=\"ord_dt\" property=\"orderDate\"\/>\n <result column=\"cust_cd\" property=\"customerCode\"\/>\n <result column=\"tot_amt\" property=\"totalAmount\"\/>\n<\/resultMap><\/pre>\n\n\n\n
2. \u30b0\u30ed\u30fc\u30d0\u30eb\u8a2d\u5b9a\u306b\u3088\u308b\u81ea\u52d5\u30de\u30c3\u30d4\u30f3\u30b0<\/h3>\n\n\n\n
<!-- mybatis-config.xml -->\n<settings>\n <!-- \u30b9\u30cd\u30fc\u30af\u30b1\u30fc\u30b9\u304b\u3089\u30ad\u30e3\u30e1\u30eb\u30b1\u30fc\u30b9\u3078\u306e\u81ea\u52d5\u5909\u63db\u3092\u6709\u52b9\u5316 -->\n <setting name=\"mapUnderscoreToCamelCase\" value=\"true\"\/>\n<\/settings><\/pre>\n\n\n\n
<resultMap id=\"simpleMap\" type=\"com.example.Entity\">\n <id column=\"id\" property=\"id\"\/>\n <!-- \u81ea\u52d5\u7684\u306buser_name\u306fuserName\u306b\u30de\u30c3\u30d4\u30f3\u30b0\u3055\u308c\u308b -->\n<\/resultMap><\/pre>\n\n\n\n
\u578b\u5909\u63db\u3092\u6d3b\u7528\u3057\u305f\u30de\u30c3\u30d4\u30f3\u30b0\u624b\u6cd5<\/h2>\n\n\n\n
1. \u57fa\u672c\u7684\u306a\u578b\u5909\u63db<\/h3>\n\n\n\n
<resultMap id=\"dataTypeMap\" type=\"com.example.DataTypes\">\n <!-- \u6570\u5024\u578b\u306e\u5909\u63db -->\n <result column=\"int_value\" property=\"intValue\" jdbcType=\"INTEGER\"\/>\n <result column=\"decimal_value\" property=\"decimalValue\" jdbcType=\"DECIMAL\"\/>\n\n <!-- \u65e5\u4ed8\u578b\u306e\u5909\u63db -->\n <result column=\"date_value\" property=\"dateValue\" jdbcType=\"DATE\"\/>\n <result column=\"timestamp_value\" property=\"timestampValue\" jdbcType=\"TIMESTAMP\"\/>\n\n <!-- \u6587\u5b57\u5217\u578b\u306e\u5909\u63db -->\n <result column=\"string_value\" property=\"stringValue\" jdbcType=\"VARCHAR\"\/>\n <result column=\"clob_value\" property=\"clobValue\" jdbcType=\"CLOB\"\/>\n<\/resultMap><\/pre>\n\n\n\n
2. \u30ab\u30b9\u30bf\u30e0\u578b\u30cf\u30f3\u30c9\u30e9\u30fc\u306e\u5b9f\u88c5<\/h3>\n\n\n\n
\n
public class JsonTypeHandler extends BaseTypeHandler<Map<String, Object>> {\n private final ObjectMapper objectMapper = new ObjectMapper();\n\n @Override\n public void setNonNullParameter(PreparedStatement ps, int i, \n Map<String, Object> parameter, JdbcType jdbcType) throws SQLException {\n ps.setString(i, toJson(parameter));\n }\n\n @Override\n public Map<String, Object> getNullableResult(ResultSet rs, String columnName) \n throws SQLException {\n return fromJson(rs.getString(columnName));\n }\n\n \/\/ \u4ed6\u306e\u30e1\u30bd\u30c3\u30c9\u306e\u5b9f\u88c5\u306f\u7701\u7565\n\n private String toJson(Map<String, Object> map) throws SQLException {\n try {\n return objectMapper.writeValueAsString(map);\n } catch (JsonProcessingException e) {\n throw new SQLException(\"Error converting map to JSON\", e);\n }\n }\n\n private Map<String, Object> fromJson(String json) throws SQLException {\n try {\n if (json == null) return null;\n return objectMapper.readValue(json, new TypeReference<Map<String, Object>>() {});\n } catch (JsonProcessingException e) {\n throw new SQLException(\"Error converting JSON to map\", e);\n }\n }\n}<\/pre>\n\n\n\n\n
<!-- mybatis-config.xml -->\n<typeHandlers>\n <typeHandler handler=\"com.example.JsonTypeHandler\" \n javaType=\"java.util.Map\" \n jdbcType=\"VARCHAR\"\/>\n<\/typeHandlers><\/pre>\n\n\n\n
\n
<resultMap id=\"configMap\" type=\"com.example.Configuration\">\n <id column=\"id\" property=\"id\"\/>\n <result column=\"config_json\" property=\"configData\" \n typeHandler=\"com.example.JsonTypeHandler\"\/>\n<\/resultMap><\/pre>\n\n\n\n
\u5b9f\u88c5\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h3>\n\n\n\n
\n
\n
\u9805\u76ee<\/strong><\/td> \u63a8\u5968\u898f\u5247<\/strong><\/td> \u4f8b<\/strong><\/td><\/tr> ID<\/td> \u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u540d + Map<\/td> userMap, orderMap<\/td><\/tr> \u30ab\u30e9\u30e0\u540d<\/td> \u30b9\u30cd\u30fc\u30af\u30b1\u30fc\u30b9<\/td> user_id, created_at<\/td><\/tr> \u30d7\u30ed\u30d1\u30c6\u30a3\u540d<\/td> \u30d7\u30ed\u30d1\u30c6\u30a3\u540d<\/td> userId, createdAt<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n \n
\n
3. \u9ad8\u5ea6\u306aResultMap\u5b9f\u88c5\u30c6\u30af\u30cb\u30c3\u30af<\/h1>\n\n\n\n
1\u5bfe\u591a\u95a2\u4fc2\u306e\u30de\u30c3\u30d4\u30f3\u30b0\u5b9f\u88c5<\/h2>\n\n\n\n
\u57fa\u672c\u7684\u306a1\u5bfe\u591a\u30de\u30c3\u30d4\u30f3\u30b0<\/h3>\n\n\n\n
\n
public class Department {\n private Long id;\n private String name;\n private List<Employee> employees;\n \/\/ getter\/setter\u7701\u7565\n}\n\npublic class Employee {\n private Long id;\n private String name;\n private String position;\n private BigDecimal salary;\n \/\/ getter\/setter\u7701\u7565\n}<\/pre>\n\n\n\n\n
<resultMap id=\"departmentWithEmployeesMap\" type=\"com.example.Department\">\n <id column=\"dept_id\" property=\"id\"\/>\n <result column=\"dept_name\" property=\"name\"\/>\n <collection property=\"employees\" ofType=\"com.example.Employee\">\n <id column=\"emp_id\" property=\"id\"\/>\n <result column=\"emp_name\" property=\"name\"\/>\n <result column=\"position\" property=\"position\"\/>\n <result column=\"salary\" property=\"salary\"\/>\n <\/collection>\n<\/resultMap><\/pre>\n\n\n\n
\n
<select id=\"getDepartmentWithEmployees\" resultMap=\"departmentWithEmployeesMap\">\n SELECT d.dept_id, d.dept_name,\n e.emp_id, e.emp_name, e.position, e.salary\n FROM departments d\n LEFT JOIN employees e ON d.dept_id = e.dept_id\n WHERE d.dept_id = #{id}\n<\/select><\/pre>\n\n\n\n\u591a\u5bfe\u591a\u95a2\u4fc2\u306e\u52b9\u7387\u7684\u306a\u51e6\u7406\u65b9\u6cd5<\/h2>\n\n\n\n
\u4e2d\u9593\u30c6\u30fc\u30d6\u30eb\u3092\u4f7f\u7528\u3057\u305f\u591a\u5bfe\u591a\u30de\u30c3\u30d4\u30f3\u30b0<\/h3>\n\n\n\n
\n
public class User {\n private Long id;\n private String username;\n private List<Role> roles;\n \/\/ getter\/setter\u7701\u7565\n}\n\npublic class Role {\n private Long id;\n private String name;\n private String description;\n \/\/ getter\/setter\u7701\u7565\n}<\/pre>\n\n\n\n\n
<resultMap id=\"userWithRolesMap\" type=\"com.example.User\">\n <id column=\"user_id\" property=\"id\"\/>\n <result column=\"username\" property=\"username\"\/>\n <collection property=\"roles\" ofType=\"com.example.Role\">\n <id column=\"role_id\" property=\"id\"\/>\n <result column=\"role_name\" property=\"name\"\/>\n <result column=\"role_description\" property=\"description\"\/>\n <\/collection>\n<\/resultMap><\/pre>\n\n\n\n
\n
<select id=\"getUserWithRoles\" resultMap=\"userWithRolesMap\">\n SELECT u.user_id, u.username,\n r.role_id, r.role_name, r.role_description\n FROM users u\n LEFT JOIN user_roles ur ON u.user_id = ur.user_id\n LEFT JOIN roles r ON ur.role_id = r.role_id\n WHERE u.user_id = #{id}\n<\/select><\/pre>\n\n\n\n\u30cd\u30b9\u30c8\u3055\u308c\u305fResultMap\u306e\u6d3b\u7528\u65b9\u6cd5<\/h2>\n\n\n\n
\u8907\u96d1\u306a\u968e\u5c64\u69cb\u9020\u306e\u30de\u30c3\u30d4\u30f3\u30b0<\/h3>\n\n\n\n
\n