1.hibernate添加
Configuration config = new Configuration().configure();
@SuppressWarnings("deprecation")
SessionFactory sessionFactory = config.buildSessionFactory();
Session session = sessionFactory.openSession();
Transaction tx = null;
String hql = "from Account where XID=:xid and account=:ac and UID=:uid";
Query query = session.createQuery(hql);
query.setInteger("xid", 2);
query.setString("ac", acco);
query.setInteger("uid", Uid);
slist = query.list();
System.out.print(slist.size());
Iterator itor = slist.iterator();
while(itor.hasNext())
{
racco = (Account)itor.next();
}
float rrama = racco.getRama();
if(slist.size() == 1)
{
rrama = rrama + money;
allrama = allrama + money;
trama = trama + money;
racco0.setRama(allrama);
racco.setRama(rrama);
racco1.setRama(trama);
try
{
tx = session.beginTransaction();
session.save(inco);
session.update(racco0);
session.update(racco);
session.update(racco1);
tx.commit();
list.add(inco);
return "success";
}
catch(Exception e)
{
if(tx != null)
tx.rollback();
e.printStackTrace();
return "error";
}
finally
{
session.close();
}
}
else
{
try
{
allrama = allrama + money;
trama = trama + money;
account.setAccount(acco);
account.setRama(money);
account.setUID(Uid);
account.setXID(2);
racco0.setRama(allrama);
racco1.setRama(trama);
tx = session.beginTransaction();
session.update(racco0);
session.save(inco);
session.save(account);
session.update(racco1);
tx.commit();
list.add(inco);
return "success";
}
catch(Exception e)
{
if(tx != null)
tx.rollback();
e.printStackTrace();
return "error";
}
finally
{
session.close();
}
}
}
2.hibernate删除
String hql = "delete from com.adk.vo.Delete where name='"+ name + "'";
SessionFactory sf = new Configuration().configure().buildSessionFactory();
Session session = sf.openSession();
tx = session.beginTransaction();
Query q = session.createQuery(hql);
session.close();