📄 menubean.java
字号:
+ "' 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 news.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 news.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 news.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 news.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 news.MENU set ZT='0' where ZT='1' and ID1="
+ strID11);
}
if (stroldzt.equals("0") && strzt.equals("1"))//将正常改为挂起:删除权限
{
String delsql = "delete from news.ZZ_FBXWB where DXBH="
+ String.valueOf(strID) + " and ZGBH='1'";
int ii = deleteRecord(delsql);
deleteRecord("update news.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() //删除菜单维护表数据记录
{
String sql = "";
sql="delete from news.article where MENUID="+strID+"";
int jj = deleteRecord(sql);
sql = "delete from news.menu where id = " + strID + "";
jj = deleteRecord(sql);
return jj;
}
public Vector delMenu(String strID) //删除多条菜单数据记录
{
Vector vect = new Vector();
Vector vect1 = new Vector();
Vector vect2 = new Vector();
String sql = "";
if (strID.equals(""))
return vect;
sql = "select count(id),menuid from news.article where menuid in("
+ strID + ") group by menuid order by menuid";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try {
while (rs.next()) {
Hashtable hash = new Hashtable();
hash.put("COUNT", (String) rs.getString(1));
hash.put("MENUID", (String) rs.getString(2));
vect1.add(hash);
}
vect.add(vect1);
sql = "select * from news.menu where id in(select distinct menuid from news.article where menuid in ("
+ strID + ")) order by id";
stmt = rs.getStatement();
rs.close();
stmt.close();
rs = selectRecord(sql);
ResultSetMetaData rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
while (rs.next()) {
Hashtable hash = new Hashtable();
for (int i = 1; i <= cols; i++) {
String field = ds.toString(rsmd.getColumnName(i));
String value = ds.toString(rs.getString(i));
hash.put(field, value);
}
vect2.add(hash);
}
} catch (Exception e) {
System.out.println("运行时出错：" + e);
} finally {
if (rs != null)
try {
stmt = rs.getStatement();
rs.close();
} catch (Exception e) {
System.out.println("关闭记录集rs时出错" + e);
}
if (stmt != null)
try {
stmt.close();
} catch (Exception e) {
System.out.println("关闭声明时statement出错" + e);
}
}
vect.add(vect2);
// sql="select news.menu.id from news.menu,news.article where not
// exists(select article.id from article where
// article.menuid=news.menu.id) and news.menu.id in("+strID+") group by
// news.menu.id";////////////修改未完成
sql = "delete from news.menu where not exists(select news.article.id from news.article where news.article.menuid=news.menu.id) and news.menu.id in("
+ strID + ")";
deleteRecord(sql);
sql = "delete from news.zz_fbxwb where not exists(select news.article.id from news.article where news.article.menuid=dxbh) and dxbh in("
+ strID + ")";
deleteRecord(sql);
return vect;
}
//生成树并返回根节点
public Vector buildTree() {
Vector vt = new Vector();
MenuChildBean mcb = null;
String sql = " Select * from news.MENU Where ID2=0 and ID3=0 order by ID1 ";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try {
mcb = new MenuChildBean();
ResultSetMetaData rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
while (rs.next()) {
Hashtable hash = new Hashtable();
hash.clear();
for (int i = 1; i <= cols; i++) {
String field = ds.toString(rsmd.getColumnName(i));
String value = ds.toString(rs.getString(i));
hash.put(field, value);
}
DefaultMutableTreeNode root = new DefaultMutableTreeNode(hash);//生成根节点，一级版面
String ParentId = (String) hash.get("ID1");
sql = "select * from news.menu where id1="
+ Integer.parseInt(ParentId)
+ " and id2!=0 and id3=0 order by id2";
ResultSet rs1 = selectRecord(sql);
try {
ResultSetMetaData rsmd1 = rs1.getMetaData();
int cols1 = rsmd1.getColumnCount();
while (rs1.next()) {
Hashtable hash1 = new Hashtable();
hash1.clear();
for (int i1 = 1; i1 <= cols1; i1++) {
String field1 = ds
.toString(rsmd1.getColumnName(i1));
String value1 = ds.toString(rs1.getString(i1));
hash1.put(field1, value1);
}
DefaultMutableTreeNode root1 = new DefaultMutableTreeNode(
hash1);//生成二级节点，二级版面
String ParentId1 = (String) hash1.get("ID2");
sql = "select * from news.menu where id1="
+ Integer.parseInt(ParentId) + " and id2="
+ Integer.parseInt(ParentId1)
+ " and id3!=0 order by id3";
ResultSet rs2 = selectRecord(sql);
try {
ResultSetMetaData rsmd2 = rs2.getMetaData();
int cols2 = rsmd2.getColumnCount();
while (rs2.next()) {
Hashtable hash2 = new Hashtable();
hash2.clear();
for (int i2 = 1; i2 <= cols2; i2++) {
String field2 = ds.toString(rsmd2
.getColumnName(i2));
String value2 = ds.toString(rs2
.getString(i2));
hash2.put(field2, value2);
}
DefaultMutableTreeNode root2 = new DefaultMutableTreeNode(
hash2);//生成三级节点，三级版面
String str = (String) hash2.get("ID");
mcb.setParentID(Integer.parseInt(str));
Vector child = mcb.buildTree();
if (child.size() != 0) {
for (int a = 0; a < child.size(); a++) {
DefaultMutableTreeNode root3 = (DefaultMutableTreeNode) child
.get(a);
root2.add(root3);
}
}
root1.add(root2);
}
} catch (Exception e) {
System.out.println("运行时出错：" + e);
} finally {
if (rs2 != null)
try {
stmt = rs2.getStatement();
rs2.close();
} catch (Exception e) {
System.out.println("关闭记录集rs时出错" + e);
}
if (stmt != null)
try {
stmt.close();
} catch (Exception e) {
System.out.println("关闭声明时statement出错" + e);
}
}
}
} catch (Exception e) {
System.out.println("运行时出错：" + e);
} finally {
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -