hibernate与sqlserver的连接

Hibernate是一个开放源代码的对象关系映射框架，它对JDBC进行了非常轻量级的对象封装，它将POJO与数据库表建立映射关系，是一个全自动的orm框架，hibernate可以自动生成SQL语句，自动执行，使得Java程序员可以随心所欲的使用对象编程思维来操纵数据库。 Hibernate可以应用在任何使用JDBC的场合，既可以在Java的客户端程序使用，也可以在Servlet/JSP的Web应用中使用，最具革命意义的是，Hibernate可以在应用EJB的J2EE架构中取代CMP，完成数据持久化的重任。

 

Hibernate的核心类和接口一共有6个:Session、SessionFactory、Transaction、Query、Criteria、Configuration。

导入相关的包。

创建hibernate的配置文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
    <property name="hibernate.connection.password"> </property>
    <property name="hibernate.connection.username">sa</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> 
    <property name="hbm2ddl.auto">create</property> 
    <mapping  resource="student.hbm.xml"/>
    <mapping class="student"/>
    </session-factory>
</hibernate-configuration>

创建持久化类import java.sql.Date;




public class student {

private int sid;
private String sname;
private String gender;
private Date birthday;
private String address;

   public student()
   {
  
  
   }


public student(int sid, String sname, String gender, Date birthday,String address) 
{
//super();
this.sid = sid;
this.sname = sname;
this.gender = gender;
this.birthday = birthday;
this.address = address;
}


public int getSid() {
return sid;
}


public void setSid(int sid) {
this.sid = sid;
}


public String getSname() {
return sname;
}


public void setSname(String sname) {
this.sname = sname;
}

public String getGender() {
return gender;
}

public void setGender(String gender) {
this.gender = gender;
}

public Date getBirthday() {
return birthday;
}

public void setBirthday(Date birthday) {
this.birthday = birthday;
}

public String getAddress() {
return address;
}

public void setAddress(String address) {
this.address = address;
}

@Override
public String toString() {
return "student [sid=" + sid + ", sname=" + sname + ", gender="
+ gender + ", birthday=" + birthday + ", address=" + address
+ "]";
}


}

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

<?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 2016-12-12 14:16:35 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
    <class name="student" table="STUDENT">
        <id name="sid" type="int">
            <column name="SID" />
            <generator class="assigned" />
        </id>
        <property name="sname" type="java.lang.String">
            <column name="SNAME" />
        </property>
        <property name="gender" type="java.lang.String">
            <column name="GENDER" />
        </property>
        <property name="birthday" type="java.sql.Date">
            <column name="BIRTHDAY" />
        </property>
        <property name="address" type="java.lang.String">
            <column name="ADDRESS" />
        </property>
    </class>
</hibernate-mapping>

使用junit进行测试

import java.util.Date;


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








public class StudentTest {
// private String cfgFile="hibernate.cfg.xml";
private SessionFactory Factory;
private Session        session;
private Transaction    transation;

@Before
public void init()
{
Configuration config=new Configuration().configure();
//ServiceRegistry  serviceRegistry=new ServiceRegistryBuilder().applySettings(config.getProperties()).buildServiceRegistry();
Factory=config.buildSessionFactory();
session=Factory.openSession();
transation  =session.beginTransaction();


}

@After
public void destory()
{
transation.commit();
session.close();
Factory.close();

}


@Test
public void testSavestudent()
{
//student s=new student(1,"张三丰","男",new Date(),"武当山");
student s=new student();
s.setSid(1);
        s.setSname("zzz");
        s.setGender("nan");
        s.setAddress("ss");
       
session.save(s);

}


}

结果：