因为最近要用到Hibernate 所以对Hibernate增删改查进行一些整理。
数据库连接:
public class Connection {
public static Configuration cf=null;
public static SessionFactory sf=null;
public static Session session=null;
//加载Hibernate配置文件,并且创建SessionFactory实例
@SuppressWarnings("deprecation")
public static SessionFactory getConnection(){
cf=new Configuration().configure();
sf=cf.buildSessionFactory();
return sf;
}
//关闭连接
public static void closeConnection(SessionFactory sf,Session session){
if(session!=null){
session.close(); //关闭Session
}
if(sf!=null){
sf.close(); //关闭SessionFactory
}}}
保存信息:
public int save(Object basicIfo){
int result=0;
SessionFactory sf=Connection.getConnection();
Session session=sf.openSession();
try{
session.save(basicIfo);
session.beginTransaction().commit();
}catch (Exception e){
result=1;
}finally{
Connection.closeConnection(sf, session);
}
return result;
}
更新信息:
方法一:HQL语句
public int getUpdate(String hql, Object[] parameters) {
SessionFactory sf = Connection.getConnection();
Session session = sf.openSession();
Transaction ts = session.beginTransaction();
int result;
try {
Query query = session.createQuery(hql);
if (parameters.length > 0) {
for (int i = 0; i < parameters.length; i++) {
query.setParameter(i, parameters[i]);
}
}
result = query.executeUpdate();
ts.commit();
} catch (Exception e) {
e.printStackTrace();
ts.rollback();
result = 0;
} finally {
Connection.closeConnection(sf, session);
}
return result;
}
方法二:
//更新信息
public int updata(Object basicIfo){
int result=0;
SessionFactory sf=Connection.getConnection();
Session session=sf.openSession();
Transaction ts=session.beginTransaction();
try{
session.clear();
session.update(basicIfo);
ts.commit();
session.clear();
}catch(Exception e){
e.printStackTrace();
ts.rollback();
result=1;
}finally{
Connection.closeConnection(sf, session);
}
return result;
}
查询信息:
// hql 使用HQL语句进行查询// parameters为查询参数
public List getSelectList(String hql, Object[] parameters) {
SessionFactory sf = Connection.getConnection();// 调用数据库连接类进行连接
Session session = sf.openSession();// 创建session实例
Transaction ts = session.beginTransaction();// 创建事务实例
List result = null;// 存放查询的结果
try {
Query query = session.createQuery(hql);
if (parameters.length > 0) {
for (int i = 0; i < parameters.length; i++) {
query.setParameter(i, parameters[i]);
}
}
result = query.list();// 将查询结果返回
ts.commit();// 提交
} catch (Exception e) {
e.printStackTrace();
ts.rollback();// 如果出错进行回滚
} finally {
Connection.closeConnection(sf, session);// 关闭数据库连接
}
return result;
}
删除:delete()方法,或者也可以使用HQL语句进行删除,同更新操作类似