1 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>
<!-- 基本配置 开始 -->
<property name="connection.username">user</property>
<property name="connection.password">yourpsd</property>
<property name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="connection.url">jdbc:sqlserver://ip:1433;database=DBName</property>
<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
<!-- 更新数据库表格的方式 -->
<property name="hbm2ddl.auto">update</property>
<!-- 控制台显示sql语句 -->
<property name="show_sql">true</property>
<!-- 控制台显示的sql语句,是否非标准格式 -->
<property name="format_sql">true</property>
<!-- 映射的类(文件) -->
<mapping resource="com/spider/domain/Student.hbm.xml"/>
</session-factory>
</hibernate-configuration>
2 Student.hbm.xml 的配置
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2019-12-12 22:22:31 by Hibernate Tools 3.5.0.Final -->
<hibernate-mapping>
<class name="com.spider.domain.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>
</class>
</hibernate-mapping>
3 Student.java
package com.spider.domain;
public class Student {
private int sid;
private String sname;
private String gender;
public Student(int sid, String sname, String gender) {
this.sid = sid;
this.sname = sname;
this.gender = gender;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public Student() {
}
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;
}
@Override
public String toString() {
return "Student [sid=" + sid + ", sname=" + sname + ", gender=" + gender + "]";
}
}
4 测试类 StudentsTest2.java
package hibernate001;
import java.util.Date;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.criterion.Projection;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
import com.spider.domain.Student;
import com.trash.Sqtudent2;
public class StudentsTest2 {
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();
}
@After
public void destory() {
//提交事务
transaction.commit();
//关闭会话
session.close();
//关闭会话工厂
sessionFactory.close();
}
@Test
public void testCriteriaRows() {
Criteria criteria2 = session.createCriteria(Sqtudent2.class);
criteria2.setProjection(Projections.rowCount());
long rowcount = (long) criteria2.uniqueResult();
System.out.println("总页数是: "+rowcount);
}
@Test
public void testSQL() {
String sqlstr= "SELECT * FROM STUDENT2 where sid = ? ";
SQLQuery query = session.createSQLQuery(sqlstr);
query.setParameter(0, 14);
query.addEntity(Sqtudent2.class);
List list = query.list();
System.out.println("list: "+list);
}
}