{"id":1776,"date":"2022-11-26T22:28:22","date_gmt":"2022-11-26T14:28:22","guid":{"rendered":"https:\/\/qaqaq.top\/?p=1776"},"modified":"2022-11-27T12:40:30","modified_gmt":"2022-11-27T04:40:30","slug":"%e9%92%88%e5%af%b9customers%e8%a1%a8%e7%9a%84%e6%9f%a5%e8%af%a2%e6%93%8d%e4%bd%9c%e4%b8%be%e4%be%8b%e3%80%81%e9%92%88%e5%af%b9customers%e8%a1%a8%e7%9a%84%e9%80%9a%e7%94%a8%e7%9a%84%e6%9f%a5%e8%af%a2","status":"publish","type":"post","link":"https:\/\/qaqaq.top\/?p=1776","title":{"rendered":"\u9488\u5bf9customers\u8868\u7684\u67e5\u8be2\u64cd\u4f5c\u4e3e\u4f8b\u3001\u9488\u5bf9customers\u8868\u7684\u901a\u7528\u7684\u67e5\u8be2\u64cd\u4f5c"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>package top.qaqaq.P17.preparedstatement.crud;\r\n\r\nimport java.lang.reflect.Field;\r\nimport java.sql.Connection;\r\nimport java.sql.Date;\r\nimport java.sql.PreparedStatement;\r\nimport java.sql.ResultSet;\r\nimport java.sql.ResultSetMetaData;\r\nimport java.sql.SQLException;\r\n\r\nimport org.junit.Test;\r\n\r\nimport top.qaqaq.P14.util.JDBCUtils;\r\nimport top.qaqaq.P17.bean.Customer;\r\n\r\n\/**\r\n * \r\n* @Description\t\u9488\u5bf9\u4e8eCustomers\u8868\u7684\u67e5\u8be2\u64cd\u4f5c\r\n* @author RichieZhang Email:18358892@qq.com\r\n* @version\r\n* @date 2022\u5e7411\u670826\u65e5\u4e0b\u53484:55:42\r\n*\r\n *\/\r\npublic class CustomerForQuery {\r\n\t\r\n\t@Test\r\n\tpublic void testQueryForCustomers() {\r\n\t\t\r\n\t\tString sql = \"select id,name,birth,email from customers where id = ?\";\r\n\t\tCustomer customer = queryForCustomers(sql,13);\r\n\t\tSystem.out.println(customer);\r\n\t\t\r\n\t\tsql = \"select name,email from customers where name = ?\";\r\n\t\tCustomer customer1 = queryForCustomers(sql, \"\u5468\u6770\u4f26\");\r\n\t\tSystem.out.println(customer1);\r\n\t}\r\n\t\r\n\t\/**\r\n\t * \r\n\t* @Description \t\u9488\u5bf9\u4e8ecustomers\u8868\u7684\u901a\u7528\u7684\u67e5\u8be2\u64cd\u4f5c\r\n\t* @author RichieZhang\r\n\t * @throws Exception \r\n\t* @date 2022\u5e7411\u670826\u65e5\u4e0b\u53485:58:44\r\n\t *\/\r\n\tpublic Customer queryForCustomers(String sql, Object ...args) {\r\n\t\tConnection conn = null;\r\n\t\tPreparedStatement ps = null;\r\n\t\tResultSet rs = null;\r\n\t\ttry {\r\n\t\t\tconn = JDBCUtils.getConnection();\r\n\t\t\t\r\n\t\t\tps = conn.prepareStatement(sql);\r\n\t\t\tfor(int i = 0; i &lt; args.length; i++) {\r\n\t\t\t\tps.setObject(i + 1, args&#91;i]);\r\n\t\t\t}\r\n\t\t\t\r\n\t\t\trs = ps.executeQuery();\r\n\t\t\t\/\/\u83b7\u53d6\u7ed3\u679c\u96c6\u7684\u5143\u6570\u636e : ResultSetMetaData\r\n\t\t\tResultSetMetaData rsmd = rs.getMetaData();\r\n\t\t\t\/\/\u901a\u8fc7ResultSetMetaData\u83b7\u53d6\u7ed3\u679c\u96c6\u4e2d\u7684\u5217\u6570\r\n\t\t\tint columnCount = rsmd.getColumnCount();\r\n\t\t\t\r\n\t\t\tif(rs.next()) {\r\n\t\t\t\tCustomer cust = new Customer();\r\n\t\t\t\t\/\/\u5904\u7406\u7ed3\u679c\u96c6\u4e00\u884c\u6570\u636e\u4e2d\u7684\u6bcf\u4e00\u4e2a\u5217\r\n\t\t\t\tfor(int i = 0; i &lt; columnCount; i++) {\r\n\t\t\t\t\t\/\/\u83b7\u53d6\u5217\u503c\r\n\t\t\t\t\tObject columnvalue = rs.getObject(i + 1);\r\n\t\t\t\t\t\r\n\t\t\t\t\t\/\/\u83b7\u53d6\u6bcf\u4e2a\u5217\u7684\u5217\u540d\r\n\/\/\t\t\t\t\tString columnName = rsmd.getColumnName(i + 1);\r\n\t\t\t\t\tString columnLabel = rsmd.getColumnLabel(i + 1);\r\n\t\t\t\t\t\r\n\t\t\t\t\t\/\/\u7ed9cust\u5bf9\u8c61\u6307\u5b9a\u7684columnName\u5c5e\u6027\uff0c\u8d4b\u503c\u4e3acolumnvalue\uff1b\u901a\u8fc7\u53cd\u5c04\r\n\t\t\t\t\tField field = Customer.class.getDeclaredField(columnLabel);\r\n\t\t\t\t\tfield.setAccessible(true);\r\n\t\t\t\t\tfield.set(cust, columnvalue);\r\n\t\t\t\t\t\r\n\t\t\t\t}\r\n\t\t\t\treturn cust;\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, ps, rs);\r\n\t\t}\r\n\t\t\r\n\t\treturn null;\r\n\t}\r\n\r\n\t@Test\r\n\tpublic void testQuery1() {\r\n\t\tConnection conn = null;\r\n\t\tPreparedStatement ps = null;\r\n\t\tResultSet resultSet = null;\r\n\t\ttry {\r\n\t\t\tconn = JDBCUtils.getConnection();\r\n\t\t\tString sql = \"select id,name,email,birth from customers where id = ?\";\r\n\t\t\tps = conn.prepareStatement(sql);\r\n\t\t\tps.setObject(1, 1);\r\n\t\t\t\r\n\t\t\t\/\/\u6267\u884c\uff0c\u5e76\u8fd4\u56de\u7ed3\u679c\u96c6\r\n\t\t\tresultSet = ps.executeQuery();\r\n\t\t\t\/\/\u5904\u7406\u7ed3\u679c\u96c6\r\n\t\t\tif(resultSet.next()) {\/\/next():\u5224\u65ad\u7ed3\u679c\u96c6\u7684\u4e0b\u4e00\u6761\u662f\u5426\u6709\u6570\u636e\uff0c\u5982\u679c\u6709\u6570\u636e\u8fd4\u56detrue\uff0c\u5e76\u6307\u9488\u4e0b\u79fb\uff1b\u5982\u679c\u8fd4\u56defalse\uff0c\u6307\u9488\u4e0d\u4f1a\u4e0b\u79fb\u3002\r\n\t\t\t\t\r\n\t\t\t\t\/\/\u83b7\u53d6\u5f53\u524d\u8fd9\u6761\u6570\u636e\u7684\u5404\u4e2a\u5b57\u6bb5\u503c\r\n\t\t\t\tint id = resultSet.getInt(1);\r\n\t\t\t\tString name = resultSet.getString(2);\r\n\t\t\t\tString email = resultSet.getString(3);\r\n\t\t\t\tDate birth = resultSet.getDate(4);\r\n\t\t\t\t\r\n\t\t\t\t\/\/\u65b9\u5f0f\u4e00\uff1a\r\n\/\/\t\t\tSystem.out.println(\"id = \" + id + \",name = \" + name + \",email = \" + email + \",birth = \" + birth);\r\n\t\t\t\t\r\n\t\t\t\t\/\/\u65b9\u5f0f\u4e8c\uff1a\r\n\/\/\t\t\tObject&#91;] data = new Object&#91;] {id,name,email,birth};\r\n\t\t\t\t\r\n\t\t\t\t\/\/\u65b9\u5f0f\u4e09\uff1a\u5c06\u6570\u636e\u5c01\u88c5\u4e3a\u4e00\u4e2a\u5bf9\u8c61\uff08\u63a8\u8350\uff09\r\n\t\t\t\tCustomer customer = new Customer(id, name, email, birth);\r\n\t\t\t\tSystem.out.println(customer);\r\n\t\t\t\t\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\t\/\/\u5173\u95ed\u8d44\u6e90\r\n\t\t\tJDBCUtils.closeResource(conn, ps, resultSet);\r\n\t\t}\r\n\t\t\r\n\t}\r\n}\r\n<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>package top.qaqaq.P17.bean;\r\n\r\nimport java.sql.Date;\r\n\r\n\/*\r\n * ORM\u7f16\u7a0b\u601d\u60f3\uff08object relational mapping\uff09\r\n * \u4e00\u4e2a\u6570\u636e\u8868\u5bf9\u5e94\u4e00\u4e2ajava\u7c7b\r\n * \u8868\u4e2d\u7684\u4e00\u6761\u8bb0\u5f55\u5bf9\u5e94java\u7c7b\u7684\u4e00\u4e2a\u5bf9\u8c61\r\n * \u8868\u4e2d\u7684\u4e00\u4e2a\u5b57\u6bb5\u5bf9\u5e94java\u7c7b\u7684\u4e00\u4e2a\u5c5e\u6027\r\n * \r\n *\/\r\npublic class Customer {\r\n\r\n\tprivate int id;\r\n\tprivate String name;\r\n\tprivate String email;\r\n\tprivate Date birth;\r\n\r\n\tpublic Customer() {\r\n\t}\r\n\r\n\tpublic Customer(int id, String name, String email, Date birth) {\r\n\t\tthis.id = id;\r\n\t\tthis.name = name;\r\n\t\tthis.email = email;\r\n\t\tthis.birth = birth;\r\n\t}\r\n\r\n\tpublic int getId() {\r\n\t\treturn id;\r\n\t}\r\n\r\n\tpublic void setId(int id) {\r\n\t\tthis.id = id;\r\n\t}\r\n\r\n\tpublic String getName() {\r\n\t\treturn name;\r\n\t}\r\n\r\n\tpublic void setName(String name) {\r\n\t\tthis.name = name;\r\n\t}\r\n\r\n\tpublic String getEmail() {\r\n\t\treturn email;\r\n\t}\r\n\r\n\tpublic void setEmail(String email) {\r\n\t\tthis.email = email;\r\n\t}\r\n\r\n\tpublic Date getBirth() {\r\n\t\treturn birth;\r\n\t}\r\n\r\n\tpublic void setBirth(Date birth) {\r\n\t\tthis.birth = birth;\r\n\t}\r\n\r\n\t@Override\r\n\tpublic String toString() {\r\n\t\treturn \"Customer &#91;id=\" + id + \", name=\" + name + \", email=\" + email + \", birth=\" + birth + \"]\";\r\n\t}\r\n\r\n}\r\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-1776","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\/1776"}],"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=1776"}],"version-history":[{"count":1,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/1776\/revisions"}],"predecessor-version":[{"id":1778,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/1776\/revisions\/1778"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}