/**
* <p>Title: Orders</p>
* <p>Description: </p>
*
* @author yesir
* @email yesir520@gmail.com
* @website www.yesir520.com
*/
package com.xp.yesir.dao.hibernate;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.apache.log4j.LogManager;
import org.apache.log4j.Logger;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.xp.yesir.bean.Gadget;
import com.xp.yesir.dao.IGadgetDAO;
public class GadgetHibernateDAO extends HibernateDaoSupport implements
IGadgetDAO {
private static final Logger LOGGER = LogManager
.getLogger(GadgetHibernateDAO.class);
/**
*
*/
public GadgetHibernateDAO() {
super();
// TODO Auto-generated constructor stub
}
public Gadget saveGadget(Gadget gadget) {
try {
LOGGER.info("保存服务到数据库！");
this.getHibernateTemplate().save(gadget);
return gadget;
} catch (Exception ex) {
LOGGER.error("保存服务到数据库失败！");
LOGGER.error(ex.getMessage());
ex.printStackTrace();
return null;
}
}
public Gadget updateGadget(Gadget gadget) {
try {
LOGGER.info("修改服务到数据库！");
this.getHibernateTemplate().update(gadget);
return gadget;
} catch (Exception ex) {
LOGGER.error("修改服务到数据库失败！");
LOGGER.error(ex.getMessage());
ex.printStackTrace();
return null;
}
}
public int getRows(String type, String serviceClass, Integer customerId, String orderType, String searchKey) {
try {
LOGGER.info("获取总数");
String serviceAll = "";
if (type.equals("1")) {
serviceAll = "'SF000001','SF000002','SF000003','SF000004'";
} else if (type.equals("2")) {
serviceAll = "'SF000002','SF000007'";
} else if (type.equals("3")) {
serviceAll = "'SF000006'";
} else if (type.equals("4")) {
serviceAll = "'SF000005'";
}
serviceClass = "'" + serviceClass + "'";
if (serviceClass.equals("'all'")) {
serviceClass = serviceAll;
}
serviceClass = "(" + serviceClass + ")";
String orderBy = "";
//orderType=0 提交时间降序
//orderType=1 提交时间升序
//orderType=2 人气升序
//orderType=3 人气降序
if (orderType.equals("0")) {
orderBy = " order by g.createTime desc ";
} else if (orderType.equals("1")) {
orderBy = " order by g.createTime ";
} else if (orderType.equals("2")) {
orderBy = " order by g.serviceCount ";
} else if (orderType.equals("3")) {
orderBy = " order by g.serviceCount desc ";
}
String searchStr = "";
if(!searchKey.equals("")){
searchStr = " and g.serviceTitle like '%" + searchKey + "%' ";
}
String sql = "";
if (type.equals("3")){
sql = "from Gadget g where g.serviceClass in " + serviceClass
+ " and g.creator='" + customerId.toString() + "' " + searchStr + orderBy;
}
else{
sql = "from Gadget g where g.serviceClass in " + serviceClass
+ searchStr + orderBy;
}
List list = this.getHibernateTemplate().find(sql);
return list.size();
} catch (Exception ex) {
LOGGER.error("获取所有订单明明细项列表失败！");
LOGGER.error(ex.getMessage());
ex.printStackTrace();
return 0;
}
}
public List findGadgetType(String type, String serviceClass,
Integer pageSize, Integer startRow, Integer customerId, String orderType, String searchKey) {
try {
LOGGER.info("按类型查询");
String serviceAll = "";
//type=1 主页服务
//type=2 游戏服务
//type=3 QQ空间服务
//type=4 FLASH报务
if (type.equals("1")) {
serviceAll = "'SF000001','SF000002','SF000003','SF000004'";
} else if (type.equals("2")) {
serviceAll = "'SF000002','SF000007'";
} else if (type.equals("3")) {
serviceAll = "'SF000006'";
} else if (type.equals("4")) {
serviceAll = "'SF000005'";
}
serviceClass = "'" + serviceClass + "'";
if (serviceClass.equals("'all'")) {
serviceClass = serviceAll;
}
serviceClass = "(" + serviceClass + ")";
String orderBy = "";
//orderType=0 提交时间降序
//orderType=1 提交时间升序
//orderType=2 人气升序
//orderType=3 人气降序
if (orderType.equals("0")) {
orderBy = " order by g.createTime desc ";
} else if (orderType.equals("1")) {
orderBy = " order by g.createTime ";
} else if (orderType.equals("2")) {
orderBy = " order by g.serviceCount ";
} else if (orderType.equals("3")) {
orderBy = " order by g.serviceCount desc ";
}
String searchStr = "";
if(!searchKey.equals("")){
searchStr = " and g.serviceTitle like '%" + searchKey + "%' ";
}
final int pageSize1 = pageSize.intValue();
final int startRow1 = startRow.intValue();
String sql = "";
if (type.equals("3")){
sql = "from Gadget g where g.serviceClass in " + serviceClass
+ " and g.creator='" + customerId.toString() + "' " + searchStr + orderBy;
}
else{
sql = "from Gadget g where g.serviceClass in " + serviceClass
+ searchStr + orderBy;
}
final String sql1 = sql;
return this.getHibernateTemplate().executeFind(
new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
Query query = session.createQuery(sql1);
query.setFirstResult(startRow1);
query.setMaxResults(pageSize1);
return query.list();
}
});
} catch (Exception ex) {
LOGGER.error("按类型查询失败！");
LOGGER.error(ex.getMessage());
ex.printStackTrace();
return new ArrayList();
}
}
public void removeGadget(Gadget gadget) {
try {
LOGGER.info("删除指定服务");
String gadgetId = gadget.getGadgetId().toString();
this.getHibernateTemplate().delete(gadget);
LOGGER.info("将用户已添加的指定服务置为无效");
final String sql = "update Orders od set od.isValid=0 where od.gadgetId="
+ gadgetId;
this.getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
Query query = session.createQuery(sql);
query.executeUpdate();
return null;
}
});
} catch (Exception ex) {
LOGGER.error("删除指定服务失败");
LOGGER.error(ex.getMessage());
ex.printStackTrace();
}
}
public void updateGadgetCount(Integer gadgetId) {
try {
LOGGER.info("根据gadgetId更新人气");
final String sql = "update Gadget gd set gd.serviceCount=gd.serviceCount+1 where gd.gadgetId="
+ gadgetId.intValue();
this.getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
Query query = session.createQuery(sql);
query.executeUpdate();
return null;
}
});
} catch (Exception ex) {
LOGGER.error("根据gadgetId更新人气失败！");
LOGGER.error(ex.getMessage());
ex.printStackTrace();
}
}
public int findGagdetForCheck(String checkType, String checkValue) {
try {
LOGGER.info("检查有无重复服务");
String checkTypeName = "sourceLink";
if ("SF000006".equals(checkType))
checkTypeName = "qqid";
List list = this.getHibernateTemplate().find(
"from Gadget g where g." + checkTypeName + "='" + checkValue +"' and serviceClass='" + checkType +"'");
return list.size();
} catch (Exception ex) {
LOGGER.error("检查有无重复服务失败！");
LOGGER.error(ex.getMessage());
ex.printStackTrace();
return 0;
}
}
public Gadget findGadgetByID(Integer gadgetId){
try {
LOGGER.info("根据服务ID查服务信息");
List list = this.getHibernateTemplate().find("from Gadget
jsp+Mysql做的QQ空间 界面豪华 大方 美观 功能齐全
5星 · 超过95%的资源 需积分: 10 197 浏览量
2011-06-23
07:27:57
上传
评论 3
收藏 1.38MB RAR 举报 
jsp+Mysql做的QQ空间 界面豪华 大方 美观 功能齐全 （522个子文件） 
GadgetHibernateDAO.class 7KB UpdateServiceAction.class 5KB SetServiceAction.class 5KB OrderHibernateDAO.class 5KB CustomerHibernateDAO.class 5KB DelServiceAction.class 5KB MessageBoardHibernateDAO.class 5KB LoginAction.class 4KB SetMessageBoardAction.class 4KB UpdateMessageBoardAction.class 4KB SearchAllServiceAction.class 4KB SaveMyServiceAction.class 4KB RegisterAction.class 4KB DelMyServiceAction.class 4KB DelMessageBoardAction.class 4KB AbstractCustomer.class 4KB proxyGetFile.class 4KB SetPasswordAction.class 4KB IndexEnterAction.class 4KB SearchMessageBoardAction.class 4KB SetPersonalInfoAction.class 4KB AbstractGadget.class 4KB UpdateMyServiceAction.class 3KB BaseAction.class 3KB SearchMyServiceInnerAction.class 3KB AbstractMessageBoard.class 3KB SearchMyServiceAction.class 3KB FindServiceForCheckAction.class 3KB CheckUserNameAction.class 3KB RandomFetchMaximAction.class 3KB CheckCodeVerifyAction.class 3KB LogoutAction.class 3KB RandomFindCustomerAction.class 3KB GadgetInfoForm.class 3KB GadgetServiceImpl.class 3KB ShowPersonalInfoAction.class 3KB SetMyServiceAction.class 2KB AbstractOrders.class 2KB PersonalInfoForm.class 2KB MessageInfoForm.class 2KB MaximHibernateDAO.class 2KB Pager.class 2KB RegisterForm.class 2KB CustomerServiceImpl.class 2KB OrderInfoForm.class 2KB MessageBoardServiceImpl.class 2KB AbstractMaximBoard.class 2KB OrderServiceImpl.class 1KB MessageBoardHibernateDAO$1.class 1KB GadgetHibernateDAO$1.class 1KB CustomerHibernateDAO$1.class 1KB SetCharacterEncodingFilter.class 1KB AjaxResponseDTO.class 1KB MaximHibernateDAO$1.class 1KB MessageBoardHibernateDAO$2.class 1KB MessageBoardHibernateDAO$3.class 1KB GadgetHibernateDAO$2.class 1KB GadgetHibernateDAO$3.class 1KB OrderHibernateDAO$3.class 1KB OrderHibernateDAO$2.class 1KB OrderHibernateDAO$1.class 1KB LoginForm.class 1KB AjaxUtil.class 978B AppContext.class 855B MaximServiceImpl.class 820B IGadgetDAO.class 763B IGadgetService.class 668B MessageBoard.class 561B Customer.class 545B Gadget.class 535B Maxim.class 535B Orders.class 534B ICustomerDAO.class 533B ICustomerService.class 528B IMessageBoardDAO.class 459B YesirConstant.class 408B IMessageBoardService.class 400B IOrderDAO.class 353B IOrderService.class 348B IMaximService.class 181B IMaximDAO.class 168B .classpath 5KB setService.css 10KB common.css 7KB default.css 5KB screen.css 4KB thickbox.css 4KB adidas.css 3KB messageBox.css 2KB login.css 2KB guide.css 983B Thumbs.db 106KB Thumbs.db 82KB Thumbs.db 23KB Thumbs.db 9KB Thumbs.db 7KB Entries 2KB Entries 2KB Entries 2KB Entries 1KB共 522 条
- 1
- 2
- 3
- 4
- 5
- 6
hurryin
- 粉丝: 6
- 资源: 27
- 1
- 2
- 3
前往页