📄 menubean.java
字号:
hash_t.put("CZ","3");
hash_t.put("WHICHTALBE","1");
hash_t.put("BMBH","");
hash_t.put("SFGL","");
ii = mnbean.addNews(hash_t);
}finally{
if(mnbean!=null)mnbean.closeConn();
}
}
}
if(strAct.equals("2"))
{
if(strID2.equals("")||Integer.parseInt(strID2)<1)
strID2="999";
if(getOneData(strID1,strID2,"0")){
sql = "update menu set id2=id2+1 where id1="+Integer.parseInt(strID1)+" and id2>="+Integer.parseInt(strID2);
db.ExecuteSQL(sql);
}
else
strID2 = ""+makeID("MENU","ID1","ID2",strID1,true);
vect.add(addVector("ID1",strID1,"NUM"));
vect.add(addVector("ID2",strID2,"NUM"));
vect.add(addVector("MENU1",strMenu1,"CHAR"));
vect.add(addVector("MENU2",strMenu2,"CHAR"));
vect.add(addVector("ADMIN",strAdmin,"CHAR"));
vect.add(addVector("ZT",strzt,"CHAR"));
vect.add(addVector("INTRODUCE",strIntro,"CHAR"));
}
if(strAct.equals("3"))
{
if(strID3.equals("")||Integer.parseInt(strID3)<1)
strID3="999";
if(getOneData(strID1,strID2,strID3)) {
sql = "update menu set id3=id3+1 where id1="+Integer.parseInt(strID1)+" and id2="+Integer.parseInt(strID2)+" and id3>="+Integer.parseInt(strID3);
db.ExecuteSQL(sql);
}
else
strID3 = ""+makeID("MENU","ID1","ID2","ID3",strID1,strID2,true,true);
vect.add(addVector("ID1",strID1,"NUM"));
vect.add(addVector("ID2",strID2,"NUM"));
vect.add(addVector("ID3",strID3,"NUM"));
vect.add(addVector("MENU1",strMenu1,"CHAR"));
vect.add(addVector("MENU2",strMenu2,"CHAR"));
vect.add(addVector("MENU3",strMenu3,"CHAR"));
vect.add(addVector("ADMIN",strAdmin,"CHAR"));
vect.add(addVector("ZT",strzt,"CHAR"));
vect.add(addVector("INTRODUCE",strIntro,"CHAR"));
}
System.out.println(vect);
return insertRecord(vect);
}
public void changeMenu1(String ID1,String ID11,String Menu1)//ID1：新编号ID11：旧编号menu1:新名称
{
String sql = "";
//修改他的子菜单
sql = "update menu set id1=10141 where id2 is not null and id1="+Integer.parseInt(ID11);
db.ExecuteSQL(sql);
//当新编号不等于旧编号
if(!ID1.equals(ID11))
{
if(Integer.parseInt(ID1)>Integer.parseInt(ID11))
{
sql = "update menu set id1=id1-1 where id1>"+Integer.parseInt(ID11)+" and id1<="+Integer.parseInt(ID1);
db.ExecuteSQL(sql);
}
if(Integer.parseInt(ID1)<Integer.parseInt(ID11))
{
sql = "update menu set id1=id1+1 where id1<"+Integer.parseInt(ID11)+" and id1>="+Integer.parseInt(ID1);
db.ExecuteSQL(sql);
}
}
//修改他的子菜单
sql = "update menu set id1="+Integer.parseInt(ID1)+",menu1='"+Menu1+"' where id2 is not null and id1=10141";
db.ExecuteSQL(sql);
//修改专题列表
sql = "update NB_TOPIC set menuid1=10141 where menuid1="+ID11;
db.ExecuteSQL(sql);
if(!ID1.equals(ID11))
{
if(Integer.parseInt(ID1)>Integer.parseInt(ID11))
{
sql = "update NB_TOPIC set menuid1=menuid1-1 where menuid1>"+Integer.parseInt(ID11)+" and menuid1<="+Integer.parseInt(ID1);
db.ExecuteSQL(sql);
}
if(Integer.parseInt(ID1)<Integer.parseInt(ID11))
{
sql = "update NB_TOPIC set menuid1=menuid1+1 where menuid1<"+Integer.parseInt(ID11)+" and menuid1>="+Integer.parseInt(ID1);
db.ExecuteSQL(sql);
}
}
}
public void changeMenu2(String ID1,String ID2,String ID11,String ID22,String Menu1,String Menu2)//ID1 ID2：新编号ID11 ID22：旧编号Menu1 menu2:新名称
{
String sql = "";
//修改他的子菜单
sql = "update menu set id1=10141 where id3 is not null and id1="+Integer.parseInt(ID11)+" and id2="+Integer.parseInt(ID22);
db.ExecuteSQL(sql);
//当新一级编号等于旧编号
if(ID1.equals(ID11))
{
if(Integer.parseInt(ID2)>Integer.parseInt(ID22))
{
sql = "update menu set id2=id2-1 where id1="+Integer.parseInt(ID11)+" and id2>"+Integer.parseInt(ID22)+" and id2<="+Integer.parseInt(ID2);
db.ExecuteSQL(sql);
}
if(Integer.parseInt(ID2)<Integer.parseInt(ID22))
{
sql = "update menu set id2=id2+1 where id1="+Integer.parseInt(ID11)+" and id2<"+Integer.parseInt(ID22)+" and id2>="+Integer.parseInt(ID2);
db.ExecuteSQL(sql);
}
}
//当新一级编号不等于旧编号
if(!ID1.equals(ID11))
{
if(Integer.parseInt(ID2)>Integer.parseInt(ID22))
{
sql = "update menu set id2=id2-1 where id1="+Integer.parseInt(ID1)+" and id2>"+Integer.parseInt(ID22)+" and id2<="+Integer.parseInt(ID2);
db.ExecuteSQL(sql);
}
if(Integer.parseInt(ID2)<Integer.parseInt(ID22))
{
sql = "update menu set id2=id2+1 where id1="+Integer.parseInt(ID1)+" and id2<"+Integer.parseInt(ID22)+" and id2>="+Integer.parseInt(ID2);
db.ExecuteSQL(sql);
}
}
//修改他的子菜单
sql = "update menu set id1="+Integer.parseInt(ID1)+",menu1='"+Menu1+"',id2="+Integer.parseInt(ID2)+",menu2='"+Menu2+"' where id3 is not null and id1=10141";
db.ExecuteSQL(sql);
}
public void changeMenu3(String ID1,String ID2,String ID3,String ID11,String ID22,String ID33)//ID1 ID2：新编号ID11 ID22：旧编号Menu1 menu2:新名称
{
String sql = "";
if(ID1.equals(ID11)) //当新一级编号等于旧编号
{
if(ID2.equals(ID22))//当新二级编号等于旧编号
{
if(Integer.parseInt(ID3)>Integer.parseInt(ID33))
{
sql = "update menu set id3=id3-1 where id1="+Integer.parseInt(ID11)+" and id2="+Integer.parseInt(ID22)+" and id3>"+Integer.parseInt(ID33)+" and id3<="+Integer.parseInt(ID3);
db.ExecuteSQL(sql);
}
if(Integer.parseInt(ID3)<Integer.parseInt(ID33))
{
sql = "update menu set id3=id3+1 where id1="+Integer.parseInt(ID11)+" and id2="+Integer.parseInt(ID22)+" and id3<"+Integer.parseInt(ID33)+" and id3>="+Integer.parseInt(ID3);
db.ExecuteSQL(sql);
}
}
else
{
sql = "update menu set id3=id3+1 where id1="+Integer.parseInt(ID11)+" and id2="+Integer.parseInt(ID2)+" and id3>="+Integer.parseInt(ID3);
db.ExecuteSQL(sql);
}
}
else
{
sql = "update menu set id3=id3+1 where id1="+Integer.parseInt(ID1)+" and id2="+Integer.parseInt(ID2)+" and id3>="+Integer.parseInt(ID3);
db.ExecuteSQL(sql);
}
}
public int modMenu(Hashtable hash)//修改菜单维护表数据记录
{
int ret=0;
String strID1 = ds.toString((String)hash.get("ID1"));
String strID2 = ds.toString((String)hash.get("ID2"));
String strID3 = ds.toString((String)hash.get("ID3"));
String strMenu1 = ds.toString((String)hash.get("MENU1"));
String strMenu2 = ds.toString((String)hash.get("MENU2"));
String strMenu3 = ds.toString((String)hash.get("MENU3"));
String strAdmin = ds.toString((String)hash.get("ADMIN"));
String strIntro = ds.toString((String)hash.get("INTRODUCE"));
String strAct = ds.toString((String)hash.get("ACT"));
String strID11 = ds.toString((String)hash.get("ID11"));
String strID22 = ds.toString((String)hash.get("ID22"));
String strID33 = ds.toString((String)hash.get("ID33"));
String strzt = ds.toString((String)hash.get("ZT"));
String stroldzt = ds.toString((String)hash.get("OLDZT"));
String strstyle = ds.toString((String)hash.get("STYLE"));
Vector vect = new Vector();
vect.add("MENU");
if(strID2.equals("")&&strID3.equals(""))//修改一级菜单
{
//给管理员分配以及版面权限
if(stroldzt.equals("1") && strzt.equals("0"))//将挂起改为正常:新增权限
{
MakeNews mnbean = null;
try{
mnbean=new MakeNews();
Hashtable hash_t = new Hashtable();
//新增版面权限
hash_t.put("ZGBH","1");
hash_t.put("LB","1");
hash_t.put("DXBH",String.valueOf(strID));
hash_t.put("SF","2");
hash_t.put("CZ","0");
hash_t.put("WHICHTALBE","1");
hash_t.put("BMBH","");
hash_t.put("SFGL","");
int ii = mnbean.addNews(hash_t);
hash_t.clear();
hash_t.put("ZGBH","1");
hash_t.put("LB","1");
hash_t.put("DXBH",String.valueOf(strID));
hash_t.put("SF","2");
hash_t.put("CZ","1");
hash_t.put("WHICHTALBE","1");
hash_t.put("BMBH","");
hash_t.put("SFGL","");
ii = mnbean.addNews(hash_t);
hash_t.clear();
hash_t.put("ZGBH","1");
hash_t.put("LB","1");
hash_t.put("DXBH",String.valueOf(strID));
hash_t.put("SF","2");
hash_t.put("CZ","2");
hash_t.put("WHICHTALBE","1");
hash_t.put("BMBH","");
hash_t.put("SFGL","");
ii = mnbean.addNews(hash_t);
hash_t.clear();
hash_t.put("ZGBH","1");
hash_t.put("LB","1");
hash_t.put("DXBH",String.valueOf(strID));
hash_t.put("SF","2");
hash_t.put("CZ","3");
hash_t.put("WHICHTALBE","1");
hash_t.put("BMBH","");
hash_t.put("SFGL","");
ii = mnbean.addNews(hash_t);
}catch(Exception e){System.out.println("运行时出错："+e);}
finally{
if(mnbean!=null)
mnbean.closeConn();
}
deleteRecord("update MENU set ZT='0' where ZT='1' and ID1="+strID11);
}
if(stroldzt.equals("0") && strzt.equals("1"))//将正常改为挂起:删除权限
{
String delsql = "delete from ZZ_FBXWB where DXBH=" + String.valueOf(strID) + " and ZGBH='1'";
int ii = deleteRecord(delsql);
deleteRecord("update MENU set ZT='1' where ZT='0' and ID1="+strID11);
}
vect.add(addVector("ID1",strID1,"NUM"));
vect.add(addVector("MENU1",strMenu1,"CHAR"));
vect.add(addVector("ADMIN",strAdmin,"CHAR"));
vect.add(addVector("INTRODUCE",strIntro,"CHAR"));
vect.add(addVector("ZT",strzt,"CHAR"));
vect.add(addVector("STYLE",strstyle,"NUM"));
vect.add("ID="+strID+"");
changeMenu1(strID1,strID11,strMenu1);
return updateRecord(vect);
}
if(!strID2.equals("")&&strID3.equals(""))//修改二级菜单
{
vect.add(addVector("ID1",strID1,"NUM"));
vect.add(addVector("ID2",strID2,"NUM"));
vect.add(addVector("MENU1",strMenu1,"CHAR"));
vect.add(addVector("MENU2",strMenu2,"CHAR"));
vect.add(addVector("ADMIN",strAdmin,"CHAR"));
vect.add(addVector("INTRODUCE",strIntro,"CHAR"));
vect.add("ID="+strID+"");
changeMenu2(strID1,strID2,strID11,strID22,strMenu1,strMenu2);
return updateRecord(vect);
}
if(!strID2.equals("")&&!strID3.equals(""))//修改三级菜单
{
vect.add(addVector("ID1",strID1,"NUM"));
vect.add(addVector("ID2",strID2,"NUM"));
vect.add(addVector("ID3",strID3,"NUM"));
vect.add(addVector("MENU1",strMenu1,"CHAR"));
vect.add(addVector("MENU2",strMenu2,"CHAR"));
vect.add(addVector("MENU3",strMenu3,"CHAR"));
vect.add(addVector("ADMIN",strAdmin,"CHAR"));
vect.add(addVector("INTRODUCE",strIntro,"CHAR"));
vect.add("ID="+strID+"");
changeMenu3(strID1,strID2,strID3,strID11,strID22,strID33);
return updateRecord(vect);
}
return 0;
//return updateRecord(vect);
}
public int delMenu() //删除菜单维护表数据记录
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -