修改三级

81041

2019-06-20 e4efa2387409d35e1fc5e566b84e2065aafa30a6

 sensor/src/com/fgkj/dao/impl/CustompageImpl.java

New file
@@ -0,0 +1,120 @@
package com.fgkj.dao.impl;



import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;



import com.fgkj.actions.ActionUtil;

import com.fgkj.dao.BaseDAO;

import com.fgkj.dao.CallBack;

import com.fgkj.dao.DAOHelper;

import com.fgkj.db.DBUtil;

import com.fgkj.db.IDatabaseName;

import com.fgkj.dto.Custompage;



public class CustompageImpl extends ActionUtil implements BaseDAO,CallBack {



   public List getResults(ResultSet rs) {

      List list=new ArrayList();

      try {

         while(rs.next()){

            Custompage cpage=new Custompage();

				
            cpage.setNum(rs.getInt("num"));

            cpage.setNavigate(rs.getString("navigate"));

            cpage.setNavigate_order(rs.getInt("navigate_order"));

            cpage.setSubmenu(rs.getString("submenu"));

            cpage.setSubflag(rs.getInt("subflag"));

            cpage.setSublink(rs.getString("sublink"));

            cpage.setSubenable(rs.getInt("subenable"));

            cpage.setSubjudge(rs.getInt("subjudge"));

            if(cpage.getSubjudge()==2){

               cpage.setSubname(getText(cpage.getNavigate()));					
            }else if(cpage.getSubjudge()==1){

               cpage.setSubname(getText(cpage.getSubmenu()));

            }else{

               cpage.setSubname(rs.getString("subname"));

            }

            cpage.setPage_order(rs.getInt("page_order"));

            //System.out.println(cpage);

            list.add(cpage);

         }

      } catch (SQLException e) {

         // TODO Auto-generated catch block

         e.printStackTrace();

      }

      return list;

   }

    //页面定制下添加导航或者子页面

   public boolean add(Object obj) {

      Custompage cpage=(Custompage) obj;

      String sql="insert into web_site.tb_custompage(navigate,navigate_order,submenu,subflag,sublink,subenable,subname,subjudge,page_order) values(?,?,?,?,?,?,?,?,?)";

      Boolean bl=DAOHelper.executeUpdate( DBUtil.getConn(),sql, new Object[]{

         cpage.getNavigate(),cpage.getNavigate_order(),cpage.getSubmenu(),cpage.getSubflag()

         ,cpage.getSublink(),cpage.getSubenable(),cpage.getSubname(),cpage.getSubjudge()

         ,cpage.getPage_order()});

      return bl;

   }

    //页面定制可以看到的子菜单和子模块

   public boolean update(Object obj) {

      Custompage cpage=(Custompage) obj;

      String sql="update web_site.tb_custompage set subflag=? where num=? ";

      Boolean bl=DAOHelper.executeUpdate( DBUtil.getConn(),sql, new Object[]{

         cpage.getSubflag(),cpage.getNum()});

      return bl;

   }

   //页面定制修改主导航下子页面的顺序

   public boolean updateOrder(Object obj) {

      Custompage cpage=(Custompage) obj;

      String sql="update web_site.tb_custompage set page_order=? where num=? ";

      Boolean bl=DAOHelper.executeUpdate( DBUtil.getConn(),sql, new Object[]{

         cpage.getPage_order(),cpage.getNum()});

      return bl;

   }

    
   public boolean del(Object obj) {

      // TODO Auto-generated method stub

      return false;

   }

	
    //查询所有的菜单(页面定制可以看到的子菜单和子模块)

   public List searchAll() {

      String sql="select num,navigate,navigate_order,submenu,subflag,sublink,page_order," +

            "subenable,subname,subjudge from web_site.tb_custompage order by navigate_order,page_order ";

       List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new CustompageImpl());	    
      return list;

   }



   //根据页面查询子模块

   public List serchByCondition(Object obj) {

      Custompage cpage=(Custompage) obj;

      String sql="select  num,navigate,navigate_order,submenu,subflag,sublink,page_order," +

            "subenable,subname,subjudge from web_site.tb_custompage where navigate=? and subjudge=? order by page_order";

      List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{cpage.getNavigate() ,cpage.getSubjudge()},new CustompageImpl());

      return list;

   }

    //根据主导航的名字查询所有的子页面

   public List serchByInfo(Object obj) {

      Custompage cpage=(Custompage) obj;

      String sql="select num,navigate,navigate_order,submenu,subflag,sublink,page_order," +

            "subenable,subname,subjudge from web_site.tb_custompage where navigate=?  order by navigate_order,page_order ";

       List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{cpage.getNavigate()}, new CustompageImpl());	    
      return list;

   }

   public static void main(String[] args) {

      CustompageImpl cimpl=new CustompageImpl();

      Custompage cpage=new Custompage();

      cpage.setNum(25);

      cpage.setNavigate_order(5);

      cpage.setSubflag(1);

      cpage.setSubenable(0);

      cpage.setSubjudge(1);

      List<Custompage> list=cimpl.searchAll();

      for (Custompage c : list) {

         System.out.println(c);

      }

      //Boolean bl=cimpl.update(cpage);

      //System.out.println(bl);

   }

}