?? mainbean.java
字號:
Statement stmt = null;
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);
}
vect.add(hash);
}
}catch(Exception e){System.out.println("MainBean.getMenu()運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getMenu()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getMenu()關閉聲明時statement出錯"+e);}
}
return vect;
}
//根據一級菜單取得所有二級菜單------------------------------------------------------------------
public Vector getMenu2()
{
Vector vect = new Vector();
String sql = "";
sql = "select * from news.MENU where ID1 = "+id1+" and ID2!=0 and ID3=0 order by ID2";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
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);
}
vect.add(hash);
}
}catch(Exception e){System.out.println("MainBean.getMenu2()運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getMenu2()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getMenu2()關閉聲明時statement出錯"+e);}
}
return vect;
}
//根據一二級菜單取得所有三級菜單信息
public Vector getMenu3()
{
Vector vect = new Vector();
String sql = "";
sql = "select * from news.MENU where ID1 = "+id1+" and ID2 = "+id2+" and ID3!=0";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
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);
}
vect.add(hash);
}
}catch(Exception e){System.out.println("MainBean.getMenu3()運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getMenu3()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getMenu3()關閉聲明時statement出錯"+e);}
}
return vect;
}
//根據一級菜單名得到其編號-----------------------------------------------------------------------
public String toId1(String m1)
{
String id = "";
String sql = "";
sql = "select distinct ID1 from news.MENU where MENU1 = '"+m1+"'";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next())
{
id = ds.toString(rs.getString("ID1"));
}
}catch(Exception e){System.out.println("MainBean.toId1(String m1)運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.toId1(String m1)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.toId1(String m1)關閉聲明時statement出錯"+e);}
}
return id;
}
//根據一級菜單編號得到其名------------------------------------------------------------------------
public String toMenu1(String id1)
{
String menu = "";
String sql = "";
if (id1.equals(""))
{
return menu;
}
sql = "select distinct MENU1 from news.MENU where ID1 = "+id1+"";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next())
{
menu = ds.toString(rs.getString("MENU1"));
}
}catch(Exception e){System.out.println("MainBean.toMenu1(String id1)運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.toMenu1(String id1)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.toMenu1(String id1)關閉聲明時statement出錯"+e);}
}
return menu;
}
//根據一、二級菜單編號得到其名
public String toMenu2(String id1,String id2)
{
String menu = "";
String sql = "";
if(id1.equals("")||id2.equals(""))
{
return menu;
}
sql = "select distinct MENU2 from news.MENU where ID1 = "+id1+" and ID2 = "+id2+" and ID3= 0";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next())
{
menu = ds.toString(rs.getString("MENU2"));
}
}catch(Exception e){System.out.println("MainBean.toMenu2(String id1,String id2)運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.toMenu2(String id1,String id2)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.toMenu2(String id1,String id2)關閉聲明時statement出錯"+e);}
}
return menu;
}
//根據一級菜單下的取得文章------------------------------------------------------------------------
public Vector getArticle(String id)
{
Vector v_menu = new Vector();
Vector v_article = new Vector();
if(id.equals(""))
return v_article;
//檢索菜單表編號
int num=0;
String sql = "select num from news.nb_zyszb where id="+id;
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next()) num = rs.getInt(1);
}catch(Exception e){System.out.println("MainBean.getArticle(String id)運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)關閉聲明時statement出錯"+e);}
}
sql = "select ID from news.Menu where Id3!=0 and Id1="+id;
rs = selectRecord(sql);
Vector v_child = new Vector();
try{
while(rs.next())
{
v_menu.add(rs.getString("ID"));
}
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)關閉聲明時statement出錯"+e);}
if(v_menu.isEmpty()) return v_menu;
//檢索子菜單表編號
sql = "select ID from news.menuchild where isthis=0 and IDPARENT in (select ID from news.Menu where Id3!=0 and Id1="+id+")";
rs = selectRecord(sql);
while(rs.next())
{
String id4 = rs.getString("ID");
v_child.add(id4);
Stack s4 = new Stack();
s4.push(id4);
while(!s4.empty())//當有孩子節點時繼續搜索
{
id4 = (String)s4.pop();
sql = "select count(id) from news.menuchild where isthis=1 and IDPARENT="+id4;
ResultSet rs4 = selectRecord(sql);
int count =0;
try{
if(rs4.next())
count = rs4.getInt(1);
}catch(Exception e){System.out.println("MainBean.getArticle(String id)運行時出錯："+e);}
finally{
if(rs4!=null)try{ stmt = rs4.getStatement(); rs4.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)關閉聲明時statement出錯"+e);}
}
if(count>0)
{
sql = "select id from news.menuchild where isthis=1 and IDPARENT="+id4;
ResultSet rs_t = selectRecord(sql);
try{
while(rs_t.next())
{
String id_t = rs_t.getString("id");
s4.push(id_t);
v_child.add(id_t);
}
}catch(Exception e){System.out.println("MainBean.getArticle(String id)運行時出錯："+e);}
finally{
//if(rs_t!=null)try{ stmt = rs_t.getStatement(); rs_t.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)關閉記錄集rs時出錯"+e);}
//if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)關閉聲明時statement出錯"+e);}
}
}
}
}
}catch(Exception e){System.out.println("MainBean.getArticle(String id)運行時出錯："+e);}
finally{
//if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)關閉記錄集rs時出錯"+e);}
//if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)關閉聲明時statement出錯"+e);}
}
//檢索文章編號
sql = "";
for(int i=0;i<v_menu.size();i++)
{
if(!sql.equals(""))sql += " union ";
sql += "select id from news.article where whichtable='1' and ifshow='1' and ORGANID='00000000000000000000' and menuid="+(String)v_menu.get(i);
}
for(int i=0;i<v_child.size();i++)
{
if(!sql.equals(""))sql += " union ";
sql += "select id from news.article where whichtable='0' and ifshow='1' and ORGANID='00000000000000000000' and menuid="+(String)v_child.get(i);
}
sql = "select id,title,addtime,hits from news.article where id in ("+sql+") order by edittime desc";
rs = selectRecord(sql);
try{
int i = 0;
ResultSetMetaData rsmd = rs.getMetaData();
int cols = 0;
cols = rsmd.getColumnCount();
while(rs.next())
{
Hashtable hash = new Hashtable();
for(i=1;i<=cols;i++)
{
String field = ds.toString(rsmd.getColumnName(i));
String value = ds.toString(rs.getString(i));
hash.put(field,value);
}
v_article.add(hash);//把文章信息存入
i++;
if(i==num)break;
}
}catch(Exception e){System.out.println("MainBean.getArticle(String id)運行時出錯："+e);}
finally{
//if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)關閉記錄集rs時出錯"+e);}
//if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)關閉聲明時statement出錯"+e);}
}
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id)關閉聲明時statement出錯"+e);}
return v_article;
}
//根據一級菜單下的取得文章------------------------------------------------------------------------
public Vector getArticle1(String id1,String menu2)
{
Vector v_menu = new Vector();
Vector v_article = new Vector();
if(id1.equals(""))
return v_article;
//檢索菜單表編號
int num=0;
String sql = "select num from news.nb_zyszb where id=20";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next()) num = rs.getInt(1);
}catch(Exception e){System.out.println("MainBean.getArticle1(String id1,String menu2)運行時出錯："+e);}
finally{
//if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getArticle1(String id1,String menu2)關閉記錄集rs時出錯"+e);}
//if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle1(String id1,String menu2)關閉聲明時statement出錯"+e);}
}
sql = "select ID from news.Menu where Id3!=0 and Id1="+id1+" and MENU2='"+menu2+"'";
rs = selectRecord(sql);
Vector v_child = new Vector();
try{
while(rs.next())
{
v_menu.add(rs.getString("ID"));
}
//if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getArticle1(String id1,String menu2)關閉記錄集rs時出錯"+e);}
//if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle1(String id1,String menu2)關閉聲明時statement出錯"+e);}
if(v_menu.isEmpty()) return v_menu;
//檢索子菜單表編號
sql = "select ID from news.menuchild where isthis=0 and IDPARENT in (select ID from news.Menu where Id3!=0 and Id1="+id1+" and MENU2='"+menu2+"')";
rs = selectRecord(sql);
while(rs.next())
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -