📄 menubean.java
字号:
lr += ","
+ (String) ((Hashtable) vlr.get(j))
.get("XM");
}
for (int j = 0; j < vshow.size(); j++) {
if (((Hashtable) vshow.get(j)).get("ID").equals(id))
if (show.equals(""))
show = (String) ((Hashtable) vshow.get(j))
.get("XM");
else
show += ","
+ (String) ((Hashtable) vshow
.get(j)).get("XM");
}
for (int j = 0; j < vgood.size(); j++) {
if (((Hashtable) vgood.get(j)).get("ID").equals(id))
if (good.equals(""))
good = (String) ((Hashtable) vgood.get(j))
.get("XM");
else
good += ","
+ (String) ((Hashtable) vgood
.get(j)).get("XM");
}
for (int j = 0; j < vhead.size(); j++) {
if (((Hashtable) vhead.get(j)).get("ID").equals(id))
if (head.equals(""))
head = (String) ((Hashtable) vhead.get(j))
.get("XM");
else
head += ","
+ (String) ((Hashtable) vhead
.get(j)).get("XM");
}
for (int j = 0; j < vimg.size(); j++) {
if (((Hashtable) vimg.get(j)).get("ID").equals(id))
if (img.equals(""))
img = (String) ((Hashtable) vimg.get(j))
.get("XM");
else
img += ","
+ (String) ((Hashtable) vimg.get(j))
.get("XM");
}
hash.put("LR", lr);
hash.put("IMG", img);
hash.put("GOOD", good);
hash.put("HEAD", head);
hash.put("SHOW", show);
} else
hash.put(field, value);
}
vect.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);
}
if (rslr != null)
try {
stmt = rslr.getStatement();
rslr.close();
} catch (Exception e) {
System.out.println("关闭记录集rs时出错" + e);
}
if (stmt != null)
try {
stmt.close();
} catch (Exception e) {
System.out.println("关闭声明时statement出错" + e);
}
if (rscz0 != null)
try {
stmt = rscz0.getStatement();
rscz0.close();
} catch (Exception e) {
System.out.println("关闭记录集rs时出错" + e);
}
if (stmt != null)
try {
stmt.close();
} catch (Exception e) {
System.out.println("关闭声明时statement出错" + e);
}
if (rscz1 != null)
try {
stmt = rscz1.getStatement();
rscz1.close();
} catch (Exception e) {
System.out.println("关闭记录集rs时出错" + e);
}
if (stmt != null)
try {
stmt.close();
} catch (Exception e) {
System.out.println("关闭声明时statement出错" + e);
}
if (rscz2 != null)
try {
stmt = rscz2.getStatement();
rscz2.close();
} catch (Exception e) {
System.out.println("关闭记录集rs时出错" + e);
}
if (stmt != null)
try {
stmt.close();
} catch (Exception e) {
System.out.println("关闭声明时statement出错" + e);
}
if (rscz3 != null)
try {
stmt = rscz3.getStatement();
rscz3.close();
} catch (Exception e) {
System.out.println("关闭记录集rs时出错" + e);
}
if (stmt != null)
try {
stmt.close();
} catch (Exception e) {
System.out.println("关闭声明时statement出错" + e);
}
}
return vect;
}
public Vector getAllMenu(String strmenuID1){
String sql="";
if (strmenuID1.equals("0"))sql="select ID,MENU3 ,ADMIN,INTRODUCE from news.menu where menu3!='NULL'";
else sql="select ID,MENU3 ,ADMIN,INTRODUCE from news.menu where menu3!='NULL' and ID1="+strmenuID1;
ResultSet rs=this.selectRecord(sql);
Vector r_ve=new Vector();//ID NUM MENU3 ADMIN INTRODUCE
try {
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);
if(i==1){
String sql1="select NUM=count(*) from news.article where menuid="+value;
ResultSet rss=this.selectRecord(sql1);
String va=String.valueOf(getIntByResultSet(rss,"NUM"));
hash.put("NUM",va);
}
}
r_ve.add(hash);
}
} catch (Exception e) {
System.out.println("运行时出错：" + e);
}
return r_ve;
}
public Hashtable getOneData()//取得一条记录的信息
{
Hashtable ht = new Hashtable();
String sql = "";
sql = "select * from news.menu where ID=" + strID + "";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try {
ResultSetMetaData rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
while (rs.next()) {
for (int i = 1; i <= cols; i++) {
String field = ds.toString(rsmd.getColumnName(i));
String value = ds.toString(rs.getString(i));
ht.put(field, value);
}
}
} 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);
}
}
return ht;
}
public boolean getOneData(String a, String b, String c) //判断是否有满足条件的记录
{
int intID1 = Integer.parseInt(a);
int intID2 = Integer.parseInt(b);
int intID3 = Integer.parseInt(c);
String sql = "select * from news.menu where id1=" + intID1
+ " and id2=" + intID2 + " and id3=" + intID3 + " and id!="
+ strID;
ResultSet rs = selectRecord(sql);
Statement stmt = null;
boolean bo = false;
try {
if (rs.next()) {
bo = true;
}
} 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);
}
}
return bo;
}
public int addMenu(Hashtable hash)//增加菜单维护表数据记录
{String sql = "";
try{
String strName =ds.toString((String) hash.get("NAME"));
String strMenu1 = ds.toString((String) hash.get("MEN1"));
String strMenu2 = ds.toString((String) hash.get("MEN2"));
String strIntro = ds.toString((String) hash.get("INTR"));
String strzt = ds.toString((String) hash.get("ZT"));
sql="insert into news.menu (id,id1,id2,id3,menu1,menu2,menu3,admin,introduce,zt) values(100,4,3,2,'网络服务','信息前沿','"+strName+"','wyy','"+strIntro+"',0)";
}catch(Exception e){e.printStackTrace();}
return executeUpdate(sql);
}
public void changeMenu1(String ID1, String ID11, String Menu1)//ID1：新编号ID11：旧编号menu1:新名称
{
String sql = "";
//修改他的子菜单
sql = "update news.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 news.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 news.menu set id1=id1+1 where id1<"
+ Integer.parseInt(ID11) + " and id1>="
+ Integer.parseInt(ID1);
db.ExecuteSQL(sql);
}
}
//修改他的子菜单
sql = "update news.menu set id1=" + Integer.parseInt(ID1) + ",menu1='"
+ Menu1 + "' where id2 is not null and id1=10141";
db.ExecuteSQL(sql);
//修改专题列表
sql = "update news.NB_TOPIC set menuid1=10141 where menuid1=" + ID11;
db.ExecuteSQL(sql);
if (!ID1.equals(ID11)) {
if (Integer.parseInt(ID1) > Integer.parseInt(ID11)) {
sql = "update news.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 news.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 news.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 news.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 news.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 news.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 news.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 news.menu set id1=" + Integer.parseInt(ID1) + ",menu1='"
+ Menu1 + "',id2=" + Integer.parseInt(ID2) + ",menu2='" + Menu2
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -