首页 > 代码库 > Hibernate学习（一）创建数据表
Hibernate学习（一）创建数据表
（1）生成数据库表的创建：
1 // 默认读取hibernate.cfg.xml文件 2 Configuration cfg = new Configuration().configure(); 3 4 // 生成并输出sql到文件（当前目录）和数据库 5 SchemaExport export = new SchemaExport(cfg); 6 7 // 创建表结构，第一个true 表示在控制台打印sql语句，第二个true 表示导入sql语句到数据库 8 export.create(true, true);
(2)Hibernate.cfg.xml文件
1 <?xml version="1.0" encoding="UTF-8"?> 2 <!DOCTYPE hibernate-configuration PUBLIC 3 "-//Hibernate/Hibernate Configuration DTD 3.0//EN" 4 "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"> 5 6 <hibernate-configuration> 7 <session-factory> 8 <!-- 必须去配置的属性 --> 9 <!-- 配置数据库连接的基本信息: --> 10 <property name="hibernate.connection.driver_class"> 11 com.mysql.jdbc.Driver 12 </property> 13 <property name="hibernate.connection.url"> 14 jdbc:mysql:///hibernate 15 </property> 16 <property name="hibernate.connection.username">root</property> 17 <property name="hibernate.connection.password">123456</property> 18 <!-- Hibernate的方言 --> 19 <!-- 生成底层SQL不同的 --> 20 <property name="hibernate.dialect"> 21 org.hibernate.dialect.MySQLDialect 22 </property> 23 24 <!-- 可选的属性 --> 25 <!-- 显示SQL --> 26 <property name="hibernate.show_sql">true</property> 27 <!-- 格式化SQL --> 28 <property name="hibernate.format_sql">true</property> 29 <!-- hbm:映射 to DDL: create drop alter --> 30 <property name="hibernate.hbm2ddl.auto">update</property> 31 32 33 <!-- 通知Hibernate加载那些映射文件 --> 34 <mapping resource="cn/lonecloud/domain/User.hbm.xml" /> 35 <mapping resource="cn/lonecloud/domain/Customer.hbm.xml" /> 36 <mapping resource="cn/lonecloud/domain/Order.hbm.xml" /> 37 38 </session-factory> 39 </hibernate-configuration>
(3)log4j.properties文件
1 ### direct log messages to stdout ### 2 log4j.appender.stdout=org.apache.log4j.ConsoleAppender 3 log4j.appender.stdout.Target=System.err 4 log4j.appender.stdout.layout=org.apache.log4j.PatternLayout 5 log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n 6 7 ### direct messages to file mylog.log ### 8 log4j.appender.file=org.apache.log4j.FileAppender 9 log4j.appender.file.File=c\:mylog.log 10 log4j.appender.file.layout=org.apache.log4j.PatternLayout 11 log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n 12 13 ### set log levels - for more verbose logging change ‘info‘ to ‘debug‘ ### 14 15 log4j.rootLogger=off, stdout
（4）User.java
1 package cn.lonecloud.domain; 2 3 import java.io.Serializable; 4 import java.lang.reflect.Field; 5 import java.lang.reflect.Method; 6 import java.util.Date; 7 8 public class User implements Serializable,Cloneable { 9 10 private String id; 11 private String name; 12 private String password; 13 private Date birthday; 14 public User(){ 15 System.out.println("user"); 16 } 17 public String getId() { 18 return id; 19 } 20 public void setId(String id) { 21 this.id = id; 22 } 23 public String getName() { 24 return name; 25 } 26 public void setName(String name) { 27 this.name = name; 28 } 29 public String getPassword() { 30 return password; 31 32 } 33 public void setPassword(String password) { 34 this.password = password; 35 } 36 public Date getBirthday() { 37 return birthday; 38 } 39 public void setBirthday(Date birthday) { 40 this.birthday = birthday; 41 } 42 @Override 43 public Object clone() throws CloneNotSupportedException { 44 Class clazz = User.class; 45 User user =null; 46 try { 47 user = (User)clazz.newInstance(); 48 /*user.setBirthday(this.birthday); 49 user.setId(this.id); 50 user.setPassword(this.password); 51 user.setName(this.name);*/ 52 Field[] declaredFields = clazz.getDeclaredFields(); 53 for(Field field :declaredFields){ 54 Class<?> parameterTypes = field.getType(); 55 String fieldName = field.getName(); 56 String methodName = "set"+fieldName.substring(0,1).toUpperCase()+field.getName().substring(1); 57 Method method = clazz.getDeclaredMethod(methodName, parameterTypes); 58 field.setAccessible(true); 59 method.invoke(user,field.get(this)); 60 } 61 return user; 62 } catch (Exception e) { 63 e.printStackTrace(); 64 } 65 return null; 66 } 67 68 69 }
(5).user.hbm.xml
1 <?xml version="1.0"?> 2 <!DOCTYPE hibernate-mapping PUBLIC 3 "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 4 "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> 5 <hibernate-mapping package="cn.lonecloud.domain" > 6 <class name="User" table="t_user" select-before-update="false"> 7 <!--hibernate为我们生成主键id--> 8 <id name="id"> 9 <generator class="uuid" /> 10 </id> 11 12 <!--默认把类的变量映射为相同名字的表列，当然我们使用column属性修改表字段--> 13 <property name="name" column="names"></property> 14 <property name="password"></property> 15 <property name="birthday" type="date"></property> <!--当为日期类型的时候标明date类型--> 16 17 </class> 18 </hibernate-mapping>
6.Customer.java
1 package cn.lonecloud.domain; 2 3 import java.io.Serializable; 4 import java.util.HashSet; 5 import java.util.Set; 6 7 public class Customer implements Serializable { 8 9 private String id; 10 11 private String customerName; 12 13 private Set<Order> orders = new HashSet<Order>(); 14 15 public String getId() { 16 return id; 17 } 18 19 public void setId(String id) { 20 this.id = id; 21 } 22 23 public String getCustomerName() { 24 return customerName; 25 } 26 27 public void setCustomerName(String customerName) { 28 this.customerName = customerName; 29 } 30 31 public Set<Order> getOrders() { 32 return orders; 33 } 34 35 public void setOrders(Set<Order> orders) { 36 this.orders = orders; 37 } 38 39 40 }
7.Customer.hbm.xml
1 <?xml version="1.0"?> 2 <!DOCTYPE hibernate-mapping PUBLIC 3 "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 4 "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> 5 <hibernate-mapping package="cn.lonecloud.domain" > 6 <class name="Customer" table="t_customer" lazy="true"> 7 <!--hibernate为我们生成主键id--> 8 <id name="id"> 9 <generator class="uuid" /> 10 </id> 11 12 <!--默认把类的变量映射为相同名字的表列，当然我们使用column属性修改表字段--> 13 <property name="customerName" column="customerName"></property> 14 <set name="orders" lazy="extra" fetch="join" cascade="all-delete-orphan"> <!-- lazy fetch --> 15 <key column="customer_id"></key> 16 <one-to-many class="cn.lonecloud.domain.Order"/> 17 </set> 18 19 </class> 20 </hibernate-mapping>
8.Order.java
1 package cn.lonecloud.domain; 2 3 import java.io.Serializable; 4 5 public class Order implements Serializable{ 6 7 private String id; 8 9 private String orderNumber; 10 11 private float price; 12 13 private Customer customer; 14 15 16 public Customer getCustomer() { 17 return customer; 18 } 19 20 public void setCustomer(Customer customer) { 21 this.customer = customer; 22 } 23 24 public String getId() { 25 return id; 26 } 27 28 public void setId(String id) { 29 this.id = id; 30 } 31 32 public String getOrderNumber() { 33 return orderNumber; 34 } 35 36 public void setOrderNumber(String orderNumber) { 37 this.orderNumber = orderNumber; 38 } 39 40 public float getPrice() { 41 return price; 42 } 43 44 public void setPrice(float price) { 45 this.price = price; 46 } 47 48 49 50 51 52 }
9.Order.hbm.xml
1 <?xml version="1.0"?> 2 <!DOCTYPE hibernate-mapping PUBLIC 3 "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 4 "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> 5 <hibernate-mapping package="cn.lonecloud.domain" > 6 <class name="Order" table="t_order" > 7 <!--hibernate为我们生成主键id--> 8 <id name="id"> 9 <generator class="uuid" /> 10 </id> 11 12 <!--默认把类的变量映射为相同名字的表列，当然我们使用column属性修改表字段--> 13 <property name="orderNumber" column="orderNumber"></property> 14 <property name="price" column="price"></property> 15 <many-to-one name="customer" class="cn.lonecloud.domain.Customer"> 16 <column name="customer_id"/> 17 </many-to-one> 18 </class> 19 </hibernate-mapping>
Hibernate学习（一）创建数据表
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。