实例介绍
【实例简介】
【实例截图】
【实例截图】
【核心代码】
package com.yxq.action; import java.io.UnsupportedEncodingException; import java.util.List; import com.yxq.actionSuper.InfoSuperAction; import com.yxq.dao.OpDB; import com.yxq.model.CreatePage; import com.yxq.tools.DoString; public class InfoAction extends InfoSuperAction { public String ListShow(){ request.setAttribute("mainPage","/pages/show/listshow.jsp"); String infoType=request.getParameter("infoType"); Object[] params={infoType}; String sqlPayfor="SELECT * FROM tb_info WHERE (info_type = ?) AND (info_state='1') AND (info_payfor = '1') ORDER BY info_date DESC"; OpDB myOp=new OpDB(); /* 获取所有的付费信息 */ List onepayforlist=myOp.OpListShow(sqlPayfor, params); //获取所有付费信息 request.setAttribute("onepayforlist",onepayforlist); /* 获取当前页要显示的免费信息 */ String sqlFreeAll="SELECT * FROM tb_info WHERE (info_type = ?) AND (info_state='1') AND (info_payfor = '0') ORDER BY info_date DESC"; String sqlFreeSub=""; int perR=3; String strCurrentP=request.getParameter("showpage"); String gowhich="info_ListShow.action?infoType=" infoType; CreatePage createPage=myOp.OpCreatePage(sqlFreeAll, params,perR,strCurrentP,gowhich); //调用OpDB类中的OpCreatePage()方法计算出总记录数、总页数,并且设置当前页码,这些信息都封装到了createPage对象中 int top1=createPage.getPerR(); int currentP=createPage.getCurrentP(); if(currentP==1){ //设置显示第1页信息的SQL语句 sqlFreeSub="SELECT * FROM tb_info WHERE (info_type = ?) AND (info_state = '1') AND (info_payfor = '0') ORDER BY info_date DESC limit 0," top1; } else{ //设置显示除第1页外,其他指定页码信息的SQl语句 int top2=(currentP-1)*top1; sqlFreeSub="SELECT * FROM tb_info i WHERE (info_type = ?) AND (info_state = '1') AND (info_payfor = '0') AND (info_date < (SELECT MIN(info_date) FROM (SELECT TOP " top2 " (info_date) FROM tb_info WHERE (info_type = i.info_type) AND (info_state = '1') AND (info_payfor = '0') ORDER BY info_date DESC) AS mindate)) ORDER BY info_date DESC limit 0," top1; // sqlFreeSub="SELECT TOP " top1 " * FROM tb_info i WHERE (info_type = ?) AND (info_state = '1') AND (info_payfor = '0') AND (info_date NOT IN (SELECT TOP " top2 " info_date FROM tb_info WHERE (info_type = i.info_type) AND (info_state = '1') AND (info_payfor = '0') ORDER BY info_date DESC)) ORDER BY info_date DESC"; //另一种实现分页查询的SQL语句 } List onefreelist=myOp.OpListShow(sqlFreeSub, params); //获取免费信息,信息数量由createPage.setPerR(int PerR)方法指定 request.setAttribute("onefreelist",onefreelist); request.setAttribute("createpage", createPage); return SUCCESS; } public String SingleShow(){ request.setAttribute("mainPage","/pages/show/singleshow.jsp"); String id=request.getParameter("id"); String sql="SELECT * FROM tb_info WHERE (id = ?)"; Object[] params={id}; OpDB myOp=new OpDB(); infoSingle=myOp.OpSingleShow(sql, params); if(infoSingle==null){ request.setAttribute("mainPage","/pages/error.jsp"); addFieldError("SingleShowNoExist",getText("city.singleshow.no.exist")); } return SUCCESS; } public String Add(){ System.out.println("正在执行Add()方法…"); String addType=request.getParameter("addType"); if(addType==null||addType.equals("")){ request.setAttribute("mainPage","/pages/add/addInfo.jsp"); addType="linkTo"; } if(addType.equals("add")){ request.setAttribute("mainPage","/pages/error.jsp"); OpDB myOp=new OpDB(); Integer type=Integer.valueOf(infoSingle.getInfoType()); String title=infoSingle.getInfoTitle(); String content=DoString.HTMLChange(infoSingle.getInfoContent()); String phone=infoSingle.getInfoPhone(); phone=phone.replaceAll(",","●"); String linkman=infoSingle.getInfoLinkman(); String email=infoSingle.getInfoEmail(); String date=DoString.dateTimeChange(new java.util.Date()); String state="0"; String payfor="0"; Object[] params={type,title,content,linkman,phone,email,date,state,payfor}; String sql="insert into tb_info values(null,?,?,?,?,?,?,?,?,?)"; int i=myOp.OpUpdate(sql,params); if(i<=0) addFieldError("addE",getText("city.info.add.E")); else{ sql="select * from tb_info where info_date=?"; Object[] params1={date}; int infoNum=myOp.OpSingleShow(sql, params1).getId(); addFieldError("addS",getText("city.info.add.S") infoNum); } } return SUCCESS; } public String SearchShow() throws UnsupportedEncodingException{ request.setAttribute("mainPage","/pages/show/searchshow.jsp"); String subsql=searchInfo.getSubsql(); String sqlvalue=searchInfo.getSqlvalue(); String type=searchInfo.getType(); String showType=request.getParameter("showType"); if(showType==null) showType=""; if(showType.equals("link")){ //对从超链接中获取的参数进行转码操作 try { sqlvalue=new String(sqlvalue.getBytes("ISO-8859-1"),"gb2312"); } catch (UnsupportedEncodingException e) { sqlvalue=""; e.printStackTrace(); } searchInfo.setSqlvalue(sqlvalue); } session.put("subsql",subsql); session.put("sqlvalue",sqlvalue); session.put("type",type); String param=""; String opname=""; if(type.equals("like")){ opname=" LIKE "; param="%" sqlvalue "%"; } else{ opname=" = "; param=sqlvalue; } String sqlSearchAll="SELECT * FROM tb_info WHERE (" subsql opname "?) ORDER BY info_date DESC"; String sqlSearchSub=""; Object[] params={param}; int perR=8; String strCurrentP=request.getParameter("showpage"); String gowhich = "info_SearchShow.action?searchInfo.subsql=" subsql "&searchInfo.sqlvalue=" sqlvalue "&searchInfo.type=" type "&showType=link"; OpDB myOp=new OpDB(); CreatePage createPage=myOp.OpCreatePage(sqlSearchAll, params,perR,strCurrentP,gowhich); //调用OpDB类中的OpCreatePage()方法计算出总记录数、总页数,并且设置当前页码,这些信息都封装到了createPage对象中 int top1=createPage.getPerR(); int currentP=createPage.getCurrentP(); if(currentP==1){ //显示第1页信息的SQL语句 sqlSearchSub="SELECT * FROM tb_info WHERE (" subsql opname "?) ORDER BY info_date DESC limit 0," top1; } else{ //显示除第1页外,其他指定页码信息的SQl语句 int top2=(currentP-1)*top1; sqlSearchSub="SELECT * FROM tb_info WHERE (" subsql opname "?) AND (info_date < (SELECT MIN(info_date) FROM (SELECT info_date FROM tb_info WHERE " subsql opname "'" param "' ORDER BY info_date DESC limit 0," top2 ") AS mindate)) ORDER BY info_date DESC limit 0," top1; // sqlSearchSub="SELECT TOP " top1 " * FROM tb_info WHERE (" subsql opname "?) AND (info_date NOT IN (SELECT TOP " top2 " info_date FROM tb_info WHERE " subsql opname "'" param "' ORDER BY info_date DESC)) ORDER BY info_date DESC"; //另一种实现分页查询的SQL语句 } List searchlist=myOp.OpListShow(sqlSearchSub, params); request.setAttribute("searchlist",searchlist); request.setAttribute("createpage", createPage); return SUCCESS; } public void validateListShow(){ request.setAttribute("mainPage","/pages/error.jsp"); String infoType=request.getParameter("infoType"); if(infoType==null&&infoType.equals("")){ System.out.println("请选择要查询的信息类别!"); addFieldError("ListShowNoType",getText("city.info.listshow.no.infoType")); } else{ try{ Integer.parseInt(infoType); }catch(NumberFormatException e){ System.out.println("信息类别不是数字格式!"); addFieldError("ListShowWrongType",getText("city.info.listshow.format.infoType")); e.printStackTrace(); } } } public void validateSingleShow(){ request.setAttribute("mainPage","/pages/error.jsp"); String id=request.getParameter("id"); if(id==null&&id.equals("")){ System.out.println("请选择要查看的信息!"); addFieldError("SingleShowNoID",getText("city.info.singleshow.no.id")); } else{ try{ Integer.parseInt(id); }catch(NumberFormatException e){ System.out.println("信息ID值不是数字格式!"); addFieldError("ListShowWrongID",getText("city.info.listshow.format.infoID")); e.printStackTrace(); } } } public void validateAdd(){ System.out.println("正在执行validateAdd()方法…"); request.setAttribute("mainPage","/pages/add/addInfo.jsp"); String addType=request.getParameter("addType"); if(addType==null||addType.equals("")) addType="linkTo"; if(addType.equals("add")){ int type=infoSingle.getInfoType(); String title=infoSingle.getInfoTitle(); String content=infoSingle.getInfoContent(); String phone=infoSingle.getInfoPhone(); String linkman=infoSingle.getInfoLinkman(); String email=infoSingle.getInfoEmail(); boolean mark=true; if(type<=0){ mark=false; addFieldError("typeError",getText("city.info.no.infoType")); } if(title==null||title.equals("")){ mark=false; addFieldError("titleError",getText("city.info.no.infoTitle")); } if(content==null||content.equals("")){ mark=false; addFieldError("contentError",getText("city.info.no.infoContent")); } if(phone==null||phone.equals("")){ mark=false; addFieldError("phoneError",getText("city.info.no.infoPhone")); } if(linkman==null||linkman.equals("")){ mark=false; addFieldError("linkmanError",getText("city.info.no.infoLinkman")); } if(email==null||email.equals("")){ mark=false; addFieldError("emailError",getText("city.info.no.infoEmail")); } if(mark){ String phoneRegex="(\\d{3}-)\\d{8}|(\\d{4}-)(\\d{7}|\\d{8})|\\d{11}"; if(phone.indexOf(",")<0){ if(!infoSingle.getInfoPhone().matches(phoneRegex)){ addFieldError("phoneError",getText("city.info.format.infoPhone")); } } else{ String[] phones=phone.split(","); for(int i=0;i<phones.length;i ){ if(!phones[i].matches(phoneRegex)){ addFieldError("phoneError",getText("city.info.format.infoPhone")); break; } } } String emailRegex="\\w ([- .]\\w )*@\\w ([-.]\\w )*\\.\\w ([-.]\\w )*"; if(!infoSingle.getInfoEmail().matches(emailRegex)){ addFieldError("emailError",getText("city.info.format.infoEmail")); } } } } public void validateSearchShow() { request.setAttribute("mainPage","/pages/error.jsp"); String subsql=searchInfo.getSubsql(); String sqlvalue=searchInfo.getSqlvalue(); String type=searchInfo.getType(); if(subsql==null||subsql.equals("")){ addFieldError("SearchNoC",getText("city.info.search.no.condition")); } if(sqlvalue==null||sqlvalue.equals("")){ addFieldError("SearchNoV",getText("city.info.search.no.value")); } if(type==null||type.equals("")){ addFieldError("SearchNoT",getText("city.info.search.no.type")); } } }
好例子网口号:伸出你的我的手 — 分享!
相关软件
小贴士
感谢您为本站写下的评论,您的评论对其它用户来说具有重要的参考价值,所以请认真填写。
- 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
- 相信您也不想看到一排文字/表情墙,所以请不要反馈意义不大的重复字符,也请尽量不要纯表情的回复。
- 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
- 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。
关于好例子网
本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享,对搜索内容的合法性不具有预见性、识别性、控制性,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论平台是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定,若资源存在侵权或相关问题请联系本站客服人员,点此联系我们。关于更多版权及免责申明参见 版权及免责申明
网友评论
我要评论