{"id":1821,"date":"2022-11-27T23:19:14","date_gmt":"2022-11-27T15:19:14","guid":{"rendered":"https:\/\/qaqaq.top\/?p=1821"},"modified":"2022-12-19T20:21:55","modified_gmt":"2022-12-19T12:21:55","slug":"%e8%af%be%e5%90%8e%e7%bb%83%e4%b9%a01","status":"publish","type":"post","link":"https:\/\/qaqaq.top\/?p=1821","title":{"rendered":"\u589e\u5220\u6539\u67e5\u8bfe\u540e\u7ec3\u4e601"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>package top.qaqaq.P25.exer;\n\nimport java.sql.Connection;\nimport java.sql.PreparedStatement;\nimport java.sql.SQLException;\nimport java.util.Scanner;\n\nimport org.junit.Test;\n\nimport top.qaqaq.P14.util.JDBCUtils;\n\n\/\/\u8bfe\u540e\u7ec3\u4e601\npublic class Exer1Test {\n\t\n\t@Test\n\tpublic void testInsert() {\n\t\tScanner scanner = new Scanner(System.in);\n\t\tSystem.out.print(\"\u8bf7\u8f93\u5165\u7528\u6237\u540d\uff1a\");\n\t\tString name = scanner.next();\n\t\tSystem.out.print(\"\u8bf7\u8f93\u5165\u90ae\u7bb1\uff1a\");\n\t\tString email = scanner.next();\n\t\tSystem.out.print(\"\u8bf7\u8f93\u5165\u751f\u65e5\uff1a\");\n\t\tString birthday = scanner.next();\/\/'1992-09-08'\n\t\t\n\t\tString sql = \"insert into customers(name,email,birth)values(?,?,?)\";\n\t\tint insertCount = update(sql,name,email,birthday);\n\t\tif(insertCount &gt; 0) {\n\t\t\tSystem.out.println(\"\u6dfb\u52a0\u6210\u529f\");\n\t\t}else {\n\t\t\tSystem.out.println(\"\u6dfb\u52a0\u5931\u8d25\");\n\t\t}\n\t\t\n\t}\n\t\n\t\/\/\u901a\u7528\u7684\u589e\u5220\u6539\u64cd\u4f5c\n\tpublic int update(String sql,Object ...args) {\/\/sql\u4e2d\u5360\u4f4d\u7b26\u7684\u4e2a\u6570\u4e0e\u53ef\u53d8\u5f62\u53c2\u7684\u957f\u5ea6\u76f8\u540c\uff01\n\t\tConnection conn = null;\n\t\tPreparedStatement ps = null;\n\t\ttry {\n\t\t\t\/\/1.\u83b7\u53d6\u6570\u636e\u5e93\u7684\u8fde\u63a5\n\t\t\tconn = JDBCUtils.getConnection();\n\t\t\t\/\/2.\u9884\u7f16\u8bd1sql\u8bed\u53e5\uff0c\u8fd4\u56dePreparedStatement\u5b9e\u4f8b\n\t\t\tps = conn.prepareStatement(sql);\n\t\t\t\/\/3.\u586b\u5145\u5360\u4f4d\u7b26\n\t\t\tfor(int i = 0; i &lt; args.length; i++) {\n\t\t\t\tps.setObject(i + 1, args&#91;i]);\/\/\u5c0f\u5fc3\u53c2\u6570\u58f0\u660e\u9519\u8bef\uff01\uff01\n\t\t\t}\n\t\t\t\/\/4.\u6267\u884c\n\t\t\t\/*\n\t\t\t * ps.execute();\n\t\t\t * \u5982\u679c\u6267\u884c\u7684\u662f\u67e5\u8be2\u64cd\u4f5c\uff0c\u6709\u8fd4\u56de\u7ed3\u679c\uff0c\u5219\u6b64\u65b9\u6cd5\u8fd4\u56detrue;\n\t\t\t * \u5982\u679c\u6267\u884c\u7684\u662f\u589e\u3001\u5220\u3001\u6539\u64cd\u4f5c\uff0c\u6ca1\u6709\u8fd4\u56de\u7ed3\u679c\uff0c\u5219\u6b64\u65b9\u6cd5\u8fd4\u56defalse.\n\t\t\t *\/\n\t\t\t\/\/\u65b9\u5f0f\u4e00\uff1a\n\/\/\t\t\treturn ps.execute();\n\t\t\t\/\/\u65b9\u5f0f\u4e8c\uff1a\n\t\t\treturn ps.executeUpdate();\n\t\t} catch (SQLException e) {\n\t\t\t\/\/ TODO Auto-generated catch block\n\t\t\te.printStackTrace();\n\t\t} catch (Exception e) {\n\t\t\t\/\/ TODO Auto-generated catch block\n\t\t\te.printStackTrace();\n\t\t}finally {\n\t\t\t\/\/5.\u8d44\u6e90\u7684\u5173\u95ed\n\t\t\tJDBCUtils.closeResource(conn, ps);\n\t\t}\n\t\t\n\t\treturn 0;\n\t}\n\n}\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","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-1821","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\/1821"}],"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=1821"}],"version-history":[{"count":2,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/1821\/revisions"}],"predecessor-version":[{"id":2675,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/1821\/revisions\/2675"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1821"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1821"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1821"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}