article.java

来自「一个很有用的电子刊物发布系统」· Java 代码 · 共 215 行

package com.am;

import java.util.*;
import java.sql.*;
import java.text.*;
public class article
{
    public long ID;
    public String title;
    public String summary;
    public String fileName;
    public String author;
    public long issuer;
    public long workgroup;
    public long reviewer1;
    public long reviewer2;    
    public String createDatetime;   
    public int tag;
    public int accept;
    public int allowmodify;
    public int recommend;
    private String strSql;
    private Connection dbConn;
    private int errNum;
    private String errDesc;
    SimpleDateFormat dateFormatter;
    public article()
    {
        dateFormatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        ID=0;
    	title="";
    	summary="";
    	fileName="";
    	author="";
    	issuer=0;  
        workgroup=0;
        reviewer1=0;
        reviewer2=0;
    	createDatetime=dateFormatter.format(new java.util.Date());  
		tag=0;
    	accept=0;
        allowmodify=0;
        recommend=0;
		strSql="";       
        errNum=0;
        errDesc="";


   }
  
   public void add()
   {
       
        createDatetime=dateFormatter.format(new java.util.Date());
        strSql="insert into articles ";
		strSql=strSql + "(title,summary,fileName,author,issuer,workgroup,reviewer1,reviewer2," ;
		strSql=strSql + "createDatetime,tag,accept,allowmodify,recommend )";
		strSql=strSql + "values('" + title + "',";
		strSql=strSql + "'" + summary + "',";
		strSql=strSql + "'" + fileName + "',";
		strSql=strSql + "'" + author + "',";
		strSql=strSql + "'" + issuer + "',";
		strSql=strSql + "'" + workgroup + "',";
		strSql=strSql + "'" + reviewer1 + "',";
		strSql=strSql + "'" + reviewer2 + "',";
		strSql=strSql + "'" + createDatetime + "',";
		strSql=strSql + "'" + tag + "',";               
        strSql=strSql + "'" + accept + "',";
        strSql=strSql + "'" + allowmodify + "',";
        strSql=strSql + "'" + recommend + "')";
       	exeSql(strSql);
   }

   public void update()
   {

   		strSql="update articles set ";
		strSql=strSql + "title=" + "'" + title + "',";
		strSql=strSql + "summary=" + "'" + summary + "',";
		strSql=strSql + "fileName=" + "'" + fileName + "',";
		strSql=strSql + "author=" + "'" + author + "',";
		strSql=strSql + "issuer=" + "'" + issuer + "',";
		strSql=strSql + "workgroup=" + "'" + workgroup + "',";
		strSql=strSql + "reviewer1=" + "'" + reviewer1 + "',";
		strSql=strSql + "reviewer2=" + "'" + reviewer2 + "',";
		strSql=strSql + "createDatetime=" + "'" + createDatetime + "',";
		strSql=strSql + "tag=" + "'" + tag + "',";         
		strSql=strSql + "accept=" + "'" + accept + "',";
        strSql=strSql + "allowmodify=" + "'" + allowmodify + "',";
		strSql=strSql + "recommend=" + "'" + recommend + "'";
		strSql=strSql + " where ID='" + ID + "'";
		System.out.print(strSql);
        exeSql(strSql);

   }

  public void assign()
      {
                   strSql="update articles set ";
                   strSql=strSql + "reviewer1=" + "'" + reviewer1 + "',";
                   strSql=strSql + "reviewer2=" + "'" + reviewer2 + "'";
                   strSql=strSql + " where ID='" + ID + "'";
                   System.out.print(strSql);
                  exeSql(strSql);

      }

   public void delete()
   {
        strSql="delete from articles where ID='";
        strSql=strSql + this.ID + "'";
        exeSql(strSql);

   }

   public void enable()
   {
        strSql="update articles set tag=0 where ID='";
        strSql=strSql  + this.ID + "'";
        exeSql(strSql);

   }

   public void  disable()
   {
        strSql="update articles set tag=-1 where ID='";
        strSql=strSql + this.ID + "'";

        exeSql(strSql);

   }

  public boolean  init()
   {
    	strSql="select * from articles where ID=";
        strSql=strSql + "'" + this.ID + "'";
        try
		{
   			Statement stmt=dbConn.createStatement();
			ResultSet rs =stmt.executeQuery(strSql);
            if (rs.next())
            {
                ID=rs.getLong("ID");
                title=rs.getString("title");
                summary=rs.getString("summary");
                fileName=rs.getString("fileName");
                author=rs.getString("author");
                issuer=rs.getLong("issuer");
                workgroup=rs.getLong("workgroup");
                reviewer1=rs.getLong("reviewer1");
                reviewer2=rs.getLong("reviewer2");
                createDatetime=rs.getString("createDatetime");
                tag=rs.getInt("tag");
                accept=rs.getInt("accept");
                allowmodify=rs.getInt("allowmodify");
                recommend=rs.getInt("recommend");
                this.errNum=0;
                this.errDesc="";
                return true;
            }
            else
            {
                this.errNum=-1;
                this.errDesc="init faild!";
                return false;

            }

		}
		catch(Exception ex)
		{
            this.errNum=-1;
            this.errDesc=ex.toString();
            return false;

		}


   }

   public void  setConnection(Connection dbConn)
   {
   		this.dbConn=dbConn;
   }
  
   private void exeSql(String strSql)
   {
   		try
		{
   			Statement stmt=dbConn.createStatement();
			stmt.executeUpdate(strSql);
            this.errNum=0;
            this.errDesc="";
		}
		catch(Exception ex)
		{
            this.errNum=-1;
            this.errDesc=ex.toString();

		}
   }

   
    public int getErrNum()
    {
        return errNum;

    }
   
    public String getErrDesc()
    {
        return errDesc;
    }
}