控制臺上sql陳述句已經顯示出來
Hibernate:
alter table member
drop
foreign key FK5b3s28nglgv8ksv45tenjbm2t
Hibernate:
drop table if exists company
Hibernate:
drop table if exists member
Hibernate:
create table company (
cid integer not null auto_increment,
cname varchar(255),
primary key (cid)
)
Hibernate:
create table member (
mid integer not null auto_increment,
mname varchar(255),
com_mem_id integer,
primary key (mid)
)
Hibernate:
alter table member
add constraint FK5b3s28nglgv8ksv45tenjbm2t
foreign key (com_mem_id)
references company (cid)
下面是組態檔
核心組態檔
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.driver_class">com.mysql.cj.jdbc.Driver</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">vinllor</property>
<property name="hibernate.connection.url">jdbc:mysql:///springboot02</property>
<!--hibernate資訊配置-->
<property name="hibernate.hbm2ddl.auto">create</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>
<property name="hibernate.show_sql">true</property>
<property name="hibernate.format_sql">true</property>
<!--配置與本地執行緒系結session-->
<property name="hibernate.current_session_context_class">thread</property>
<mapping resource="mappers/Company.hbm.xml"/>
<mapping resource="mappers/Member.hbm.xml"/>
</session-factory>
</hibernate-configuration>
兩個物體對應的組態檔
公司
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="entity.Company" table="company">
<id name="cid" column="cid">
<generator class="native"></generator>
</id>
<property name="cname" column="cname"></property>
<set name="members">
<!--一對多建表,有外鍵
hibernate機制,雙向維護外鍵
在一和多的那一方都配置外鍵
column 屬性值 外鍵名稱-->
<key column="com_mem_id"></key>
<one-to-many class="entity.Member"></one-to-many>
</set>
</class>
</hibernate-mapping>
員工
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="entity.Member" table="member">
<id name="mid" column="mid">
<generator class="native"></generator>
</id>
<property name="mname" column="mname"></property>
<many-to-one name="company" class="entity.Company" column="com_mem_id"/>
</class>
</hibernate-mapping>
向大家請教,謝謝
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/49934.html
標籤：MySQL
上一篇：mysql 5.7.17老版本binlog恢復出的sql無法匯入資料庫問題
下一篇：essql決議器關鍵字識別