Hibernate的入门之配置文件和增删改查

我会带着你远行 2022-04-16 05:58 120阅读 0赞

首先使用maven导入jar包,然后配置主xml文件

<?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="connection.username">root</property>
          <property name="connection.password">root</property>
          
          <property name="connection.url">jdbc:mysql://localhost:3306/hibernate?useUnicode=true&characterEncoding=UTF-8</property>
          
          <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
          
          <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
          
          <property name="hibernate.current_session_context_class">thread</property>
          
          
          <property name="show_sql">true</property>
          
          <property name="format_sql">true</property>
          
          <mapping resource="User.hbm.xml"/>
       </session-factory>
    </hibernate-configuration>

然后配置实体类的xml文件,一个实体类对应一个文件

实体类:

package com.hw.one;
    
    import java.io.Serializable;
    
    public class User implements Serializable {
    
        private static final long serialVersionUID = -3363120264501521428L;
    
        private Integer id;
        private String userName;
        private String userPwd;
    
        private String realName;
        private String sex;
        private java.sql.Date birthday;
    
        private java.sql.Timestamp createDatetime;
        private String remark;
    
        public User() {
            super();
        }
    
        public Integer getId() {
            return id;
        }
    
        public void setId(Integer id) {
            this.id = id;
        }
    
        public String getUserName() {
            return userName;
        }
    
        public void setUserName(String userName) {
            this.userName = userName;
        }
    
        public String getUserPwd() {
            return userPwd;
        }
    
        public void setUserPwd(String userPwd) {
            this.userPwd = userPwd;
        }
    
        public String getRealName() {
            return realName;
        }
    
        public void setRealName(String realName) {
            this.realName = realName;
        }
    
        public String getSex() {
            return sex;
        }
    
        public void setSex(String sex) {
            this.sex = sex;
        }
    
        public java.sql.Date getBirthday() {
            return birthday;
        }
    
        public void setBirthday(java.sql.Date birthday) {
            this.birthday = birthday;
        }
    
        public java.sql.Timestamp getCreateDatetime() {
            return createDatetime;
        }
    
        public void setCreateDatetime(java.sql.Timestamp createDatetime) {
            this.createDatetime = createDatetime;
        }
    
        public String getRemark() {
            return remark;
        }
    
        public void setRemark(String remark) {
            this.remark = remark;
        }
    
        @Override
        public String toString() {
            return "User [id=" + id + ", userName=" + userName + ", userPwd=" + userPwd + ", realName=" + realName
                    + ", sex=" + sex + ", birthday=" + birthday + ", createDatetime=" + createDatetime + ", remark="
                    + remark + "]";
        }
    
    }

实体类的配置文件

<?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.hw.one.User" table="t_hibernate_user">
          <id name="id" type="java.lang.Integer" column="id">
             <generator class="increment" />
          </id>
          
          <property name="userName" type="java.lang.String"
             column="user_name">
          </property>
          <property name="userPwd" type="java.lang.String"
             column="user_pwd">
          </property>
          <property name="realName" type="java.lang.String"
             column="real_name">
          </property>
          <property name="sex" type="java.lang.String" column="sex">
          </property>
          <property name="birthday" type="java.sql.Date"
             column="birthday">
          </property>
          <property insert="false" update="false" name="createDatetime" type="java.sql.Timestamp"
             column="create_datetime">
          </property>
          <property name="remark" type="java.lang.String"
             column="remark">
          </property>
       </class>
    </hibernate-mapping>

使用测试类连接数据库对数据增删改查代码

package com.hw.one;
    
    
    import org.hibernate.Session;
    import org.hibernate.SessionFactory;
    import org.hibernate.Transaction;
    import org.hibernate.cfg.Configuration;
    
    import java.sql.Date;
    import java.util.List;
    
    /**
     * hibernate测试
     */
    public class test {
    
    
        public static void main(String[] args) {
            /**
             * 1.对hibernate.config.xml建模
             * 2.通过建模获得的config文件类，获取所配置的sessionfactory
             * 3.获取session会话
             * 4.开启事务
             * 5。操作数据库
             * 6.提交事务
             * 7.关闭session会话
             */
            Configuration configure = new Configuration().configure("hibernate.cfg.xml");
            SessionFactory sessionFactory = configure.buildSessionFactory();
            Session session = sessionFactory.openSession();
            Transaction transaction = session.beginTransaction();
            //添加
    //        User user = new User();
    //        user.setBirthday(new Date(new java.util.Date().getTime()));
    //        user.setRealName("123");
    //        user.setRemark("123");
    //        user.setSex("男");
    //        user.setUserName("123");
    //        user.setUserPwd("213");
    //        session.save(user);
    
            //删除
    //        User user=new User();
    //        user.setId(3);
    //        session.delete(user);
    
    //        查询
    //        User user=session.get(User.class,2);
    //        System.out.println(user.toString());
    //        List<User> users=session.createQuery("from User").list();
    //        for (User user : users) {
    //            System.out.println(user.toString());
    //        }
    
    //        修改
    //        User user=session.get(User.class,2);
    //        user.setUserName("www");
    //        System.out.println(user.toString());
    
    
            transaction.commit();
            session.close();
    
        }
    
    }