插入数据
public class PersonOperate {
private Session session ;
public PersonOperate()
{
this.session = new Configuration().configure().buildSessionFactory().openSession() ;
}
public void insert(Person p)
{
this.session.save(p) ;
this.session.beginTransaction().commit() ;
}
}
//////////////////////////////////////////////////////////////////////////////////////////////
Configuration conf = new Configuration().configure();
SessionFactory factory = conf.buildSessionFactory() ;//一个数据库一个SessionFactory
Session session = null;//Session 类似于connection
session = factory.openSession();
//开启事务
session.beginTransaction();
//赋值对象
User user = new User();
user.setId("333");
user.setName("333");
user.setPassword("333");
user.setCreateTime(new Date());
user.setExpireTime(new Date());
System.out.println(user.getId());
//添加数据
session.save(user);
//修改数据by id(默认根据id修改数据)
session.update(user);
session.getTransaction().commit();//提交事务完成添加或修改
session.close();//关闭连接
1. 删除数据:
Configuration conf = new Configuration().configure();
SessionFactory factory = conf.buildSessionFactory();
Session session = factory.openSession();
User u = null;
//根据id删除数据
session.beginTransaction();
String hql1 ="DELETE User WHERE id =?";//必须是User类名,而不是USERS表名因为删除的是对象,而不是表,对象就对应着表
Query w = session.createQuery(hql1);
w.setString(0, "bbb");
w.executeUpdate();
session.getTransaction().commit();
session.close();
/**
//删除数据操作通过传一个对象值
session.beginTransaction();
session.delete(u);
session.getTransaction().commit();
session.close();
**/
session.getTransaction().commit();
session.close();