<?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"><!--
Mapping file autogenerated by MyEclipse Persistence Tools
--><hibernate-mapping><classname="cn.houserent.entity.User"table="users"lazy="false"schema="scott"><idname="id"type="java.lang.Integer"><columnname="id"/><generatorclass="sequence"><paramname="sequence">SEQ_ID</param></generator></id><propertyname="name"type="java.lang.String"lazy="false"><columnname="name"length="50"not-null="true"/></property><propertyname="password"type="java.lang.String"lazy="false"><columnname="password"length="50"not-null="true"/></property><propertyname="telephone"type="java.lang.String"lazy="false"><columnname="telephone"length="12"/></property><propertyname="username"type="java.lang.String"lazy="false"><columnname="username"length="50"/></property><propertyname="isadmin"type="java.lang.String"lazy="false"><columnname="isadmin"length="2"/></property></class><queryname="loginUser"><![CDATA[
from User user where user.name = :name and user.password = :password
]]></query><sql-queryname="findUserHouse"><![CDATA[
select {u.*},{h.*} from users u,house h where u.id = h.user_id
]]><returnalias="u"class="cn.houserent.entity.User"/><returnalias="h"class="cn.houserent.entity.House"/></sql-query></hibernate-mapping>
pom文件
<?xml version="1.0" encoding="UTF-8"?><projectxmlns="http://maven.apache.org/POM/4.0.0"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><groupId>com.baojiaren</groupId><artifactId>SSH</artifactId><version>1.0-SNAPSHOT</version><packaging>war</packaging><name>SSH Maven Webapp</name><!-- FIXME change it to the project's website --><url>http://www.example.com</url><properties><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><maven.compiler.source>1.8</maven.compiler.source><maven.compiler.target>1.8</maven.compiler.target><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding><java.version>1.8</java.version><struts2.version>2.5.26</struts2.version><log4j2.version>2.10.0</log4j2.version><spring-version>5.1.5.RELEASE</spring-version><hibernate.version>5.4.20.Final</hibernate.version></properties><dependencyManagement><dependencies><dependency><groupId>org.springframework</groupId><artifactId>spring-framework-bom</artifactId><version>${spring-version}</version><type>pom</type><scope>import</scope></dependency><!--struts2--><dependency><groupId>org.apache.struts</groupId><artifactId>struts2-bom</artifactId><version>2.5.26</version><type>pom</type><scope>import</scope></dependency><!--log4j--><dependency><groupId>org.apache.logging.log4j</groupId><artifactId>log4j-bom</artifactId><version>${log4j2.version}</version><scope>import</scope><type>pom</type></dependency></dependencies></dependencyManagement><dependencies><!--spring start --><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-orm</artifactId></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-aspects</artifactId></dependency><!--spring end--><!--struts2 start--><dependency><groupId>org.apache.struts</groupId><artifactId>struts2-core</artifactId></dependency><dependency><groupId>org.apache.struts</groupId><artifactId>struts2-json-plugin</artifactId></dependency><dependency><groupId>org.apache.struts</groupId><artifactId>struts2-spring-plugin</artifactId></dependency><!--struts2 end--><!--hibernate start--><dependency><groupId>org.hibernate</groupId><artifactId>hibernate-core</artifactId><version>${hibernate.version}</version></dependency><!--c3p0--><dependency><groupId>org.hibernate</groupId><artifactId>hibernate-c3p0</artifactId><version>${hibernate.version}</version></dependency><!--hikaricp--><dependency><groupId>org.hibernate</groupId><artifactId>hibernate-hikaricp</artifactId><version>${hibernate.version}</version></dependency><!--hibernate end--><dependency><groupId>org.apache.logging.log4j</groupId><artifactId>log4j-core</artifactId></dependency><dependency><groupId>org.apache.logging.log4j</groupId><artifactId>log4j-api</artifactId></dependency><dependency><groupId>javax.servlet</groupId><artifactId>javax.servlet-api</artifactId><version>4.0.0</version><scope>provided</scope></dependency><dependency><groupId>javax.servlet</groupId><artifactId>jstl</artifactId><version>1.2</version></dependency><!--<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.4</version>
</dependency>--><!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.26</version></dependency><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>4.13.2</version><scope>test</scope></dependency></dependencies><build><finalName>SSH</finalName><pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) --><plugins><plugin><artifactId>maven-clean-plugin</artifactId><version>3.1.0</version></plugin><!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging --><plugin><artifactId>maven-resources-plugin</artifactId><version>3.0.2</version></plugin><plugin><artifactId>maven-compiler-plugin</artifactId><version>3.8.0</version></plugin><plugin><artifactId>maven-surefire-plugin</artifactId><version>2.22.1</version></plugin><plugin><artifactId>maven-war-plugin</artifactId><version>3.2.2</version></plugin><plugin><artifactId>maven-install-plugin</artifactId><version>2.5.2</version></plugin><plugin><artifactId>maven-deploy-plugin</artifactId><version>2.8.2</version></plugin></plugins></pluginManagement><resources><resource><directory>src/main/java</directory><includes><include>**/*.properties</include><include>**/*.xml</include></includes><filtering>false</filtering></resource></resources></build></project>