?? 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"));
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -