自己定义映射文件
这里的映射文件指的是相应到数据库表的xml 的定义文件。
相应的每一个数据库表栏位, 能够定义的属性有:
属性名 | 类型 | Description |
---|---|---|
length | number | 栏位的长度 |
precision | number | precision表示数字中的有效位。假设没有指定precision的话。Oracle将使用38作为精度 |
scale | number | scale表示数字小数点右边的位数。scale默认设置为0. 假设把scale设成负数,Oracle将把该数字取舍到小数点左边的指定位数。 |
not-null |
|
是否为空 |
unique |
|
值是否唯一 |
index | string | The name of a multi-column index |
unique-key | string | The name of a multi-column unique constraint |
foreign-key | string | The name of the foreign key constraint generated for an association. This applies to <one-to-one>, <many-to-one>, <key>, and <many-to-many> mapping elements. inverse="true" sides are skipped by SchemaExport. |
sql-type | string | Overrides the default column type. This applies to the <column> element only. |
default | string | Default value for the column |
check | string | An SQL check constraint on either a column or atable |
设置步骤
1. 设置 映射元素的length, precision 和 scale
<property name="zip" length="5"/>
<property name="balance" precision="12" scale="2"/>
2. 设置 not-null, UNIQUE, unique-key
not-null 如为true,指名该字段不同意为null,默认false
unique 如为true,指名该字段具有唯一约束,默认false
unique-key 为多个字段设定唯一约束
<many-to-one name="bar" column="barId" not-null="true"/>
<element column="serialNumber" type="long" not-null="true" unique="true"/> <many-to-one name="org" column="orgId" unique-key="OrgEmployeeId"/>
<property name="employeeId" unique-key="OrgEmployee"/>
3. 设置 index 和 foreign-key
foreign-key 为外键约束命名,在<many-to-many><one-to-one><key><many-to-one>元素中包括
foreign-key属性,在双向关联中,inverse属性为true的一端不能设置foreign-key
ndex 给一个或多个字段建立索引
<many-to-one name="bar" column="barId" foreign-key="FKFooBar"/>
4. 设置 child 元素
当有多个数据库栏位组成一个类的属性
<property name="name" type="my.customtypes.Name"/>
<column name="last" not-null="true" index="bar_idx" length="30"/>
<column name="first" not-null="true" index="bar_idx" length="20"/>
<column name="initial"/>
</property>
5. 设置默认值
<property name="credits" type="integer" insert="false">
<column name="credits" default="10"/>
</property>
<version name="version" type="integer" insert="false">
<column name="version" default="0"/>
</version>
6. 设置 sql-type
sql-type 设定字段sql类型
<property name="balance" type="float">
<column name="balance" sql-type="decimal(13,3)"/>
</property>
7. 设置 check
check 设定sql检查约束
<property name="foo" type="integer">
<column name="foo" check="foo > 10"/>
</property>
<class name="Foo" table="foos" check="bar < 100.0">
...
<property name="bar" type="float"/>
</class>
8. 加入凝视
<class name="Customer" table="CurCust">
<comment>Current customers only</comment>
...
</class>
使用SchemaExport 工具产生数据库DDL 脚本
以
[Hibernate系列—] 1. 下载与试用Hibernate(MySQL与Oracle 配置)
这一篇的Usr.hbm.xml 为例,介绍怎样使用命名行的方式产生DDl.
cmd 到 Eclipse 创建的project的 bin 文件夹下,
运行:
java -cp .;../lib/hibernate-core-4.3.5.Final.jar;../lib/jboss-logging-3.1.3.GA.jar;../lib/jboss-transaction-api_1.2_spec-1.0.0.Final.jar;../lib/dom4j-1.6.1.jar;../lib/hibernate-commons-annotations-4.0.4.Final.jar;../lib/ojdbc14.jar;../lib/javassist-3.18.1-GA.jar;../lib/jandex-1.1.0.Final.jar;../lib/hibernate-jpa-2.1-api-1.0.0.Final.jar org.hibernate.tool.hbm2ddl.SchemaExport --config=hibernate.cfg.xml --output=my_schema.ddl
能够看到产生的 my_schema.ddl 文件的内容例如以下:
aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAxkAAAAiCAIAAAC81INbAAAKQUlEQVR4nO1dO67cOgzVUtMFabWCB7z+Ir2BLCBAulSuBkGAtwEjSJYQI3vwK/wjJR59ZjxjZeYcqLhXtimKJqVjymO5P79/pstEEARBEMRJuFwuZ6tAZOD+/P75/c055z58/q+YSw2dc873j1a2AItmo3Fo7L1zDh4uxCZlQTfk9Vka3S9dTbfL6rrO94b47eRNkJbQNtr1k8MxdLf5FUEQBAC5VPtwvz6/c29f/3z7t4ZLTdM0dA+cI3ufoSz65NSkNqYPl2DodgY1dAV0Sja4201qMnQ751Aajr0H5/8lM/dD/aQWVX71BO0SBPE3glyqfbiFM5VwKZEz6YZ9jpxrRd5lnydEkmWp7L1zzvd9tydY0pQgStTs0kWqRkrpve8HkQIaQ3lhlUz5lEz8kksVkLMSLmVpGLKQkGMVTMeDMPN+NbDbJO+X9160XicH+Em1nVG7ll8tjXrvg3rUL+xX0J9Bf+18J9In4c/Y/gRBvDLIpdpHOZeSqZBo7WaeZtbVqHl66L2YXYZOL2zJqSVPCgBxGAYx/+m5cG05kh8xGMWMxt7np3nNpcJ/jdNtLjWpuXOvjJcCY81LrCZTZmPvxVxv2w3lySrlID+ptjNqF/nVInQM+4L6NSXyQ5Y/I7vFraT1Qe0m9CQI4pVBLtU+irmUZgRy7ck4OhmJk+2UYB4qybDYp+hH/A7Mc4H8cM4L3kOKUhoGjuNSqithvsrIS5l5kUSz9hFgN20LsYpZJQf5SbWdQbvYr9QhpYbZr2lKcinDwtBuW0dxCGiB6NkA6UkQxCuDXKp9nMKlQklXcSn1ypAUkpZvcKnaaeuWNb7AbpbQ3Npf0UtamANBu8VnXSMnwaXq7Hwglwq13v6r4VIZux3BpaCeBEG8Msil2kfVGp9+VSnNpUJOo9+vKpnPTFE7jRD6jL0P3ndR6z7pNb6i9TKF0BKZq6UK4m/9+riYd9F6ULBuVZI+C3Iz3TAl7aZPtxbtCuRAP6m1M2gX+hXiLqhfk+1X4eXGldpuW10NlzLaTehJEMQrg1yqfbj5gwg73n+C756rJYhufRUmXLzRL8UY9b33XVe1XCUbMcUvArtheUNHyNfv7tiaBoeSk1jy3eG8+juJjD5ysL5YE6q5URctIaCkJqQw+V5UbLfgZPjudoEc4CeVdsbt2n61Va5OsNk00S/Lr6A/g/4Cv8L6gHaTehIE8cIgl2ofzsxF3fVbnbd/lIAgCIIgXgTkUu3j0VzK/OUaQRAEQRAmyKXaxwl5KYIgCIIgCkEu1T7IpY6A9ZYT33ohCIIgbge5VPsglyIIgiCIdkEu1T7IpQiCIAiiXZBLtQ9yKYIgCIJoF+RS7YNciiAIgiDaBblU+yCXIgiCIIh2QS7VPtyf3z+/vF9+dWZuI3O2hvfF/J1089uh24/zbvq0aPgTv8wv+8Tnzcf9Uvmt80VMN++dYvyC0NxLuPJrXtv3VIH8WXq0fbDvp/D73Xnr2R8ar7TbvTGrc5QS4sbaxgm+Z2ufP9qfhU/V/80fdUPxeEicnhV3MpB0u0JQuFmCEXdQn5PAeDFkhzfXHD/N+z5dLhd7nFS1dXtwKA9B4y2qv21+ORxN+Nv3t41Cff3o3MdvZ3Kpkr35DpeT/g57duviPOTeagXbEuut2/b95qQmcp87paGI/+D8il4kNm/e5GvnHTrv5eZzamuUopYNO1fa7d4o2YS7BOJegF5p+8PzkUJY0Xvv8ndU/CaQ3/n7WpwVdyp2gvl77L3vw83RQdwhfc4C42UTXzl+Gvd9y0uZfo52ck/rFF6FxltQf/38ch+c7m9qje/X53dpLiX3ldssOZMy8TxnUVe9EbKoFk5m0e6UHBNlcsKNZgfIRO05voqPJ6iJfXp+TLc0FLv8xufXOFqwCbEtf+x9NyxC5d+zzgUjGOiFQI3dZF4h3LsQ3nfgt8DPx953/eYnOpgq5ctOxbWJTaDV+fVzQ8UUOyvtvdFflXpEz68lO34b8uUUEz28bz04jUtZLd4ad0Pn+351dX2DlqulZjjukD6gUcZLrn46LDVVOX4a9/1YLmX41YTHW1Bf5eev4G+SS339GG1sLLmUJGnjvLOutcQzDd2656vejlZkqod9n2OllqV5Qg4EuLF2u/OgvvRlDA0V+W69PsHTTe5hB43pk5zD9IAbVwaaJ4abnLpA/uxlQ+f7cb4Acalj8lKGXkkJ6mTob5bfQj8P/pbeXyVfHTacJ9HPaDjeBomSNYtFePGwOzt31N+9dpW3XVH3ZAjkq/ErmiUez6WmO8fd3O7Sup68V0sIZXDcIX0QGC+Z+kX4rQmX+vHTuO/HcinDryY83oL6Wj9/en9budSPTx+sBT7BpZKPO/HNDFd3HXqEzXCphBwMe0wH7cZpGCsrc4M+x3Ep1ZXwudl4Pt5UrAg1yCaN56rFHMtrUpJLudqmb+dS8gwlDPubNQhBP4dzfJ18pZX9KGT2E52/NmQfi+orWPWobql4+lPXyy5Wc6lYfpNcSrZyeNwpFiW5lLh3+5847qryUoFUxguqr3kKtVE9flr3/UguZfpV+E8Rl6oc5J/c39y8tOfcuy8/0r/jq+dStg8qph+MzDaXqvdlkN+y2w2cM8+lavW5ZY0PJpnV6JqZXapeNspn5tbaJdKGNTzsvFR5s7es8SmlwhECp6IPiNVa+ctpcPyxYjV1fkbtsJ5cCuGsuFOm7fd2w6e2WRKOuysswHjJ1h/HpaJacB/N+17OpaIADWH71YTH2+waX/H88tz+5r6/OWct7ZlrfMGqXmLIm6AXCkNG1G/3EyH+Cm+25MB2Z7tN+6EMk6jWJ0X+DUgVxN/a/MIpAg3NsRWR6ay6UH4UsnfmUoUyh06soIcXxo8alt8iP8exWi0/uQoT9hSdL9fa5P1F9Ubn0gBcJzSvWpMy4rdW/u4J1pBWx6XmeaPMGc+KO9H1PUthTeqZuEP6ZBtnvFTHS6Vf1Yyf9n0/jksBv5rweAvqr5pfntnf3AdNUtPvnlsLy5DmRof2e7ClBrtO/5Rxv0Kqa8tJwZJjtjuPXvO/8yE1rkECX6yPTjAWBuDeQPhzaLcf2KcbS8/tdPm77rLkv4wLW/5euy5PiKZrU7/w+bvebpMV1cDfEn5r+PkmZHmuEt2rk1/QL9WD5PnmezyJepxuMe24tqf7m86Zl96uIvm+77dvlqB4TMTpyk2KkzWPjztx+vqIP6/0qeq4j2Hc9UifHBgviXoUL+V+VTl+bgjuuy/7JgI0UaRNKF/8+qrM/tfOL8/sb/xWJxHiqnVV4jDczf6vdmNlyoF4Wjw8Xh7vV/xWZ0MAbkEuRRi4+eUT4ibcxf7lSannQM3CNvFX46HxcoZfkUs1BdPfyKUIgiAIol2QS7UPcqkzYK2ig8XZp8Cr9ZcgJOj/xG2o41L0tzNALkUQBEEQ7YJ5qfZRzqX+YWFhYWFhYXlwuVwup+vAki7kUiwsLCwsLO0Wcqn2C7kUCwsLCwtLu4Vcqv3yPxYs/BkPt8fZAAAAAElFTkSuQmCC" alt="" />
代码方式产生DDL脚本并运行
除了使用命令行外。 还能够使用代码的方式产生DDL 并运行这个DDL.
在bibernate.cfg.xml 配置好的前提下, 运行下面代码:
public static void main(String[] args) {
// TODO Auto-generated method stub
Configuration cfg = new Configuration().configure();
new SchemaExport(cfg).create(true, true);
}
create 方法有两个參数:
1. 第一个參数设置是否输出DDL到控制台,
假设设置成true, 在控制台就能够看到下面相似的SQL
aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAXQAAAEoCAIAAADHTZ2IAAAeY0lEQVR4nO2d3bmjIBRFrZl2KGE6sA6rSBPOg4oHOAchCbnBrPXNwx1CABE2P8rOtAIAdGD66wIAwD1BXACgC4gLAHQBcQGALiAuANAFxAUAuoC4AEAXEBcA6ALiAgBd+Iy4LH6aJjd/JK829pI9lI8es5umyfy4kpDKjl+uy7Nnen71qLozLe+9m5XkQ+SQUJxCGZHhC5f8Ob63Xb2dxY9yU04+NnNZ/Acbwewu+nAcuXTXHuWPa1j8KSmLr9AXmeFZb7Ikiz87VVTCx+yM+JdXIeJUlPJb+Gi7aqWpHd4g34Se4iJGVb+cjWALFSPzWRFiGN4DZzdNk5tnP1WOqdlQfqYuBnOZyuzcvJhjtiIuclJQ07KluFSoVY24aCVMu1kqOi3trTL6Im7LmZtRz6u8v845Udq2dIx21XxfrHy1drhn6pxLwq3rstuh2f6N69Vn0FZ5Cu3frv9O9BMXOVhm09etHo8J/Hb9sxPVt/h4LSDr7rrZG11jWcQNjm/2kXOWftalI6l4zO66Hcfikv5Xia6Lyxo1jjMwXz3lJa+qtbgIFZGSJn3ebrWerZlXYzpWu2q+L1a+VjvcE32k12Jd11qYQWjt36q3PJdyeax8C+XsRDdxibuInK4rn67KWBmiJBVdM6jqUWJR98aNTNJPb2qyl5ENYgrvE5foUtIZjTJzUUfCCx6zq1oT2QJk1HNcd2Kh2JSO1a6a74uRr90Oo4+iYqjXta5FcVHuiFlv4ULtLhMnaA2uVjk7MYS4pCk9JS7RtoNMpJy+Ii6t9+WVZVFSb1qiV8ulhi2UeOJQxhIFs57zWM+kUxCXtvvyRnFJSx3+1yIuF/X2DnExy9mJrsuieLujLC5pJ4/3aGpumJrU2a9EeeLBOUr/elnUusTIa+Li27II4u94T1Y0LGtKnEzdayZYTQ0uLlCo6EI9x9G1dU5FOma7ar0vRr5mO7Q6s3Vdq94O068r39Qmj43iouRbKGcnem7oRrMwfyyP0/lrvFBWly3O+8YZ/pmJmvyeoF/2VbtIP17P6yVNPirepeIG23Xxz96ePVs+FttpMUPfjFNINPot5ZTfkXsreT0nkc0N0Yp0jHaVV1HNIKTFVtthCDwaTbgHhevS2qHZ/o3rNdqhXR4j32I5+zDAS3SvPwsGgM/z7eKiPh8BgO/n28UFAAYFcfkLtJ2ST6yE/ypf+EkQFwDoAuICAF1AXACgC4gLAHQBcQGALkzrNK3TtCavqc1uD08eI3gt8s6ixC+w+D2LyV9HtvK1yllOpz5+SD9/y+ZPyt+PrSSFUvi4/H5aJ7fycuMqbmLNu55WPT9Xn87ovzuL3nST8KbyJ/l6r6W/M52ZiQMb5xe8CJ/d6pd18Xoh3LTOc0unreiT5Xytclok8S+r0sc3QMb/k/L3ZnZtZXB/Jy6uuvI/k86atZByTLWeW+vzbMOLPTAsRufPwpvKH2J6Vbx2pvMLoXBeXOQj0wtVXLbrzCOrPOZCgUzyfMvlzIlualK5y8UcRFZoqfx2Oq+XfxUjhszCHcPOPgQdHz3mI7JbZ389NM1unWclfWtkc25dRBbiUNwRGLc8tZxbIZ1T8pXpyMoPgdu/5SpflUI6q1HPhfC1tXNq9azU5yIqJ3yqaZBs2/LSFtHOrfBnym/E9KL+nTtmLjKnpNEnhcg7yTYyr9U9ZPGr93ElVnDZOStMm+KpoGwfligsSmMtlf8FcbksvxN9bPFpkUIhF78uW0mO9LdWddl0Znd+JW9AeYib4iy2q15SYboo5/ZdNd/l7DAu6fzqnbLztVBnLlY9F+o/LXkRq57N+pzWZas6tz7UjGT/Ffc9Wv5Y4e3lX4XIRrohVvezWyc37S1P3rlWcfFC/qd4qhb9O27kNnAdp3rFxRvxzXwbO+cqBmE3t02J5TJKL/8VL5Y/F24fTxbyNZeMX9N05OinDiG5uMRHm48+YN9HddorL01GSCYXZXEp52uRp2PVc7n+12eXRfJ61foMwhEKkGSU9N+khkO7ssKfKH/yrdB/swaszR3k+r9yWWRFvijQuq7VS01V1ArlvEqucWm2RLOez5f/RXEp3LVAs7hkvWvJ8k1oEJclapnJPoUqLk9sin+XuGj1WRYXOQnKE1z7i8s5YVTFJecxRxs2yS17XVxWKdLVnTzPt1zOMml8bTkjRxIfP9Axy9+yLGotf9T4lnS5kU+Vz2Is2bJIK+cTM5doPe/PcOta2sQl3jyKxOWoisVX5WvdFz0do54L9b9anbOlnvX6tMVF30yNl4deLovU8Nbyx6Iv7130kGRZp8sNLdmjkuVPUrjwaZX+LXq+KoV81XKaeYqZcxpfbXyLebFm+bV03lV+fZmQLSfVDU7vL8QlLBjl0mZ+mMvV7dGpDxuxccdTlidGOcNFbQ/UZBOaReLeGZeWb5ypyyJDXNR0rOVYZf2X87XqWa9PseW35e6XPYV//2rv+yQ2uZTwxvKn8eN5k4vKw0t0v8GTk16A50Fcbo26qw/wERAXAOgC4gIAXUBcAKALiAsAdAFxAYAuIC4A0AXEBQC6kL05mhwAC+9HWOEbc3Zkvhy/npDO8trfSTmTN2KfDrdeU1ZNtvLweuQL0AULq3GR7zGXK+kJc6MLLFOlL6BgIvWWekitJ65Oe5bbYWwidcxc5EGmxAxGnpKywiMN8hfxW0nOYshj3U3hljlTa7hlIhWsJ8rpPF0Pvni2ZWiesPh58zvHn63PphP55ZOxr9dD0keu9cVoh5mJ1HRxBEseTNLDF+VcVjgboqazf6tCJkOCbxEXy5ypNTwpmxSX5Sq8/qBjjnpTC2ZLq3xD9xgApM1ibr4Zm/2c2anhBXOmPN9CuHr2qlzOteWgoIVlnmSZb8nyy9OSwYsrP2tTzrRwJkhemmXKZdVDk2nW2u7OUSMu67ruy6KCuLhJ7zAhPD/qrp4NT0+sNoqLvBmJr0p9uOWf0hp+ln/SA5PwZ0yqNKybapktWXaE1qnczOxnT1MPt82ZCvla9ojqzKX1lPa6ttRn0TxJNbUqmEhFB7if8pHZiqGaY+kmUgdpPbSbZuXuHOXFe2EGHR83MWYuqoKq4WVxUdNpxWpkreHvFJcDH1fFKcQ+9eY4R/5nfVsL4qKaLUUHWOMGp9RPtdlq+GIyAicOD8pMygp/o7hUU/Y3Uf0xLD8X3eSpiNoGrNPY5fSTenjCNOuN4iJLde65JB9sxU0WYHp4xbKoZiFX4G3iYpgztYZHLLoYma43L6ztLbEzxUVm669mLu3iUmlzYX29y8ylmneKi2ryVES36TTMscrp5+LS+tDglWWRuVm2rJMX4uK0jVi5SVkIv9zQlfH3vJ/dc3laXCxzptZwy0Sq3BnydNa1uR5kXuFvS1xcLHb5fUy8dTOzn3PLQw23zJmsfK3w1RYXtZzJpxFNyyLbPEm9faaJVOLRU7Msyk2qbHMsy5RrQzXxapKX6F5kc4UcvR0qJlLZ9ClMq5K6s8JDHskcrBy/vhFY5jqt4aEMW0ii7m3hlomUMe1vNqmy8Vm+BbMl6dyjmyFlvwoQm/0o9RCFG+ZMVr5V4VMkmko5W82NbCrNk+Rgoy9bpMlT3Q6AalKlmmOZplyFeiiYZmWUfwXBIm+HaaZuffASHcCL/OHvN303iAvAC2DHZYO4AEAXEBcAiMk3Ymq2bzIQFwDoAuICAF1AXACgC4gLAHQBcQGALiAuANAFxAUAuoC4AEAXEBcA6ALiAgBdQFwAoAuICwB0AXEBgC4gLgDQBcQFALqAuABAFxAXAOgC4gIAXUBcAKALiAsAdAFxAYAuIC4A0AXEpY3FT9Pk1F/sfMxumibz40pCKjsXvyq++Clken71+IGuMy3vvZuV5EPkkFCcQhmRYdslz+6lSoIhGFtcZnfR93qkU+4Yj9f7zeIn8cPyFfoiM1z8oQuyJIs/9SIq4WN2RvzLqxBxKkqZfPM99w2+mr7icg6Hbg5NdxvuxEh7NDQ5eMqRU4RHvSIegM/maqWjUpeO7Gmzc/NijtmKuDSVZ0373qVa1YiLVsIzphL/0abbTdFnh7b8BB3FRQ5nj9lF/XDrb8eE3C9r0qUesxP9cFmOD5J2qTXpQjomRtfQ852d0JRH2lOyLt1enmRgvxrnLXFZ5bJIBOarp7zkjf0/1amLyGjLb9BPXIoNLu4QW0i6FxArkzKzUEWhkI6NLi5GvknHSwbtVFyeKM/7xCW6lHRGo8xc1JnaBY/ZNa2JMjmGu/JN4qI3uWj5n/RkXVzam64xA9LzTdTjWlxay/PKskjsoViJXi2XGrZQ0glpDYjLz9B3WZQshOR2Rt4kjUYnulo2SJ7dRCT/ROPV0jHz3TrUen5UXha1lycSl2txkkUQf8fVLyQwKWH4QIbXKIDcJG6BZdGv0HdDV64rtG3bZJGQfHQ2+jBb995N+p5rspBoWxap6aj5bo+it//GC4h8/RM98qktT2GDuab4YqMqfbb8UJM/chDPtLfvRxr6pnKGlFGXX2DsR9EwJMxdfgPEBf4AXqL7BRAXAOgC4jIC2k5J40bHUPnCLUBcAKALiAsAdAFxAYAuIC4A0AXEBQC6MKq4GKZHx2lr7fh18o0avxLlCUmjmVNvtuK8qxCX5k/J+yl6/If2YnY5/JljBN+CZRL2HvOwkRlVXFbL9CjubYt3zsnX8M82Xfkel+7P0mLm1JtG6xWTa/On+M1aM75VILugvV/ZfZepWIHr46C/xw3EJT5+/ZidX/bGJP9e19xapabFXYjLVeuRNpTp+R3TjGoPSc20DPOtx+z8HCYF+lGtyvTlReWhhTNBUfx2cWmYvGyFdk653mhyqvt1XM/yjPTlmJVNj8MVIC4RY4tL1FdDqF+2U9ebCFji8p6ZS/7fcgrxiWfLBEsz0zLNt5K/5ZqwKf3oY6WrF64z0/emZdGeeHUf3Mxpsus9Q4/0wjeabfW09CNtzI71Iy45Y4uLNXMJRtrrmojLSeUtf11cZIwoMdsES7OkMP1xzEbfln5UKn0yo15n2SzKqpwsvOGo9CO6pWL+Fn1fXuLznp0iFcSllRuISxa6D/TL0Z/1mcvzuTSaOa1S8aIljm1Z+wZxaU1/j2aqriYuFWZRVrHTcMTlftxHXOQ+i4zWWVwq01y82CVJv5gP/lrnt8y3bHFpTr9o/pReqRVfLk+kIlnhysWVMTp/Wr3RsqjldwpscVEWouJLDeKyzaHvfkJrVHHRTY/kNsxDRvJLtNtX1Y7rHkXXtpB84DdMsApmWor5VkgkrAXD5bWlX3Fd0RUU46vG4IXw5g3d6XTumuLNJ738uqnY0+m7eQ6/X2WZhBXMw45F+90nNKOKC/wB3Z4Y/5p7VLT3fF8QF2igywbC4C/RNVNjUHwLEBcA6MJviwtmSADd+G1xAYBuIC4A0AXEBQC6gLgAQBcQFwDowqjiIq0M8uPR50Mg77fXwA1zKeVXT2vyTV+BPX2qkkRM8yqzPH8EplPwdkYVlzU9H3OeJZGnOeT5F91cKotf4VAnDKiSBv2YnZujgtnmVVZ5/gpMp+C93FxcJLpFQ97Jr5rn4t08+/Nsj0gtnH5OElTNq6zyGJmKsR3TqddNp6A/NxSX1Tggp5tLZYZDl0Pflu+ee9yag93DWRjbvMoqjwWmUxfhe+K/cGpnDO4pLoHNVCz8bc1c1JH5It9NVqS4iF5z/mmbVzXNXJJUMZ2ywn/l3M4I3EVczPlw1M0vHDfq3LYjf6L5zNe0aDDMq56wEcJ06jIccfkeBhYX2UrF3/HEWPQG3VwqDq85sCo61Dkf0Vr5hXmVVZ7LzDGdajad+g1zpm9jYHFZ443JPEwudHRzKRldPsa2+0a0sbrujTnaPnnkZTjChXnVbJXnCkynCuHWBPZHzJm+jbHFBYbk46ZTP2LO9G0gLvAHfNR06mfMmb4NxAUAuoC4aGAiBfAyiAsAdAFxAYAuIC4A0AXEBQC6gLgAQBdGFRfDbMk0ZzLMnM4o6ROhKLTuxXw1/bSg0av0SnijeVVvMJGCpxlVXFbLbMk2ZwrR1NN26jHCwqHfQpnSb8n3RuXZSCO81byqN5hIwXPcQFwyExDDnGkNzU/TjLeIi55+3LSjQ9haeJN5FSZSF4mGj5i8fJyxxUVfhhjmTKtq5iS+97q46Okn42b4rxHeal6FidRF+J74n08Bf46xxcWauajmTLqZU5paRJu4WOm3i4s6I6jJGBMpK5zzRZ/nBuKShRrmTCUPggpxudx6MNN/ellUZ161SkXFRMoIR1w+z33E5cqcyTBzMlLbaBEXO31rGmOEt5pXhdwxkcJE6qsYVVx086fEtEl9Xh2ZOUXboNGMI/d7KjRC0yzKzYthhmSZJDWaV0VFwEQKE6lvYlRxgRuCidS9QFzgi8BE6k4gLgDQBcSlBUykAKpBXACgC4gLAHQBcQGALiAuANAFxAUAujCsuBTNnMRTHeWw7v6S6f5Wu27ypD0XEid+jCdFeb7SvUo/xv1ZMH+CjzGsuKzrapyPe8zu7L3i7F9mKRC/bB6bPIUDPuHlzqSf5GeR7HyFYdUXdAzMn+Az3E9c0oa3q0CxSxVMpKx2nImLke9+ptCfZ3WK4oL500Wi4aO/1mi45Hbiojq1+KVszVIwkaoVFyvfo5B7/hW9AvOni/A9cU4FfTuIy4WJ1LvEZZeVqiEX86frcM4FfT/3ERexQWssi4zOVjaRes+ySK5H6vwTMH8qhyMu38/9xKW0oauZIV2YSFWLS2lDV5j5Vz4qwvwJ86fhGVZcimZO1qPodBFfMHl6mKuEJx5FT/I5dt1OJOZPhXDMn4ZgWHGB7wfzp98GcYGOYP70yyAuANAFxAUAuoC4AEAXEBcA6ALiAgBdQFwAoAuICwB0YVRxaTVzMuMbplPqL8H+2dVi8gQDMrC4NJk5leNbplOJeVSXK6kGkycYi1HFJVB/sLAQvygu5vHiJNlzbMfkCZMnQFyOQMMus2VBhMnTRfieOKd/fgXEZQt8deaSpI3JkxXO+Z/fAXHZAnVfmNZBFpOny3DE5XdAXLbAa3Gp207F5AmTJ9gZWFxazZz0+IbplPbouqrtY/JUCMfk6acYWFygF5g8wTtAXEABkyd4HcQFALqAuABAFxAXAOgC4gIAXUBcAKALiAsAdAFxAYAuDCoux2nfRxqw/S//WdXsRdPoALPyCiomUnoETKSglkHFJe1Vi3fOCR3RfhA+OZuTiIJ6FgkTqTQGJlJQzcji4pe9tcq/s4YatCAVl+wEUKO4YCJlxMdECtZ1HV1ctt6/CcXecvNB8HFKkLrSCbHqxaVpQYSJ1EX4njini+7G4OJynKdd1ypxiecAJc/dIxYmUjIcEyloYHRxOYfntmWR9t+yuGAihYkUNDG+uBzMTRu62Tz8aXHBRCoBEynYGFNc5LbHQ/43f/BsPYo+23LFo+jzE0yk8tKXyomJ1A8zprjAn4CJFLSAuEADmEhBPYgLAHQBcQGALiAuANAFxAUAuoC4AEAXEBcA6ALiAgBdGFVcLNOmPTj2NDDerD1dENJXWt0srRJEuCubVP1VPWAWBV/IqOKy2qZN8rXO8OpniBxCwrel0ZRMJz5/cxy0s02q/grMouA7uYG45Odu97auvuGZt+PFu3mOROgMV8VFN6nSwSzqItHwEZOX2zG2uER9Nf/MOAuniMvjkJI6cVFMqorlxCyqFL4nzimiuzG2uJimTXs7vpzabyFCVirFJTepKoFZ1HU454juxw3EJWcfBiNjF/GZLi5hfaGKSxAd06TqoqiYRZXDEZf7cR9xCd1HNtN8Z7IgLnI+ssa96fzbNqkqglkUZlE/x6jiYpk2Se+k2ElJXyVEG67r3shDLnIDNc5VN6m6KDBmUZhF/RKjigv8AZhFQQuICzSAWRTUg7gAQBcQFwDoAuICAF1AXACgC4gLAHQBcQGALiAuANCFYcVFGEFFf1f+PKt8xz+hfPY//UJ00iBPwTKpas43v3g8CuC7GVZcsjM1+cv1yfteMkQeZbFMp0xkXsnhpcfs3JycTLZMqprzTQpREf9NNlIAz/Cj4iK/XLJuUInzksmG08/qscCkozfnK2Y7fhHfUk2hCmd/5CSO6Q90Y2xxSRcb8aeFEPliecl0SiXRCfHfYMeQ64UqLi35yslWsiwyTaG0mUtUENWVAuAtjC0uuknS8WkeoirRizOX878iXDN2eG3mklygXEbZplCKuKQ7UhOOBtCJ3xKX01chHr3bTuMZy6KSV0JJXGozNcSlZAqliwtiAh/hJ8UlM4JSTadMUkM5fSmUeb9diMtVvmmu0ykupinUmYPQ09JZY8yZ4H2MKi4Fk6SLR9HiF0gmN1umU9cZy9iJiVRsQaWuWprzTS7M+7DtYphCJV9JFnJ6vpgzwRsZVVygB5gzwRtBXOAAcyZ4K4gLAHQBcdHQdkSqtkUA4ABxAYAuIC4A0AXEBQC6gLgAQBcQFwDowrDi8pT5k/As8OFt/cKZIPnzo9sBgy1y+nuphZOHmEvBrzKsuLSbPyXxk86Wn0VK0hQ/J+1cbAZzUVDMpeAnuYm41Jg/lU8hp5/avXfxbp6Prt8qLphLwc9wE3GpNH+Sy5xCauuqd3j5yf55u7hgLgU/wtjioozAdSN83klscREDt1/OTzZZeUVcMJeCWzO2uLxg/pR2XmVZlLo9nXsuYRPEz88vizCXgntzC3GpMn+KOlWuHXnXtaYyotvWPYXBXAp+kmHFpdn8KXt2/UhTSmcQSVr7mij+/uIbf+cIcyn4FYYVF/gCMJeCAogLPAvmUlAEcQGALiAu7wBzKYAMxAUAuoC4AEAXEBcA6ALiAgBdQFwAoAvjiotutpR+5ubtRX/LhGlV39A9Y/tljV6o3V5pTZL5/MUHtqK966FU8uKwFiH6RI8f1XV8qsoK56T1HRlXXNZ1VcyW1vgYY+h7BRMmkZLsUebZn9dMm95PdkzqScThq8TSSsQQoWZ8q0B2QTkdeUvGFhfFbOmqq1ntWHWik6doMqe7KuuD6NRQch5KNW06pgNufhwjvXb0x83Soc7P8VQrjV2bvqyNPLTwQm4Uv11cvkGj4e2MLS6K2ZJt8nR8XisusjMk8tW0IIpSjhXLMm0KVr3b3+fJy2hGdoqL/FtcRVv60cfKpRWmF3H81mXRnjinlO7GyOKimi29UVzC0ikeV5vtJkWeUSa2aZN2FWZ20YRAV8Ga9KNS6ZMZteas+EdG+mdZOOeU7sfA4qJbJVxNsJvEZeuEyXS+zbTp+Mq2fIuXOPZi7g3i0pr+Hs3czNXEpRT/otj5lhbicjfGFRdzwzWeYad7k23iorkhNZo2naWNv1cybbIsu9XrssWlOf3iQi+tOSu+9GGQimSFKxcX5cEJrVEZU1yKZkurNOI2vZ+0XVJtNyCRkmdMm8IXs5TDfqswbSoVJ7+ukMg+MxK10JZ+wf1f5B7t2taUM5ueqOHWfBMzqqEZU1zgT+j2xNhKGDOqoUFcoIH27aYKrG0yzKgGB3EBgC4gLgDQBcQFALqAuABAFxAXAOgC4gIAXUBcAKALPycu33P8dnafe/1U+jOkLxi7+TwlHZ0u2N+jTb5xWWLzzJf1Qi9+Czfl58Tlq+jyTlpO/AKsbnYVW9ot3rnzxFL0/coyK2e1ZDLxkS/Mom7JqOKyD/uzzwdUywwpjJ3pAO3cPkwv4avnh/lwbaS/x47G6asBeeuAYlDPTv+cKTyTfiiwdqo7M2Hxy34EUv69Z31tBZVwIS7fZ+gHb2dUcVn3Ti4P/mYmbJoZkmJneZ7627t6UJc2s6X4qHFNHxTiYvbkyfDBqja3TKcFutnVphmLd/Nj+4IlLu+ZuaT//Z7VKryNscUlUQ3dMynG9Mp9nMO2uj9R44eiW9cVLyHt5OmORZRza/rHVaiWEcrMJZxDjvKKy1SZb6O44OdyQ4YWl9Rh+63i8ozZUugwldOK2U3ex4Yz5e2HxvT3ohf9aM7QfXm3HKZ5+sylPtuGZRHickeGFpdozI/623vEpc1s6SiGm+faacWZVTQ9KXWzpvT3staYXWVbKZ3FJZ/GsCy6G0OLS/QrQso2bLSoyNcbfhH2SuFxyeN4RPyEmdORT+20JftRAPUS4tSq05cZGY5ZR/qJ+db5X79Ej6Kr+n/do2hF8FquCQZgbHH5xrGufjfkY+l//ZPery8gPMOo4mIaJv4dcsTu0VVeSf9LhXiDactNGVVcAODLQVygHW3nptuMDUYFcQGALiAuANAFxAUAuoC4AEAXEBcA6EJPceH9BYAfpu/MhTcvAX6WzssiJi8Av0rvPRdOuwL8KN03dPHpAPhNEBcA6ALLIgDoAhu6ANAFHkUDQBd4iQ4AusDr/wDQBcQFALqAuABAFxAXAOjCf/B87ldUFpnzAAAAAElFTkSuQmCC" alt="" />
2. 第二个參数设置是否要在Db 中运行这个SQL
版权声明:本文博客原创文章,博客,未经同意,不得转载。