hibernate入门 增删改查

什么是hibernate
ORM框架/持久层框架 jdbc的一个框架
object reference mapping
通过管理对象来改变数据库中的数据
通过管理对象来操作数据库
如何在项目中添加hibernate支持(手动添加)
添加hibernate相关依赖
在resource目录下添加hibernate.cfg.xml(核心配置文件)
添加DTD支持
添加Hibernate的配置
数据库相关(connection.username|connection.password|connection.url|connection.driver_class|dialect)
调试相关(show_sql|format_sql)
在开发阶段再创建实体类和实体映射文件(.hbm.xml)
实体必须实现Serializable接口
小结:hibernate.cfg.xml(1)/
.hbm.xml(N)
实体映射文件一定要加到核心配置文件

1.建一个maven项目导入pom依赖

代码:

<project xmlns="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/maven-v4_0_0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>com.zking</groupId>
  <artifactId>T226_hiber</artifactId>
  <packaging>war</packaging>
  <version>0.0.1-SNAPSHOT</version>
  <name>T226_hiber Maven Webapp</name>
  <url>http://maven.apache.org</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>
		<junit.version>4.12</junit.version>
		<servlet.version>4.0.0</servlet.version>
		<hibernate.version>5.3.0.Final</hibernate.version>
		<mysql.driver.version>5.1.46</mysql.driver.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>${junit.version}</version>
			<scope>test</scope>
		</dependency>

		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>javax.servlet-api</artifactId>
			<version>${servlet.version}</version>
			<scope>provided</scope>
		</dependency>

		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-core</artifactId>
			<version>${hibernate.version}</version>
		</dependency>

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>${mysql.driver.version}</version>
		</dependency>
	</dependencies>
  <build>
    <finalName>T226_hiber</finalName>
    <plugins>
			<plugin>
				<groupId>org.apache.maven.plugins</groupId>
				<artifactId>maven-compiler-plugin</artifactId>
				<version>3.7.0</version>
				<configuration>
					<source>${maven.compiler.source}</source>
					<target>${maven.compiler.target}</target>
					<encoding>${project.build.sourceEncoding}</encoding>
				</configuration>
			</plugin>
		</plugins>
  </build>
</project>

在src/main/resources文件夹下创建hibernate.cfg.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>
			<!-- 1. 数据库相关 -->
		<property name="connection.username">root</property>
		<property name="connection.password">123</property>
		<property name="connection.url">jdbc:mysql://localhost:3306/mybatis_ssm?useUnicode=true&amp;characterEncoding=UTF-8
		</property>
		<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="dialect">org.hibernate.dialect.MySQLDialect</property>

		<!-- 配置本地事务(No CurrentSessionContext configured!) -->
		<property name="hibernate.current_session_context_class">thread</property>

		<!-- 2. 调试相关 -->
		<property name="show_sql">true</property>
		<property name="format_sql">true</property>

		<!-- 3. 添加实体映射文件 -->
		<mapping resource="com/pengyuxuan/one/entity/User.hbm.xml" />
	</session-factory>
	</hibernate-configuration>

User实体类
代码:

package com.pengyuxuan.one.entity;

import java.sql.Date;
import java.sql.Timestamp;

public class User {
	private Integer id;
	private String userName;
	private String userPwd;
	private String realName;
	private String sex;
	private Date birthday; 
	private Timestamp createDatetime;
	private String remark; 
	public User() {
		super();
	}
	public User(String userName, String userPwd, String realName, String sex, Date birthday, Timestamp createDatetime,
			String remark) {
		super();
		this.userName = userName;
		this.userPwd = userPwd;
		this.realName = realName;
		this.sex = sex;
		this.birthday = birthday;
		this.createDatetime = createDatetime;
		this.remark = remark;
	}
	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 Date getBirthday() {
		return birthday;
	}
	public void setBirthday(Date birthday) {
		this.birthday = birthday;
	}
	public Timestamp getCreateDatetime() {
		return createDatetime;
	}
	public void setCreateDatetime(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 + "]";
	}
	
}

实体类添加映射文件,并且要在同包下建立 User.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:实体类的全路径
          table:实体类对应数据库中的表
     id标签:
          name:实体类中的属性(映射是表的主键)
          type:属性对应的类型
          colume:属性对应表中的哪一个列段
      property
          name:实体类中的属性(映射是表的非主键)
          type:属性对应的类型
          colume:属性对应表中的哪一个列段
-->
	<class name="com.pengyuxuan.one.entity.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.pengyuxuan.one.test;

import java.util.List;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class QueryDemo {
	
 public static void main(String[] args) {
	//对hibernate.cfg.xml进行建模拿到sessionfactory工厂
	 Configuration configure = new Configuration().configure("/hibernate.cfg.xml");
	 SessionFactory sessionFactory = configure.buildSessionFactory();
	 //对工厂获取到session会话(操作数据库)
	 Session session = sessionFactory.openSession();
	 //直接操作到数据库
	 List list = session.createQuery("from User").list();
	 for (Object obj : list) {
		System.out.println(obj);
	}
	 
	 //关闭资源
	 session.close();
 	}
}

结果:
在这里插入图片描述
增加方法
代码:

package com.pengyuxuan.one.test;

import java.sql.Date;
import java.sql.Timestamp;
import java.util.List;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

import com.pengyuxuan.one.entity.User;

public class AddDemo {
	public static void main(String[] args) {
//		对hibernate.cfg.xml进行建模拿到sessionfactory工厂(两步)
		Configuration configure = new Configuration().configure("/hibernate.cfg.xml");//拿到配置对象
		SessionFactory sessionFactory = configure.buildSessionFactory();//拿到sessionfactory工厂
//		通过工厂获取到session会话
		Session session = sessionFactory.openSession();
//		获取事务对象
		Transaction transaction = session.beginTransaction();
//		直接操作数据库
		session.save(new User("qqq", "996", "马云",  "男", new Date(System.currentTimeMillis()), new Timestamp(System.currentTimeMillis()), "无"));
//		提交事务对象
		transaction.commit();
//		关闭资源 
		session.close();
	}
}

结果
在这里插入图片描述
在这里插入图片描述
修改方法
代码:

package com.pengyuxuan.one.test;
import java.sql.Timestamp;
import java.util.List;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

import com.pengyuxuan.one.entity.User;
public class EditDemo {
	public static void main(String[] args) {
		//对hibernate.cfg.xml进行建模拿到sessionfactory工厂
		Configuration configure = new Configuration().configure("/hibernate.cfg.xml");
	    SessionFactory sessionFactory = configure.buildSessionFactory();
	//通过工厂拿到session会话
	    Session openSession = sessionFactory.openSession();
	//获取事务对象
	    Transaction beginTransaction = openSession.beginTransaction();
	//直接操作数据库
	//方法一:
	//    User user = new User("11", "123", "22", "男", new java.sql.Date(System.currentTimeMillis()), new Timestamp(System.currentTimeMillis()), "暂无介绍");
	//    user.setId(15);
	//    openSession.update(user);
	
	//方法二:
	    User user = openSession.get(User.class, 15);
	    System.out.println(user);
	    user.setRealName("ningjie");
	//提交事务
	    beginTransaction.commit();
	//关闭资源
	    openSession.close();
	}
}

结果
在这里插入图片描述

在这里插入图片描述
删除方法
代码:

package com.pengyuxuan.one.test;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

import com.pengyuxuan.one.entity.User;



public class DelDemo {
	public static void main(String[] args) {
//		对hibernate.cfg.xml进行建模拿到sessionfactory工厂(两步)
		Configuration configure = new Configuration().configure("/hibernate.cfg.xml");//拿到配置对象
		SessionFactory sessionFactory = configure.buildSessionFactory();//拿到sessionfactory工厂
//		通过工厂获取到session会话
		Session session = sessionFactory.openSession();
//		获取事务对象
		Transaction transaction = session.beginTransaction();
//		直接操作数据库
		User user=new User();
		user.setId(1);
		session.delete(user);
//		提交事务对象
		transaction.commit();
//		关闭资源 
		session.close();
	}
}

结果
在这里插入图片描述
在这里插入图片描述

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值