springframework:jdbc

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

--- springframework:jdbc [2015/12/22 13:27]
kwon37xi
+++ springframework:jdbc [2022/03/23 22:19]
kwon37xi
@@ 줄 6: / 줄 6: @@
 ===== Stored Procedure =====
   * [[https://lalitjc.wordpress.com/2013/07/02/different-ways-of-calling-stored-procedure-using-spring/|Different ways of calling stored procedure using spring]]
+===== NamedParameterJdbcTemplate =====
+  * [[https://docs.spring.io/spring/docs/current/javadoc-api/org/springframework/jdbc/core/namedparam/NamedParameterJdbcTemplate.html|NamedParameterJdbcTemplate]]
+  * '':paramName'' 방식으로 파라미터 바인딩 가능
+  * [[https://docs.spring.io/spring-framework/docs/current/javadoc-api/org/springframework/jdbc/core/namedparam/SqlParameterSource.html|SqlParameterSource]]를 통해 파라미터 저장
+    * [[https://docs.spring.io/spring-framework/docs/current/javadoc-api/org/springframework/jdbc/core/namedparam/MapSqlParameterSource.html|MapSqlParameterSource]]
+    * [[https://docs.spring.io/spring-framework/docs/current/javadoc-api/org/springframework/jdbc/core/namedparam/BeanPropertySqlParameterSource.html|BeanPropertySqlParameterSource]] : 일반 Java Bean의 프라퍼티명을 통해 파라미터 지정 가능.
+===== RowMapper =====
+  * [[https://docs.spring.io/spring/docs/current/javadoc-api/org/springframework/jdbc/core/RowMapper.html|RowMapper]] : 쿼리 결과를 Java 객체로 생성하는 매핑 규칙
+==== BeanPropertyRowMapper ====
+  * [[https://docs.spring.io/spring/docs/current/javadoc-api/org/springframework/jdbc/core/BeanPropertyRowMapper.html|BeanPropertyRowMapper]]
+  * Java Bean property 이름과 컬럼 이름을 매핑
+<code java>
+var rowMapper = BeanPropertyRowMapper.newInstance(Country.class);
+</code>
+  * 한번 초기화 되면 Thread safe 하게 사용가능하다.(억지로 값을 설정하지만 않으면 됨)
+  * [[https://docs.spring.io/spring/docs/current/javadoc-api/org/springframework/core/convert/ConversionService.html|ConversionService]] 지정을 통해 프라퍼티 타입 확장 가능.
+    * [[https://docs.spring.io/spring-framework/docs/current/javadoc-api/org/springframework/core/convert/support/DefaultConversionService.html|DefaultConversionService]] : 기본값
+    * [[https://docs.spring.io/spring-framework/docs/current/javadoc-api/org/springframework/format/support/DefaultFormattingConversionService.html|DefaultFormattingConversionService]]
+===== DatabasePopulator =====
+  * [[https://docs.spring.io/spring-framework/docs/current/javadoc-api/org/springframework/jdbc/datasource/init/DatabasePopulator.html|DatabasePopulator]]
+  * [[https://docs.spring.io/spring-framework/docs/current/javadoc-api/org/springframework/jdbc/datasource/init/ResourceDatabasePopulator.html|ResourceDatabasePopulator]]
+  * ''DataSource''를 지정하여 자동으로 SQL을 실행해준다.

springframework/jdbc.txt · 마지막으로 수정됨: 2022/03/23 22:27 저자 kwon37xi