基于webwork+spring+hibernate的portlet开发实例

package cn.ln.portal.visit.dao.imp; import java.util.List; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.Transaction; import cn.ln.portal.visit.orm.VnumTable; import cn.ln.portal.visit.dao.BaseDao; import cn.ln.portal.visit.dao.IVisitDao; public class VisitDaoImp extends BaseDao implements IVisitDao { public void AddToTable(VnumTable vTable) { // TODO Auto-generated method stub Session session = getSession(); Transaction tx = session.beginTransaction(); session.save(vTable); tx.commit(); session.close(); } public void VisitCounter(int numID) { // TODO Auto-generated method stub } public Long getDayNum(int numID) { // TODO Auto-generated method stub Session session = getSession(); String hql = "from VnumTable v where v.numid=?"; Query query = session.createQuery(hql); query.setParameter(0,numID); List vnumTables = query.list(); if(vnumTables.size() != 0){ VnumTable vnum= (VnumTable)vnumTables.get(0); return vnum.getDaynum(); } return null; } public Integer getID(String name) { // TODO Auto-generated method stub Session session = getSession(); String hql = "from VnumTable v where v.name=?"; Query query = session.createQuery(hql); query.setParameter(0,name); List vnumTables = query.list(); if(vnumTables.size() != 0){ VnumTable vnum= (VnumTable)vnumTables.get(0); return vnum.getNumid(); } return null; } public Long getMonthNum(int numID) { // TODO Auto-generated method stub Session session = getSession(); String hql = "from VnumTable v where v.numid=?"; Query query = session.createQuery(hql); query.setParameter(0,numID); List vnumTables = query.list(); if(vnumTables.size() != 0){ VnumTable vnum= (VnumTable)vnumTables.get(0); return vnum.getMonthnum(); } return null; } public Long getYearNum(int numID) { // TODO Auto-generated method stub Session session = getSession(); String hql = "from VnumTable v where v.numid=?"; Query query = session.createQuery(hql); query.setParameter(0,numID); List vnumTables = query.list(); if(vnumTables.size() != 0){ VnumTable vnum= (VnumTable)vnumTables.get(0); return vnum.getYearnum(); } return null; } public String getName(int numID) { // TODO Auto-generated method stub Session session = getSession(); String hql = "from VnumTable v where v.numid=?"; Query query = session.createQuery(hql); query.setParameter(0,numID); List vnumTables = query.list(); if(vnumTables.size() != 0){ VnumTable vnum= (VnumTable)vnumTables.get(0); return vnum.getName(); } return null; } }