sitebean.java

来自「就业管理系统 源代码 可以运行 没有错误」· Java 代码 · 共 587 行 · 第 1/2 页

package com.bean;

/**
 * 后台网站设置操作类
 * 
 */

import java.io.File;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.util.Constant;
import com.util.DBO;

public class SiteBean {

	private ResultSet rs;
	private List list;
/*****************************************************************
 * 导航条菜单
 ******************************************************************/	
	//增加导航条主菜单
	public int addMenu(String menuname,String pic,String linkurl,String wordcolor,String targettype,String hide,String ordernum){
		String sql="select * from fz_menu where menuname='"+menuname+"'";
		String sql2="insert into fz_menu(menuname,pic,linkurl,wordcolor,targettype,hide,ordernum) " +
				"values('"+menuname+"','"+pic+"','"+linkurl+"','"+wordcolor+"','"+targettype+"','"+hide+"','"+ordernum+"')";
		DBO dbo=new DBO();
		dbo.open();
		try{
			rs=dbo.executeQuery(sql);
			if(rs.next()){
				return Constant.SAME_NAME;
			}
			else{
				int i=dbo.executeUpdate(sql2);
				if(i==1){
					return Constant.SUCCESS;
				}
				else{
					return Constant.SUCCESS;
				}
			}
		}catch(Exception e){
			e.printStackTrace();
			return Constant.SYSTEM_ERROR;
		}finally{
			dbo.close();
		}
	}
//	修改导航条主菜单（修改装饰图片）
	public int upmenu(int id,String menuname,String pic,String linkurl,String wordcolor,String targettype,String hide,String ordernum){
		String sql="select * from fz_menu where menuname='"+menuname+"'and id!='"+id+"'";
		String sql2="update fz_menu set menuname='"+menuname+"',pic='"+pic+"',linkurl='"+linkurl+"',wordcolor='"+wordcolor+"'," +
				"targettype='"+targettype+"',hide='"+hide+"',ordernum='"+ordernum+"' where id='"+id+"'";
		DBO dbo=new DBO();
		dbo.open();
		try{
			rs=dbo.executeQuery(sql);
			if(rs.next()){
				return Constant.SAME_NAME;
			}
			else{
				int i=dbo.executeUpdate(sql2);
				if(i==1){
					return Constant.SUCCESS;
				}
				else{
					return Constant.SUCCESS;
				}
			}
		}catch(Exception e){
			e.printStackTrace();
			return Constant.SYSTEM_ERROR;
		}finally{
			dbo.close();
		}
	}

//	修改导航条主菜单（不修改装饰图片）
	public int upmenu(int id,String menuname,String linkurl,String wordcolor,String targettype,String hide,String ordernum){
		String sql="select * from fz_menu where menuname='"+menuname+"'and id!='"+id+"'";
		String sql2="update fz_menu set menuname='"+menuname+"',linkurl='"+linkurl+"',wordcolor='"+wordcolor+"'," +
				"targettype='"+targettype+"',hide='"+hide+"',ordernum='"+ordernum+"' where id='"+id+"'";
		DBO dbo=new DBO();
		dbo.open();
		try{
			rs=dbo.executeQuery(sql);
			if(rs.next()){
				return Constant.SAME_NAME;
			}
			else{
				int i=dbo.executeUpdate(sql2);
				if(i==1){
					return Constant.SUCCESS;
				}
				else{
					return Constant.SUCCESS;
				}
			}
		}catch(Exception e){
			e.printStackTrace();
			return Constant.SYSTEM_ERROR;
		}finally{
			dbo.close();
		}
	}
	
	//get all menu 
	public List getAllmenu(){
		String sql = "select * from fz_menu order by ordernum desc";
		DBO dbo = new DBO();
		list = new ArrayList();
		dbo.open();
		try{
			rs = dbo.executeQuery(sql);
			while(rs.next()){
				List list2 = new ArrayList();
				list2.add(rs.getString(1));
				list2.add(rs.getString(2));
				list2.add(rs.getString(3));
				list2.add(rs.getString(4));
				list2.add(rs.getString(5));
				list2.add(rs.getString(6));
				list2.add(rs.getString(7));
				list2.add(rs.getString(8));
				list.add(list2);
			}
			return list;
		}catch(Exception e){
			e.printStackTrace();
			return list;
		}finally{
			dbo.close();
		}
	}
	
//	get all menu hide is 1
	public List getAllmenuIsUse(){
		String sql = "select menuname,linkurl from fz_menu order by ordernum desc";
		DBO dbo = new DBO();
		list = new ArrayList();
		dbo.open();
		try{
			rs = dbo.executeQuery(sql);
			while(rs.next()){
				List list2 = new ArrayList();
				list2.add(rs.getString(1));
				list2.add(rs.getString(2));
				
				list.add(list2);
			}
			return list;
		}catch(Exception e){
			e.printStackTrace();
			return list;
		}finally{
			dbo.close();
		}
	}
//	get a menu with id to update
	public List get1menu(int id){
		String sql = "select * from fz_menu where id='"+id+"'  ";
		DBO dbo = new DBO();
		list = new ArrayList();
		dbo.open();
		try{
			rs = dbo.executeQuery(sql);
			while(rs.next()){
				list.add(rs.getString(1));
				list.add(rs.getString(2));
				list.add(rs.getString(3));
				list.add(rs.getString(4));
				list.add(rs.getString(5));
				list.add(rs.getString(6));
				list.add(rs.getString(7));
				list.add(rs.getString(8));
			}
			return list;
		}catch(Exception e){
			e.printStackTrace();
			return list;
		}finally{
			dbo.close();
		}
	}
	//删除导航菜单
	public int delMenu(int id){
		String sql = "delete from fz_menu where id='"+id+"'";
		DBO dbo = new DBO();
		dbo.open();
		try{
			int i = dbo.executeUpdate(sql);
			if(i == 1)
				return Constant.SUCCESS;
			else
				return Constant.SYSTEM_ERROR;
		}catch(Exception e){
			e.printStackTrace();
			return Constant.SYSTEM_ERROR;
		}finally{
			dbo.close();
		}
	}
	//查看导航菜单装饰图片是否启用
	public String getMenuPicOff(){
		String sql = "select isoff from fz_menupic ";
		DBO dbo = new DBO();
		dbo.open();
		try{
			rs = dbo.executeQuery(sql);
			rs.next();
			if(rs.getInt(1) == 1)
				return "open";
			else
				return "close";
		}catch(Exception e){
			e.printStackTrace();
			return null;
		}finally{
			dbo.close();
		}
	}
	//关闭 开启菜单图片
	public int upDownMenuPower(int isoff){
		String sql = "update fz_menupic  set isoff='"+isoff+"' ";
		DBO dbo = new DBO();
		dbo.open();
		try{
			int i = dbo.executeUpdate(sql);
			if(i == 1){
				return Constant.SUCCESS;
			}
			else{
				return Constant.SYSTEM_ERROR;
			}
		}catch(Exception e){
			e.printStackTrace();
			return Constant.SYSTEM_ERROR;
		}finally{
			dbo.close();
		}
	}
	public int getMenu1Count(){//查询菜单总数，用循环更改排序
		String sql = "select count(*) from fz_menu";
		DBO dbo = new DBO();
		dbo.open();
		try{
			rs = dbo.executeQuery(sql);
			if(rs.next()){
				return rs.getInt(1);
			}
			else{
				return 0;
			}
		}catch(Exception e){
			e.printStackTrace();
			return 0;
		}finally{
			dbo.close();
		}
	}
//	更新导航菜单排列顺序
	public int updateMenuOrder(int id,int ordernum){
		String sql = "update fz_menu set ordernum = '"+ordernum+"' where id = '"+id+"'";
		DBO dbo = new DBO();
		dbo.open();
		try{
			int i = dbo.executeUpdate(sql);
			return i;
		}catch(Exception e){
			e.printStackTrace();
			return Constant.DEFAULT_ERROR;
		}finally{
			dbo.close();
		}
	}
	/**************************************************************
	 * 单独页面设置 alone.jsp
	 * 关于我们│ 站点导航│ 服务项目│ 招募英才│ 联系我们| 网站帮助
	 **************************************************************/
	public int upDateAlone(String type,String title,String content){//更改
		String sql = "update fz_alone set title='"+title+"',content='"+content+"' where type='"+type+"'";
		DBO dbo = new DBO();
		dbo.open();
		try{
			int i = dbo.executeUpdate(sql);
			if(i == 1)
				return Constant.SUCCESS;
			else 
				return Constant.DEFAULT_ERROR;
		}catch(Exception e){
			e.printStackTrace();