zlxzfunc.java~64~

c++通信编程学习1

package com.j2ee.func.zlxz;
import java.util.Vector;
import java.sql.SQLException;
import java.util.Calendar;
import java.text.SimpleDateFormat;
import com.j2ee.func.systemvia.SystemviaInfo;
import com.j2ee.func.systemvia.SystemviaFunc;
import com.j2ee.func.qyzp.ZpBean;
import com.j2ee.func.xszx.SellgoodsBean;
import com.j2ee.database.*;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class ZlxzFunc {
    public static String searchkey="";
    public static String typep="";
    public String sortid;
    public String sorttype;
    public int ptype; //哪一种类型;
    public int pageno; //分页的页数;
    public String type;
    public int id;
    public int flag; //是否过期的推荐新闻或文章；
    public ZlxzInfo wif;
    public TjxzInfo ti;
    public ZlxzFunc() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
    public ZlxzFunc(String type, int flag) {
        this.type = type;
        this.flag = flag;
    }
    public ZlxzFunc(String type) {
        this.type=type;
    }
    public ZlxzFunc(int id) {
        this.id=id;
    }
    public ZlxzFunc(String type, int page,int ptype) {
      this.type = type;
      this.pageno = page ;
      this.ptype=ptype;
    }
    public ZlxzFunc(int ptype, int pageno, String sortid, String sorttype) { //选出所有新闻
        this.ptype = ptype;
        this.pageno = pageno;
        this.sortid = sortid;
        this.sorttype = sorttype;
    }
    public ZlxzFunc(ZlxzInfo wif) {
        this.wif = wif;
    }
    public ZlxzFunc(TjxzInfo ti){
        this.ti=ti;
    }
    public int getAllXzcount() throws SQLException {
        String sql = "select count(*) from zlxz";
        ZpBean zb = new ZpBean();
        int count = zb.getpositionCount(sql);
        return count;
    }

    public int getPagesize() throws SQLException {
    SystemviaFunc svf = new SystemviaFunc();
    Vector vct = svf.getPagesize();
    SystemviaInfo svi = (SystemviaInfo) vct.firstElement();
    int pagestart = 0, pagesize = 0;
    if (this.ptype == 1) {
        pagestart = (this.pageno - 1) * svi.getPagesizeone(); //一级页面
        pagesize = svi.getPagesizeone();
    } else if (this.ptype == 2) {
        pagestart = (this.pageno - 1) * svi.getPagesizetwo(); //2级页面
        pagesize = svi.getPagesizetwo();
    } else if (this.ptype == 3) {
        pagestart = (this.pageno - 1) * svi.getPagesizethree(); //3级页面
        pagesize = svi.getPagesizethree();
    } else if (this.ptype == 4) {
        pagestart = (this.pageno - 1) * svi.getPagesizeback(); //后台页面大小；
        pagesize = svi.getPagesizeback();
    }
    return pagesize;
}


    public String selectZlxzInfosql() throws SQLException {
        SystemviaFunc svf = new SystemviaFunc();
        Vector vct = null;
        vct = svf.getPagesize();
        SystemviaInfo svi = (SystemviaInfo) vct.firstElement();
        int pagestart = 0, pagesize = 100;
        if (this.ptype == 1) {
            pagestart = (this.pageno - 1) * svi.getPagesizeone(); //一级页面
            pagesize = svi.getPagesizeone();
        } else if (this.ptype == 2) {
            pagestart = (this.pageno - 1) * svi.getPagesizetwo(); //2级页面
            pagesize = svi.getPagesizetwo();
        } else if (this.ptype == 3) {
            pagestart = (this.pageno - 1) * svi.getPagesizethree(); //3级页面
            pagesize = svi.getPagesizethree();
        } else if (this.ptype == 4) {
            pagestart = (this.pageno - 1) * svi.getPagesizeback(); //后台页面大小；
            pagesize = svi.getPagesizeback();
        }
        String sql = "select * from zlxz where type like '%" + this.type +
                         "%' order by sentdate desc limit " + pagestart + ","+pagesize;
        return sql;
    }
    public int SelectCount() throws SQLException {
    String sql = "select count(*) from zlxz where type like '%" + this.type + "%'";
    ZlxzBean nb = new ZlxzBean();
    int count = nb.selectCount(sql);
    return count;
    }
    public Vector SelectZlxzInfo() throws SQLException {//取出type类型的数据
        ZlxzBean zb=new ZlxzBean();
        Vector vct=zb.selectZlxzInfo(selectZlxzInfosql());
        return vct;
    }
    public String selectdetailZlxzinfosql(){
        String sql="select * from zlxz where  id="+this.id+"";
        return sql;
    }
    public Vector SelectdetailZlxzinfo() throws SQLException {//显示详细信息
        ZlxzBean zb=new ZlxzBean();
        Vector vct= zb.selectZlxzInfo(selectdetailZlxzinfosql());
        return vct;
    }

    public boolean increaseCount(){
        String sql="update zlxz set seecount=seecount+1 where id='"+this.id+"'";
         ZlxzBean zb=new ZlxzBean();
        boolean bl=zb.updateSeecount(sql);
        return bl;
    }
    public String selecttalltitle(){
            String sql="select * from zlxz order by sentdate desc limit 10";
            return sql;
        }

        public Vector selectTalltitle() throws SQLException {
            ZlxzBean zb=new ZlxzBean();
           Vector vct=zb.selectZlxzInfo(selecttalltitle());
           return vct;
}
       //************ 添加xinwen类
            public String addXzSql() {
                Calendar now = Calendar.getInstance();
                SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
                String date = sdf.format(now.getTime());
                String sql = "insert into zlxz values(null,'" + wif.getTitle() + "',null,'" +
                             wif.getType() + "',null,'" +
                             wif.getLink() + "','" +wif.getShortbrief() + "','" +wif.getLoadman() + "','" +
                             date + "',0,0)";
                return sql;
            }

           public boolean addXz() {
               ZlxzBean nb = new ZlxzBean();
               boolean bl = nb.insertXz(addXzSql());
               return bl;
    }
    //*************************************************
     public Vector getAllXz() throws SQLException {
         SystemviaFunc svf = new SystemviaFunc();
         Vector vct = svf.getPagesize();
         SystemviaInfo svi = (SystemviaInfo) vct.firstElement();
         int pagestart = 0, pagesize = 100;
         if (this.ptype == 1) {
             pagestart = (this.pageno - 1) * svi.getPagesizeone(); //一级页面
             pagesize = svi.getPagesizeone();
         } else if (this.ptype == 2) {
             pagestart = (this.pageno - 1) * svi.getPagesizetwo(); //2级页面
             pagesize = svi.getPagesizetwo();
         } else if (this.ptype == 3) {
             pagestart = (this.pageno - 1) * svi.getPagesizethree(); //3级页面
             pagesize = svi.getPagesizethree();
         } else if (this.ptype == 4) {
             pagestart = (this.pageno - 1) * svi.getPagesizeback(); //后台页面大小；
             pagesize = svi.getPagesizeback();
         }
         ZlxzBean nb = new ZlxzBean();
         String sql = " select * from zlxz  where (title like '%"+this.searchkey+"%'"+
                     " or loadman like '%"+this.searchkey+"%' or type like '%"+this.searchkey+"%'"+
                    "  or sentdate like '%"+this.searchkey+"%' or shortbrief like '%"+this.searchkey+"%' )"+
                     " and type like '%"+this.typep+"%' order by " +
                      this.sortid + " " +
                      this.sorttype + " limit " + pagestart + "," + pagesize;
         Vector vctall = nb.selectZlxzInfo(sql);
         return vctall;
     }
     //*****************
       public String selecttjwz() {
        String sql = "select * from zlxz,tjxz  where zlxz.type='" + this.type +
                     "' and zlxz.id=tjxz.xzid order by zlxz.sentdate desc limit 3";
        return sql;
       }

       public Vector SelectTjxz() throws SQLException {
        ZlxzBean wb=new ZlxzBean();
        Vector vct = null;
        vct = wb.selectTjxz(selecttjwz());
        return vct;
 }
 //*****************更新；
  public boolean updateFile(int id, String gn,String size) {
      String sql = "update zlxz set name='" + gn + "',large='"+size+"' where id=" +
                   id;
      ZlxzBean sgb = new ZlxzBean();
      boolean bl = sgb.updateXzzl(sql);
      return bl;
     }
     //************ 热点
          public String selectTopWz() {
              String sql = "select * from zlxz order by seecount desc limit 10";
              return sql;
          }

         public Vector SelectTopWz() throws SQLException { //显示详细信息
             ZlxzBean nb = new ZlxzBean();
             Vector vct = nb.selectZlxzInfo(selectTopWz());
             return vct;
     }
     //*************最新
      public String selectttoptitle() {
          String sql = "select * from zlxz order by sentdate desc limit 10";
          return sql;
      }

      public Vector selectToptitle() throws SQLException {
          ZlxzBean nb = new ZlxzBean();
          Vector vct = nb.selectZlxzInfo(selectttoptitle());
          return vct;
    }
//********************************
     public String selectmanaTjwz() {
         Calendar now = Calendar.getInstance();
         SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
         String date = sdf.format(now.getTime());
         String sql=null;
         if (flag == 2) { //非过期文章
             sql = "select * from zlxz,tjxz  where zlxz.type='" +
                   this.type +
                   "' and zlxz.id=tjxz.xzid and " +
                   " tjxz.begindate <='" + date +
                   "' and tjxz.enddate >='" + date +
                   "' order by zlxz.sentdate desc limit 3";
         }
         else if(flag==1){ //过期文章；
             sql = "select * from zlxz,tjxz  where zlxz.type='" +
                   this.type +
                   "' and zlxz.id=tjxz.xzid and " +
                   " tjxz.enddate <='" + date +
                   "' order by zlxz.sentdate desc limit 3";
         }
         return sql;
     }
//*********************************
     public Vector SelectmanaTjxz() throws SQLException {
         ZlxzBean nb = new ZlxzBean();
         Vector vct = null;
         vct = nb.selectTjxz(selectmanaTjwz());
         return vct;
    }
    //******判断是否存在该新闻；
     public boolean ifExistTjxz() {
         String sql = "select * from zlxz where id='" + this.flag +
                      "' and type='" + this.type + "'";
         J2eedatabase j2db = new J2eedatabase();
         boolean bl = j2db.isExitInDB(sql);
         return bl;
     }
    //*************shanchu
        public boolean deleteWz(){
            String sql="delete from zlxz where id="+this.id;
            ZlxzBean nb=new ZlxzBean();
            boolean bl=nb.deleteZl(sql);
            return bl;
        }

    //*************shanchu
        public boolean deleteTjxz(){
            String sql="delete from tjxz where id="+this.id;
            ZlxzBean nb=new ZlxzBean();
            boolean bl=nb.deleteZl(sql);
            return bl;
    }
    //***************添加推荐文章
         public boolean insertTjxz() {
             String sql = "insert into tjxz values(null,'" + ti.getXzid() +
                          "','" + ti.getBegindate() +
                          "','" + ti.getEnddate() + "')";
             WzBean nb = new WzBean();
             boolean bl = nb.insertWz(sql);
             return bl;
    }
  //*********************************
     public boolean upDateZl() {
         String sql = " update zlxz set title='" + wif.getTitle() +
                      "', shortbrief='" + wif.getShortbrief() +
                      "', loadman='" + wif.getLoadman() + "', link='" + wif.getLink() +
                      "', large='" + wif.getLarge() + "',type='" + wif.getType() + "' where id=" +  wif.getId();
         ZlxzBean nb = new ZlxzBean();
         boolean bl = nb.updateSeecount(sql);
         return bl;
     }

     public boolean deleteZl() {
         String sql = "delete from zlxz where id=" + this.id;
         ZlxzBean nb = new ZlxzBean();
         boolean bl = nb.deleteZl(sql);
         return bl;
    }

    //*******
     public int getLastzlxzId() throws SQLException {
       String sql = "select max(id) from zlxz";
       ZlxzBean sgl = new ZlxzBean();
       int id=sgl.getId(sql);
       return id;
   }




    private void jbInit() throws Exception {
    }
}