?? makenews.java
字號(hào):
/**********************************************************
Version 1.0
Date:2003-11-29
Description:維護(hù)ZZ_FBXWB
Other:
Variable List:
1.int strID //新聞發(fā)表唯一編號(hào)
Function List:
1.public MakeNews()//構(gòu)造函數(shù)
2.public void setID(String o)//設(shè)置新聞發(fā)表唯一編號(hào)
/*
4.public Vector getData()//取得新聞發(fā)表維護(hù)表所有記錄
5.public Hashtable getOneData()//取得一條記錄的信息
6.public boolean getOneData(String a,String b,String c)//判斷是否有滿足條件的記錄 true:有，false:無
7.public Vector getData(String a,String b,String c)//取得菜單維護(hù)表中滿足條件的所有記錄
public Vector changeData(String a,String b,String c)//修改菜單中的須修改的記錄
public Hashtable getID1() //取得一條記錄的一級(jí)菜單
public Hashtable getID2() //取得一條記錄的二級(jí)菜單
.public int addNews(Hashtable hash)//增加新聞發(fā)表維護(hù)表數(shù)據(jù)記錄
.public int modNews(Hashtable hash)//修改新聞發(fā)表維護(hù)表數(shù)據(jù)記錄
.public int delNews()//刪除新聞發(fā)表維護(hù)表數(shù)據(jù)記錄
.public Vector getData(String zgbh)//取得某人所有版面權(quán)限的ID號(hào)
.public Hashtable getOneData()//取得一條記錄的信息
.public boolean hasSuchData(String zgbh,String bmbh,String sf,String cz,String wt)//判斷是否有滿足條件的記錄 false:無， true:有，并且刪除這條紀(jì)錄
.public Hashtable getbmqx(String uid) //獲得個(gè)人有管理員權(quán)限的所有版面 明黎民
History:
***********************************************************/
package oa.bean;
import java.text.*;
import java.util.*;
import java.lang.*;
import java.io.*;
import java.sql.*;
import oa.main.*;
import javax.swing.tree.DefaultMutableTreeNode;
public class MakeNews extends ParentBean
{
int strID=-1;//新聞發(fā)表唯一編號(hào)
public void setID(int o)//設(shè)置新聞發(fā)表唯一編號(hào)
{
strID = o;
}
public int addNews(Hashtable hash)//增加新聞發(fā)表維護(hù)表數(shù)據(jù)記錄
{
int intMax = db.makeID("ZZ_FBXWB","ID","","",true);
String zgbh = ds.toString((String)hash.get("ZGBH"));
String lb = ds.toString((String)hash.get("LB"));
String dxbh = ds.toString((String)hash.get("DXBH"));
String sf = ds.toString((String)hash.get("SF"));
String cz = ds.toString((String)hash.get("CZ"));
String whichtable = ds.toString((String)hash.get("WHICHTALBE"));
String bmbh = ds.toString((String)hash.get("BMBH"));
String sfgl = ds.toString((String)hash.get("SFGL"));
Vector vect =new Vector();
vect.add("ZZ_FBXWB");
vect.add(addVector("ID",String.valueOf(intMax),"NUM"));
vect.add(addVector("ZGBH",zgbh,"CHAR"));
vect.add(addVector("LB",lb,"CHAR"));
vect.add(addVector("DXBH",dxbh,"NUM"));
vect.add(addVector("SF",sf,"CHAR"));
vect.add(addVector("CZ",cz,"CHAR"));
vect.add(addVector("WHICHTABLE",whichtable,"CHAR"));
vect.add(addVector("BMBH",bmbh,"CHAR"));
vect.add(addVector("SFGL",sfgl,"CHAR"));
return insertRecord(vect);
}
public int modNews(Hashtable hash)//修改新聞發(fā)表維護(hù)表數(shù)據(jù)記錄
{
String zgbh = ds.toString((String)hash.get("ZGBH"));
String lb = ds.toString((String)hash.get("LB"));
String dxbh = ds.toString((String)hash.get("DXBH"));
String sf = ds.toString((String)hash.get("SF"));
String cz = ds.toString((String)hash.get("CZ"));
String whichtable = ds.toString((String)hash.get("WHICHTALBE"));
String bmbh = ds.toString((String)hash.get("BMBH"));
String sfgl = ds.toString((String)hash.get("SFGL"));
Vector vect =new Vector();
vect.add("ZZ_FBXWB");
vect.add(addVector("ZGBH",zgbh,"CHAR"));
vect.add(addVector("LB",lb,"CHAR"));
vect.add(addVector("DXBH",dxbh,"NUM"));
vect.add(addVector("SF",sf,"CHAR"));
vect.add(addVector("CZ",cz,"CHAR"));
vect.add(addVector("WHICHTABLE",whichtable,"CHAR"));
vect.add(addVector("BMBH",bmbh,"CHAR"));
vect.add(addVector("SFGL",sfgl,"CHAR"));
vect.add("ID="+strID+"");
return updateRecord(vect);
}
public int delNews() //刪除新聞發(fā)表維護(hù)表數(shù)據(jù)記錄
{
String sql="";
sql = "delete from news.ZZ_FBXWB where ID = "+strID+"";
return deleteRecord(sql);
}
public Hashtable getbmqx(String uid)//獲得個(gè)人有管理員權(quán)限的所有版面
{
String showqx1 = "";//所有可審批的位于menu表中的版面
String showqx2 = "";//所有可審批的位于menuchild表中的版面
String imgqx1 = "";//所有可審批圖片的位于menu表中的版面
String imgqx2 = "";//所有可審批圖片的位于menuchild表中的版面
String headqx1 = "";//所有可審批首頁的位于menu表中的版面
String headqx2 = "";//所有可審批首頁的位于menuchild表中的版面
String goodqx1 = "";//所有可審批焦點(diǎn)的位于menu表中的版面
String goodqx2 = "";//所有可審批焦點(diǎn)的位于menuchild表中的版面
Hashtable ht = new Hashtable();
MenuBean mb = null;
String sql = "select dxbh,cz,whichtable from news.zz_fbxwb where zgbh='"+uid+"' and lb='1' and sf='2' ";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
mb = new MenuBean();
while(rs.next())
{
String dxbh = ds.toString(rs.getString(1));
String cz = ds.toString(rs.getString(2));
String whichtable = ds.toString(rs.getString(3));
String str1 = "";//保存中間結(jié)果
String str2 = "";//保存中間結(jié)果
String sql_1 = "";
ResultSet rs_1 = null;
if(whichtable.equals("1"))//在menu表中
{
sql_1 = "select id,id1,id2,id3 from news.menu where id = "+dxbh;
rs_1 = selectRecord(sql_1);
String id1="",id2="",id3 = "";
try{
if(rs_1.next()){
id1 = ds.toString(rs_1.getString(2));
id2 = ds.toString(rs_1.getString(3));
id3 = ds.toString(rs_1.getString(4));
}
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs_1!=null)try{ stmt = rs_1.getStatement(); rs_1.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
if(id2.equals("0"))//一級(jí)菜單
{
sql_1 = "select id from news.menu where id1='"+id1+"'";
rs_1 = selectRecord(sql_1);
try{
while(rs_1.next())
{
if(!str1.equals(""))
{
str1 = str1 + ",";
}
str1 = str1 + ds.toString(rs_1.getString(1));
}
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs_1!=null)try{ stmt = rs_1.getStatement(); rs_1.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
sql_1 = "select id from news.menuchild where idparent in ("+str1+") and isthis='0'";
rs_1 = selectRecord(sql_1);
try{
while(rs_1.next())
{
if(!str2.equals(""))
{
str2 = str2 + ",";
}
str2 = str2 + ds.toString(rs_1.getString(1));
}
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs_1!=null)try{ stmt = rs_1.getStatement(); rs_1.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
}
if(id3.equals("0")&&!id2.equals("0"))//二級(jí)菜單
{
sql_1 = "select id from news.menu where id1='"+id1+"' and id2='"+id2+"'";
rs_1 = selectRecord(sql_1);
try{
while(rs_1.next())
{
if(!str1.equals(""))
{
str1 = str1 + ",";
}
str1 = str1 + ds.toString(rs_1.getString(1));
}
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs_1!=null)try{ stmt = rs_1.getStatement(); rs_1.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
sql_1 = "select id from news.menuchild where idparent in ("+str1+") and isthis='0'";
rs_1 = selectRecord(sql_1);
try{
while(rs_1.next())
{
if(!str2.equals(""))
{
str2 = str2 + ",";
}
str2 = str2 + ds.toString(rs_1.getString(1));
}
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs_1!=null)try{ stmt = rs_1.getStatement(); rs_1.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
}
if(!id3.equals("0"))//三級(jí)菜單
{
if(!str1.equals(""))
{
str1 = str1 + ",";
}
str1 = str1 + dxbh;
sql_1 = "select id from news.menuchild where idparent in ("+str1+") and isthis='0'";
rs_1 = selectRecord(sql_1);
try{
while(rs_1.next())
{
if(!str2.equals(""))
{
str2 = str2 + ",";
}
str2 = str2 + ds.toString(rs_1.getString(1));
}
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs_1!=null)try{ stmt = rs_1.getStatement(); rs_1.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
}
if(!showqx1.equals(""))
{
showqx1 = showqx1 + ",";
}
showqx1 = showqx1 + str1;
if(!showqx2.equals(""))
{
showqx2 = showqx2 + ",";
}
showqx2 = showqx2 + str2;
if(cz.equals("1"))//審焦點(diǎn)
{
if(!goodqx1.equals(""))
{
goodqx1 = goodqx1 + ",";
}
goodqx1 = goodqx1 + str1;
if(!goodqx2.equals(""))
{
goodqx2 = goodqx2 + ",";
}
goodqx2 = goodqx2 + str2;
}
if(cz.equals("2"))//審首頁
{
if(!headqx1.equals(""))
{
headqx1 = headqx1 + ",";
}
headqx1 = headqx1 + str1;
if(!headqx2.equals(""))
{
headqx2 = headqx2 + ",";
}
headqx2 = headqx2 + str2;
}
if(cz.equals("3"))//審圖片
{
if(!imgqx1.equals(""))
{
imgqx1 = imgqx1 + ",";
}
imgqx1 = imgqx1 + str1;
if(!imgqx2.equals(""))
{
imgqx2 = imgqx2 + ",";
}
imgqx2 = imgqx2 + str2;
}
}
if(whichtable.equals("2"))//menuchild表中
{
str2 = dxbh;
if(!showqx2.equals(""))
{
showqx2 = showqx2 + ",";
}
showqx2 = showqx2 + str2;
if(cz.equals("1"))//審焦點(diǎn)
{
if(!goodqx2.equals(""))
{
goodqx2 = goodqx2 + ",";
}
goodqx2 = goodqx2 + str2;
}
if(cz.equals("2"))//審首頁
{
if(!headqx2.equals(""))
{
headqx2 = headqx2 + ",";
}
headqx2 = headqx2 + str2;
}
if(cz.equals("3"))//審圖片
{
if(!imgqx2.equals(""))
{
imgqx2 = imgqx2 + ",";
}
imgqx2 = imgqx2 + str2;
}
}
}
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
if(mb!=null)mb.closeConn();
}
ht.put("SHOW1",showqx1);
ht.put("SHOW2",showqx2);
ht.put("IMG1",imgqx1);
ht.put("IMG2",imgqx2);
ht.put("HEAD1",headqx1);
ht.put("HEAD2",headqx2);
ht.put("GOOD1",goodqx1);
ht.put("GOOD2",goodqx2);
return ht;
}
//取得某人所有版面權(quán)限的ID號(hào)
public Vector getData(String zgbh)
{
Vector vect = new Vector();
String sql = "select ID from news.ZZ_FBXWB where ZGBH='"+zgbh+"'";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
while(rs.next())
{
String id = ds.toString(rs.getString(1));
vect.add(id);
}
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
return vect;
}
//取得一條記錄的信息
public Hashtable getOneData()
{
Hashtable hash = new Hashtable();
String sql = "select * from news.ZZ_FBXWB where ID="+strID+"";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
ResultSetMetaData rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
if(rs.next())
{
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);
}
}
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
return hash;
}
//判斷是否有滿足條件的記錄 -1:無， id:有，并且刪除這條紀(jì)錄
public int hasSuchData(String zgbh,String bmbh,String sf,String cz,String wt)
{
int id = -1;
String sql = "";
String strcz = ds.toString(cz); //(CZ is null or CZ='"+cz+"')
if(strcz.equals(""))
sql = "select ID from news.ZZ_FBXWB where ZGBH='"+zgbh+"' and LB='1' and DXBH="+bmbh+" and SF='"+sf+"' and CZ is null and WHICHTABLE='"+wt+"'";
else
sql = "select ID from news.ZZ_FBXWB where ZGBH='"+zgbh+"' and LB='1' and DXBH="+bmbh+" and SF='"+sf+"' and CZ='"+strcz+"' and WHICHTABLE='"+wt+"'";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next())
{
id = rs.getInt(1);
//setID(rs.getInt(1));
//int ii = delNews();
}
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
return id;
}
public static void main(String args[])
{
MakeNews mb = new MakeNews();
System.out.println("begin\r\n\r\n");
//mb.setID(1);
System.out.println("\r\n\r\nend");
}
}?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -