📄 articlebean.java
字号:
String sql = "";
sql = " select ID,MENUID,TITLE,ORGANID,TOPICID,FROMSITE,WRITER,ADDTIME,KEYWORD,IFHEAD,IFGOOD,IFSHOW,IMG,IFIMG,HITS,ORGID,EDITER,EDITTIME,EDITIP,WZLX,FTPFILE,WHICHTABLE,AUTHOR,OLDORGID,STRSIZE,CURSIZE from ARTICLE where ID="+strID;
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
//取得列数和列名
ResultSetMetaData rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
String menuid = "";
String wtable = "";
while(rs.next())
{
for(int i=1;i<=cols;i++)
{
String field = ds.toString(rsmd.getColumnName(i));
String value = ds.toString(rs.getString(i));
if(field.equals("MENUID"))
menuid = value;
else if(field.equals("WHICHTABLE"))
wtable = value;
ht.put(field,value);
}
if(wtable.equals("1"))
{
menuid = toName("MENU","ID","MENU3",menuid);
ht.put("MENU",menuid);
}
if(wtable.equals("0"))
{
menuid = toName("MENUCHILD","ID","MENUCHILD",menuid);
ht.put("MENU",menuid);
}
}
}catch(Exception e){System.out.println("ArticleBean.getOneData()运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("ArticleBean.getOneData()关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("ArticleBean.getOneData()关闭声明时statement出错"+e);}
}
return ht;
}
public int addArticle(Hashtable hash)//增加文章表数据记录
{
int intMax = db.makeID_Add1("ARTICLE","ID","","",true);
String strTitle = ds.toString((String)hash.get("TITLE"));
String strbm = ds.toString((String)hash.get("BMBH"));
String strContent = ds.toString((String)hash.get("CONTENT"));
String strOrgId = ds.toString((String)hash.get("ORGID"));
String strFromSite = ds.toString((String)hash.get("FROMSITE"));
String strKeyword = ds.toString((String)hash.get("KEYWORD"));
String strFTPFile = ds.toString((String)hash.get("FTPFILE"));
String strIfhead = ds.toString((String)hash.get("IFHEAD"));
String strIfgood = ds.toString((String)hash.get("IFGOOD"));
String strIfimg = ds.toString((String)hash.get("IFIMG"));
String strIfshow = ds.toString((String)hash.get("IFSHOW"));
String strWriter = ds.toString((String)hash.get("WRITER"));
String strAuthor = ds.toString((String)hash.get("AUTHOR"));
String strOldOrgId=ds.toString((String)hash.get("OLDORGID"));
String strsize=ds.toString((String)hash.get("STRSIZE"));
String strcursize=ds.toString((String)hash.get("CURSIZE"));
String strAddTime = ds.getDateTime();
String strHits = strTitle +" 发表时间："+strAddTime;//ds.toString((String)hash.get("HITS"));
strHits = strHits.replaceAll(" "," ");
if(strAuthor.equals(""))
strAuthor = toName("ZZ_ZGB","ZGBH","XM",strWriter);
if(strFromSite.equals(""))
strFromSite = toName("ZZ_BMB","BMBH","BMMC",strbm);
Vector vect =new Vector();
vect.add("ARTICLE");
vect.add(addVector("ID",String.valueOf(intMax),"NUM"));
vect.add(addVector("TITLE",strTitle,"CHAR"));
vect.add(addVector("ORGANID",strbm,"CHAR"));
vect.add(addVector("ORGID",strOrgId,"CHAR"));
vect.add(addVector("FROMSITE",strFromSite,"CHAR"));
vect.add(addVector("KEYWORD",strKeyword,"CHAR"));
vect.add(addVector("HITS",strHits,"CHAR"));
vect.add(addVector("FTPFILE",strFTPFile,"CHAR"));
vect.add(addVector("IFHEAD",strIfhead,"CHAR"));
vect.add(addVector("IFGOOD",strIfgood,"CHAR"));
vect.add(addVector("IFSHOW",strIfshow,"CHAR"));
vect.add(addVector("IFIMG",strIfimg,"CHAR"));
vect.add(addVector("WRITER",strWriter,"CHAR"));
vect.add(addVector("ADDTIME",strAddTime,"CHAR"));
vect.add(addVector("AUTHOR",strAuthor,"CHAR"));
vect.add(addVector("OLDORGID",strOldOrgId,"CHAR"));
vect.add(addVector("STRSIZE",strsize,"CHAR"));
vect.add(addVector("CURSIZE",strcursize,"CHAR"));
if(strbm.equals("00000000000000000000"))//公司文章
{
String strImg = ds.toString((String)hash.get("IMG"));
String strTopicId = ds.toString((String)hash.get("TOPICID"));
String strMenuId = ds.toString((String)hash.get("MENUID"));
String strWhichTable = ds.toString((String)hash.get("WHICHTABLE"));
vect.add(addVector("IMG",strImg,"CHAR"));
vect.add(addVector("TOPICID",strTopicId,"NUM"));
vect.add(addVector("MENUID",strMenuId,"NUM"));
vect.add(addVector("WHICHTABLE",strWhichTable,"CHAR"));
}
else//部门文章
{
String strEditIP = ds.toString((String)hash.get("EDITIP"));
String strwzlx = ds.toString((String)hash.get("WZLX"));
vect.add(addVector("EDITER",strWriter,"CHAR"));
vect.add(addVector("EDITTIME",strAddTime,"CHAR"));
vect.add(addVector("WZLX",strwzlx,"CHAR"));
vect.add(addVector("EDITIP",strEditIP,"CHAR"));
}
int ret = insertRecord(vect);
if(ret!=0)
return ret;
else
{
ret = UpdateBLOB_JNDI("ARTICLE","ID="+intMax,"CONTENT",strContent);
return ret;
}
}
public int modArticle(Hashtable hash)//修改文章表数据记录
{
String strTitle = ds.toString((String)hash.get("TITLE"));
String strbm = ds.toString((String)hash.get("BMBH"));
String strContent = ds.toString((String)hash.get("CONTENT"));
String strOrgId = ds.toString((String)hash.get("ORGID"));
String strFromSite = ds.toString((String)hash.get("FROMSITE"));
String strKeyword = ds.toString((String)hash.get("KEYWORD"));
String strFTPFile = ds.toString((String)hash.get("FTPFILE"));
String strIfhead = ds.toString((String)hash.get("IFHEAD"));
String strIfgood = ds.toString((String)hash.get("IFGOOD"));
String strIfimg = ds.toString((String)hash.get("IFIMG"));
String strIfshow = ds.toString((String)hash.get("IFSHOW"));
String strImg = ds.toString((String)hash.get("IMG"));
String strTopicId = ds.toString((String)hash.get("TOPICID"));
String strMenuId = ds.toString((String)hash.get("MENUID"));
String strWhichTable = ds.toString((String)hash.get("WHICHTABLE"));
String strAuthor = ds.toString((String)hash.get("AUTHOR"));
String strOldOrgId=ds.toString((String)hash.get("OLDORGID"));
String strsize=ds.toString((String)hash.get("STRSIZE"));
String strcursize=ds.toString((String)hash.get("CURSIZE"));
String strHits = "";
String strAddTime = ds.getDateTime();
ResultSet rs = selectRecord("select ADDTIME from ARTICLE where ID=" + strID);
Statement stmt = null;
try{
if(rs.next())
strAddTime = rs.getString("ADDTIME");
}catch(Exception e){System.out.println("ArticleBean.modArticle(Hashtable)运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("ArticleBean.modArticle(Hashtable)关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("ArticleBean.modArticle(Hashtable)关闭声明时statement出错"+e);}
}
strHits = strTitle +" 发表时间："+strAddTime;
strHits = strHits.replaceAll(" "," ");
if(strAuthor.equals("")){
rs = selectRecord("select WRITER from ARTICLE where ID=" + strID);
try{
if(rs.next())
strAuthor = rs.getString("WRITER");
}catch(Exception e){System.out.println("ArticleBean.modArticle(Hashtable)运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("ArticleBean.modArticle(Hashtable)关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("ArticleBean.modArticle(Hashtable)关闭声明时statement出错"+e);}
}
}
Vector vect =new Vector();
vect.add("ARTICLE");
vect.add(addVector("TITLE",strTitle,"CHAR"));
vect.add(addVector("ORGANID",strbm,"CHAR"));
vect.add(addVector("ORGID",strOrgId,"CHAR"));
vect.add(addVector("FROMSITE",strFromSite,"CHAR"));
vect.add(addVector("KEYWORD",strKeyword,"CHAR"));
vect.add(addVector("HITS",strHits,"CHAR"));
vect.add(addVector("FTPFILE",strFTPFile,"CHAR"));
vect.add(addVector("IFHEAD",strIfhead,"CHAR"));
vect.add(addVector("IFGOOD",strIfgood,"CHAR"));
vect.add(addVector("IFSHOW",strIfshow,"CHAR"));
vect.add(addVector("IFIMG",strIfimg,"CHAR"));
vect.add(addVector("MENUID",strMenuId,"NUM"));
vect.add(addVector("TOPICID",strTopicId,"NUM"));
vect.add(addVector("IMG",strImg,"CHAR"));
vect.add(addVector("WHICHTABLE",strWhichTable,"CHAR"));
vect.add(addVector("AUTHOR",strAuthor,"CHAR"));
vect.add(addVector("OLDORGID",strOldOrgId,"CHAR"));
vect.add(addVector("STRSIZE",strsize,"CHAR"));
vect.add(addVector("CURSIZE",strcursize,"CHAR"));
vect.add(addVector("EDITTIME",ds.getDateTime(),"CHAR"));
vect.add("ID="+strID);
int ret = updateRecord(vect);
if(ret!=0)
return ret;
else
{
return UpdateBLOB_JNDI("ARTICLE","ID="+strID,"CONTENT",strContent);
}
}
public int updateArticle(Hashtable hash)
{
String strid = ds.toString((String)hash.get("ID"));
String struid = ds.toString((String)hash.get("EDITER"));
String strEditIP = ds.toString((String)hash.get("EDITIP"));
String strEditTime = ds.getDateTime();
executeUpdate("update article set img=null where img is not null and ifimg=0 and id="+strid);
Vector vt = new Vector();
vt.add("ARTICLE");
vt.add(addVector("IFSHOW","1","CHAR"));
vt.add(addVector("EDITER",struid,"CHAR"));
vt.add(addVector("EDITIP",strEditIP,"CHAR"));
vt.add(addVector("EDITTIME",strEditTime,"CHAR"));
vt.add("ID="+strid);
return updateRecord(vt);
}
public static void main(String args[])
{
ArticleBean mb = new ArticleBean();
System.out.println("begin\r\n\r\n");
System.out.println("Please input string to be translated");
System.out.print(mb.getOrg("1"));
System.out.print(mb.getkybm("1"));
System.out.print(mb.getbmqx("1"));
//System.out.print("000000000000000"+mb.toName("NB_TOPIC","ID","NAME","1"));
System.out.println("\rend ");
}
//删除数据记录
public int delData(String strid)
{
String sql="";
sql = "select ORGID from article where ORGID is not null and ID in ("+strid+") union select img from article where img is not null and ID in ("+strid+")";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
String wz_1 = oa.main.ParentBean.FilesPath+"news\\appendix\\";
String wz_2 = oa.main.ParentBean.FilesPath+"news\\img\\";
File f = null;
try{
String file = null;
while(rs.next()){
file = rs.getString(1);
//if(file.indexOf(',')!=-1)
String[] files = file.split(",");
for(int i=0;i<files.length;i++)
{
if(files[i].equals(""))
continue;
f = new File(wz_1+files[i]);
if (f.exists())
f.delete();
f = new File(wz_2+files[i]);
if (f.exists())
f.delete();
}
}
}catch(Exception e){System.out.println("ArticleBean.delData(String strid)出错:"+e);}
finally
{
if(rs!=null)
try{stmt = rs.getStatement();rs.close();}catch(Exception e){System.out.println("ArticleBean.delData(String strid)释放记录集rs出错:"+e);}
if(stmt != null)
try{stmt.close();}catch(Exception e){System.out.println("ArticleBean.delData(String strid)释放statement出错:"+e);}
}
sql = "delete ARTICLE where ID in ("+strid+")";
// System.out.println(sql);
return deleteRecord(sql);
}
/* //修改操作权限
public int updateCZQX(String qx,String zgbh)
{
String sql = "select LRSF from ZZ_ZGB where ZGBH='"+ zgbh +"'";
ResultSet rs = selectRecord(sql);
String str = "";
if(rs.next())
{
str = ds.toString((String)rs.getString("LRSF"));
}
if(str.equals("")) str = qx;
else str = str + qx;
sql = "update ZZ_ZGB set LRSF='"+str+"' where ZGBH='"+ zgbh +"'";
int ii = db.ExecuteSQL(sql);
return ii;
}
//修改ZZ_ZGZWB的 WZQX
public int updateWZQX(qx,zgbh)
{
}*/
public Vector getwzly()//从字典表取得文章来源
{
String sql = "";
sql = "select XMMC from CODE_ZDB where ZDMC='文章来源' order by jbxh";
ResultSet rs = selectRecord(sql);
Vector vt = new Vector();
Statement stmt = null;
try{
while(rs.next())
{
vt.add(ds.toString(rs.getString("XMMC")));
}
}catch(Exception e){System.out.println("ArticleBean.getwzly()运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("ArticleBean.getwzly()关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("ArticleBean.getwzly()关闭声明时statement出错"+e);}
}
return vt;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -