【Java开源代码栏目提醒】:网学会员--在 Java开源代码编辑为广大网友搜集整理了:artBean.java绩等信息,祝愿广大网友取得需要的信息,参考学习。
package com.ideas.bean;
import java.lang.*;
import java.util.*;
import java.sql.*;
public class artBean extends ParentBean
{
String id = "-1";
public void setID(String id)
{
this.id = id;
}
public Vector getCurPage(int cur,int records)
{
return getOnePage("SELECT * FROM art order by id",cur,records);
}
//取得数据表中的某一条记录
public Vector getOneData() throws Exception
{
String sql = " select * from art where id= "+id;
return getResultSetData(selectRecord(sql));
}
public int add(Hashtable hash) throws Exception
{
String name = ds.toString((String)hash.get("name"));
String isuse = ds.toString((String)hash.get("isuse"));
String menuid = ds.toString((String)hash.get("menuid"));
String menufloor = ds.toString((String)hash.get("menufloor"));
String addtime = ds.toString((String)hash.get("addtime"));
String edittime = ds.toString((String)hash.get("edittime"));
String title = ds.toString((String)hash.get("title"));
String title1 = ds.toString((String)hash.get("title1"));
String writer = ds.toString((String)hash.get("writer"));
String reporter = ds.toString((String)hash.get("reporter"));
String fromer = ds.toString((String)hash.get("fromer"));
String file = ds.toString((String)hash.get("file"));
String editer = ds.toString((String)hash.get("editer"));
String Content = ds.toString((String)hash.get("Content"));
String keywords = ds.toString((String)hash.get("keywords"));
Content = Content.replaceAll("<","<").replaceAll(">",">");
//文件重名时返回
String f = file.substring(file.lastIndexOf("/") + 1, file.length());
String sql = "select * from art where file='"+f+"'";
if(getResultSetData(selectRecord(sql)).size() != 0)
{
return 1;
}
else
{
DealFile df = new DealFile();
df.connFOS(file);
df.writeCHStr(Content);
df.closeFOS();
Vector vect = new Vector();
vect.add("art");
vect.add(addVector("name", name, "CHAR"));
vect.add(addVector("isuse", isuse, "CHAR"));
vect.add(addVector("menuid", menuid, "NUM"));
vect.add(addVector("menufloor", menufloor, "NUM"));
vect.add(addVector("addtime", addtime, "CHAR"));
vect.add(addVector("edittime", edittime, "CHAR"));
vect.add(addVector("title", title, "CHAR"));
vect.add(addVector("title1", title1, "CHAR"));
vect.add(addVector("writer", writer, "CHAR"));
vect.add(addVector("reporter", reporter, "CHAR"));
vect.add(addVector("fromer", fromer, "CHAR"));
vect.add(addVector("file", f, "CHAR"));
vect.add(addVector("editer", editer, "CHAR"));
vect.add(addVector("keywords", keywords, "CHAR"));
return insertRecord(vect);
}
}
public Vector getMenuList(String table)
{
String sql = "select id,name from "+table+" order by id";
return getResultSetData(selectRecord(sql));
}
public int mod(Hashtable hash) throws Exception
{
String name = ds.toString((String)hash.get("name"));
String isuse = ds.toString((String)hash.get("isuse"));
String menuid = ds.toString((String)hash.get("menuid"));
String menufloor = ds.toString((String)hash.get("menufloor"));
String addtime = ds.toString((String)hash.get("addtime"));
String edittime = ds.toString((String)hash.get("edittime"));
String title = ds.toString((String)hash.get("title"));
String title1 = ds.toString((String)hash.get("title1"));
String writer = ds.toString((String)hash.get("writer"));
String reporter = ds.toString((String)hash.get("reporter"));
String fromer = ds.toString((String)hash.get("fromer"));
String file = ds.toString((String)hash.get("file"));
String editer = ds.toString((String)hash.get("editer"));
String Content = ds.toString((String)hash.get("Content"));
String keywords = ds.toString((String)hash.get("key
words"));
Content = Content.replaceAll("<","<").replaceAll(">",">");
//文件重名时返回
String f = file.substring(file.lastIndexOf("/") + 1, file.length());
String
sql = "select * from art where id!="+id+" and file='"+f+"'";
if(getResultSetData(selectRecord(sql)).size() != 0)
{
return 1;
}
else
{
DealFile df = new DealFile();
df.connFOS(file);
df.writeCHStr(Content);
df.closeFOS();
Vector vect = new Vector();
vect.add("art");
vect.add(addVector("name", name, "CHAR"));
vect.add(addVector("isuse", isuse, "CHAR"));
vect.add(