📄 articlebean.java
字号:
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++;
}
}
}
}
} catch (Exception e) {
System.out.println("ArticleBean.getkybm(String)运行时出错：" + e);
} finally {
if (rs != null)
try {
stmt = rs.getStatement();
rs.close();
} catch (Exception e) {
System.out.println("ArticleBean.getkybm(String)关闭记录集rs时出错"
+ e);
}
if (stmt != null)
try {
stmt.close();
} catch (Exception e) {
System.out
.println("ArticleBean.getkybm(String)关闭声明时statement出错"
+ e);
}
}
return vt;
}
public Vector getWzlx(String orgid)//获得个人能发表文章的可选类型
{
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 {
//取得列数和列名
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)运行时出错：" + e);
} finally {
if (rs != null)
try {
stmt = rs.getStatement();
rs.close();
} catch (Exception e) {
System.out.println("ArticleBean.getWzlx(String)关闭记录集rs时出错"
+ e);
}
if (stmt != null)
try {
stmt.close();
} catch (Exception e) {
System.out
.println("ArticleBean.getWzlx(String)关闭声明时statement出错"
+ e);
}
}
return vect;
}
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(""))//标题
{
field = "news.article.TITLE";
}
if (title_kw.equals("2"))//关键字
{
field = "news.article.KEYWORD";
}
//多个关键字检索
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 {
//取得列数和列名
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()运行时出错：" + e);
} finally {
if (rs != null)
try {
stmt = rs.getStatement();
rs.close();
} catch (Exception e) {
System.out.println("ArticleBean.getData()关闭记录集rs时出错" + e);
}
if (stmt != null)
try {
stmt.close();
} catch (Exception e) {
System.out.println("ArticleBean.getData()关闭声明时statement出错"
+ e);
}
}
return vet;
}
public Hashtable getOneData()//取得一篇文章的信息
{
Hashtable ht = new Hashtable();
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 news.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("news.ZZ_ZGB", "ZGBH", "XM", strWriter);
if (strFromSite.equals(""))
strFromSite = toName("news.ZZ_BMB", "BMBH", "BMMC", strbm);
Vector vect = new Vector();
vect.add("news.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 {
return ret;
}
}
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.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 news.article where ORGID is not null and ID in ("
+ strid
+ ") union select img from news.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 news.ARTICLE where ID in (" + strid + ")";
// System.out.println(sql);
return deleteRecord(sql);
}
/*
* //修改操作权限 public int updateCZQX(String qx,String zgbh) { String sql =
* "select LRSF from news.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 news.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 + -