package one;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.classic.Session;
import org.junit.Test;
public class hibernate_curd {
//@Test
public void test_add() {
Configuration con = new Configuration().configure();
SessionFactory sf = con.buildSessionFactory();
Session session = sf.openSession();
Transaction tx = session.beginTransaction();
person p = new person();
p.setName("林泽森");
p.setAge(18);
session.save(p);
tx.commit();
}
//@Test
public void test_dele() {
Configuration con = new Configuration().configure();
SessionFactory sf = con.buildSessionFactory();
Session session = sf.openSession();
Object index = session.get(person.class,3);
session.delete(index);
Transaction tx = session.beginTransaction();
tx.commit();
}
//@Test
public void test_update() {
Configuration con = new Configuration().configure();
SessionFactory sf = con.buildSessionFactory();
Session session = sf.openSession();
person p = new person();
p.setId(2);
p.setName("罗小姐");
p.setAge(16);
session.update(p);//session的update方法只能接受对象参数,同时该对象作用于数据库中存在的元组
Transaction tx = session.beginTransaction();
tx.commit();
}
@Test
public void test_select() {
Configuration con = new Configuration().configure();
SessionFactory sf = con.buildSessionFactory();
Session session = sf.openSession();
Query sql = session.createQuery("from person where id=?");//使用hql查询
Query list = sql.setParameter(0, 2);//注意:参数从0开始
List result = list.list();
System.out.println(result);
}
}
import java.util.List;
import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.classic.Session;
import org.junit.Test;
public class hibernate_curd {
//@Test
public void test_add() {
Configuration con = new Configuration().configure();
SessionFactory sf = con.buildSessionFactory();
Session session = sf.openSession();
Transaction tx = session.beginTransaction();
person p = new person();
p.setName("林泽森");
p.setAge(18);
session.save(p);
tx.commit();
}
//@Test
public void test_dele() {
Configuration con = new Configuration().configure();
SessionFactory sf = con.buildSessionFactory();
Session session = sf.openSession();
Object index = session.get(person.class,3);
session.delete(index);
Transaction tx = session.beginTransaction();
tx.commit();
}
//@Test
public void test_update() {
Configuration con = new Configuration().configure();
SessionFactory sf = con.buildSessionFactory();
Session session = sf.openSession();
person p = new person();
p.setId(2);
p.setName("罗小姐");
p.setAge(16);
session.update(p);//session的update方法只能接受对象参数,同时该对象作用于数据库中存在的元组
Transaction tx = session.beginTransaction();
tx.commit();
}
@Test
public void test_select() {
Configuration con = new Configuration().configure();
SessionFactory sf = con.buildSessionFactory();
Session session = sf.openSession();
Query sql = session.createQuery("from person where id=?");//使用hql查询
Query list = sql.setParameter(0, 2);//注意:参数从0开始
List result = list.list();
System.out.println(result);
}
}