Intellij idea 配置hibernate web项目

1.创建项目的时候勾选Hibernate，这里第三布一种是可以选择download从网上下载，也可以自己从网上下载hibernate的源码，然后把其lib/required的包都导入到intellij中，可以看到两种方法导入的包是一样的，只不过一种从网上下载，一种直接本地添加

image image

可以看到idea 为我们生成了一个hibernate配置文件

image

2.在WEB-INF下新建两个文件夹lib 和classes,将工程所需要的jar包都放到lib目录下

image

3. 更改output路径和添加依赖

image image image image image

3.配置数据库源

[图片上传中...(image-741903-1510642137647-4)]

image

之后点击可显示数据库相关信息

image

接下来根据相应的表来建立相应的映射类及hbm映射配置文件。

image image

生成的CstCustomer.hbm.xml文件

<?xml version='1.0' encoding='utf-8'?>
<!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="com.gentleni.domain.CstCustomer" table="cst_customer" schema="hibernate_demo">
        <id name="custId">
            <column name="cust_id" sql-type="bigint(32)"/>
        </id>
        <property name="custName">
            <column name="cust_name" sql-type="varchar(32)" length="32"/>
        </property>
        <property name="custUserId">
            <column name="cust_user_id" sql-type="bigint(32)" not-null="true"/>
        </property>
        <property name="custCreateId">
            <column name="cust_create_id" sql-type="bigint(32)" not-null="true"/>
        </property>
        <property name="custSource">
            <column name="cust_source" sql-type="varchar(32)" length="32" not-null="true"/>
        </property>
        <property name="custIndustry">
            <column name="cust_industry" sql-type="varchar(32)" length="32" not-null="true"/>
        </property>
        <property name="custLevel">
            <column name="cust_level" sql-type="varchar(32)" length="32" not-null="true"/>
        </property>
        <property name="custLinkman">
            <column name="cust_linkman" sql-type="varchar(64)" length="64" not-null="true"/>
        </property>
        <property name="custPhone">
            <column name="cust_phone" sql-type="varchar(64)" length="64" not-null="true"/>
        </property>
        <property name="custMobile">
            <column name="cust_mobile" sql-type="varchar(16)" length="16" not-null="true"/>
        </property>
    </class>
</hibernate-mapping>

修改 hibernate.cfg.xml文件

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD//EN"
        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <!--配置数据库连接-->
        <!--比说明字符编码为utf-8-->
        <property name="connection.url">jdbc:mysql://127.0.0.1:3306/hibernate_demo?useSSL=false&amp;useUnicode=true&amp;characterEncoding=utf-8</property>
        <!--若驱动导入报错，请检查是否倒入了相关数据库连接的Jar包-->
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="connection.username">root</property>
        <property name="connection.password">123456</property>
        <!--相关的属性-->
        <property name="hbm2ddl.auto">update</property>
        <!--格式化控制台显示的MySQL语句-->
        <property name="format_sql">true</property>
        <!--在控制台显示执行的MySQL语句-->
        <property name="show_sql">true</property>
        <!--使用MySQL数据库的方言-->
        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
        <!--相关的映射-->
        <mapping resource="com/gentleni/domain/CstCustomer.hbm.xml"/>

    </session-factory>
</hibernate-configuration>

测试代码

public class Test1 {
    private SessionFactory sessionFactory;
    private Session session;
    private Transaction transaction;
    @Before
    public void Init() {
        Configuration configuration = new Configuration().configure();
        sessionFactory = configuration.buildSessionFactory();
        session = sessionFactory.openSession();
        transaction = session.beginTransaction();
    }
    @Test
    public void test() {
        CstCustomer cstCustomer = new CstCustomer();
        cstCustomer.setCustName("张三");
        session.save(cstCustomer);
    }
    @After
    public void destroy() {
        transaction.commit();
        session.close();
        sessionFactory.close();
    }
}

控制台输出

image.png

数据添加成功

image.png