javaWeb快速开发必备(二 hibernate,jdbc相关配置)

最新推荐文章于 2024-09-14 18:46:05 发布

mxl421204733

最新推荐文章于 2024-09-14 18:46:05 发布

阅读量84

点赞数

分类专栏：常用代码文章标签： java 数据库

本文链接：https://blog.csdn.net/mxl421204733/article/details/84768784

版权

常用代码专栏收录该内容

5 篇文章 0 订阅

订阅专栏


hibernate相关配置
     1.----------- hibernate.cfg.xml
       <!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="dialect">org.hibernate.dialect.Oracle10gDialect</property>
			<!-- 控制台打印SQL语句 -->
			<property name="hibernate.show_sql">false</property>
			<!-- 格式化SQL语句 -->
			<property name="format_sql">false</property>
			<!-- 加载实体映射信息  -->
			<mapping resource="comn/test/hbm/Test.hbm.xml" />
		</session-factory>
	</hibernate-configuration>
      2.实体映射文件
      ----------- Test.hbm.xml
	<?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 package="com.kh.pajx.dmp.domain.school">	 
		<class name="Test" table="test">
			<id name="Id" column="ID" length="32" type="java.lang.String">
				<generator class="uuid"></generator>
			</id>
			<property name="Name" column="NAME" type="java.lang.String"
				length="80">
			</property>
			<property name="status" type="java.lang.Integer">
			<column name="STATUS" length="1" />
			</property>
			<many-to-one name="userGroup" class="UserGroup"  property-ref="usgCode" column="USR_GROUP_CODE" />
			<!-- menuAuths属性，本类与SysMenuAuth的多对多关系 -->
			<set name="menuAuths" table="SYS_ROLE_MENU" lazy="false">
				<key column="user_role_id"></key>
				<many-to-many class="com.kh.pajx.dmp.domain.sys.MenuAuth" column="menu_auth_id"></many-to-many>
			</set>
		</class>
	</hibernate-mapping>
	一对多：
	<?xml version="1.0" encoding="UTF-8"?>
	<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
	<hibernate-mapping>
		<class name="com.bochy.pojo.Category" table="tb_category">
			<id name="cid" column="cid" type="integer">
				<generator class="identity"></generator>
			</id>
			<property name="cname" column="cname" type="string" length="20"></property>
			<set name="productset"><!-- 实体类里的属性 -->
				<key column="c_id"></key><!-- 外键列 -->
				<one-to-many class="com.bochy.pojo.Product"/>
			</set>
		</class>
	</hibernate-mapping>
	多对一：
	<?xml version="1.0" encoding="UTF-8"?>
	<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
	<hibernate-mapping>
		<class name="com.bochy.pojo.Product" table="tb_product">	
			<id name="pid" column="pid" type="integer">
				<generator class="identity"></generator>
			</id>
			<property name="pname" type="string" length="255"></property>
			<property name="price" type="float" ></property>

			<many-to-one name="category" class="com.bochy.pojo.Category" column="c_id"></many-to-one>
		</class>
	</hibernate-mapping>
//-------------------------------------------------------
jdbc.properties
	#mysql 数据库配置（?useUnicode=true&characterEncoding=utf8 设置编码格式）
	jdbcUrl = jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8
	driverClass = com.mysql.jdbc.Driver
	username = root
	password =root
	#oracle数据库配置
	jdbcUrl = jdbc:oracle:thin:@192.168.0.120:1521:orcl
	driverClass = oracle.jdbc.OracleDriver
	username = home_
	password =123456