📄 mainbean.java
字号:
String sql = "";
sql = "select * from 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 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 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 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 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;
}
//取得vet_maintable中的编号为id的NUM
public int getNUMfromMAINTABLE(String id)
{
int num=0;
for ( int i = 0; i < vet_maintable.size(); i++ )
{
Hashtable hash = (Hashtable)vet_maintable.get(i);
String intID = ds.toString((String)hash.get("ID"));
String strNUM = ds.toString((String)hash.get("NUM"));
if(intID.equals(id)&&!strNUM.equals(""))
{
num = Integer.parseInt(strNUM);
break;
}
}
return num;
}
//取得vet_menutable表中满足条件的ID(逗号分割)
public String getStrIDfromMENUTABLE(String id1,String id2)
{
String out = "" ;
for ( int i = 0; i < vet_menutable.size(); i++ )
{
Hashtable hash = (Hashtable)vet_menutable.get(i);
String intID1 = ds.toString((String)hash.get("ID1"));
String intID2 = ds.toString((String)hash.get("ID2"));
String intID3 = ds.toString((String)hash.get("ID3"));
String intID = ds.toString((String)hash.get("ID"));
if(id2.equals(""))
{
if( !intID3.equals("0") && intID1.equals(id1) )
{
if(!out.equals(""))out += ",";
out += intID;
}
}
else
{
if( !intID3.equals("0") && intID1.equals(id1) && intID2.equals(id2) )
{
if(!out.equals(""))out += ",";
out += intID;
}
}
}
return out;
}
//根据一级菜单下的取得文章------------------------------------------------------------------------
public Vector getArticle(String id)
{
Vector v_article = new Vector();
if(id.equals(""))return v_article;
//检索菜单表编号
int num = getNUMfromMAINTABLE( id );
String sql = "";
ResultSet rs = null;
Statement stmt = null;
sql = getStrIDfromMENUTABLE( id, "");
if(sql.equals("")) return v_article;
sql = "select id from article where whichtable='1' and ifshow='1' and ORGANID='00000000000000000000' and menuid in ("+sql+")";
sql = "select id,title,addtime,hits from article where id in ("+sql+") order by edittime desc";
rs = selectRecord(sql);
try{
int i = 0;
int count = 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);//把文章信息存入
count++;
if(count==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);}
}
return v_article;
}
//根据一级菜单下的取得文章------------------------------------------------------------------------
public Vector getArticle1(String id1,String id2)
{
Vector v_article = new Vector();
//取得显示数量
int num = getNUMfromMAINTABLE( "20" );
String sql = "";
ResultSet rs = null;
//检索菜单表编号
sql = getStrIDfromMENUTABLE( id1 , id2 );
if(sql.equals("")) return v_article;
sql = "select id from article where whichtable='1' and ifshow='1' and ORGANID='00000000000000000000' and menuid in ("+sql+")";
sql = "select id,title,addtime,hits from article where id in ("+sql+") order by edittime desc";
try
{
rs = selectRecord(sql);
int i = 0;
int count = 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);//把文章信息存入
count++;
if(count==num)break;
}
}catch(Exception e){System.out.println("MainBean.getArticle1(String id1,String menu2)运行时出错："+e);}
finally{
if(rs!=null)try{ rs.close();}catch(Exception e){System.out.println("MainBean.getArticle1(String id1,String menu2)关闭记录集rs时出错"+e);}
}
return v_article;
}
//根据一级菜单下的取得文章------------------------------------------------------------------------
public Vector getArticle(String id1,String menu2,int cur,int records)
{
Vector v_menu = new Vector();
Vector v_article = new Vector();
if(id1.equals(""))
return v_article;
//检索菜单表编号
String sql = "select num from nb_zyszb where id=20";
ResultSet rs = null;
Statement stmt = null;
try{
int num = records;
if(num==0)
{
rs = selectRecord(sql);
if(rs.next())
num = rs.getInt(1);
}
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id1,String menu2,int cur,int records)关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id1,String menu2,int cur,int records)关闭声明时statement出错"+e);}
sql = "select ID from Menu where Id3!=0 and Id1="+id1+" and MENU2='"+menu2+"'";
rs = selectRecord(sql);
while(rs.next())
{
v_menu.add(rs.getString("ID"));
}
if(v_menu.isEmpty()) return v_menu;
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id1,String menu2,int cur,int records)关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id1,String menu2,int cur,int records)关闭声明时statement出错"+e);}
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id1,String menu2,int cur,int records)关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id1,String menu2,int cur,int records)关闭声明时statement出错"+e);}
//检索文章编号
sql = "";
for(int i=0;i<v_menu.size();i++)
{
if(!sql.equals(""))sql += ",";
sql += (String)v_menu.get(i);
}
sql = "select id from article where whichtable='1' and ifshow='1' and ORGANID='00000000000000000000' and menuid in ("+sql+")";
//计算总页数
rs = selectRecord("select count(id) from article where id in ("+sql+") order by edittime desc");
rs.next();
int rows = rs.getInt(1);
int sum = rows/records;
if(rows%records!=0||rows==0)sum++;
v_article.add(""+sum);
v_article.add(""+rows);
int pos = (cur-1)*records+1;
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id1,String menu2,int cur,int records)关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id1,String menu2,int cur,int records)关闭声明时statement出错"+e);}
sql = "select id,title,addtime,hits from article where id in ("+sql+") order by edittime desc";
rs = selectRecord(sql);
int i = 0;
ResultSetMetaData rsmd = rs.getMetaData();
int cols = 0;
cols = rsmd.getColumnCount();
while(rs.next())
{
i++;
if(i<pos)continue;
Hashtable hash = new Hashtable();
for(int j=1;j<=cols;j++)
{
String field = ds.toString(rsmd.getColumnName(j));
String value = ds.toString(rs.getString(j));
hash.put(field,value);
}
v_article.add(hash);//把焦点文章信息存入
if((v_article.size()-2)==num)break;
if(i==rows)break;
}
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id1,String menu2,int cur,int records)关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id1,String menu2,int cur,int records)关闭声明时statement出错"+e);}
}catch(Exception e){System.out.println("MainBean.getArticle(String id1,String menu2,int cur,int records)运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id1,String menu2,int cur,int records)关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("MainBean.getArticle(String id1,String menu2,int cur,int records)关闭声明时statement出错"+e);}
}
return v_article;
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -