hibernate小例子—hibernate连接sqlserver

hibernate工程项目就是普通的Java项目，建立好Java项目后。导入必要的jar包。

https://download.csdn.net/download/weixin_40544356/10615901里面有需要的jar包，需要一个积分，因为不知道怎么可以让大家免费下载，我没找到0积分

1、创建hibernate的配置文件hibernate.cfg.xml。右键点击src，选择other，选择hibernate，选择第一个cfg.xml，点击next，保留默认名，点击finish。

<?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>
    	<!-- super administrator的简写，超级管理用户 -->
    	<property name="connection.username">sa</property> 
    	<property name="connection.password">123366</property>
    	<property name="hibernate.connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
    	<property name="connection.url">jdbc:sqlserver://localhost:1433;databaseName=hibernate</property> 
    	<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
    	
    	<!-- hibernate工程成功运行后，可以在console看见格式化的sql语句 -->
    	<property name="show_sql">true</property>
    	<property name="format_sql">true</property>
    	<!-- 给所有表添加前缀 -->
    	<!--<property name="hibernate.default_schema">dbo</property>-->
    	<!-- 删除原有的表结构，生成新的表后加入数据 -->
    	<!-- update值，保留原有的表，加入新的数据 -->
    	<property name="hbm2ddl.auto">create</property>
    	
    	<mapping resource="Student.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

2、在src目录下建立Student.java的JavaBean

package hibernate_demo1;

public class Student {
	private int id;
	private String name;
	private String sex;
	
	public Student() {}

	public Student(int id, String name, String sex) {
		this.id = id;
		this.name = name;
		this.sex = sex;
	}

    //getter、setter方法
	
	@Override
	public String toString() {
		return "Student [id=" + id + ", name=" + name + ", sex=" + sex +"]";
	}
	
}

3、创建对象—关系映射文件

右键点击src，选择other，选择hibernate，选择最后一个hbm.xml，选择对应的JavaBean。所有内容都是自动添加的。

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2018-8-20 17:30:00 by Hibernate Tools 3.5.0.Final -->
<hibernate-mapping>
    <class name="hibernate_demo1.Student" table="STUDENT">
        <id name="id" type="int">
            <column name="ID" />
            <generator class="assigned" />
        </id>
        <property name="name" type="java.lang.String">
            <column name="NAME" />
        </property>
        <property name="sex" type="java.lang.String">
            <column name="SEX" />
        </property>
    </class>
</hibernate-mapping>

4、右键点击工程，建立一个source folder，取名test，在test中新建StudentTest.java，重写@Before、@Test、@After方法

package hibernate_demo1;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;

public class StudentTest {
	private SessionFactory sessionFactory;
	private Session        session;
	private Transaction    transaction;
	
	@Before
	public void init() {
		//创建配置对象
		Configuration config=new Configuration().configure();
		//创建服务注册对象
		ServiceRegistry  serviceRegistry=new ServiceRegistryBuilder().applySettings(config.getProperties()).buildServiceRegistry();
		//创建会话工厂对象
		sessionFactory=config.buildSessionFactory(serviceRegistry);
		//会话对象
		session=sessionFactory.openSession();
		//打开事务
		transaction  =session.beginTransaction();
	}
	
	@Test
	public void testSaveStudent() {
		Student s = new Student(1,"张三","男");
		session.save(s);
	}
	
	@After
	public void destory() {
		transaction.commit();	//提交事务
		session.close();	//关闭会话
		sessionFactory.close();	//关闭会话工厂
	}
}

5、在SQL server中新建一个数据库

6、运行。右键点击重写的@Test方法，选择run as，选择JUnit Test

7、运行结果。出现蓝色进度条，表明运行成功