{"id":516,"date":"2023-04-28T13:10:57","date_gmt":"2023-04-14T12:18:18","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/index.php\/2023\/11\/30\/hibernate%e5%8e%9f%e7%94%9fsql%e6%9f%a5%e8%af%a2%e7%a4%ba%e4%be%8b%e7%9a%84%e4%be%8b%e5%ad%90\/"},"modified":"2025-08-02T15:10:21","modified_gmt":"2025-08-02T07:10:21","slug":"hibernate%e5%8e%9f%e7%94%9fsql%e6%9f%a5%e8%af%a2%e7%a4%ba%e4%be%8b%e7%9a%84%e4%be%8b%e5%ad%90","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/hibernate%e5%8e%9f%e7%94%9fsql%e6%9f%a5%e8%af%a2%e7%a4%ba%e4%be%8b%e7%9a%84%e4%be%8b%e5%ad%90\/","title":{"rendered":"Hibernate\u539f\u751fSQL\u67e5\u8be2\u6559\u7a0b\uff1a10\u4e2a\u5b9e\u7528\u793a\u4f8b\u8be6\u89e3"},"content":{"rendered":"<h1>Hibernate\u539f\u751fSQL\u67e5\u8be2\u793a\u4f8b\u6559\u7a0b<\/h1>\n<p>\u6b22\u8fce\u6765\u5230Hibernate\u539f\u751fSQL\u67e5\u8be2\u793a\u4f8b\u6559\u7a0b\u3002\u4e4b\u524d\u6211\u4eec\u5df2\u7ecf\u4ecb\u7ecd\u4e86Hibernate\u67e5\u8be2\u8bed\u8a00\u548cHibernate Criteria\u67e5\u8be2\uff0c\u4eca\u5929\u6211\u4eec\u5c06\u901a\u8fc7\u5b9e\u4f8b\u6765\u5b66\u4e60Hibernate\u539f\u751fSQL\u67e5\u8be2\u7684\u4f7f\u7528\u65b9\u6cd5\u3002<\/p>\n<h2>Hibernate SQL\u67e5\u8be2\u6982\u8ff0<\/h2>\n<p>\u901a\u8fc7\u4f7f\u7528SQLQuery\u5bf9\u8c61\uff0cHibernate\u63d0\u4f9b\u4e86\u6267\u884c\u672c\u5730SQL\u67e5\u8be2\u7684\u9009\u9879\u3002\u5f53\u6211\u4eec\u9700\u8981\u6267\u884c\u4e0d\u88abHibernate API\u652f\u6301\u7684\u7279\u5b9a\u4e8e\u6570\u636e\u5e93\u4f9b\u5e94\u5546\u7684\u67e5\u8be2\u65f6\uff0cHibernate SQL\u67e5\u8be2\u975e\u5e38\u65b9\u4fbf\u3002\u4f8b\u5982\uff0c\u5728Oracle\u6570\u636e\u5e93\u4e2d\u4f7f\u7528\u67e5\u8be2\u63d0\u793a\u6216CONNECT\u5173\u952e\u5b57\u3002\u5bf9\u4e8e\u6b63\u5e38\u60c5\u51b5\uff0c\u4e0d\u63a8\u8350\u4f7f\u7528Hibernate SQL\u67e5\u8be2\uff0c\u56e0\u4e3a\u6211\u4eec\u4f1a\u5931\u53bb\u4e0eHibernate\u5173\u8054\u548cHibernate\u4e00\u7ea7\u7f13\u5b58\u76f8\u5173\u7684\u597d\u5904\u3002\u6211\u5c06\u4f7f\u7528MySQL\u6570\u636e\u5e93\uff0c\u5e76\u4f7f\u7528\u4e0eHQL\u793a\u4f8b\u76f8\u540c\u7684\u8868\u548c\u6570\u636e\u8bbe\u7f6e\uff0c\u8bf7\u60a8\u5148\u67e5\u770bHQL\u793a\u4f8b\u4ee5\u4e86\u89e3\u8868\u548c\u5bf9\u5e94\u7684\u6a21\u578b\u7c7b\u6620\u5c04\u3002<\/p>\n<h3>Hibernate\u539f\u751fSQL\u793a\u4f8b<\/h3>\n<p>\u5bf9\u4e8eHibernate\u539f\u751fSQL\u67e5\u8be2\uff0c\u6211\u4eec\u4f7f\u7528Session.createSQLQuery(String query)\u521b\u5efaSQLQuery\u5bf9\u8c61\u5e76\u6267\u884c\u5b83\u3002\u4f8b\u5982\uff0c\u5982\u679c\u4f60\u60f3\u4eceEmployee\u8868\u4e2d\u8bfb\u53d6\u6240\u6709\u8bb0\u5f55\uff0c\u53ef\u4ee5\u901a\u8fc7\u4ee5\u4e0b\u4ee3\u7801\u5b9e\u73b0\u3002<\/p>\n<pre class=\"post-pre\"><code>\/\/ \u51c6\u5907\u5de5\u4f5c\r\nSessionFactory sessionFactory = HibernateUtil.getSessionFactory();\r\nSession session = sessionFactory.getCurrentSession();\r\n\r\n\/\/ \u83b7\u53d6\u6240\u6709\u5458\u5de5\r\nTransaction tx = session.beginTransaction();\r\nSQLQuery query = session.createSQLQuery(\"select emp_id, emp_name, emp_salary from Employee\");\r\nList&lt;Object[]&gt; rows = query.list();\r\nfor(Object[] row : rows){\r\n\tEmployee emp = new Employee();\r\n\temp.setId(Long.parseLong(row[0].toString()));\r\n\temp.setName(row[1].toString());\r\n\temp.setSalary(Double.parseDouble(row[2].toString()));\r\n\tSystem.out.println(emp);\r\n}\r\n<\/code><\/pre>\n<p>\u5f53\u6211\u4eec\u5bf9\u73b0\u6709\u6570\u636e\u6267\u884c\u4e0a\u8ff0\u4ee3\u7801\u65f6\uff0c\u5b83\u4f1a\u4ea7\u751f\u4ee5\u4e0b\u8f93\u51fa\u7ed3\u679c\u3002<\/p>\n<pre class=\"post-pre\"><code>Hibernate: select emp_id, emp_name, emp_salary from Employee\r\nId= 1, Name= Pankaj, Salary= 100.0, {Address= null}\r\nId= 2, Name= David, Salary= 200.0, {Address= null}\r\nId= 3, Name= Lisa, Salary= 300.0, {Address= null}\r\nId= 4, Name= Jack, Salary= 400.0, {Address= null}\r\n<\/code><\/pre>\n<p>\u8bf7\u6ce8\u610f\uff0clist()\u65b9\u6cd5\u8fd4\u56de\u7684\u662f\u5bf9\u8c61\u6570\u7ec4\u7684\u5217\u8868\uff0c\u6211\u4eec\u9700\u8981\u660e\u786e\u5730\u5c06\u5b83\u4eec\u89e3\u6790\u4e3adouble\u3001long\u7b49\u7c7b\u578b\u3002\u6211\u4eec\u7684Employee\u548cAddress\u7c7b\u7684toString()\u65b9\u6cd5\u5b9e\u73b0\u5982\u4e0b\u3002<\/p>\n<pre class=\"post-pre\"><code>@Override\r\npublic String toString() {\r\n\treturn \"Id= \" + id + \", Name= \" + name + \", Salary= \" + salary\r\n\t\t\t+ \", {Address= \" + address + \"}\";\r\n}\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>@Override\r\npublic String toString() {\r\n\treturn \"AddressLine1= \" + addressLine1 + \", City=\" + city\r\n\t\t\t+ \", Zipcode=\" + zipcode;\r\n}\r\n<\/code><\/pre>\n<p>\u6ce8\u610f\u5230\u6211\u4eec\u7684\u67e5\u8be2\u672a\u8fd4\u56de\u5730\u5740\u6570\u636e\uff0c\u800c\u5982\u679c\u6211\u4eec\u4f7f\u7528HQL\u67e5\u8be2&#8221;from Employee&#8221;\uff0c\u5b83\u8fd8\u4f1a\u8fd4\u56de\u5173\u8054\u8868\u6570\u636e\u3002<\/p>\n<h3>\u4f7f\u7528Hibernate\u7684SQL\u67e5\u8be2\u6dfb\u52a0addScalar\u65b9\u6cd5<\/h3>\n<p>Hibernate\u4f7f\u7528ResultSetMetadata\u6765\u63a8\u65ad\u67e5\u8be2\u8fd4\u56de\u7684\u5217\u7684\u7c7b\u578b\uff0c\u4ece\u6027\u80fd\u7684\u89d2\u5ea6\u6765\u770b\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528addScalar()\u65b9\u6cd5\u6765\u5b9a\u4e49\u5217\u7684\u6570\u636e\u7c7b\u578b\u3002\u7136\u800c\uff0c\u6211\u4eec\u4ecd\u7136\u4f1a\u4ee5\u5bf9\u8c61\u6570\u7ec4\u7684\u5f62\u5f0f\u83b7\u53d6\u6570\u636e\u3002<\/p>\n<pre class=\"post-pre\"><code>\/\/\u83b7\u53d6\u6240\u6709\u5458\u5de5 - addScalar\u793a\u4f8b\r\nquery = session.createSQLQuery(\"select emp_id, emp_name, emp_salary from Employee\")\r\n\t\t.addScalar(\"emp_id\", new LongType())\r\n\t\t.addScalar(\"emp_name\", new StringType())\r\n\t\t.addScalar(\"emp_salary\", new DoubleType());\r\nrows = query.list();\r\nfor(Object[] row : rows){\r\n\tEmployee emp = new Employee();\r\n\temp.setId(Long.parseLong(row[0].toString()));\r\n\temp.setName(row[1].toString());\r\n\temp.setSalary(Double.parseDouble(row[2].toString()));\r\n\tSystem.out.println(emp);\r\n}\r\n<\/code><\/pre>\n<p>\u5f53\u6570\u636e\u91cf\u5de8\u5927\u65f6\uff0c\u751f\u6210\u7684\u8f93\u51fa\u7ed3\u679c\u5c06\u4f1a\u76f8\u540c\uff0c\u4f46\u6211\u4eec\u5c06\u4f1a\u770b\u5230\u8f7b\u5fae\u7684\u6027\u80fd\u6539\u5584\u3002<\/p>\n<h3>\u4f7f\u7528Hibernate\u539f\u751fSQL\u67e5\u8be2\u591a\u4e2a\u8868<\/h3>\n<p>\u5982\u679c\u6211\u4eec\u60f3\u4ece\u5458\u5de5\u8868\u548c\u5730\u5740\u8868\u4e2d\u83b7\u53d6\u6570\u636e\uff0c\u6211\u4eec\u53ef\u4ee5\u7b80\u5355\u5730\u7f16\u5199SQL\u67e5\u8be2\u5e76\u89e3\u6790\u7ed3\u679c\u96c6\u3002<\/p>\n<pre class=\"post-pre\"><code>query = session.createSQLQuery(\"select e.emp_id, emp_name, emp_salary,address_line1, city, \r\n\tzipcode from Employee e, Address a where a.emp_id=e.emp_id\");\r\nrows = query.list();\r\nfor(Object[] row : rows){\r\n\tEmployee emp = new Employee();\r\n\temp.setId(Long.parseLong(row[0].toString()));\r\n\temp.setName(row[1].toString());\r\n\temp.setSalary(Double.parseDouble(row[2].toString()));\r\n\tAddress address = new Address();\r\n\taddress.setAddressLine1(row[3].toString());\r\n\taddress.setCity(row[4].toString());\r\n\taddress.setZipcode(row[5].toString());\r\n\temp.setAddress(address);\r\n\tSystem.out.println(emp);\r\n}\r\n<\/code><\/pre>\n<p>\u5bf9\u4e8e\u4e0a\u8ff0\u4ee3\u7801\uff0c\u4ea7\u751f\u7684\u8f93\u51fa\u5c06\u4f1a\u5982\u4e0b\u3002<\/p>\n<pre class=\"post-pre\"><code>Hibernate: select e.emp_id, emp_name, emp_salary,address_line1, city, zipcode from Employee e, Address a where a.emp_id=e.emp_id\r\nId= 1, Name= Pankaj, Salary= 100.0, {Address= AddressLine1= Albany Dr, City=San Jose, Zipcode=95129}\r\nId= 2, Name= David, Salary= 200.0, {Address= AddressLine1= Arques Ave, City=Santa Clara, Zipcode=95051}\r\nId= 3, Name= Lisa, Salary= 300.0, {Address= AddressLine1= BTM 1st Stage, City=Bangalore, Zipcode=560100}\r\nId= 4, Name= Jack, Salary= 400.0, {Address= AddressLine1= City Centre, City=New Delhi, Zipcode=100100}\r\n<\/code><\/pre>\n<h3>Hibernate\u672c\u5730SQL\u5b9e\u4f53\u548c\u8fde\u63a5<\/h3>\n<p>\u6211\u4eec\u8fd8\u53ef\u4ee5\u4f7f\u7528addEntity()\u548caddJoin()\u65b9\u6cd5\u901a\u8fc7\u8868\u8054\u63a5\u4ece\u5173\u8054\u8868\u4e2d\u83b7\u53d6\u6570\u636e\u3002\u4f8b\u5982\uff0c\u53ef\u4ee5\u6309\u7167\u4ee5\u4e0b\u65b9\u5f0f\u68c0\u7d22\u4e0a\u8ff0\u6570\u636e\u3002<\/p>\n<pre class=\"post-pre\"><code>\/\/\u4f7f\u7528addEntity\u548caddJoin\u7684\u8054\u63a5\u793a\u4f8b\r\nquery = session.createSQLQuery(\"select {e.*}, {a.*} from Employee e join Address a ON e.emp_id=a.emp_id\")\r\n\t\t.addEntity(\"e\",Employee.class)\r\n\t\t.addJoin(\"a\",\"e.address\");\r\nrows = query.list();\r\nfor (Object[] row : rows) {\r\n    for(Object obj : row) {\r\n    \tSystem.out.print(obj + \"::\");\r\n    }\r\n    System.out.println(\"\\n\");\r\n}\r\n\/\/\u4e0a\u8ff0\u8054\u63a5\u5728\u6570\u7ec4\u4e2d\u8fd4\u56deEmployee\u548cAddress\u5bf9\u8c61\r\nfor (Object[] row : rows) {\r\n\tEmployee e = (Employee) row[0];\r\n\tSystem.out.println(\"Employee Info::\"+e);\r\n\tAddress a = (Address) row[1];\r\n\tSystem.out.println(\"Address Info::\"+a);\r\n}\r\n<\/code><\/pre>\n<p>\u4f7f\u7528`{[\u522b\u540d].*}`\u53ef\u4ee5\u8fd4\u56de\u5b9e\u4f53\u7684\u6240\u6709\u5c5e\u6027\u3002\u5f53\u6211\u4eec\u5728\u4e0a\u8ff0\u7c7b\u4f3c\u7684\u8054\u63a5\u67e5\u8be2\u4e2d\u4f7f\u7528addEntity()\u548caddJoin()\u65b9\u6cd5\u65f6\uff0c\u5b83\u4f1a\u8fd4\u56de\u4e24\u4e2a\u5bf9\u8c61\uff0c\u5982\u4e0a\u6240\u793a\u3002\u4e0a\u8ff0\u4ee3\u7801\u751f\u6210\u7684\u8f93\u51fa\u5982\u4e0b\u6240\u793a\u3002<\/p>\n<pre class=\"post-pre\"><code>Hibernate: select e.emp_id as emp_id1_1_0_, e.emp_name as emp_name2_1_0_, e.emp_salary as emp_sala3_1_0_, a.emp_id as emp_id1_0_1_, a.address_line1 as address_2_0_1_, a.city as city3_0_1_, a.zipcode as zipcode4_0_1_ from Employee e join Address a ON e.emp_id=a.emp_id\r\nId= 1, Name= Pankaj, Salary= 100.0, {Address= AddressLine1= Albany Dr, City=San Jose, Zipcode=95129}::AddressLine1= Albany Dr, City=San Jose, Zipcode=95129::\r\n\r\nId= 2, Name= David, Salary= 200.0, {Address= AddressLine1= Arques Ave, City=Santa Clara, Zipcode=95051}::AddressLine1= Arques Ave, City=Santa Clara, Zipcode=95051::\r\n\r\nId= 3, Name= Lisa, Salary= 300.0, {Address= AddressLine1= BTM 1st Stage, City=Bangalore, Zipcode=560100}::AddressLine1= BTM 1st Stage, City=Bangalore, Zipcode=560100::\r\n\r\nId= 4, Name= Jack, Salary= 400.0, {Address= AddressLine1= City Centre, City=New Delhi, Zipcode=100100}::AddressLine1= City Centre, City=New Delhi, Zipcode=100100::\r\n\r\nEmployee Info::Id= 1, Name= Pankaj, Salary= 100.0, {Address= AddressLine1= Albany Dr, City=San Jose, Zipcode=95129}\r\nAddress Info::AddressLine1= Albany Dr, City=San Jose, Zipcode=95129\r\nEmployee Info::Id= 2, Name= David, Salary= 200.0, {Address= AddressLine1= Arques Ave, City=Santa Clara, Zipcode=95051}\r\nAddress Info::AddressLine1= Arques Ave, City=Santa Clara, Zipcode=95051\r\nEmployee Info::Id= 3, Name= Lisa, Salary= 300.0, {Address= AddressLine1= BTM 1st Stage, City=Bangalore, Zipcode=560100}\r\nAddress Info::AddressLine1= BTM 1st Stage, City=Bangalore, Zipcode=560100\r\nEmployee Info::Id= 4, Name= Jack, Salary= 400.0, {Address= AddressLine1= City Centre, City=New Delhi, Zipcode=100100}\r\nAddress Info::AddressLine1= City Centre, City=New Delhi, Zipcode=100100\r\n<\/code><\/pre>\n<p>\u4f60\u53ef\u4ee5\u5728MySQL\u5ba2\u6237\u7aef\u8fd0\u884c\u8fd9\u4e24\u4e2a\u67e5\u8be2\uff0c\u4f1a\u6ce8\u610f\u5230\u4ea7\u751f\u7684\u8f93\u51fa\u7ed3\u679c\u662f\u76f8\u540c\u7684\u3002<\/p>\n<pre class=\"post-pre\"><code>mysql&gt; select e.emp_id as emp_id1_1_0_, e.emp_name as emp_name2_1_0_, e.emp_sala3_1_0_, a.emp_id as emp_id1_0_1_, a.address_line1 as address_2_0_1_, a.city as city3_0_1_, a.zipcode as zipcode4_0_1_ from Employee e join Address a ON e.emp_id=a.emp_id;\r\n+--------------+----------------+----------------+--------------+----------------+-------------+---------------+\r\n| emp_id1_1_0_ | emp_name2_1_0_ | emp_sala3_1_0_ | emp_id1_0_1_ | address_2_0_1_ | city3_0_1_  | zipcode4_0_1_ |\r\n+--------------+----------------+----------------+--------------+----------------+-------------+---------------+\r\n|            1 | Pankaj         |            100 |            1 | Albany Dr      | San Jose    | 95129         |\r\n|            2 | David          |            200 |            2 | Arques Ave     | Santa Clara | 95051         |\r\n|            3 | Lisa           |            300 |            3 | BTM 1st Stage  | Bangalore   | 560100        |\r\n|            4 | Jack           |            400 |            4 | City Centre    | New Delhi   | 100100        |\r\n+--------------+----------------+----------------+--------------+----------------+-------------+---------------+\r\n4 rows in set (0.00 sec)\r\n\r\nmysql&gt; select e.emp_id, emp_name, emp_salary,address_line1, city, zipcode from Employee e, Address a where a.emp_id=e.emp_id;\r\n+--------+----------+------------+---------------+-------------+---------+\r\n| emp_id | emp_name | emp_salary | address_line1 | city        | zipcode |\r\n+--------+----------+------------+---------------+-------------+---------+\r\n|      1 | Pankaj   |        100 | Albany Dr     | San Jose    | 95129   |\r\n|      2 | David    |        200 | Arques Ave    | Santa Clara | 95051   |\r\n|      3 | Lisa     |        300 | BTM 1st Stage | Bangalore   | 560100  |\r\n|      4 | Jack     |        400 | City Centre   | New Delhi   | 100100  |\r\n+--------+----------+------------+---------------+-------------+---------+\r\n4 rows in set (0.00 sec)\r\n\r\nmysql&gt; \r\n<\/code><\/pre>\n<h3>\u4f7f\u7528\u5e26\u53c2\u6570\u7684Hibernate\u539f\u751fSQL\u67e5\u8be2<\/h3>\n<p>\u6211\u4eec\u4e5f\u53ef\u4ee5\u50cfJDBC PreparedStatement\u4e00\u6837\u5411Hibernate SQL\u67e5\u8be2\u4f20\u9012\u53c2\u6570\u3002\u53ef\u4ee5\u4f7f\u7528\u53c2\u6570\u540d\u79f0\u548c\u7d22\u5f15\u4e24\u79cd\u65b9\u5f0f\u6765\u8bbe\u7f6e\u53c2\u6570\u503c\uff0c\u5982\u4e0b\u9762\u7684\u793a\u4f8b\u4ee3\u7801\u6240\u793a\u3002<\/p>\n<pre class=\"post-pre\"><code>query = session\r\n\t\t.createSQLQuery(\"select emp_id, emp_name, emp_salary from Employee where emp_id = ?\");\r\nList&lt;Object[]&gt; empData = query.setLong(0, 1L).list();\r\nfor (Object[] row : empData) {\r\n\tEmployee emp = new Employee();\r\n\temp.setId(Long.parseLong(row[0].toString()));\r\n\temp.setName(row[1].toString());\r\n\temp.setSalary(Double.parseDouble(row[2].toString()));\r\n\tSystem.out.println(emp);\r\n}\r\n\r\nquery = session\r\n\t\t.createSQLQuery(\"select emp_id, emp_name, emp_salary from Employee where emp_id = :id\");\r\nempData = query.setLong(\"id\", 2L).list();\r\nfor (Object[] row : empData) {\r\n\tEmployee emp = new Employee();\r\n\temp.setId(Long.parseLong(row[0].toString()));\r\n\temp.setName(row[1].toString());\r\n\temp.setSalary(Double.parseDouble(row[2].toString()));\r\n\tSystem.out.println(emp);\r\n}\r\n<\/code><\/pre>\n<p>\u4e0a\u8ff0\u4ee3\u7801\u4ea7\u751f\u7684\u8f93\u51fa\u5c06\u662f\uff1a<\/p>\n<pre class=\"post-pre\"><code>Hibernate: select emp_id, emp_name, emp_salary from Employee where emp_id = ?\r\n\u7f16\u53f7= 1, \u59d3\u540d= Pankaj, \u85aa\u8d44= 100.0, {\u5730\u5740= null}\r\nHibernate: select emp_id, emp_name, emp_salary from Employee where emp_id = ?\r\n\u7f16\u53f7= 2, \u59d3\u540d= David, \u85aa\u8d44= 200.0, {\u5730\u5740= null}\r\n<\/code><\/pre>\n<p>\u4ee5\u4e0a\u5c31\u662f\u5bf9Hibernate\u539f\u751fSQL\u67e5\u8be2\u7684\u7b80\u8981\u4ecb\u7ecd\u3002\u9700\u8981\u6ce8\u610f\u7684\u662f\uff0c\u9664\u975e\u9700\u8981\u6267\u884c\u7279\u5b9a\u4e8e\u6570\u636e\u5e93\u7684\u67e5\u8be2\uff0c\u5426\u5219\u5e94\u5c3d\u91cf\u907f\u514d\u4f7f\u7528\u539f\u751fSQL\u67e5\u8be2\uff0c\u800c\u4f18\u5148\u4f7f\u7528HQL\u6216Criteria API\u7b49Hibernate\u63d0\u4f9b\u7684\u67e5\u8be2\u65b9\u5f0f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hibernate\u539f\u751fSQL\u67e5\u8be2\u793a\u4f8b\u6559\u7a0b \u6b22\u8fce\u6765\u5230Hibernate\u539f\u751fSQL\u67e5\u8be2\u793a\u4f8b\u6559\u7a0b\u3002\u4e4b\u524d\u6211\u4eec\u5df2\u7ecf\u4ecb\u7ecd\u4e86 [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[981,761,1254,1540,1539],"class_list":["post-516","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-hibernate","tag-java","tag-orm","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Hibernate\u539f\u751fSQL\u67e5\u8be2\u6559\u7a0b\uff1a10\u4e2a\u5b9e\u7528\u793a\u4f8b\u8be6\u89e3 - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"\u672c\u6587\u8be6\u7ec6\u4ecb\u7ecdHibernate\u6846\u67b6\u4e2d\u539f\u751fSQL\u67e5\u8be2\u7684\u4f7f\u7528\u65b9\u6cd5\uff0c\u5305\u542b10\u4e2a\u5b9e\u7528\u793a\u4f8b\u4ece\u57fa\u7840\u5230\u9ad8\u7ea7\u3002\u5b66\u4e60\u5982\u4f55\u5728Hibernate\u4e2d\u6267\u884c\u539f\u751fSQL\u8bed\u53e5\uff0c\u5904\u7406\u7ed3\u679c\u96c6\uff0c\u4ee5\u53ca\u4f18\u5316\u67e5\u8be2\u6027\u80fd\u3002\u9002\u5408Java\u5f00\u53d1\u8005\u63d0\u5347\u6570\u636e\u5e93\u64cd\u4f5c\u6280\u80fd\u3002\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/hibernate\u539f\u751fsql\u67e5\u8be2\u793a\u4f8b\u7684\u4f8b\u5b50\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hibernate\u539f\u751fSQL\u67e5\u8be2\u6559\u7a0b\uff1a10\u4e2a\u5b9e\u7528\u793a\u4f8b\u8be6\u89e3\" \/>\n<meta property=\"og:description\" content=\"\u672c\u6587\u8be6\u7ec6\u4ecb\u7ecdHibernate\u6846\u67b6\u4e2d\u539f\u751fSQL\u67e5\u8be2\u7684\u4f7f\u7528\u65b9\u6cd5\uff0c\u5305\u542b10\u4e2a\u5b9e\u7528\u793a\u4f8b\u4ece\u57fa\u7840\u5230\u9ad8\u7ea7\u3002\u5b66\u4e60\u5982\u4f55\u5728Hibernate\u4e2d\u6267\u884c\u539f\u751fSQL\u8bed\u53e5\uff0c\u5904\u7406\u7ed3\u679c\u96c6\uff0c\u4ee5\u53ca\u4f18\u5316\u67e5\u8be2\u6027\u80fd\u3002\u9002\u5408Java\u5f00\u53d1\u8005\u63d0\u5347\u6570\u636e\u5e93\u64cd\u4f5c\u6280\u80fd\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/hibernate\u539f\u751fsql\u67e5\u8be2\u793a\u4f8b\u7684\u4f8b\u5b50\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-14T12:18:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-02T07:10:21+00:00\" \/>\n<meta name=\"author\" content=\"\u65b0, \u97f5\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u65b0, \u97f5\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/hibernate%e5%8e%9f%e7%94%9fsql%e6%9f%a5%e8%af%a2%e7%a4%ba%e4%be%8b%e7%9a%84%e4%be%8b%e5%ad%90\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/hibernate%e5%8e%9f%e7%94%9fsql%e6%9f%a5%e8%af%a2%e7%a4%ba%e4%be%8b%e7%9a%84%e4%be%8b%e5%ad%90\/\",\"name\":\"Hibernate\u539f\u751fSQL\u67e5\u8be2\u6559\u7a0b\uff1a10\u4e2a\u5b9e\u7528\u793a\u4f8b\u8be6\u89e3 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-04-14T12:18:18+00:00\",\"dateModified\":\"2025-08-02T07:10:21+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9\"},\"description\":\"\u672c\u6587\u8be6\u7ec6\u4ecb\u7ecdHibernate\u6846\u67b6\u4e2d\u539f\u751fSQL\u67e5\u8be2\u7684\u4f7f\u7528\u65b9\u6cd5\uff0c\u5305\u542b10\u4e2a\u5b9e\u7528\u793a\u4f8b\u4ece\u57fa\u7840\u5230\u9ad8\u7ea7\u3002\u5b66\u4e60\u5982\u4f55\u5728Hibernate\u4e2d\u6267\u884c\u539f\u751fSQL\u8bed\u53e5\uff0c\u5904\u7406\u7ed3\u679c\u96c6\uff0c\u4ee5\u53ca\u4f18\u5316\u67e5\u8be2\u6027\u80fd\u3002\u9002\u5408Java\u5f00\u53d1\u8005\u63d0\u5347\u6570\u636e\u5e93\u64cd\u4f5c\u6280\u80fd\u3002\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/hibernate%e5%8e%9f%e7%94%9fsql%e6%9f%a5%e8%af%a2%e7%a4%ba%e4%be%8b%e7%9a%84%e4%be%8b%e5%ad%90\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/hibernate%e5%8e%9f%e7%94%9fsql%e6%9f%a5%e8%af%a2%e7%a4%ba%e4%be%8b%e7%9a%84%e4%be%8b%e5%ad%90\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/hibernate%e5%8e%9f%e7%94%9fsql%e6%9f%a5%e8%af%a2%e7%a4%ba%e4%be%8b%e7%9a%84%e4%be%8b%e5%ad%90\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hibernate\u539f\u751fSQL\u67e5\u8be2\u6559\u7a0b\uff1a10\u4e2a\u5b9e\u7528\u793a\u4f8b\u8be6\u89e3\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9\",\"name\":\"\u65b0, \u97f5\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g\",\"caption\":\"\u65b0, \u97f5\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunxin\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/hibernate%e5%8e%9f%e7%94%9fsql%e6%9f%a5%e8%af%a2%e7%a4%ba%e4%be%8b%e7%9a%84%e4%be%8b%e5%ad%90\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Hibernate\u539f\u751fSQL\u67e5\u8be2\u6559\u7a0b\uff1a10\u4e2a\u5b9e\u7528\u793a\u4f8b\u8be6\u89e3 - Blog - Silicon Cloud","description":"\u672c\u6587\u8be6\u7ec6\u4ecb\u7ecdHibernate\u6846\u67b6\u4e2d\u539f\u751fSQL\u67e5\u8be2\u7684\u4f7f\u7528\u65b9\u6cd5\uff0c\u5305\u542b10\u4e2a\u5b9e\u7528\u793a\u4f8b\u4ece\u57fa\u7840\u5230\u9ad8\u7ea7\u3002\u5b66\u4e60\u5982\u4f55\u5728Hibernate\u4e2d\u6267\u884c\u539f\u751fSQL\u8bed\u53e5\uff0c\u5904\u7406\u7ed3\u679c\u96c6\uff0c\u4ee5\u53ca\u4f18\u5316\u67e5\u8be2\u6027\u80fd\u3002\u9002\u5408Java\u5f00\u53d1\u8005\u63d0\u5347\u6570\u636e\u5e93\u64cd\u4f5c\u6280\u80fd\u3002","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/hibernate\u539f\u751fsql\u67e5\u8be2\u793a\u4f8b\u7684\u4f8b\u5b50\/","og_locale":"zh_CN","og_type":"article","og_title":"Hibernate\u539f\u751fSQL\u67e5\u8be2\u6559\u7a0b\uff1a10\u4e2a\u5b9e\u7528\u793a\u4f8b\u8be6\u89e3","og_description":"\u672c\u6587\u8be6\u7ec6\u4ecb\u7ecdHibernate\u6846\u67b6\u4e2d\u539f\u751fSQL\u67e5\u8be2\u7684\u4f7f\u7528\u65b9\u6cd5\uff0c\u5305\u542b10\u4e2a\u5b9e\u7528\u793a\u4f8b\u4ece\u57fa\u7840\u5230\u9ad8\u7ea7\u3002\u5b66\u4e60\u5982\u4f55\u5728Hibernate\u4e2d\u6267\u884c\u539f\u751fSQL\u8bed\u53e5\uff0c\u5904\u7406\u7ed3\u679c\u96c6\uff0c\u4ee5\u53ca\u4f18\u5316\u67e5\u8be2\u6027\u80fd\u3002\u9002\u5408Java\u5f00\u53d1\u8005\u63d0\u5347\u6570\u636e\u5e93\u64cd\u4f5c\u6280\u80fd\u3002","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/hibernate\u539f\u751fsql\u67e5\u8be2\u793a\u4f8b\u7684\u4f8b\u5b50\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-04-14T12:18:18+00:00","article_modified_time":"2025-08-02T07:10:21+00:00","author":"\u65b0, \u97f5","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u65b0, \u97f5","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"1 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/hibernate%e5%8e%9f%e7%94%9fsql%e6%9f%a5%e8%af%a2%e7%a4%ba%e4%be%8b%e7%9a%84%e4%be%8b%e5%ad%90\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/hibernate%e5%8e%9f%e7%94%9fsql%e6%9f%a5%e8%af%a2%e7%a4%ba%e4%be%8b%e7%9a%84%e4%be%8b%e5%ad%90\/","name":"Hibernate\u539f\u751fSQL\u67e5\u8be2\u6559\u7a0b\uff1a10\u4e2a\u5b9e\u7528\u793a\u4f8b\u8be6\u89e3 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-04-14T12:18:18+00:00","dateModified":"2025-08-02T07:10:21+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9"},"description":"\u672c\u6587\u8be6\u7ec6\u4ecb\u7ecdHibernate\u6846\u67b6\u4e2d\u539f\u751fSQL\u67e5\u8be2\u7684\u4f7f\u7528\u65b9\u6cd5\uff0c\u5305\u542b10\u4e2a\u5b9e\u7528\u793a\u4f8b\u4ece\u57fa\u7840\u5230\u9ad8\u7ea7\u3002\u5b66\u4e60\u5982\u4f55\u5728Hibernate\u4e2d\u6267\u884c\u539f\u751fSQL\u8bed\u53e5\uff0c\u5904\u7406\u7ed3\u679c\u96c6\uff0c\u4ee5\u53ca\u4f18\u5316\u67e5\u8be2\u6027\u80fd\u3002\u9002\u5408Java\u5f00\u53d1\u8005\u63d0\u5347\u6570\u636e\u5e93\u64cd\u4f5c\u6280\u80fd\u3002","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/hibernate%e5%8e%9f%e7%94%9fsql%e6%9f%a5%e8%af%a2%e7%a4%ba%e4%be%8b%e7%9a%84%e4%be%8b%e5%ad%90\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/hibernate%e5%8e%9f%e7%94%9fsql%e6%9f%a5%e8%af%a2%e7%a4%ba%e4%be%8b%e7%9a%84%e4%be%8b%e5%ad%90\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/hibernate%e5%8e%9f%e7%94%9fsql%e6%9f%a5%e8%af%a2%e7%a4%ba%e4%be%8b%e7%9a%84%e4%be%8b%e5%ad%90\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"Hibernate\u539f\u751fSQL\u67e5\u8be2\u6559\u7a0b\uff1a10\u4e2a\u5b9e\u7528\u793a\u4f8b\u8be6\u89e3"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9","name":"\u65b0, \u97f5","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g","caption":"\u65b0, \u97f5"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunxin\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/hibernate%e5%8e%9f%e7%94%9fsql%e6%9f%a5%e8%af%a2%e7%a4%ba%e4%be%8b%e7%9a%84%e4%be%8b%e5%ad%90\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/516","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=516"}],"version-history":[{"count":4,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/516\/revisions"}],"predecessor-version":[{"id":110185,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/516\/revisions\/110185"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=516"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=516"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}