src/com/bean/SiteBean.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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 menu where menuname='"+menuname+"'";
		String sql2="insert into 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 menu where menuname='"+menuname+"'and id!='"+id+"'";
		String sql2="update 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);