{"id":1867,"date":"2022-11-28T21:35:32","date_gmt":"2022-11-28T13:35:32","guid":{"rendered":"https:\/\/qaqaq.top\/?p=1867"},"modified":"2022-11-28T21:35:33","modified_gmt":"2022-11-28T13:35:33","slug":"customerdaoimpl%e7%9a%84%e5%8d%95%e5%85%83%e6%b5%8b%e8%af%95","status":"publish","type":"post","link":"https:\/\/qaqaq.top\/?p=1867","title":{"rendered":"CustomerDAOImpl\u7684\u5355\u5143\u6d4b\u8bd5"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>package top.qaqaq.P44.dao.juint;\r\n\r\nimport static org.junit.jupiter.api.Assertions.*;\r\n\r\nimport java.sql.Connection;\r\nimport java.sql.Date;\r\nimport java.text.SimpleDateFormat;\r\nimport java.util.List;\r\n\r\nimport org.junit.jupiter.api.Test;\r\n\r\nimport top.qaqaq.P35.util.JDBCUtils;\r\nimport top.qaqaq.P43.bean.Customer;\r\nimport top.qaqaq.P43.dao.CustomerDAOImpl;\r\n\r\nclass CustomerDAOImplTest {\r\n\t\r\n\tprivate CustomerDAOImpl dao = new CustomerDAOImpl();\r\n\r\n\t@Test\r\n\tvoid testInsert() {\r\n\t\tConnection conn = null;\r\n\t\ttry {\r\n\t\t\tconn = JDBCUtils.getConnection();\r\n\t\t\t\r\n\t\t\tCustomer cust = new Customer(1, \"\u5f20\u5c0f\u98de\", \"xiaofei@126.com\", new Date(42131114141214L));\r\n\t\t\tdao.insert(conn, cust);\r\n\t\t\t\r\n\t\t\tSystem.out.println(\"\u6dfb\u52a0\u6210\u529f\");\r\n\t\t} catch (Exception e) {\r\n\t\t\te.printStackTrace();\r\n\t\t} finally {\r\n\t\t\tJDBCUtils.closeResource(conn, null);\r\n\t\t}\r\n\t\t\r\n\t}\r\n\r\n\t@Test\r\n\tvoid testDeleteById() {\r\n\t\tConnection conn = null;\r\n\t\ttry {\r\n\t\t\tconn = JDBCUtils.getConnection();\r\n\t\t\t\r\n\t\t\tdao.deleteById(conn, 13);\r\n\t\t\t\r\n\t\t\tSystem.out.println(\"\u5220\u9664\u6210\u529f\");\r\n\t\t} catch (Exception e) {\r\n\t\t\te.printStackTrace();\r\n\t\t} finally {\r\n\t\t\tJDBCUtils.closeResource(conn, null);\r\n\t\t}\r\n\t\t\r\n\t}\r\n\r\n\t@Test\r\n\tvoid testUpdateConnectionCustomer() {\r\n\t\tConnection conn = null;\r\n\t\ttry {\r\n\t\t\tconn = JDBCUtils.getConnection();\r\n\t\t\t\r\n\t\t\tSimpleDateFormat sdf = new SimpleDateFormat(\"yyyy-MM-dd\");\r\n\t\t\tjava.util.Date birth = sdf.parse(\"2000-01-01\");\r\n\t\t\t\r\n\t\t\tCustomer cust = new Customer(18,\"\u8d1d\u591a\u82ac\",\"beiduofen@126.com\",new Date(birth.getTime()));\r\n\t\t\tdao.update(conn, cust);\r\n\t\t\t\r\n\t\t\tSystem.out.println(\"\u4fee\u6539\u6210\u529f\");\r\n\t\t} catch (Exception e) {\r\n\t\t\te.printStackTrace();\r\n\t\t} finally {\r\n\t\t\tJDBCUtils.closeResource(conn, null);\r\n\t\t}\r\n\t\t\r\n\t}\r\n\r\n\t@Test\r\n\tvoid testGetCustomerById() {\r\n\t\tConnection conn = null;\r\n\t\ttry {\r\n\t\t\tconn = JDBCUtils.getConnection();\r\n\t\t\t\r\n\t\t\tCustomer cust = dao.getCustomerById(conn, 19);\r\n\t\t\t\r\n\t\t\tSystem.out.println(cust);\r\n\t\t} catch (Exception e) {\r\n\t\t\te.printStackTrace();\r\n\t\t} finally {\r\n\t\t\tJDBCUtils.closeResource(conn, null);\r\n\t\t}\r\n\t\t\r\n\t}\r\n\r\n\t@Test\r\n\tvoid testGetAll() {\r\n\t\tConnection conn = null;\r\n\t\ttry {\r\n\t\t\tconn = JDBCUtils.getConnection();\r\n\t\t\t\r\n\t\t\tList&lt;Customer> list = dao.getAll(conn);\r\n\t\t\t\r\n\t\t\tlist.forEach(System.out::println);\r\n\t\t\t\r\n\t\t} catch (Exception e) {\r\n\t\t\te.printStackTrace();\r\n\t\t} finally {\r\n\t\t\tJDBCUtils.closeResource(conn, null);\r\n\t\t}\r\n\t\t\r\n\t}\r\n\r\n\t@Test\r\n\tvoid testGetCount() {\r\n\t\tConnection conn = null;\r\n\t\ttry {\r\n\t\t\tconn = JDBCUtils.getConnection();\r\n\t\t\t\r\n\t\t\tLong count = dao.getCount(conn);\r\n\t\t\t\r\n\t\t\tSystem.out.println(\"\u8868\u4e2d\u7684\u8bb0\u5f55\u6570\u4e3a\uff1a\" + count);\r\n\t\t} catch (Exception e) {\r\n\t\t\te.printStackTrace();\r\n\t\t} finally {\r\n\t\t\tJDBCUtils.closeResource(conn, null);\r\n\t\t}\r\n\t\t\r\n\t}\r\n\r\n\t@Test\r\n\tvoid testGetMaxBirth() {\r\n\t\tConnection conn = null;\r\n\t\ttry {\r\n\t\t\tconn = JDBCUtils.getConnection();\r\n\t\t\t\r\n\t\t\tDate maxBirth = dao.getMaxBirth(conn);\r\n\t\t\t\r\n\t\t\tSystem.out.println(\"\u6700\u5927\u7684\u751f\u65e5\u4e3a\uff1a\" + maxBirth);\r\n\t\t} catch (Exception e) {\r\n\t\t\te.printStackTrace();\r\n\t\t} finally {\r\n\t\t\tJDBCUtils.closeResource(conn, null);\r\n\t\t}\r\n\t\t\r\n\t}\r\n\r\n}\r\n<\/code><\/pre>\n\n\n\n<p>OrderDAO\u793a\u4f8b \u540cCustomerDAO\u4e00\u6837<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>package top.qaqaq.P44.dao;\r\n\r\npublic interface OrderDAO {\r\n\r\n}\r\n<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>package top.qaqaq.P44.dao;\r\n\r\nimport top.qaqaq.P42.dao.BaseDAO;\r\n\r\npublic class OrderDAOImpl extends BaseDAO implements OrderDAO {\r\n\r\n}\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>OrderDAO\u793a\u4f8b \u540cCustomerDAO\u4e00\u6837<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38],"tags":[48],"class_list":["post-1867","post","type-post","status-publish","format-standard","hentry","category-jdbc-code","tag-jdbc"],"_links":{"self":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/1867"}],"collection":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1867"}],"version-history":[{"count":1,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/1867\/revisions"}],"predecessor-version":[{"id":1868,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/1867\/revisions\/1868"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1867"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1867"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1867"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}