Hibernate 之 增删改查

Hibernate之增删查改（ORACLE数据库）

前提：SCHOOL的表结构如下,
SQL> describe school;
名称 是否为空 类型
----------------------------------------- -------- ------------------------
ID NOT NULL NUMBER(38)
NAME NOT NULL VARCHAR2(100)

1.
向SCHOOL表添加100条记录
void add()
{
Transaction ts = null;
Session sess = HibernateSessionFactory.getSession();

for(int i=0; i<100; i++)
{

try{

ts = sess.beginTransaction();

School bkg = new School();
bkg.setId(new BigDecimal(i));
bkg.setName("北京大学");
sess.save(bkg);

ts.commit();
}
catch(ConstraintViolationException e)
{
System.out.println(e.getMessage());
}

}

sess.close();
}

2.删除前50条记录
void Delete()
{
Transaction ts = null;
Session sess = HibernateSessionFactory.getSession();
for(int i=0; i<50; i++)
{

try{

ts = sess.beginTransaction();

School bkg = (School)sess.get(School.class, new BigDecimal(i));
sess.delete(bkg);

ts.commit();
}
catch(PropertyValueException e)
{
System.out.println(e.getMessage());
}

}
sess.close();
}

3.修改前25条记录的name为“清华大学”
void Update()
{
Transaction ts = null;
Session sess = HibernateSessionFactory.getSession();
for(int i=50; i<75; i++)
{

try{

ts = sess.beginTransaction();

School bkg = (School)sess.get(School.class, new BigDecimal(i));
bkg.setName("北京大学");
sess.update(bkg);

ts.commit();
}
catch(PropertyValueException e)
{
System.out.println(e.getMessage());
}

}
sess.close();
}
4.查询id=86的记录
void Search()
{
Transaction ts = null;
Session sess = HibernateSessionFactory.getSession();

try{

School bkg = (School)sess.get(School.class, new BigDecimal(86));
System.out.println(bkg.getId() + "---" + bkg.getName());
}
catch(PropertyValueException e)
{
System.out.println(e.getMessage());
}

sess.close();
}

5.HQL查询方式

void HQLSearch() {


Transaction ts = null;
Session sess = HibernateSessionFactory.getSession();

try{

Query qry = sess.createQuery("from School");
List lst = qry.list();
for(School sl: lst)
{
System.out.println("Name = "+sl.getName()+ " id=" +sl.getId());
}
}
catch(PropertyValueException e)
{
System.out.println(e.getMessage());
}

sess.close();

}

6.SQL查询

void SqlSearch()

{
// TODO Auto-generated method stub

Transaction ts = null;
Session sess = HibernateSessionFactory.getSession();

try{

List sq = sess.createSQLQuery("select * from school where id <52").addEntity(School.class).list();


for(School sl: sq)
{
System.out.println(sl.getName()+sl.getId());
}
}
catch(PropertyValueException e)
{
System.out.println(e.getMessage());
}

sess.close();

}