Struts 2.0+SQL Server 2000-都市供求信息网

Struts2类包：

commons-logging-1.0.4.jar

freemarker-2.3.8.jar

ognl-2.6.11.jar

struts2-core-2.0.11.jar

xwork-2.0.4.jar

 

Config:

struts.xml

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN" "http://struts.apache.org/dtds/struts-2.0.dtd"> <struts> <include file="cityinfo.xml"/> </struts>

struts.properties

struts.i18n.encoding=gb2312

cityinfo.xml

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN" "http://struts.apache.org/dtds/struts-2.0.dtd"> <struts> <package name="cityInfo" extends="struts-default"> <!-- 访问首页 --> <action name="goindex" class="com.yxq.action.IndexAction"> <result>/view/IndexTemp.jsp</result> </action> <!-- 前台信息处理 --> <action name="info_*" class="com.yxq.action.InfoAction" method="{1}"> <result>/view/IndexTemp.jsp</result> <result name="input">/view/IndexTemp.jsp</result> </action> <!-- 管理员登录/退出 --> <action name="log_*" class="com.yxq.action.LogInOutAction" method="{1}"> <result name="input">/pages/admin/Login.jsp</result> <result name="login">/pages/admin/view/AdminTemp.jsp</result> <result name="logout" type="redirectAction">goindex</result> </action> <!-- 后台管理员操作 --> <action name="admin_*" class="com.yxq.action.AdminAction" method="{1}"> <result name="input">/pages/admin/view/AdminTemp.jsp</result> <result>/pages/admin/view/AdminTemp.jsp</result> <result name="checkSuccess" type="redirectAction"> <param name="actionName">admin_*</param> <param name="method">ListShow</param> </result> <result name="deleteSuccess" type="redirectAction"> admin_ListShow.action </result> <result name="setMoneySuccess">/pages/admin/view/AdminTemp.jsp</result> <result name="UnSuccess">/pages/admin/view/AdminTemp.jsp</result> </action> </package> </struts>

web.xml

<?xml version="1.0" encoding="UTF-8"?> <web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"> <filter> <filter-name>struts2</filter-name> <filter-class>org.apache.struts2.dispatcher.FilterDispatcher</filter-class> </filter> <filter-mapping> <filter-name>struts2</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <taglib> <taglib-uri>struts2</taglib-uri> <taglib-location>/WEB-INF/tld/struts-tags.tld</taglib-location> </taglib> </web-app>

action:

AdminAction.java

package com.yxq.action; import java.util.List; import com.yxq.actionSuper.AdminSuperAction; import com.yxq.dao.OpDB; import com.yxq.model.CreatePage; public class AdminAction extends AdminSuperAction { /** 功能：管理员操作-进行列表显示信息 */ public String ListShow(){ request.setAttribute("mainPage","../info/listshow.jsp"); session.remove("adminOP"); int infoType=showType.getInfoType(); String stateType=showType.getStateType(); String payforType=showType.getPayforType(); session.put("infoType",Integer.valueOf(infoType)); //保存已选择的“信息类别”的选项 session.put("payforType",payforType); //保存已选择的“付费状态”的选项 session.put("stateType",stateType); //保存已选择的“审核状态”的选项 String sqlall=""; String sqlsub=""; Object[] params=null; String mark=""; int perR=8; if(!stateType.equals("all")&&!payforType.equals("all")){ //没有同时选择“付费状态”与“审核状态”中的“全部”选项 mark="1"; sqlall="SELECT * FROM tb_info WHERE (info_type=?) AND (info_state=?) AND (info_payfor=?) ORDER BY info_date DESC"; sqlsub="SELECT TOP "+perR+" * FROM tb_info WHERE (info_type=?) AND (info_state=?) AND (info_payfor=?) ORDER BY info_date DESC"; params=new Object[3]; params[0]=Integer.valueOf(infoType); params[1]=stateType; params[2]=payforType; }else if(stateType.equals("all")&&payforType.equals("all")){ //同时选择了“付费状态”与“审核状态”中的“全部”选项 mark="2"; sqlall="SELECT * FROM tb_info WHERE (info_type=?) ORDER BY info_date DESC"; sqlsub="SELECT TOP "+perR+" * FROM tb_info WHERE (info_type=?) ORDER BY info_date DESC"; params=new Object[1]; params[0]=Integer.valueOf(infoType); }else if(payforType.equals("all")){ //选择了“付费状态”中的“全部”选项，“审核状态”选项任意 mark="3"; sqlall="SELECT * FROM tb_info WHERE (info_type=?) AND (info_state=?) ORDER BY info_date DESC"; sqlsub="SELECT TOP "+perR+" * FROM tb_info WHERE (info_type=?) AND (info_state=?) ORDER BY info_date DESC"; params=new Object[2]; params[0]=Integer.valueOf(infoType); params[1]=stateType; } else if(stateType.equals("all")){ //选择了“审核状态”中的“全部”选项，“付费状态”选项任意 mark="4"; sqlall="SELECT * FROM tb_info WHERE (info_type=?) AND (info_payfor=?) ORDER BY info_date DESC"; sqlsub="SELECT TOP "+perR+" * FROM tb_info WHERE (info_type=?) AND (info_payfor=?) ORDER BY info_date DESC"; params=new Object[2]; params[0]=Integer.valueOf(infoType); params[1]=payforType; } String strCurrentP=request.getParameter("showpage"); String gowhich="admin_ListShow.action"; OpDB myOp=new OpDB(); CreatePage createPage=myOp.OpCreatePage(sqlall, params,perR,strCurrentP,gowhich); //调用OpDB类中的OpCreatePage()方法计算出总记录数、总页数，并且设置当前页码，这些信息都封装到了createPage对象中 int currentP=createPage.getCurrentP(); if(currentP>1){ int top=(currentP-1)*perR; if(mark.equals("1")){ sqlsub="SELECT TOP "+perR+" * FROM tb_info i WHERE (info_type = ?) AND (info_payfor = ?) AND (info_state = ?) AND (info_date < (SELECT MIN(info_date) FROM (SELECT TOP "+top+" (info_date) FROM tb_info WHERE (info_type = i.info_type) AND (info_payfor = i.info_payfor) AND (info_state = i.info_state) ORDER BY info_date DESC) AS mindate)) ORDER BY info_date DESC"; } else if(mark.equals("2")){ sqlsub="SELECT TOP "+perR+" * FROM tb_info i WHERE (info_type = ?) AND (info_date < (SELECT MIN(info_date) FROM (SELECT TOP "+top+" (info_date) FROM tb_info WHERE (info_type = i.info_type) ORDER BY info_date DESC) AS mindate)) ORDER BY info_date DESC"; } else if(mark.equals("3")){ sqlsub="SELECT TOP "+perR+" * FROM tb_info i WHERE (info_type = ?) AND (info_state = ?) AND (info_date < (SELECT MIN(info_date) FROM (SELECT TOP "+top+" (info_date) FROM tb_info WHERE (info_type = i.info_type) AND (info_state = i.info_state) ORDER BY info_date DESC) AS mindate)) ORDER BY info_date DESC"; } else if(mark.equals("4")){ sqlsub="SELECT TOP "+perR+" * FROM tb_info i WHERE (info_type = ?) AND (info_payfor = ?) AND (info_date < (SELECT MIN(info_date) FROM (SELECT TOP "+top+" (info_date) FROM tb_info WHERE (info_type = i.info_type) AND (info_payfor = i.info_payfor) ORDER BY info_date DESC) AS mindate)) ORDER BY info_date DESC"; } } List adminlistshow=myOp.OpListShow(sqlsub, params); request.setAttribute("adminlistshow",adminlistshow); request.setAttribute("createpage",createPage); return SUCCESS; } /** 功能：管理员操作-显示要审核的信息 */ public String CheckShow(){ request.setAttribute("mainPage","../info/checkshow.jsp"); comebackState(); String sql="SELECT * FROM tb_info WHERE (id = ?)"; String checkID=request.getParameter("checkID"); if(checkID==null||checkID.equals("")) checkID="-1"; Object[] params={checkID}; OpDB myOp=new OpDB(); infoSingle=myOp.OpSingleShow(sql, params); if(infoSingle==null){ //信息不存在 request.setAttribute("mainPage","/pages/error.jsp"); addFieldError("AdminShowNoExist",getText("city.singleshow.no.exist")); } return SUCCESS; } /** 功能：管理员操作-审核信息(更新数据库) */ public String Check(){ session.put("adminOP","Check"); //记录当前操作为“审核信息” String checkID=request.getParameter("checkID"); String sql="UPDATE tb_info SET info_state = 1 WHERE (id = ?)"; Object[] params={checkID}; OpDB myOp=new OpDB(); int i=myOp.OpUpdate(sql, params); if(i>0){ //审核信息成功 return "checkSuccess"; } else{ //审核信息失败 comebackState(); addFieldError("AdminCheckUnSuccess",getText("city.admin.check.no.success")); request.setAttribute("mainPage","/pages/error.jsp"); return "UnSuccess"; } } /** 功能：管理员操作-删除信息(更新数据库) */ public String Delete(){ session.put("adminOP","Delete"); //记录当前操作为“删除信息” String deleteID=request.getParameter("deleteID"); String sql="DELETE tb_info WHERE (id = ?)"; Object[] params={deleteID}; OpDB myOp=new OpDB(); int i=myOp.OpUpdate(sql, params); if(i>0){ //删除信息成功 return "deleteSuccess"; } else{ //删除信息失败 comebackState(); addFieldError("AdminDeleteUnSuccess",getText("city.admin.delete.no.success")); request.setAttribute("mainPage","/pages/error.jsp"); return "UnSuccess"; } } /** 功能：管理员操作-显示要进行付费设置的信息 */ public String SetMoneyShow(){ request.setAttribute("mainPage","../info/moneyshow.jsp"); String moneyID=request.getParameter("moneyID"); if(moneyID==null||moneyID.equals("")) moneyID="-1"; String sql="SELECT * FROM tb_info WHERE (id = ?)"; Object[] params={moneyID}; OpDB myOp=new OpDB(); infoSingle=myOp.OpSingleShow(sql, params); if(infoSingle==null){ //信息不存在 request.setAttribute("mainPage","/pages/error.jsp"); addFieldError("AdminShowNoExist",getText("city.singleshow.no.exist")); } return SUCCESS; } /** 功能：管理员操作-设置已付费信息(更新数据库) */ public String SetMoney(){ String moneyID=request.getParameter("moneyID"); if(moneyID==null||moneyID.equals("")) moneyID="-1"; String sql="UPDATE tb_info SET info_payfor=1 WHERE (id = ?)"; Object[] params={Integer.valueOf(moneyID)}; OpDB myOp=new OpDB(); int i=myOp.OpUpdate(sql, params); if(i>0){ //信息付费设置成功 addFieldError("AdminSetMoneySuccess",getText("city.admin.setmoney.success")); request.setAttribute("mainPage","/pages/error.jsp"); return "setMoneySuccess"; } else{ //信息付费设置失败 addFieldError("AdminSetMoneyUnSuccess",getText("city.admin.setmoney.no.success")); request.setAttribute("mainPage","/pages/error.jsp"); return "UnSuccess"; } } /** 功能：验证操作-后台进行列表显示信息时，验证是否选择了一种显示方式及信息类别 */ public void validateListShow(){ request.setAttribute("mainPage","/pages/error.jsp"); String adminOP=(String)session.get("adminOP"); if(adminOP==null) adminOP=""; if(adminOP.equals("Check")||adminOP.equals("Delete")) //如果是进行了“通过审核”或“删除信息”操作后，再来调用ListShow()方法显示信息列表，则需要恢复之前选择的“显示方式”和“信息类别”状态，从而重新在ListShow()方法中查询出符合条件的记录 comebackState(); else{ int getInfoType=showType.getInfoType(); String getPayforType=showType.getPayforType(); String getStateType=showType.getStateType(); if(getInfoType<=0){ if(session.get("infoType")!=null){ getInfoType=(Integer)session.get("infoType"); showType.setInfoType(getInfoType); } } if(getPayforType==null||getPayforType.equals("")){ getPayforType=(String)session.get("payforType"); showType.setPayforType(getPayforType); } if(getStateType==null||getStateType.equals("")){ getStateType=(String)session.get("stateType"); showType.setStateType(getStateType); } if(getInfoType<=0){ //没有选择“信息类别” addFieldError("AdminListNoType",getText("city.admin.list.no.infoType")); } else{ if(getPayforType==null||getPayforType.equals("")){ //没有选择“付费状态”选项 addFieldError("AdminListNoPayForType",getText("city.admin.list.no.payforType")); } if(getStateType==null||getStateType.equals("")){ //没有选择“审核状态”选项 addFieldError("AdminListNoStateType",getText("city.admin.list.no.stateType")); } } } } /** 功能：验证操作-后台进行信息的付费设置操作时，验证是否输入了信息ID值和输入的ID值是否为数字格式 */ public void validateSetMoneyShow() { request.setAttribute("mainPage","/pages/error.jsp"); String moneyID=request.getParameter("moneyID"); if(moneyID==null||moneyID.equals("")){ //没有输入信息ID值 addFieldError("moneyIDError",getText("city.admin.setMoney.no.moneyID")); } else{ //验证输入的信息ID值是否为数字格式 try{ int id=Integer.parseInt(moneyID); if(id<0) //若ID为负数 addFieldError("moneyIDError",getText("city.admin.setMoney.moneyID.0")); }catch(NumberFormatException e){ addFieldError("moneyIDError",getText("city.admin.setMoney.format.moneyID")); e.printStackTrace(); } } } /** 功能：恢复在“显示方式”中的选择状态 */ private void comebackState(){ /* 获取session中保存的选择状态。 * 将选择状态保存在session中， * 是在管理员单击“显示”按钮请求列表显示时， * 在ListShow()方法中实现的 */ Integer getInfoType=(Integer)session.get("infoType"); String getPayForType=(String)session.get("payforType"); String getStateType=(String)session.get("stateType"); /* 恢复选择的状态 */ if(getPayForType!=null&&getStateType!=null&&getInfoType!=null){ showType.setInfoType(getInfoType.intValue()); showType.setPayforType(getPayForType); showType.setStateType(getStateType); } } }

IndexAction.java

package com.yxq.action; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import java.util.TreeMap; import com.yxq.actionSuper.MySuperAction; import com.yxq.dao.OpDB; public class IndexAction extends MySuperAction { public static TreeMap typeMap; public static TreeMap searchMap; public String execute() throws Exception { /* 查询所有收费信息，按发布时间降序排列 */ OpDB myOp=new OpDB(); String sql1="select * from tb_info where (info_state='1') and (info_payfor = '1') order by info_date desc"; List payforlist=myOp.OpListShow(sql1,null); request.setAttribute("payforlist",payforlist); /* 查询免费信息，按发布时间降序排列 */ List allsublist=new ArrayList(); if(typeMap!=null&&typeMap.size()!=0){ Iterator itype=typeMap.keySet().iterator(); String sql2="SELECT TOP 5 * FROM tb_info WHERE (info_type = ?) AND (info_state='1') AND (info_payfor = '0') ORDER BY info_date DESC"; while(itype.hasNext()){ Integer sign=(Integer)itype.next(); Object[] params={sign}; List onesublist=myOp.OpListShow(sql2, params); allsublist.add(onesublist); } } request.setAttribute("allsublist",allsublist); session.put("typeMap",typeMap); session.put("searchMap",searchMap); return SUCCESS; } static{ OpDB myOp=new OpDB(); /* 获取所有信息类别 */ String sql="select * from tb_type order by type_sign"; typeMap=myOp.OpGetListBox(sql,null); if(typeMap==null) typeMap=new TreeMap(); /* 初始化搜索功能的下拉列表 */ searchMap=new TreeMap(); searchMap.put("ID值","id"); searchMap.put("信息标题","info_title"); searchMap.put("信息内容","info_content"); searchMap.put("联系人","info_linkman"); searchMap.put("联系电话","info_phone"); searchMap.put("E-mail地址","info_email"); } }

InfoAction.java

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 TOP "+top1+" * FROM tb_info WHERE (info_type = ?) AND (info_state = '1') AND (info_payfor = '0') ORDER BY info_date DESC"; } else{ //设置显示除第1页外，其他指定页码信息的SQl语句 int top2=(currentP-1)*top1; sqlFreeSub="SELECT TOP "+top1+" * 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"; // 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(?,?,?,?,?,?,?,?,?)"; 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 TOP "+top1+" * FROM tb_info WHERE ("+subsql+opname+"?) ORDER BY info_date DESC"; } else{ //显示除第1页外，其他指定页码信息的SQl语句 int top2=(currentP-1)*top1; sqlSearchSub="SELECT TOP "+top1+" * FROM tb_info WHERE ("+subsql+opname+"?) AND (info_date < (SELECT MIN(info_date) FROM (SELECT TOP "+top2+" info_date FROM tb_info WHERE "+subsql+opname+"'"+param+"' ORDER BY info_date DESC) AS mindate)) ORDER BY info_date DESC"; // 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")); } } }

LogInOutAction.java

package com.yxq.action; import com.yxq.actionSuper.MySuperAction; import com.yxq.dao.OpDB; import com.yxq.model.UserSingle; public class LogInOutAction extends MySuperAction { protected UserSingle user; public UserSingle getUser() { return user; } public void setUser(UserSingle user) { this.user = user; } /** 功能：判断当前用户是否登录 */ public String isLogin(){ Object ob=session.get("loginUser"); if(ob==null||!(ob instanceof UserSingle)) return INPUT; else return LOGIN; } /** 功能：查询数据表，验证是否存在该用户 */ public String Login(){ String sql="select * from tb_user where user_name=? and user_password=?"; Object[] params={user.getUserName(),user.getUserPassword()}; OpDB myOp=new OpDB(); if(myOp.LogOn(sql, params)){ //登录成功 session.put("loginUser",user); return LOGIN; } else{ //用户名或密码错误 addFieldError("loginE",getText("city.login.wrong.input")); return INPUT; } } /** 功能：退出登录 */ public String Logout(){ session.clear(); return "logout"; } /** 功能：验证是否输入用户名和密码 */ public void validateLogin() { String name=user.getUserName(); String password=user.getUserPassword(); if(name==null||name.equals("")) addFieldError("nameError",getText("city.login.no.name")); if(password==null||password.equals("")) addFieldError("passwordError",getText("city.login.no.password")); } }

package.properties

city.info.no.infoType=/u8bf7/u9009/u62e9 <b><font color="red">/u4fe1/u606f/u7c7b/u522b/uff01</font></b> city.info.no.infoTitle=/u8bf7/u8f93/u5165 <b><font color="red">/u4fe1/u606f/u6807/u9898/uff01</font></b> city.info.no.infoContent=/u8bf7/u8f93/u5165 <b><font color="red">/u4fe1/u606f/u5185/u5bb9/uff01</font></b> city.info.no.infoPhone=/u8bf7/u8f93/u5165 <b><font color="red">/u8054/u7cfb/u7535/u8bdd/uff01</font></b> city.info.no.infoLinkman=/u8bf7/u8f93/u5165 <b><font color="red">/u8054/u7cfb/u4eba/uff01</font></b> city.info.no.infoEmail=/u8bf7/u8f93/u5165 <b><font color="red">E-mail/u5730/u5740/uff01</font></b> city.info.format.infoPhone=/u8f93/u5165/u7684 <b><font color="red">/u8054/u7cfb/u65b9/u5f0f</font></b> /u683c/u5f0f/u4e0d/u6b63/u786e/uff01 city.info.format.infoEmail=/u8f93/u5165/u7684 <b><font color="red">E-mail/u5730/u5740/u683c/u5f0f</font></b> /u4e0d/u6b63/u786e/uff01 city.info.add.E=/u53d1/u5e03/u4fe1/u606f/u5931/u8d25/uff01 city.info.add.S=<b><li>/u4fe1/u606f/u53d1/u5e03/u6210/u529f/uff01/u9700/u8981/u7ba1/u7406/u5458/u8fdb/u884c/u5ba1/u6838/uff01</li><li>/u8bf7/u8bb0/u4f4f/u63d0/u4f9b/u7ed9/u60a8/u7684ID/uff0c/u4ee5/u4fbf/u65e5/u540e/u8fdb/u884c/u4ed8/u8d39/u64cd/u4f5c/uff01</li></b><br>/u4fe1/u606fID/uff1a city.login.no.name=/u8bf7/u8f93/u5165 <b><font color="red">/u7528/u6237/u540d/uff01</font></b> city.login.no.password=/u8bf7/u8f93/u5165 <b><font color="red">/u5bc6  /u7801/uff01</font></b> city.login.wrong.input=/u8f93/u5165/u7684 <b><font color="red">/u7528/u6237/u540d</font></b> /u6216 <b><font color="red">/u5bc6/u7801</font></b> /u4e0d/u6b63/u786e/uff01 city.info.listshow.no.infoType=/u8bf7/u9009/u62e9/u8981/u67e5/u770b/u7684/u7c7b/u522b/uff01 city.info.listshow.format.infoType=/u4fe1/u606f/u7c7b/u522b/u4e0d/u662f/u6570/u5b57/u683c/u5f0f/uff01 city.info.singleshow.no.id=/u8bf7/u9009/u62e9/u8981/u67e5/u770b/u8be6/u7ec6/u5185/u5bb9/u7684/u4fe1/u606f/uff01 city.info.listshow.format.infoID=/u4fe1/u606fID/u503c/u4e0d/u662f/u6570/u5b57/u683c/u5f0f/uff01 city.admin.list.no.infoType=/u8bf7/u9009/u62e9/u4e00/u79cd <b><font color="red">/u4fe1/u606f/u7c7b/u522b/uff01</font></b> city.admin.list.no.payforType=/u8bf7/u9009/u62e9/u4e00/u79cd <b><font color="red">/u4ed8/u8d39/u72b6/u6001</font></b> /u9009/u9879/uff01 city.admin.list.no.stateType=/u8bf7/u9009/u62e9/u4e00/u79cd <b><font color="red">/u5ba1/u6838/u72b6/u6001</font></b> /u9009/u9879/uff01 city.admin.setMoney.no.moneyID=/u8bf7/u8f93/u5165 <b><font color="red">/u4fe1/u606fID/u503c/uff01</font></b> city.admin.setMoney.format.moneyID=/u8f93/u5165/u7684 <b><font color="red">/u4fe1/u606fID/u503c</font></b> /u5fc5/u987b/u4e3a/u6570/u5b57/u683c/u5f0f/uff01 city.admin.setMoney.moneyID.0=/u8f93/u5165/u7684 <b><font color="red">/u4fe1/u606fID/u503c</font></b> /u5fc5/u987b/u5927/u4e8e0/uff01 city.admin.check.no.success=/u5ba1/u6838/u4fe1/u606f/u5931/u8d25/uff01 city.admin.delete.no.success=/u5220/u9664/u4fe1/u606f/u5931/u8d25/uff01 city.admin.setmoney.success=/u4ed8/u8d39/u8bbe/u7f6e/u6210/u529f/uff01 city.admin.setmoney.no.success=/u4ed8/u8d39/u8bbe/u7f6e/u5931/u8d25/uff01 city.singleshow.no.exist=/u8981/u67e5/u770b/u7684/u4fe1/u606f/u4e0d/u5b58/u5728/uff01 city.info.search.no.condition=/u8bf7/u8f93/u5165 <b><font color="red">/u67e5/u8be2/u6761/u4ef6/uff01</font></b> city.info.search.no.value=/u8bf7/u8f93/u5165 <b><font color="red">/u67e5/u8be2/u5173/u952e/u5b57/uff01</font></b> city.info.search.no.type=/u8bf7/u8f93/u5165 <b><font color="red">/u641c/u7d22/u7c7b/u522b/uff01</font></b>

actionSuper:

AdminSuperAction.java

package com.yxq.actionSuper; import com.yxq.model.AdminShowType; import com.yxq.model.InfoSingle; public class AdminSuperAction extends MySuperAction{ protected AdminShowType showType; protected InfoSingle infoSingle; public AdminSuperAction(){ showType=new AdminShowType(); infoSingle=new InfoSingle(); } public AdminShowType getShowType() { return showType; } public void setShowType(AdminShowType showType) { this.showType = showType; } public InfoSingle getInfoSingle() { return infoSingle; } public void setInfoSingle(InfoSingle infoSingle) { this.infoSingle = infoSingle; } }

InfoSuperAction.java

package com.yxq.actionSuper; import com.yxq.model.InfoSingle; import com.yxq.model.SearchInfo; public class InfoSuperAction extends MySuperAction { protected InfoSingle infoSingle; protected SearchInfo searchInfo; public InfoSingle getInfoSingle() { return infoSingle; } public void setInfoSingle(InfoSingle infoSingle) { this.infoSingle = infoSingle; } public SearchInfo getSearchInfo() { return searchInfo; } public void setSearchInfo(SearchInfo searchInfo) { this.searchInfo = searchInfo; } }

MySuperAction.java

package com.yxq.actionSuper; import java.util.Map; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.struts2.interceptor.ServletRequestAware; import org.apache.struts2.interceptor.ServletResponseAware; import org.apache.struts2.interceptor.SessionAware; import com.opensymphony.xwork2.ActionSupport; public class MySuperAction extends ActionSupport implements SessionAware,ServletRequestAware,ServletResponseAware { protected HttpServletRequest request; protected HttpServletResponse response; protected Map session; public void setSession(Map session) { this.session=session; } public void setServletRequest(HttpServletRequest request) { this.request=request; } public void setServletResponse(HttpServletResponse response) { this.response=response; } }

dao:

DB.java

package com.yxq.dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class DB { private Connection con; private PreparedStatement pstm; private String user="sa"; private String password=""; private String className="com.microsoft.jdbc.sqlserver.SQLServerDriver"; private String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_CityInfo"; public DB(){ try{ Class.forName(className); }catch(ClassNotFoundException e){ System.out.println("加载数据库驱动失败！"); e.printStackTrace(); } } /**创建数据库连接*/ public Connection getCon(){ try { con=DriverManager.getConnection(url,user,password); } catch (SQLException e) { System.out.println("创建数据库连接失败！"); con=null; e.printStackTrace(); } return con; } public void doPstm(String sql,Object[] params){ if(sql!=null&&!sql.equals("")){ if(params==null) params=new Object[0]; getCon(); if(con!=null){ try{ System.out.println(sql); pstm=con.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); for(int i=0;i<params.length;i++){ pstm.setObject(i+1,params[i]); } pstm.execute(); }catch(SQLException e){ System.out.println("doPstm()方法出错！"); e.printStackTrace(); } } } } public ResultSet getRs() throws SQLException{ return pstm.getResultSet(); } public int getCount() throws SQLException{ return pstm.getUpdateCount(); } public void closed(){ try{ if(pstm!=null) pstm.close(); }catch(SQLException e){ System.out.println("关闭pstm对象失败！"); e.printStackTrace(); } try{ if(con!=null){ con.close(); } }catch(SQLException e){ System.out.println("关闭con对象失败！"); e.printStackTrace(); } } }

OpDB.java

package com.yxq.dao; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import java.util.TreeMap; import com.yxq.model.CreatePage; import com.yxq.model.InfoSingle; import com.yxq.tools.DoString; public class OpDB { private DB mydb; public OpDB(){ mydb=new DB(); } public TreeMap OpGetListBox(String sql,Object[] params){ TreeMap typeMap=new TreeMap(); mydb.doPstm(sql, params); try { ResultSet rs=mydb.getRs(); if(rs!=null){ while(rs.next()){ Integer sign=Integer.valueOf(rs.getInt("type_sign")); String intro=rs.getString("type_intro"); typeMap.put(sign,intro); } rs.close(); } } catch (SQLException e) { System.out.println("OpGetListBox()方法查询失败！"); e.printStackTrace(); }finally{ mydb.closed(); } return typeMap; } public List OpListShow(String sql,Object[] params){ List onelist=new ArrayList(); mydb.doPstm(sql, params); try{ ResultSet rs=mydb.getRs(); if(rs!=null){ while(rs.next()){ InfoSingle infoSingle=new InfoSingle(); infoSingle.setId(rs.getInt("id")); infoSingle.setInfoType(rs.getInt("info_type")); infoSingle.setInfoTitle(rs.getString("info_title")); infoSingle.setInfoContent(rs.getString("info_content")); infoSingle.setInfoLinkman(rs.getString("info_linkman")); infoSingle.setInfoPhone(rs.getString("info_phone")); infoSingle.setInfoEmail(rs.getString("info_email")); infoSingle.setInfoDate(DoString.dateTimeChange(rs.getTimestamp("info_date"))); infoSingle.setInfoState(rs.getString("info_state")); infoSingle.setInfoPayfor(rs.getString("info_payfor")); onelist.add(infoSingle); } } rs.close(); }catch (Exception e){ System.out.println("查看信息列表失败！(查询数据库)"); e.printStackTrace(); }finally{ mydb.closed(); } return onelist; } public InfoSingle OpSingleShow(String sql,Object[] params){ InfoSingle infoSingle=null; mydb.doPstm(sql, params); try{ ResultSet rs=mydb.getRs(); if(rs!=null&&rs.next()){ infoSingle=new InfoSingle(); infoSingle.setId(rs.getInt("id")); infoSingle.setInfoType(rs.getInt("info_type")); infoSingle.setInfoTitle(rs.getString("info_title")); infoSingle.setInfoContent(rs.getString("info_content")); infoSingle.setInfoLinkman(rs.getString("info_linkman")); infoSingle.setInfoPhone(rs.getString("info_phone")); infoSingle.setInfoEmail(rs.getString("info_email")); infoSingle.setInfoDate(DoString.dateTimeChange(rs.getTimestamp("info_date"))); infoSingle.setInfoState(rs.getString("info_state")); infoSingle.setInfoPayfor(rs.getString("info_payfor")); rs.close(); } }catch(Exception e){ System.out.println("查看详细内容失败！(查询数据库)"); e.printStackTrace(); }finally{ mydb.closed(); } return infoSingle; } public int OpUpdate(String sql,Object[] params){ int i=-1; mydb.doPstm(sql, params); try{ i=mydb.getCount(); }catch(SQLException e){ System.out.println("执行OpUpdate()方法失败！(更新数据库)"); e.printStackTrace(); }finally{ mydb.closed(); } return i; } public CreatePage OpCreatePage(String sqlall,Object[] params,int perR,String strCurrentP,String gowhich){ CreatePage page=new CreatePage(); page.setPerR(perR); if(sqlall!=null&&!sqlall.equals("")){ DB mydb=new DB(); mydb.doPstm(sqlall,params); try { ResultSet rs=mydb.getRs(); if(rs!=null&&rs.next()){ rs.last(); page.setAllR(rs.getRow()); //设置总记录数 page.setAllP(); page.setCurrentP(strCurrentP); page.setPageInfo(); page.setPageLink(gowhich); rs.close(); } } catch (SQLException e) { System.out.println("OpDB.java/OpCreatePage()方法：创建CreatePage分页类失败！"); e.printStackTrace(); }finally{ mydb.closed(); } } return page; } public boolean LogOn(String sql,Object[] params){ mydb.doPstm(sql, params); try { ResultSet rs=mydb.getRs(); boolean mark=(rs==null||!rs.next()?false:true); rs.close(); return mark; } catch (SQLException e) { System.out.println("登录失败！"); e.printStackTrace(); return false; } finally{ mydb.closed(); } } }

model:

AdminShowType.java

package com.yxq.model; public class AdminShowType { private String stateType; private String payforType; private int infoType; public String getPayforType() { return payforType; } public void setPayforType(String payforType) { this.payforType = payforType; } public String getStateType() { return stateType; } public void setStateType(String stateType) { this.stateType = stateType; } public int getInfoType() { return infoType; } public void setInfoType(int infoType) { this.infoType = infoType; } }

CreatePage.java

package com.yxq.model; public class CreatePage { private int CurrentP; //当前页码 private int AllP; //总页数 private int AllR; //总记录数 private int PerR; //每页显示记录数 private String PageLink; //分页导航栏信息 private String PageInfo; //分页状态显示信息 public CreatePage(){ CurrentP=1; AllP=1; AllR=0; PerR=3; PageLink=""; PageInfo=""; } /** 设置每页显示记录数 */ public void setPerR(int PerR){ this.PerR=PerR; } /** 设置总记录数 */ public void setAllR(int AllR){ this.AllR=AllR; } /** 计算总页数 */ public void setAllP(){ AllP=(AllR%PerR==0)?(AllR/PerR):(AllR/PerR+1); } /** 设置当前页码 */ public void setCurrentP(String currentP) { if(currentP==null||currentP.equals("")) currentP="1"; try{ CurrentP=Integer.parseInt(currentP); }catch(NumberFormatException e){ CurrentP=1; e.printStackTrace(); } if(CurrentP<1) CurrentP=1; if(CurrentP>AllP) CurrentP=AllP; } /** 设置分页状态显示信息 */ public void setPageInfo(){ if(AllP>1){ PageInfo="<table border='0' cellpadding='3'><tr><td>"; PageInfo+="每页显示："+PerR+"/"+AllR+" 条记录！"; PageInfo+="当前页："+CurrentP+"/"+AllP+" 页！"; PageInfo+="</td></tr></table>"; } } /** 设置分页导航栏信息 */ public void setPageLink(String gowhich){ if(gowhich==null) gowhich=""; if(gowhich.indexOf("?")>=0) gowhich+="&"; else gowhich+="?"; if(AllP>1){ PageLink="<table border='0' cellpadding='3'><tr><td>"; if(CurrentP>1){ PageLink+="<a href=""+gowhich+"showpage=1" mce_href=""+gowhich+"showpage=1">首页</a> "; PageLink+="<a href=""+gowhich+"showpage="+(CurrentP-1)+"" mce_href=""+gowhich+"showpage="+(CurrentP-1)+"">上一页</a> "; } if(CurrentP<AllP){ PageLink+="<a href=""+gowhich+"showpage="+(CurrentP+1)+"" mce_href=""+gowhich+"showpage="+(CurrentP+1)+"">下一页</a> "; PageLink+="<a href=""+gowhich+"showpage="+AllP+"" mce_href=""+gowhich+"showpage="+AllP+"">尾页</a>"; } PageLink+="</td></tr></table>"; } } /** 返回每页记录数 */ public int getPerR(){ return PerR; } /** 返回总记录数 */ public int getAllR() { return AllR; } /** 返回总页数 */ public int getAllP() { return AllP; } /** 返回当前页码 */ public int getCurrentP() { return CurrentP; } /** 返回分页状态显示信息 */ public String getPageInfo(){ return PageInfo; } /** 返回分页导航栏信息 */ public String getPageLink(){ return PageLink; } }

InfoSingle.java

package com.yxq.model; public class InfoSingle { private int id; private int infoType; private String infoTitle; private String infoContent; private String infoLinkman; private String infoPhone; private String infoEmail; private String infoDate; private String infoState; private String infoPayfor; public int getId() { return this.id; } public void setId(int id) { this.id = id; } public String getInfoContent() { return infoContent; } public void setInfoContent(String infoContent) { this.infoContent = infoContent; } public String getInfoDate() { return infoDate; } public void setInfoDate(String infoDate) { this.infoDate = infoDate; } public String getInfoLinkman() { return infoLinkman; } public void setInfoLinkman(String infoLinkman) { this.infoLinkman = infoLinkman; } public String getInfoPayfor() { return infoPayfor; } public void setInfoPayfor(String infoPayfor) { this.infoPayfor = infoPayfor; } public String getInfoPhone() { return infoPhone; } public void setInfoPhone(String infoPhone) { this.infoPhone=infoPhone; } public String getInfoEmail() { return infoEmail; } public void setInfoEmail(String infoEmail) { this.infoEmail = infoEmail; } public String getInfoState() { return infoState; } public void setInfoState(String infoState) { this.infoState = infoState; } public String getInfoTitle() { return infoTitle; } public void setInfoTitle(String infoTitle) { this.infoTitle = infoTitle; } public int getInfoType() { return infoType; } public void setInfoType(int infoType) { this.infoType = infoType; } public String getSubInfoTitle(int len){ if(len<=0||len>this.infoTitle.length()) len=this.infoTitle.length(); return this.infoTitle.substring(0,len); } }

SearchInfo.java

package com.yxq.model; public class SearchInfo { private String subsql; private String sqlvalue; private String type="all"; public String getSqlvalue() { return sqlvalue; } public void setSqlvalue(String sqlvalue) { this.sqlvalue = sqlvalue; } public String getSubsql() { return subsql; } public void setSubsql(String subsql) { this.subsql = subsql; } public String getType() { return type; } public void setType(String type) { this.type = type; } }

UserSingle.java

package com.yxq.model; public class UserSingle{ private String userName; private String userPassword; public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public String getUserPassword() { return userPassword; } public void setUserPassword(String userPassword) { this.userPassword = userPassword; } }

tools:

DoString.java

package com.yxq.tools; import java.text.SimpleDateFormat; import java.util.Date; public class DoString { public static String HTMLChange(String source){ String changeStr=""; changeStr=source.replaceAll("&","&"); changeStr=changeStr.replaceAll(" "," "); changeStr=changeStr.replaceAll("<","<"); changeStr=changeStr.replaceAll(">",">"); changeStr=changeStr.replaceAll("/r/n","<br>"); return changeStr; } public static String dateTimeChange(Date source){ SimpleDateFormat format=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String changeTime=format.format(source); return changeTime; } }

Index:

index.jsp

<%@ page contentType="text/html; charset=gb2312"%> <% response.sendRedirect("goindex.action"); %>

view:

default.jsp

<%@ page language="java" contentType="text/html; charset=GBK"%> <%@ taglib uri="/struts-tags" prefix="s2"%> <html> <head><title>首页</title></head> <body> <center> <!-- 缴费专区 --> <s2:set name="payforlist" value="#request.payforlist"/> <table border="0" width="670" cellspacing="0" cellpadding="5"> <tr height="35"><td style="text-indent:5" mce_style="text-indent:5" valign="bottom"><font color="#004790"><b>■推荐信息</b>『缴费专区』</font></td></tr> <tr bgcolor="#FAFCF5"> <td style="border:1 solid" mce_style="border:1 solid"> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <s2:if test="#payforlist==null||#payforlist.size()==0"> <tr height="30"><td align="center" style="border:1 solid" mce_style="border:1 solid">★★★ 缴费后，您发布信息就可在这里显示！★★★</td></tr> </s2:if> <s2:else> <s2:iterator status="payforStatus" value="payforlist"> <s2:if test="#payforStatus.odd"><tr height="23"></s2:if> <td width="50%">『<b><s2:property value="#session.typeMap[infoType]"/></b>』<a href="info_SingleShow.action?id=<s2:property value='id'></a>"><s2:property value="getSubInfoTitle(20)"/></a></td> <s2:if test="#payforStatus.even"></tr></s2:if> </s2:iterator> </s2:else> </table> </td> </tr> </table> <!-- 广告 --> <table border="0" width="670"cellspacing="0" cellpadding="0" style="margin-top:1" mce_style="margin-top:1"> <tr><td align="center"><img src="images/pcard2.jpg" mce_src="images/pcard2.jpg"></td></tr> </table> <!-- 免费专区 --> <s2:set name="allsublist" value="#request.allsublist"/> <table border="0" width="670" cellspacing="2" cellpadding="0"> <tr height="35"><td colspan="2" style="text-indent:5" mce_style="text-indent:5" valign="bottom"><font color="#004790"><b>■最新信息</b>『免费专区』</font></td></tr> <s2:if test="#allsublist==null||#allsublist.size()==0"> <tr height="30"><td align="center" style="border:1 solid" mce_style="border:1 solid">★★★ 在这里显示免费发布的信息！★★★</td></tr> </s2:if> <s2:else> <s2:iterator status="allStatus" value="allsublist"> <s2:if test="#allStatus.odd"><tr></s2:if> <td align="center"> <table border="1" cellspacing="0" cellpadding="0" width="332" height="160" rules="none" bordercolor="lightgrey" bordercolorlight="lightgrey" bordercolordark="white"> <s2:iterator status="oneStatus"> <s2:if test="#oneStatus.index==0"> <tr bgcolor="#00B48F" height="30"> <td style="text-indent:10" mce_style="text-indent:10"><b><font color="white">▲<s2:property value="#session.typeMap[infoType]"/></font></b></td> </tr> </s2:if> <tr bgcolor="#FAFCF5"><td style="text-indent:3" mce_style="text-indent:3">★ <a href="info_SingleShow.action?id=<s2:property value='id'></a>"><s2:property value="getSubInfoTitle(20)"/></a></td></tr> <s2:if test="#oneStatus.last"> <tr height="20" bgcolor="#FAFCF5"><td align="right"><a href="info_ListShow.action?infoType=<s2:property value='infoType'></a>">更多...</a>  </td></tr> </s2:if> </s2:iterator> </table> </td> <s2:if test="#allStatus.even"></tr></s2:if> </s2:iterator> </s2:else> </table> <br> </center> </body> </html>

IndexTemp.jsp

<%@ page language="java" contentType="text/html; charset=GBK"%> <%@ taglib uri="/struts-tags" prefix="s2"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; String mainPage=(String)request.getAttribute("mainPage"); if(mainPage==null||mainPage.equals("")) mainPage="default.jsp"; %> <html> <head> <title>都市信息网</title> <base href="<%=basePath%>"> <link type="text/css" rel="stylesheet" href="css/style.css" mce_href="css/style.css"> </head> <body background="images/back.gif"> <center> <table border="0" width="920" cellspacing="0" cellpadding="0" bgcolor="white"> <tr><td colspan="2"><jsp:include page="top.jsp"/></td></tr> <tr> <td width="230" valign="top" align="center"><jsp:include page="left.jsp"/></td> <td width="690" height="400" align="center" valign="top" bgcolor="#FFFFFF"><jsp:include page="<%=mainPage%>"/></td> </tr> <tr><td colspan="2"><%@ include file="end.jsp" %></td></tr> </table> </center> </body> </html>

top.jsp

<%@ page language="java" contentType="text/html; charset=GBK"%> <%@ taglib prefix="s2" uri="/struts-tags" %> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gbk"> <title>页眉</title> </head> <body> <center> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <!-- 顶部菜单 --> <tr height="20"> <td style="text-indent:10" mce_style="text-indent:10" valign="bottom"> <a href="info_Add.action?addType=linkTo" mce_href="info_Add.action?addType=linkTo" style="color:gray" mce_style="color:gray">[发布信息]</a> <a href="log_isLogin.action" mce_href="log_isLogin.action" style="color:gray" mce_style="color:gray">[进入后台]</a> </td> <td align="right" valign="bottom"> <a href="#" mce_href="#" style="color:gray" mce_style="color:gray" οnclick="this.style.behavior='url(#default#homepage)';this.setHomePage('http://localhost:8080/CityInfo');">设为主页 -</a> <a href="javascript:window.external.AddFavorite('http://localhost:8080/CityInfo','都市供求信息网')" mce_href="javascript:window.external.AddFavorite('http://localhost:8080/CityInfo','都市供求信息网')" style="color:gray" mce_style="color:gray">收藏本页 -</a> <a href="mailto:123@***.com.cn" mce_href="mailto:123@***.com.cn" style="color:gray" mce_style="color:gray">联系我们</a>   </td> </tr> <!-- 导航菜单 --> <tr height="56"> <td align="center" width="220" background="images/logo.gif"></td> <td align="right" background="images/menu.gif"> <s2:set name="types" value="#session.typeMap"/> <s2:if test="#types==null||#types.size()==0">没有信息类别可显示！</s2:if> <s2:else> <table border="0" width="600"> <tr align="center"> <td width="100"><a href="goindex.action" mce_href="goindex.action" style="color:white" mce_style="color:white">首    页</a></font></td> <s2:iterator status="typesStatus" value="types"> <td width="100"><a href="info_ListShow.action?infoType=<s2:property value='key'></a>" style="color:white"><s2:property value="value"/></a></td> <s2:if test="#typesStatus.index==4"></tr><tr align="center"></s2:if> </s2:iterator> </tr> </table> </s2:else> </td> </tr> </table> <table border="0" width="100%" height="90" cellspacing="0" cellpadding="0" style="margin-top:1" mce_style="margin-top:1"> <tr><td align="center"><img src="images/pcard1.jpg" mce_src="images/pcard1.jpg"></td></tr> </table> </center> </body> </html>

end.jsp

<%@ page language="java" contentType="text/html; charset=GBK"%> <html> <head> <title>页尾</title> </head> <body> <center> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr><td align="center"><img src="images/end.jpg" mce_src="images/end.jpg"></td></tr> </table> </center> </body> </html>

left.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"%> <%@ page import="java.util.TreeMap" %> <%@ taglib prefix="s2" uri="/struts-tags" %> <% TreeMap searchType=new TreeMap(); searchType.put("like","模糊搜索"); searchType.put("all","全字匹配"); request.setAttribute("searchType",searchType); %> <html> <head> <title>侧栏</title> </head> <body> <center> <table border="0" width="225" height="100%" cellspacing="0" cellpadding="0"> <tr height="30"><td style="text-indent:5" mce_style="text-indent:5" valign="bottom"><font color="#004790"><b>■日历</b></font></td></tr> <tr height="1"><td></td></tr> <tr height="215"> <td valign="top" background="images/leftD.jpg"><jsp:include page="/pages/calendar.jsp"/></td> </tr> <tr height="1"><td></td></tr> <tr height="30"><td style="text-indent:5" mce_style="text-indent:5" valign="bottom"><font color="#004790"><b>■信息快速搜索</b></font></td></tr> <tr height="1"><td></td></tr> <tr height="103"> <td align="center" valign="top" background="images/leftS.jpg"> <table border="0" width="99%" height="100%" cellspacing="0"> <s2:form action="info_SearchShow.action" theme="simple"> <tr height="10"><td colspan="3"></td></tr> <tr> <td align="right" width="70">关键字：</td> <td colspan="2" width="200"><s2:textfield name="searchInfo.sqlvalue" value="%{searchInfo.sqlvalue}" size="21"/></td> </tr> <tr> <td align="right">条  件：</td> <td> <s2:select emptyOption="true" list="#session.searchMap" listKey="value" listValue="key" name="searchInfo.subsql"/> </td> <td align="center" width="30"><s2:submit value="搜索"/></td> </tr> <tr> <td align="right">搜索类型：</td> <td colspan="2"> <s2:radio list="#request.searchType" value="%{'like'}" name="searchInfo.type"/> </td> </tr> <tr height="10"><td colspan="3"></td></tr> </s2:form> </table> </td> </tr> <tr><td></td></tr> </table> </center> </body> </html>

pages/add:

add.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"%> <%@ taglib prefix="s2" uri="struts2" %> <html> <head> <title>发布信息</title> <mce:script type="text/javascript" src="<s2:url value='js/InputCheck.js'/><!-- "> // --></mce:script> </head> <body> <center> <table border="0" cellpadding="0" cellspacing="0" width="688" height="100%"> <tr height="20"><td><img src="images/default_t.jpg" mce_src="images/default_t.jpg"></td></tr> <tr> <td background="images/default_m.jpg" valign="top" align="center"> <s2:form action="info_Add.action" theme="simple"> <input type="hidden" name="addType" value="add"/> <table border="0" width="650" height="300" rules="all" cellspacing="0"> <tr height="30"><td style="text-indent:10" mce_style="text-indent:10"><font color="#004790"><b>■发布信息</b></font></td></tr> <tr> <td align="center"> <table border="0" width="650" rules="all" cellspacing="8"> <tr> <td width="20%" style="text-indent:10" mce_style="text-indent:10">信息类别：</td> <td> <s2:select emptyOption="true" list="#session.typeMap" name="infoSingle.infoType"/> </td> <td align="right"><font color="#7F7F7F">[信息标题最多不得超过 40 个字符]  </font></td> </tr> <tr><td colspan="3"><s2:fielderror><s2:param value="%{'typeError'}"/></s2:fielderror></td></tr> <tr> <td style="text-indent:10" mce_style="text-indent:10">信息标题：</td> <td colspan="2"><s2:textfield name="infoSingle.infoTitle" size="80" maxlength="40"/></td> </tr> <tr><td colspan="3"><s2:fielderror><s2:param value="%{'titleError'}"/></s2:fielderror></td></tr> <tr> <td style="text-indent:10" mce_style="text-indent:10">信息内容：</td> <td> <font color="#7F7F7F"> 已用：<input type="text" name="ContentUse" value="0" size="4" disabled style="text-align:center;border:0;" mce_style="text-align:center;border:0;"> 个   剩余：<input type="text" name="ContentRem" value="500" size="4" disabled style="text-align:center;border:0;" mce_style="text-align:center;border:0;"> 个 </font> </td> <td align="right"><font color="#7F7F7F">[信息内容最多不得超过 500 个字符]  </font></td> </tr> <tr><td colspan="3"><s2:fielderror><s2:param value="%{'contentError'}"/></s2:fielderror></td></tr> <tr><td colspan="3" align="center"><s2:textarea id="content" name="infoSingle.infoContent" rows="12" cols="85" οnkeydοwn="check(content,ContentUse,ContentRem,500)" οnkeyup="check(content,ContentUse,ContentRem,500)" οnchange="check(content,ContentUse,ContentRem,500)"/></td></tr> <tr> <td style="text-indent:10" mce_style="text-indent:10">联系电话：</td> <td colspan="2"><s2:textfield label="联系电话" name="infoSingle.infoPhone" size="45"/><font color="gray"> [多个电话以逗号分隔！]</font></td> </tr> <tr><td colspan="3"><s2:fielderror><s2:param value="%{'phoneError'}"/></s2:fielderror></td></tr> <tr> <td style="text-indent:10" mce_style="text-indent:10">联 系 人：</td> <td colspan="2"><s2:textfield label="联 系 人" name="infoSingle.infoLinkman" size="50"/></td> </tr> <tr><td colspan="3"><s2:fielderror><s2:param value="%{'linkmanError'}"/></s2:fielderror></td></tr> <tr> <td style="text-indent:10" mce_style="text-indent:10">E - mail：</td> <td colspan="2"><s2:textfield label="E - mail" name="infoSingle.infoEmail" size="55"/></td> </tr> <tr><td colspan="3"><s2:fielderror><s2:param value="%{'emailError'}"/></s2:fielderror></td></tr> </table> </td> </tr> <tr align="center" height="50"> <td> <s2:submit value="发布"/> <s2:reset value="重填"/> </td> </tr> </table> </s2:form> </td> </tr> <tr height="26"><td><img src="images/default_e.jpg" mce_src="images/default_e.jpg"></td></tr> </table> </center> </body> </html>

pages/admin:

Login.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"%> <%@ taglib prefix="s2" uri="/struts-tags" %> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <html> <head> <title>管理员登录</title> <base href="<%=basePath%>"> <link type="text/css" rel="stylesheet" href="<s2:url value='css/style.css'/>"> </head> <body bgcolor="#E7ECEF"> <center> <s2:form action="log_Login.action" theme="simple"> <table border="0" cellspacing="0" cellpadding="0" style="margin-top:130" mce_style="margin-top:130"> <tr><td><img src="images/logon_top.gif" mce_src="images/logon_top.gif"></td></tr> <tr height="180"> <td background="images/logon_middle.gif" align="center" valign="top"> <table border="0" width="90%" cellspacing="0" cellpadding="0"> <tr height="50"><td colspan="2"><s2:fielderror/></td></tr> <tr height="30"> <td align="right" width="40%">用户名：  </td> <td style="text-indent:5" mce_style="text-indent:5"><s2:textfield name="user.userName" size="30"/></td> </tr> <tr height="30"> <td align="right">密  码：  </td> <td style="text-indent:5" mce_style="text-indent:5"><s2:password name="user.userPassword" size="30"/></td> </tr> <tr height="60"> <td></td> <td> <s2:submit value="登录"/> <s2:reset value="重置"/> <s2:a href="index.jsp" mce_href="index.jsp">[返回首页]</s2:a> </td> </tr> </table> </td> </tr> <tr><td><img src="images/logon_end.gif" mce_src="images/logon_end.gif"></td></tr> </table> </s2:form> </center> </body> </html>

pages/admin/info:

listshow.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"%> <%@ taglib prefix="s2" uri="/struts-tags" %> <html> <head> <title>后台-查看信息列表</title> <mce:script type="text/javascript" src="<s2:url value='js/DeleteCheck.js'/><!-- "> // --></mce:script> </head> <body> <center> <table border="0" width="650" cellspacing="0" cellpadding="0"> <s2:set name="listshow" value="#request.adminlistshow"/> <s2:if test="#listshow==null||#listshow.size()==0"> <tr height="1"><td></td></tr> <tr height="200" bgcolor="#F9F9F9"><td colspan="8" align="center" style="border:1 solid" mce_style="border:1 solid"><font color="red"><b>★★对不起，未找到符合条件的信息！★★</b></font></td></tr> </s2:if> <s2:else> <tr height="30"> <td style="text-indent:8" mce_style="text-indent:8">审核[<s2:property value="#session.typeMap[#listshow[0].infoType]"/>]</td> <td><s2:fielderror/> </td> </tr> <tr> <td colspan="2" align="center" style="border:1 solid" mce_style="border:1 solid"> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr align="center" height="30" bgcolor="#F0F0F0"> <td width="7%"><b>序号</b></td> <td width="8%"><b>信息ID</b></td> <td width="35%"><b>信息标题</b></td> <td width="20%"><b>发布时间</b></td> <td width="8%"><b>付费</b></td> <td width="8%"><b>审核</b></td> <td width="14%" colspan="2"><b>操作</b></td> </tr> <s2:iterator status="status" value="listshow"> <s2:if test="#status.odd"> <tr height="30"></s2:if> <s2:else> <tr height="30" bgcolor="#F9F9F9"></s2:else> <td align="center"><b><s2:property value="#status.index+1"/></b></td> <td style="text-indent:10" mce_style="text-indent:10"><s2:property value="id"/></td> <td style="text-indent:5" mce_style="text-indent:5"><a href="admin_CheckShow.action?checkID=<s2:property value='id'></a>"><s2:property value="getSubInfoTitle(17)"/></a></td> <td align="center"><s2:property value="infoDate"/></td> <td align="center"><s2:if test="infoPayfor==1">是</s2:if><s2:else>否</s2:else></td> <td align="center"><s2:if test="infoState==1"><font color="red">是</font></s2:if><s2:else><b><font color="blue">否</font></b></s2:else></td> <td align="center"><a href="admin_CheckShow.action?checkID=<s2:property value='id'></a>">√审核</a></td> <td align="center"><a href="admin_Delete.action?deleteID=<s2:property value='id'></a>" οnclick="return really()">×删除</a></td> </tr> </s2:iterator> </table> </td> </tr> <tr height="8"><td></td></tr> <tr><td align="center" colspan="2"><jsp:include page="/pages/page.jsp"/></td></tr> </s2:else> </table> </center> </body> </html>

checkshow.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"%> <%@ taglib prefix="s2" uri="/struts-tags" %> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <html> <head> <title>后台-审核信息</title> <base href="<%=basePath%>"> <mce:script type="text/javascript" src="<s2:url value='js/DeleteCheck.js'/><!-- "> // --></mce:script> </head> <body> <center> <br> <s2:form theme="simple"> <input type="hidden" name="checkID" value="<s2:property value="infoSingle.id"/>"> <input type="hidden" name="deleteID" value="<s2:property value="infoSingle.id"/>"> <table border="0" width="645" cellpadding="10" cellspacing="0" style="word-break:break-all" mce_style="word-break:break-all"> <tr height="30"> <td style="text-indent:5" mce_style="text-indent:5"><b>审核信息 [ID值：<s2:property value="infoSingle.id"/>]</b></td> <td colspan="2" align="right"><s2:fielderror/></td> </tr> <tr height="30" bgcolor="#F9F9F9"><td colspan="3" align="center" style="text-indent:5" mce_style="text-indent:5">信息详细内容</td></tr> <tr height="30"> <td width="25%" style="text-indent:10" mce_style="text-indent:10">信息类别：</td> <td>【<s2:property value="#session.typeMap[infoSingle.infoType]"/>】</td> <td>付费状态：  <s2:if test="infoSingle.infoPayfor==1">★ 已付费</s2:if><s2:else>● 未付费</s2:else></td> </tr> <tr height="30"> <td style="text-indent:10" mce_style="text-indent:10">发布时间：</td> <td><s2:property value="infoSingle.infoDate"/></td> <td>审核状态：  <s2:if test="infoSingle.infoState==1">★ 已审核</s2:if><s2:else>● 未审核</s2:else></td> </tr> <tr height="30"> <td style="text-indent:10" mce_style="text-indent:10">信息标题：</td> <td colspan="2"><s2:property value="infoSingle.infoTitle"/></td> </tr> <tr height="40" bgcolor="#F9F9F9"> <td style="text-indent:10" mce_style="text-indent:10">信息内容：</td> <td align="center"> <s2:if test="infoSingle.infoState==1"><s2:set name="forbid" value="true"/></s2:if> <s2:else><s2:set name="forbid" value="false"/></s2:else> <s2:submit action="admin_Check" value="√通过审核" disabled="%{forbid}"/> </td> <td align="center"><s2:submit action="admin_Delete" value="×删除信息" οnclick="return really()"/></td> </tr> <tr height="5"><td></td></tr> <tr> <td colspan="3" style="border:1 solid" mce_style="border:1 solid"> <table border="0" width="630" cellspacing="0" cellpadding="10" style="word-break:break-all" mce_style="word-break:break-all"> <tr height="130"><td colspan="3" valign="top"><s2:property value="infoSingle.infoContent" escape="false"/></td></tr> <tr height="30" align="center"> <td>联系电话：<s2:property value="infoSingle.infoPhone"/></td> <td>联系人：<s2:property value="infoSingle.infoLinkman"/></td> <td>E-mial：<s2:property value="infoSingle.infoEmail"/></td> </tr> </table> </td> </tr> <tr><td align="center" colspan="3"><a href="javascript:window.history.back(-1)" mce_href="javascript:window.history.back(-1)">返回</a></td></tr> </table> </s2:form> </center> </body> </html>

moneyshow.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"%> <%@ taglib prefix="s2" uri="/struts-tags" %> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <html> <head> <title>后台-付费设置</title> <base href="<%=basePath%>"> <mce:script type="text/javascript" src="<s2:url value='js/DeleteCheck.js'/><!-- "> // --></mce:script> </head> <body> <center> <br> <s2:form theme="simple"> <input type="hidden" name="moneyID" value="<s2:property value="infoSingle.id"/>"> <input type="hidden" name="deleteID" value="<s2:property value="infoSingle.id"/>"> <table border="0" width="645" cellpadding="10" cellspacing="0" style="word-break:break-all" mce_style="word-break:break-all"> <tr height="30"> <td style="text-indent:5" mce_style="text-indent:5"><b>付费设置 [ID值：<s2:property value="infoSingle.id"/>]</b></td> <td colspan="2" align="right"><s2:fielderror/></td> </tr> <tr height="30" bgcolor="#F9F9F9"><td colspan="3" align="center" style="text-indent:5" mce_style="text-indent:5">信息详细内容</td></tr> <tr height="30"> <td width="25%" style="text-indent:10" mce_style="text-indent:10">信息类别：</td> <td>【<s2:property value="#session.typeMap[infoSingle.infoType]"/>】</td> <td>付费状态：  <s2:if test="infoSingle.infoPayfor==1">★ 已付费</s2:if><s2:else>● 未付费</s2:else></td> </tr> <tr height="30"> <td style="text-indent:10" mce_style="text-indent:10">发布时间：</td> <td><s2:property value="infoSingle.infoDate"/></td> <td>审核状态：  <s2:if test="infoSingle.infoState==1">★ 已审核</s2:if><s2:else>● 未审核</s2:else></td> </tr> <tr height="30"> <td style="text-indent:10" mce_style="text-indent:10">信息标题：</td> <td colspan="2"><s2:property value="infoSingle.infoTitle"/></td> </tr> <tr height="40" bgcolor="#F9F9F9"> <td style="text-indent:10" mce_style="text-indent:10">信息内容：</td> <td align="center"> <s2:if test="infoSingle.infoPayfor==1"><s2:set name="forbid" value="true"/></s2:if> <s2:else><s2:set name="forbid" value="false"/></s2:else> <s2:submit action="admin_SetMoney" value="√设为付费" disabled="forbid"/> </td> <td align="center"><s2:submit action="admin_Delete" value="×删除信息" οnclick="return really()"/></td> </tr> <tr height="5"><td></td></tr> <tr> <td colspan="3" style="border:1 solid" mce_style="border:1 solid"> <table border="0" width="630" cellspacing="0" cellpadding="10" style="word-break:break-all" mce_style="word-break:break-all"> <tr height="130"><td colspan="3" valign="top"><s2:property value="infoSingle.infoContent" escape="false"/></td></tr> <tr height="30" align="center"> <td>联系电话：<s2:property value="infoSingle.infoPhone"/></td> <td>联系人：<s2:property value="infoSingle.infoLinkman"/></td> <td>E-mial：<s2:property value="infoSingle.infoEmail"/></td> </tr> </table> </td> </tr> </table> </s2:form> </center> </body> </html>

pages/admin/view:

AdminTemp.jsp

<%@ page language="java" contentType="text/html; charset=GBK"%> <%@ taglib uri="/struts-tags" prefix="s2"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <html> <head> <title>都市信息网-后台管理</title> <base href="<%=basePath%>"> <link type="text/css" rel="stylesheet" href="<s2:url value='css/style.css'/>"> </head> <body> <center> <table border="0" width="920" cellspacing="0" bgcolor="white"> <tr><td colspan="2"><%@ include file="top.jsp"%></td></tr> <tr height="10" bgcolor="lightgrey"><td colspan="2"></td></tr> <tr> <td width="700" align="center" valign="top"><jsp:include page="main.jsp"/></td> <td width="200" align="center" valign="top"><jsp:include page="right.jsp"/></td> </tr> <tr height="7" bgcolor="lightgrey"><td colspan="2"></td></tr> <tr><td colspan="2"><%@ include file="end.jsp" %></td></tr> </table> </center> </body> </html>

default.jsp

<%@ page language="java" contentType="text/html; charset=GBK"%> <%@ taglib uri="/struts-tags" prefix="s2"%> <html> <head><title>后台首页</title></head> <body> <center> <table border="0" cellpadding="0" cellspacing="0" width="650" height="300"> <tr><td align="center">欢迎登录 都市供求信息网后台！</td></tr> </table> </center> </body> </html>

main.jsp

<%@ page language="java" contentType="text/html; charset=GBK"%> <%@ taglib uri="/struts-tags" prefix="s2"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; String mainPage=(String)request.getAttribute("mainPage"); if(mainPage==null||mainPage.equals("")) mainPage="default.jsp"; %> <html> <head> <title>后台首页</title> <base href="<%=basePath%>"> <link type="text/css" rel="stylesheet" href="<s2:url value='css/style.css'/>"> </head> <body> <center> <table border="0" cellpadding="0" cellspacing="0" width="688" height="100%"> <tr height="20"><td><img src="images/default_t.jpg" mce_src="images/default_t.jpg"></td></tr> <tr><td background="images/default_m.jpg" valign="top"><jsp:include page="<%=mainPage%>"/></td></tr> <tr height="26"><td><img src="images/default_e.jpg" mce_src="images/default_e.jpg"></td></tr> </table> </center> </body> </html>

top.jsp

<%@ page language="java" contentType="text/html; charset=GBK"%> <%@ taglib prefix="s2" uri="/struts-tags" %> <html> <head><title>后台-页眉</title></head> <body> <center> <table border="0" width="100%" height="93" cellspacing="0" cellpadding="0" background="images/admin_top.jpg"> <tr> <td width="100%" height="100%" align="right" valign="bottom"> <s2:a href="goindex.action" mce_href="goindex.action"><img src="images/admin_index.gif" mce_src="images/admin_index.gif" border="0"></s2:a><s2:a href="log_Logout.action" mce_href="log_Logout.action"><img src="images/admin_exit.gif" mce_src="images/admin_exit.gif" border="0"></s2:a> </td> </tr> </table> </center> </body> </html>

end.jsp

<%@ page language="java" contentType="text/html; charset=GBK"%> <html> <head> <title>后台-页尾</title> </head> <body> <center> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr><td align="center"><img src="images/end.jpg" mce_src="images/end.jpg"></td></tr> </table> </center> </body> </html>

right.jsp

<%@ page language="java" contentType="text/html; charset=GBK"%> <%@ page import="java.util.Map,java.util.TreeMap" %> <%@ taglib prefix="s2" uri="/struts-tags" %> <% Map checkState=new TreeMap(); checkState.put("1","已审核"); checkState.put("0","未审核"); checkState.put("all","全部"); Map payforState=new TreeMap(); payforState.put("1","已付费"); payforState.put("0","未付费"); payforState.put("all","全部"); request.setAttribute("checkState",checkState); request.setAttribute("payforState",payforState); %> <html> <head><title>后台-侧栏</title></head> <body background="images/back.gif"> <center> <table border="0" width="220" height="100%" cellspacing="0" cellpadding="0" style="margin-top:7" mce_style="margin-top:7"> <!-- 显示方式 --> <tr height="30" bgcolor="#F0F0F0"><td style="text-indent:5;border:1 solid" mce_style="text-indent:5;border:1 solid"><font color="#004790"><b>■显示方式</b></font></td></tr> <tr height="1"><td></td></tr> <s2:form action="admin_ListShow.action?" theme="simple"> <tr> <td align="center" valign="top" style="border:1 solid" mce_style="border:1 solid"> <table border="0" width="220" height="150" rules="all" cellspacing="0"> <tr> <td align="center" colspan="2"> <fieldset style="height:60;width:210"> <legend>★付费状态</legend> <br> <s2:radio list="#request.payforState" name="showType.payforType" value="%{showType.payforType}"/> </fieldset> <fieldset style="height:60;width:210"> <legend>★审核状态</legend> <br> <s2:radio list="#request.checkState" name="showType.stateType" value="%{showType.stateType}"/> </fieldset> </td> </tr> <tr align="center" height="30" bgcolor="lightgrey"> <td> 信息类别： <s2:select emptyOption="true" list="#session.typeMap" name="showType.infoType"/> <s2:submit value="显示"/> </td> </tr> </table> </td> </tr> </s2:form> <tr height="5"><td></td></tr> <!-- 设置已付费信息 --> <tr height="30" bgcolor="#F0F0F0"><td style="text-indent:5" mce_style="text-indent:5" style="border:1 solid" mce_style="border:1 solid"><font color="#004790"><b>■付费设置</b></font></td></tr> <tr height="1"><td></td></tr> <form action="admin_SetMoneyShow.action"> <tr> <td align="center" valign="top" style="border:1 solid" mce_style="border:1 solid"> <table border="0" width="220" height="80" cellspacing="0" rules="none"> <tr height="25"><td align="center" valign="bottom">请输入要设为已付费状态的信息ID：</td></tr> <tr height="40"> <td align="center"> <input type="text" name="moneyID" value="${param['moneyID']}" size="24"/> <input type="submit" value="查询"/> </td> </tr> </table> </td> </tr> </form> <tr height="5"><td></td></tr> <tr height="30" bgcolor="#F0F0F0"><td style="text-indent:5;border:1 solid" mce_style="text-indent:5;border:1 solid"><font color="#004790"><b>■日历</b></font></td></tr> <tr height="1"><td></td></tr> <!-- 日历 --> <tr height="130"> <td valign="top" style="border:1 solid" mce_style="border:1 solid"><jsp:include page="/pages/calendar.jsp"/></td> </tr> </table> </center> </body> </html>

pages/show:

listshow.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"%> <%@ taglib prefix="s2" uri="/struts-tags" %> <html> <head><title>查看信息列表</title></head> <body> <center> <!-- 列表显示付费信息 --> <s2:set name="onepayforlist" value="#request.onepayforlist"/> <table border="0" width="670" cellspacing="0" cellpadding="0" style="margin-top:5" mce_style="margin-top:5"> <s2:if test="#onepayforlist==null||#onepayforlist.size()==0"> <tr height="30"><td align="center">★★★ 缴费后，您发布信息就可在这里显示！★★★</td></tr> </s2:if> <s2:else> <tr height="30"><td style="text-indent:5" mce_style="text-indent:5" valign="bottom"><font color="#004790"><b>■推荐<s2:property value="#session.typeMap[#onepayforlist[0].infoType]"/></b>『缴费专区』</font></td></tr> <s2:iterator status="onepayforStatus" value="onepayforlist"> <s2:if test="#onepayforStatus.odd"> <tr><td align="center" style="border:1 solid" mce_style="border:1 solid" bgcolor="#F0F0F0"> </s2:if> <s2:else> <tr><td align="center" style="border:1 solid" mce_style="border:1 solid" bgcolor="white"> </s2:else> <table border="0" width="655" cellpadding="3" style="word-break:break-all" mce_style="word-break:break-all"> <tr height="30"> <td colspan="2">【<s2:property value="#session.typeMap[infoType]"/>】</td> <td align="right">发布时间：『<s2:property value="infoDate"/>』 </td> </tr> <tr height="80"><td colspan="3"><s2:property value="infoContent"/></td></tr> <tr height="30" align="center"> <td>联系电话：<s2:property value="infoPhone"/></td> <td>联 系 人：<s2:property value="infoLinkman"/></td> <td>E-mail：<s2:property value="infoEmail"/></td> </tr> </table> </td> </tr> <tr height="1"><td></td></tr> </s2:iterator> </s2:else> </table> <!-- 列表显示免费信息 --> <s2:set name="onefreelist" value="#request.onefreelist"/> <table border="0" width="670" cellspacing="0" cellpadding="0" style="margin-top:5" mce_style="margin-top:5" rules="rows"> <s2:if test="#onefreelist==null||#onefreelist.size()==0"> <tr height="30"><td align="center">★★★ 在这里显示免费发布的信息！★★★</td></tr> </s2:if> <s2:else> <tr height="30"><td style="text-indent:5" mce_style="text-indent:5" valign="bottom"><font color="#004790"><b>■最新<s2:property value="#session.typeMap[#onefreelist[0].infoType]"/></b>『免费专区』</font></td></tr> <s2:iterator status="onefreeStatus" value="onefreelist"> <s2:if test="#onefreeStatus.odd"> <tr><td align="center" style="border:1 solid" mce_style="border:1 solid" bgcolor="#F0F0F0"> </s2:if> <s2:else> <tr><td align="center" style="border:1 solid" mce_style="border:1 solid" bgcolor="white"> </s2:else> <table border="0" width="655" cellpadding="3" style="word-break:break-all" mce_style="word-break:break-all"> <tr height="30"> <td colspan="2">【<s2:property value="#session.typeMap[infoType]"/>】</td> <td align="right">发布时间：『<s2:property value="infoDate"/>』 </td> </tr> <tr height="80"><td colspan="3"><s2:property value="infoContent"/></td></tr> <tr height="30" align="center"> <td>联系电话：<s2:property value="infoPhone"/></td> <td>联系人：<s2:property value="infoLinkman"/></td> <td>E-mail：<s2:property value="infoEmail"/></td> </tr> </table> </td> </tr> <tr height="1"><td></td></tr> </s2:iterator> <tr height="30"><td align="center"><jsp:include page="/pages/page.jsp"/></td></tr> </s2:else> </table> <br> </center> </body> </html>

singleshow.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"%> <%@ taglib prefix="s2" uri="/struts-tags" %> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <html> <head> <title>都市信息网-查看详细内容</title> <base href="<%=basePath%>"> <link type="text/css" rel="stylesheet" href="<s2:url value='css/style.css'/>"> </head> <body> <center> <table width="670" border="0" cellspacing="0" cellpadding="0" style="margin-top:5" mce_style="margin-top:5"> <tr height="30"><td style="text-indent:5" mce_style="text-indent:5" valign="bottom"><font color="#004790"><b>■查看详细信息</b></font></td></tr> <tr height="1"><td></td></tr> <tr bgcolor="#FAFCF5"> <td style="border:1 solid" mce_style="border:1 solid"> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <s2:if test="infoSingle==null"> <tr height="100"><td align="center" colspan="2" style="border:1 solid" mce_style="border:1 solid">★★★ 查看信息详细内容出错！★★★</td></tr> </s2:if> <s2:else> <tr height="40"> <td width="20%" style="text-indent:20" mce_style="text-indent:20">信息类别：</td> <td><s2:property value="#session.typeMap[infoSingle.infoType]"/></td> </tr> <tr height="40"> <td style="text-indent:20" mce_style="text-indent:20">发布时间：</td> <td><s2:property value="infoSingle.infoDate"/></td> </tr> <tr height="40"> <td style="text-indent:20" mce_style="text-indent:20">信息标题：</td> <td><s2:property value="infoSingle.infoTitle"/></td> </tr> <tr height="40"><td colspan="2" style="text-indent:20" mce_style="text-indent:20">信息内容：</td></tr> <tr> <td colspan="2" align="center"> <table border="1" width="630" cellspacing="0" cellpadding="10" rules="none" frame="below" style="word-break:break-all" mce_style="word-break:break-all" bordercolor="lightgrey" bordercolorlight="lightgrey" bordercolordark="white"> <tr height="200" bgcolor="white"><td colspan="3" valign="top" style="border:1 solid" mce_style="border:1 solid"><s2:property value="infoSingle.infoContent" escape="false"/></td></tr> <tr height="20" align="center"> <td>联系电话：<s2:property value="infoSingle.infoPhone"/></td> <td>联系人：<s2:property value="infoSingle.infoLinkman"/></td> <td>E-mial：<s2:property value="infoSingle.infoEmail"/></td> </tr> </table> </td> </tr> <tr height="63"><td align="center" colspan="2"><a href="javascript:window.history.back(-1)" mce_href="javascript:window.history.back(-1)">返回</a></td></tr> </s2:else> </table> </td> </tr> </table> <br> </center> </body> </html>

searchshow.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"%> <%@ taglib prefix="s2" uri="/struts-tags" %> <html> <head> <title>查询-查看信息列表</title> <mce:script type="text/javascript" src="<s2:url value='js/DeleteCheck.js'/><!-- "> // --></mce:script> </head> <body> <center> <table border="0" width="670" cellspacing="0" cellpadding="0" style="margin-top:5" mce_style="margin-top:5"> <tr height="30"><td style="text-indent:5" mce_style="text-indent:5" valign="bottom"><font color="#004790"><b>■查询结果</b></td></tr> <tr height="1"><td></td></tr> <tr> <td align="center" style="border:1 solid" mce_style="border:1 solid"> <table border="0" width="100%" rules="rows" cellspacing="0"> <tr align="center" height="30" bgcolor="#F0F0F0"> <td width="6%"><b>序号</b></td> <td width="11%"><b>信息类别</b></td> <td width="8%"><b>ID值</b></td> <td width="38%"><b>信息标题</b></td> <td width="22%"><b>发布时间</b></td> <td width="15%"><b>联系人</b></td> </tr> <s2:set name="searchlist" value="#request.searchlist"/> <s2:if test="#searchlist==null||#searchlist.size()==0"> <tr height="80"><td colspan="8" align="center">★★对不起，未找到符合条件的信息！★★</td></tr> </s2:if> <s2:else> <s2:iterator status="status" value="searchlist"> <s2:if test="#status.even"> <tr height="30" bgcolor="#F9F9F9"></s2:if> <s2:else> <tr height="30"></s2:else> <td align="center"><b><s2:property value="#status.index+1"/></b></td> <td align="center"><s2:property value="#session.typeMap[infoType]"/></td> <td style="text-indent:10" mce_style="text-indent:10"><s2:property value="id"/></td> <td style="text-indent:5" mce_style="text-indent:5"><a href="info_SingleShow.action?id=<s2:property value='id'></a>"><s2:property value="getSubInfoTitle(19)"/></a></td> <td align="center"><s2:property value="infoDate"/></td> <td style="text-indent:10" mce_style="text-indent:10"><s2:property value="infoLinkman"/></td> </tr> </s2:iterator> </s2:else> </table> </td> </tr> <tr height="1"><td></td></tr> <tr height="30"><td align="center"><jsp:include page="/pages/page.jsp"/></td></tr> </table> <br> </center> </body> </html>

pages:

calendar.jsp

<%@ page language="java" contentType="text/html; charset=gb2312" %> <%@ page language="java" import="java.util.*" %> <% String[] weekdays={"","日","一","二","三","四","五","六"}; String[] days=new String[42]; for(int i=0;i<42;i++) days[i]=""; GregorianCalendar currentDay = new GregorianCalendar(); int year= currentDay.get(Calendar.YEAR); int month=currentDay.get(Calendar.MONTH); int today=currentDay.get(Calendar.DAY_OF_MONTH); int weekday=currentDay.get(Calendar.DAY_OF_WEEK); String now=year+"年"+(month+1)+"月"+today+"日"+" 星期"+weekdays[weekday]; Calendar thisMonth=Calendar.getInstance(); thisMonth.set(Calendar.MONTH, month ); thisMonth.set(Calendar.YEAR, year ); thisMonth.setFirstDayOfWeek(Calendar.SUNDAY); thisMonth.set(Calendar.DAY_OF_MONTH,1); int firstIndex=thisMonth.get(Calendar.DAY_OF_WEEK)-1; int maxIndex=thisMonth.getActualMaximum(Calendar.DAY_OF_MONTH); for(int i=0;i<maxIndex;i++){ days[firstIndex+i]=String.valueOf(i+1); } %> <html> <head> <title>简易万年历</title> <link type="text/css" rel="stylesheet" href="<s2:url value='css/style.css'/>"> <mce:script type="text/javascript"><!-- function showTime(showWhere){ var now=new Date(); var hour=now.getHours(); var minu=now.getMinutes(); var sec=now.getSeconds(); if(hour<10) hour="0"+hour; if(minu<10) minu="0"+minu; if(sec<10) sec="0"+sec; showWhere.value=hour+":"+minu+":"+sec; setTimeout("showTime(time)",1000) } // --></mce:script> </head> <body οnlοad="showTime(time)"> <table width="210" border="0" align="center" cellspacing="1" > <tr height="25"><td colspan="7" align="center" style="border:0 solid" mce_style="border:0 solid"><%=now%> <input type="text" style="border:0;background-color:#F9F9F9" mce_style="border:0;background-color:#F9F9F9" disable="true" id="time" size="9"></td></tr> <tr height="25" bgcolor="#F0F0F0" align="center"> <td style="border:1 solid" mce_style="border:1 solid">日</td> <td style="border:1 solid" mce_style="border:1 solid">一</td> <td style="border:1 solid" mce_style="border:1 solid">二</td> <td style="border:1 solid" mce_style="border:1 solid">三</td> <td style="border:1 solid" mce_style="border:1 solid">四</td> <td style="border:1 solid" mce_style="border:1 solid">五</td> <td style="border:1 solid" mce_style="border:1 solid">六</td> </tr> <tr height="4"><td colspan="7"></td></tr> <% for(int j=0;j<6;j++) { %> <tr> <% for(int i=j*7;i<(j+1)*7;i++) { if((i-firstIndex+1)==today){%> <td width="30" height="23" align="center" bgcolor="gray" style="border:1 solid" mce_style="border:1 solid"><font color="#FFFFFF"><b><%=days[i]%></b></font></td> <% }else{ %> <td width="30" height="23" align="center" style="border:1 solid" mce_style="border:1 solid"><%=days[i]%></td> <% } }%> </tr> <% } %> <tr height="10"><td colspan="7"></td></tr> </table> </body> </html>

page.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"%> <%@ taglib uri="/struts-tags" prefix="s2"%> <html> <head><title>分页导航栏</title></head> <body> <table border="0" width="100%" cellspacing="0"> <tr> <td width="60%"><s2:property escape="false" value="#request.createpage.PageInfo"/></td> <td align="center" width="40%"><s2:property escape="false" value="#request.createpage.PageLink"/></td> </tr> </table> </body> </html>

error.jsp

<%@ page language="java" contentType="text/html; charset=GBK"%> <%@ taglib uri="/struts-tags" prefix="s2"%> <html> <head><title>友情提示</title></head> <body> <center> <table border="0" width="650" height="200" cellspacing="0" style="margin-top:20" mce_style="margin-top:20" bgcolor="#F9F9F9"> <tr> <td align="center" style="border:1 solid" mce_style="border:1 solid"> <table><tr><td><s2:fielderror/></td></tr></table> </td> </tr> </table> </center> </body> </html>

js:

InputCheck.js

function check(fieldName,UseName,RemName,len){ if(fieldName.value.length>len){ fieldName.value=(fieldName.value).substring(0,len); alert("最多可只允许输入 "+len+" 个字符！"); return false; } else{ UseName.value=eval(fieldName.value.length); RemName.value=len-UseName.value; return true; } }

DeleteCheck.js

function really(){ return confirm("确认要删除该信息吗？"); }

css:

style.css

<meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <!-- td { font-size: 9pt; color: #000000; } a:hover { font-size: 9pt; color: #FF0000; text-decoration:underline } a { font-size: 9pt; text-decoration: none; color: black; noline:expression(this.οnfοcus=this.blur); } input{ font-family: "宋体"; font-size: 9pt; color: #333333; } body { margin-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; } .textarea { font-family: "宋体"; font-size: 9pt; color: #333333; border: 1px solid #999999; } -->

 

源码来自明日科技《项目开发全程实录》之JSP篇第一例