{"id":405,"date":"2016-03-27T15:43:36","date_gmt":"2016-03-27T12:43:36","guid":{"rendered":"http:\/\/leodev.ru\/blog\/?p=405"},"modified":"2016-03-27T15:48:50","modified_gmt":"2016-03-27T12:48:50","slug":"spring-jdbctemplate-vs-jdbcdaosupport-%d0%bf%d1%80%d0%b8%d0%bc%d0%b5%d1%80%d1%8b","status":"publish","type":"post","link":"https:\/\/leodev.ru\/blog\/spring-jdbc\/spring-jdbctemplate-vs-jdbcdaosupport-%d0%bf%d1%80%d0%b8%d0%bc%d0%b5%d1%80%d1%8b\/","title":{"rendered":"Spring JdbcTemplate vs JdbcDaoSupport \u043f\u0440\u0438\u043c\u0435\u0440\u044b"},"content":{"rendered":"

\u041a\u0430\u043a \u043c\u043d\u043e\u0433\u0438\u043c \u043a\u0442\u043e \u0445\u043e\u0442\u044c \u043a\u043e\u0433\u0434\u0430 \u043d\u0438\u0431\u0443\u0434\u044c \u0440\u0430\u0431\u043e\u0442\u0430\u043b \u0441\u043e Spring \u0444\u0440\u0435\u0439\u043c\u0432\u043e\u0440\u043a\u043e\u043c — \u043d\u0435 \u0441\u043c\u043e\u0442\u0440\u044f \u043d\u0430 \u0442\u043e\u043d\u043d\u044b \u043e\u0431\u0435\u0440\u0442\u043e\u043a \u043e\u043d \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u00a0\u0443\u0441\u043a\u043e\u0440\u044f\u0435\u0442 \u043f\u0440\u043e\u0446\u0435\u0441\u0441 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0438 \u0432 \u0441\u043b\u0443\u0447\u0430\u0435 DAO \u0441\u043b\u043e\u044f\u00a0\u0442\u0430\u043a \u0436\u0435 \u043d\u0435 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0438\u0441\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0435\u043c.<\/p>\n

Data Access Object (DAO) \u2014 \u0448\u0438\u0440\u043e\u043a\u043e \u0440\u0430\u0441\u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u0435\u043d\u043d\u044b\u0439 \u043f\u0430\u0442\u0442\u0435\u0440\u043d \u0434\u043b\u044f \u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u043e\u0431\u044a\u0435\u043a\u0442\u043e\u0432 \u0431\u0438\u0437\u043d\u0435\u0441-\u043e\u0431\u043b\u0430\u0441\u0442\u0438 \u0432 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445. \u0412 \u0441\u0430\u043c\u043e\u043c \u0448\u0438\u0440\u043e\u043a\u043e\u043c \u0441\u043c\u044b\u0441\u043b\u0435, DAO \u2014 \u044d\u0442\u043e \u043a\u043b\u0430\u0441\u0441, \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0449\u0438\u0439 CRUD \u043c\u0435\u0442\u043e\u0434\u044b \u0434\u043b\u044f \u043a\u043e\u043d\u043a\u0440\u0435\u0442\u043d\u043e\u0439 \u0441\u0443\u0449\u043d\u043e\u0441\u0442\u0438.<\/p><\/blockquote>\n

<\/p>\n

\u041f\u0440\u0438\u043c\u0435\u0440 \u0431\u0435\u0437 Spring\u00a0JdbcTemplate<\/strong><\/h1>\n

\u0411\u0435\u0437 JdbcTemplate<\/strong>, \u043d\u0430\u043c \u043f\u0440\u0438\u0445\u043e\u0434\u0438\u0442\u0441\u044f \u043f\u0438\u0441\u0430\u0442\u044c \u043c\u043d\u043e\u0433\u043e \u043b\u0438\u0448\u043d\u0435\u0433\u043e \u043a\u043e\u0434\u0430\u00a0(\u0441\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435, \u0437\u0430\u043a\u0440\u044b\u0432\u0430\u0442\u044c \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435, \u043e\u0442\u043b\u0430\u0432\u043b\u0438\u0432\u0430\u0442\u044c \u0438\u0441\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f)<\/em> \u043f\u0440\u0438\u0447\u0435\u043c \u0434\u0435\u043b\u0430\u0442\u044c \u044d\u0442\u043e \u043f\u0440\u0438\u0445\u043e\u0434\u0438\u0442\u0441\u044f \u0432\u00a0\u043a\u0430\u0436\u0434\u043e\u043c\u00a0DAO<\/strong> \u043c\u0435\u0442\u043e\u0434\u0435\u00a0\u2013 insert<\/strong>, update<\/strong> \u0438\u00a0delete<\/strong>. \u042d\u0442\u043e \u043d\u0435 \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e, \u0433\u0440\u043e\u043c\u043e\u0437\u0434\u043a\u043e \u0438 \u0443\u0442\u043e\u043c\u0438\u0442\u0435\u043b\u044c\u043d\u043e.<\/p>\n

private DataSource dataSource;\r\n\t\t\r\n\tpublic void setDataSource(DataSource dataSource) {\r\n\t\tthis.dataSource = dataSource;\r\n\t}\r\n\t\t\r\n\tpublic void insert(Subscriber subscriber){\r\n\t\tString sql = \"INSERT INTO SUBSCRIBERS(IP, EMAIL, AGE) VALUES (?, ?, ?)\";\r\n\t\tConnection conn = null;\r\n\t\ttry {\r\n\t\t\t\/\/\u043a\u0430\u0436\u0434\u044b\u0439 \u0440\u0430\u0437 \u043e\u0442\u043a\u0440\u044b\u0432\u0430\u0435\u043c \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435\r\n\t\t\tconn = dataSource.getConnection();\r\n\t\t\tPreparedStatement ps = conn.prepareStatement(sql);\r\n\t\t\tps.setInt(1, subscriber.getIp());\r\n\t\t\tps.setString(2, subscriber.getEmail());\r\n\t\t\tps.setInt(3, subscriber.getAge());\r\n\t\t\tps.executeUpdate();\r\n\t\t\tps.close();\r\n\t\t} catch (SQLException e) {\r\n\t\t\tthrow new RuntimeException(e);\r\n\t\t} finally {\r\n                        \/\/\u043a\u0430\u0436\u0434\u044b\u0439 \u0440\u0430\u0437 \u0437\u0430\u043a\u0440\u044b\u0432\u0430\u0435\u043c \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435\r\n\t\t\tif (conn != null) {\r\n\t\t\t\ttry {\r\n\t\t\t\t\tconn.close();\r\n\t\t\t\t} catch (SQLException e) {}\r\n\t\t\t}\r\n\t\t}\r\n\t}<\/pre>\n
\u041f\u0440\u0438\u043c\u0435\u0440 \u0441 Spring\u00a0JdbcTemplate<\/strong><\/h1>\n
\u0421\u00a0JdbcTemplate<\/strong>, \u0432\u044b \u044d\u043a\u043e\u043d\u043e\u043c\u0438\u0442\u0435 \u0432\u0440\u0435\u043c\u044f \u043d\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0443, \u043f\u043e\u0442\u043e\u043c\u0443 \u0447\u0442\u043e\u00a0JdbcTemplate\u00a0<\/strong>\u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442 \u043f\u043e\u043b\u043e\u0432\u0438\u043d\u0443 \u0440\u0430\u0431\u043e\u0442\u044b \u0437\u0430 \u0412\u0430\u0441.<\/p>\n
@Autowired\r\nprivate DataSource dataSource;\r\n@Autowired\r\nprivate JdbcTemplate jdbcTemplate;\r\n\r\npublic void insert(Subscriber subscriber){\r\n\tString sql = \"INSERT INTO SUBSCRIBERS(IP, EMAIL, AGE) VALUES (?, ?, ?)\";\r\n\tjdbcTemplate = new JdbcTemplate(dataSource);\r\n\tjdbcTemplate.update(sql, new Object[] { subscriber.getCustId(),\r\n\t\t\tsubscriber.getName(),\r\n\t\t\tsubscriber.getAge()  \r\n\t\t});\r\n\t}<\/pre>\n
\u041f\u0440\u0438\u043c\u0435\u0440 \u0441 Spring\u00a0<\/strong>JdbcDaoSupport<\/h1>\n
\u041f\u0440\u0438\u00a0\u043d\u0430\u0441\u043b\u0435\u0434\u043e\u0432\u0430\u043d\u0438\u0438 \u043e\u0442\u00a0JdbcDaoSupport,\u00a0\u0438\u043d\u0438\u0446\u0438\u0430\u043b\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u0442\u044c JdbcTemplate \u00a0\u043d\u0430\u043c \u0431\u043e\u043b\u044c\u0448\u0435 \u043d\u0435 \u043d\u0443\u0436\u043d\u043e. \u0414\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u0437\u0430\u0438\u043d\u0436\u0435\u043a\u0442\u0438\u0442\u044c\u00a0\u0435\u0433\u043e \u0438 \u043c\u044b \u0441\u043c\u043e\u0436\u0435\u043c \u043f\u043e\u043b\u0443\u0447\u0430\u0442\u044c \u0435\u0433\u043e \u043a\u0430\u0436\u0434\u044b\u0439 \u0440\u0430\u0437 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043c\u0435\u0442\u043e\u0434\u0430\u00a0getJdbcTemplate ()<\/strong>.<\/p>\n
public class JdbcCustomerDAO extends JdbcDaoSupport implements CustomerDAO {\r\n\t   \/\/no need to set datasource here\r\n\t   public void insert(Customer customer){\r\n\t\tString sql = \"INSERT INTO SUBSCRIBERS(IP, EMAIL, AGE) VALUES (?, ?, ?)\";\r\n\t\tgetJdbcTemplate().update(sql, new Object[] { customer.getCustId(),\r\n\t\t\t\tcustomer.getName(),customer.getAge()  \r\n\t\t});\r\n\t\t\t\t\r\n\t}<\/pre>\n
<beans xmlns=\"http:\/\/www.springframework.org\/schema\/beans\"\r\n\txmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\r\n\txsi:schemaLocation=\"http:\/\/www.springframework.org\/schema\/beans\r\n\thttp:\/\/www.springframework.org\/schema\/beans\/spring-beans-2.5.xsd\">\r\n\t\r\n\t<bean id=\"dataSource\" \r\n         class=\"org.springframework.jdbc.datasource.DriverManagerDataSource\">\r\n\r\n\t\t<property name=\"driverClassName\" value=\"com.mysql.jdbc.Driver\" \/>\r\n\t\t<property name=\"url\" value=\"jdbc:mysql:\/\/localhost:3306\/leodev\" \/>\r\n\t\t<property name=\"username\" value=\"root\" \/>\r\n\t\t<property name=\"password\" value=\"password\" \/>\r\n\t<\/bean>\r\n\t\r\n<\/beans><\/pre>\n
<beans xmlns=\"http:\/\/www.springframework.org\/schema\/beans\"\r\n\txmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\r\n\txsi:schemaLocation=\"http:\/\/www.springframework.org\/schema\/beans\r\n\thttp:\/\/www.springframework.org\/schema\/beans\/spring-beans-2.5.xsd\">\r\n\r\n\t<bean id=\"customerDAO\" class=\"ru.leodev.subscriber.dao.impl.JdbcCustomerDAO\">\r\n\t\t<property name=\"dataSource\" ref=\"dataSource\" \/>\r\n\t<\/bean>\r\n\t\r\n<\/beans><\/pre>\n
\u0438\u043b\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f Java Bean Configuration<\/strong><\/p>\n
    @Bean\r\n    public DataSource dataSource() {\r\n        DriverManagerDataSource dataSource = new DriverManagerDataSource();\r\n        dataSource.setDriverClassName(env.getRequiredProperty(\"jdbc.driverClassName\"));\r\n        dataSource.setUrl(env.getRequiredProperty(\"jdbc.url\"));\r\n        dataSource.setUsername(env.getRequiredProperty(\"jdbc.username\"));\r\n        dataSource.setPassword(env.getRequiredProperty(\"jdbc.password\"));\r\n        return dataSource;\r\n    }\r\n\r\n    @Bean\r\n    public JdbcTemplate getjdbcTemplate() throws NamingException {\r\n        return new JdbcTemplate(dataSource());\r\n    }<\/pre>\n
Maven \u0437\u0430\u0432\u0438\u0441\u0438\u043c\u043e\u0441\u0442\u0438:<\/h1>\n
        <dependency>\r\n            <groupId>org.springframework<\/groupId>\r\n            <artifactId>spring-jdbc<\/artifactId>\r\n            <version>4.2.5.RELEASE<\/version>\r\n        <\/dependency><\/pre>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
\u041a\u0430\u043a \u043c\u043d\u043e\u0433\u0438\u043c \u043a\u0442\u043e \u0445\u043e\u0442\u044c \u043a\u043e\u0433\u0434\u0430 \u043d\u0438\u0431\u0443\u0434\u044c \u0440\u0430\u0431\u043e\u0442\u0430\u043b \u0441\u043e Spring \u0444\u0440\u0435\u0439\u043c\u0432\u043e\u0440\u043a\u043e\u043c — \u043d\u0435 \u0441\u043c\u043e\u0442\u0440\u044f \u043d\u0430 \u0442\u043e\u043d\u043d\u044b \u043e\u0431\u0435\u0440\u0442\u043e\u043a \u043e\u043d \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u00a0\u0443\u0441\u043a\u043e\u0440\u044f\u0435\u0442 \u043f\u0440\u043e\u0446\u0435\u0441\u0441 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0438 \u0432 \u0441\u043b\u0443\u0447\u0430\u0435 DAO \u0441\u043b\u043e\u044f\u00a0\u0442\u0430\u043a \u0436\u0435 \u043d\u0435 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0438\u0441\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0435\u043c. Data Access Object (DAO) \u2014 \u0448\u0438\u0440\u043e\u043a\u043e \u0440\u0430\u0441\u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u0435\u043d\u043d\u044b\u0439 \u043f\u0430\u0442\u0442\u0435\u0440\u043d \u0434\u043b\u044f \u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u043e\u0431\u044a\u0435\u043a\u0442\u043e\u0432 \u0431\u0438\u0437\u043d\u0435\u0441-\u043e\u0431\u043b\u0430\u0441\u0442\u0438 \u0432 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445. \u0412 \u0441\u0430\u043c\u043e\u043c \u0448\u0438\u0440\u043e\u043a\u043e\u043c \u0441\u043c\u044b\u0441\u043b\u0435, DAO \u2014 \u044d\u0442\u043e \u043a\u043b\u0430\u0441\u0441, \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0449\u0438\u0439 CRUD \u043c\u0435\u0442\u043e\u0434\u044b … \u0427\u0438\u0442\u0430\u0442\u044c \u0434\u0430\u043b\u0435\u0435 \u00abSpring  JdbcTemplate vs JdbcDaoSupport \u043f\u0440\u0438\u043c\u0435\u0440\u044b\u00bb<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":408,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[145],"tags":[149,150,147,151,152,146,148],"class_list":["post-405","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spring-jdbc","tag-dao","tag-data-access-object","tag-jdbc","tag-jdbcdaosupport","tag-jdbctemplate","tag-spring","tag-spring-jdbc"],"_links":{"self":[{"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/posts\/405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/comments?post=405"}],"version-history":[{"count":5,"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/posts\/405\/revisions"}],"predecessor-version":[{"id":412,"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/posts\/405\/revisions\/412"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/media\/408"}],"wp:attachment":[{"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/media?parent=405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/categories?post=405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/tags?post=405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}