?? articlebean.java
字號(hào):
goodqx2 = goodqx2 + str2;
}
if(cz.equals("2"))//審首頁(yè)
{
if(!headqx2.equals(""))
{
headqx2 = headqx2 + ",";
}
headqx2 = headqx2 + str2;
}
if(cz.equals("3"))//審圖片
{
if(!imgqx2.equals(""))
{
imgqx2 = imgqx2 + ",";
}
imgqx2 = imgqx2 + str2;
}
}
}
ht.put("SHOW1",ds.strDistinct(showqx1));
ht.put("SHOW2",ds.strDistinct(showqx2));
ht.put("IMG1",ds.strDistinct(imgqx1));
ht.put("IMG2",ds.strDistinct(imgqx2));
ht.put("HEAD1",ds.strDistinct(headqx1));
ht.put("HEAD2",ds.strDistinct(headqx2));
ht.put("GOOD1",ds.strDistinct(goodqx1));
ht.put("GOOD2",ds.strDistinct(goodqx2));
}catch(Exception e){System.out.println("ArticleBean.getbmqx(String)運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(mb != null) mb.closeConn();
if(rs != null) try{stmt = rs.getStatement();rs.close();}catch(Exception e){System.out.println("ArticleBean.getbmqx(String)試圖釋放記錄集rs時(shí)出錯(cuò)："+e);}
if(stmt != null)try{stmt.close();}catch(Exception e){System.out.println("ArticleBean.getbmqx(String)試圖釋放聲明Statement時(shí)出錯(cuò)："+e);}
}
return ht;
}
public Vector getkybm(String uid)//獲得個(gè)人能發(fā)表文章的可用版面
{
Vector vt = new Vector();
String sql = "select WZQX from news.zz_zgzwb where zgbh='"+uid+"'";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
//取得列數(shù)和列名
ResultSetMetaData rsmd = rs.getMetaData();
int num = 0;
String[] str = new String[100];
while(rs.next())
{
String kybm = ds.toString(rs.getString(1));
StringTokenizer st = new StringTokenizer(kybm,";");
while(st.hasMoreElements())
{
String st1 = (String)st.nextElement();
String cz = st1.substring(0,1);
String wt = st1.substring(2,3);
String no = st1.substring(st1.lastIndexOf(",")+1,st1.length());
if(num == 0)
{
Hashtable ht = new Hashtable();
ht.put("CZ",cz);
ht.put("WT",wt);
ht.put("NO",no);
vt.add(ht);
str[num]="0"+wt+no;
num++;
}
else
{
boolean bl = false;
for(int t=0;t<num;t++)
{
String str11 = "0"+wt+no;
if(str11.equals(str[t]))
{
bl=true;
break;
}
}
if(!bl)
{
Hashtable ht = new Hashtable();
ht.put("CZ",cz);
ht.put("WT",wt);
ht.put("NO",no);
vt.add(ht);
str[num]="0"+wt+no;
num++;
}
}
}
}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("ArticleBean.getkybm(String)關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("ArticleBean.getkybm(String)關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
return vt;
}
public Vector getWzlx(String orgid)//獲得個(gè)人能發(fā)表文章的可選類型
{
Vector vect = new Vector();
String sql = "";
sql = "select ID,NAME from news.wzlxb where ORGID='"+orgid+"' order by ID";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
//取得列數(shù)和列名
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("ArticleBean.getWzlx(String)運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("ArticleBean.getWzlx(String)關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("ArticleBean.getWzlx(String)關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
return vect;
}
public Vector getOrg(String uid)//獲得個(gè)人能發(fā)表文章的部門
{
Vector vt = new Vector();
String sql = "select BMBH,CZQX from news.zz_zgzwb where zgbh='"+uid+"'";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
stmt = rs.getStatement();
//取得列數(shù)和列名
ResultSetMetaData rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
int num = 0;
String[] str = new String[20];
RightBean rb =null;
try{
rb= new RightBean();
rb.setUID(uid);
Vector vtor = (Vector)rb.getRightMode();
boolean bb = false;
for(int x=0;x<vtor.size();x++)
{
if(((String)vtor.get(x)).equals("6"))
{
if(!bb)
{
Hashtable hasht = new Hashtable();
hasht.put("BMBH","00000000000000000000");
hasht.put("BMMC","公司");
vt.add(hasht);
bb = true;
}
}
}
}catch(Exception e){System.out.println("ArticleBean.getOrg(String)運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rb!=null)
rb.closeConn();
}
while(rs.next())
{
Hashtable hash = new Hashtable();
String orgid = ds.toString(rs.getString(1));
//取得二級(jí)部門
String orgid2 = "";
orgid2 = orgid.substring(0,4)+"0000000000000000";
if(!orgid2.equals("00000000000000000000"))
{
String czqx = ds.toString(rs.getString(2));
czqx = ","+czqx+",";
if(czqx.indexOf(",22,")!=-1)
{
if(num==0)
{
str[num] = orgid2;
num++;
hash.put("BMBH",orgid2);
orgid2 = toName("ZZ_BMB","BMBH","BMMC",orgid2);
hash.put("BMMC",orgid2);
vt.add(hash);
}
else
{
boolean bl = false;
for(int z=0;z<num;z++)
{
if(orgid2.equals(str[z]))
{
bl = true;
break;
}
}
if(!bl)
{
str[num] = orgid2;
num++;
hash.put("BMBH",orgid2);
orgid2 = toName("ZZ_BMB","BMBH","BMMC",orgid2);
hash.put("BMMC",orgid2);
vt.add(hash);
}
}
}
}
}
}catch(Exception e){System.out.println("ArticleBean.getOrg(String)運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs!=null)try{ rs.close();}catch(Exception e){System.out.println("ArticleBean.getOrg(String)關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("ArticleBean.getOrg(String)關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
return vt;
}
public Vector getOnePage(String flag,int page,int records)//
{
String sql = "select distinct news.article.ID,news.article.MENUID,news.article.TITLE,news.article.ORGANID,news.article.TOPICID,news.article.FROMSITE,news.article.WRITER,news.article.ADDTIME,news.article.KEYWORD,news.article.IFHEAD,news.article.IFGOOD,news.article.IFSHOW,news.article.IMG,news.article.IFIMG,news.article.HITS,news.article.ORGID,news.article.EDITER,news.article.EDITTIME,news.article.EDITIP,news.article.WZLX,news.article.FTPFILE,news.article.WHICHTABLE,news.article.AUTHOR from news.article,news.ZZ_ZGB "+flag;
return db.getOnePage(sql,page,records);
}
public Vector getOrgNews(String flag,String srchObject,String title_kw,String time,int page,int records)
{
//System.out.println("\n\rflag="+flag+"srchObject="+srchObject+"title_kw="+title_kw+"time="+time+"page="+page+"records="+records+"\n");
String sql = "select distinct news.article.ID,news.article.MENUID,news.article.TITLE,news.article.ORGANID,news.article.TOPICID,news.article.FROMSITE,news.article.WRITER,news.article.ADDTIME,news.article.KEYWORD,news.article.IFHEAD,news.article.IFGOOD,news.article.IFSHOW,news.article.IMG,news.article.IFIMG,news.article.HITS,news.article.ORGID,news.article.EDITER,news.article.EDITTIME,news.article.EDITIP,news.article.WZLX,news.article.FTPFILE,news.article.WHICHTABLE,news.article.AUTHOR,orgmenu.MC from news.article,news.orgmenu where news.article.wzlx=orgmenu.bh and news.article.MENUID is null ";
if(!srchObject.equals(""))
{
String field = "news.article.TITLE";
if(title_kw.equals("1")||title_kw.equals(""))//標(biāo)題
{
field = "news.article.TITLE";
}
if(title_kw.equals("2"))//關(guān)鍵字
{
field = "news.article.KEYWORD";
}
//多個(gè)關(guān)鍵字檢索
srchObject = ds.toString(srchObject);
String str[] = ds.splitStr(ds.toString(srchObject),' ');
String sql1 = "";
for(int i=0;i<str.length;i++)
{
if(str[i].length()==0)continue;
if(!sql1.equals(""))sql1 += " or ";
sql1 = sql1 + "lower(" + field + ") like '%"+str[i].toLowerCase()+"%' ";
}
sql += " and ( " + sql1 + " ) ";
}
sql += flag ;
if(time.equals("all")||time.equals(""))
sql = sql + " order by addtime desc ";
else
{
long i = Long.parseLong(time)*86400000;
Date now = new Date();
Date from = new Date(now.getTime()-i);
java.text.SimpleDateFormat f = new java.text.SimpleDateFormat("yyyy-MM-dd");
String fromday = f.format(from);
sql = sql + " and addtime>='"+fromday+"' order by addtime desc ";
}
return db.getOnePage(sql,page,records);
}
public Vector getData()//取得文章的信息
{
Vector vet = new Vector();
String sql = "";
sql = " select ID,TITLE,WRITER,ADDTIME,ORGANID,EDITER,EDITTIME,EDITIP,WZLX,IFHEAD,IFGOOD,IFSHOW,IMG,AUTHOR from news.ARTICLE order by addtime desc";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
//取得列數(shù)和列名
ResultSetMetaData rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
String menuid = "";
String wtable = "";
while(rs.next())
{
Hashtable ht = new Hashtable();
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);
}
vet.add(ht);
}
}catch(Exception e){System.out.println("ArticleBean.getData()運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs!=null)try{stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("ArticleBean.getData()關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("ArticleBean.getData()關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
return vet;
}
public Hashtable getOneData()//取得一篇文章的信息
{
Hashtable ht = new Hashtable();
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -