articlesaudit.java

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

package com.am;

import java.util.*;
import java.sql.*;
import java.text.*;

public class articlesaudit
{   
    public long ID;
    public long articleID;
	public String title;	
	public long reviewer;
	public String comment;
	public int point;
	public int accept;
	public String commentManager;
	public String createDatetime;	
 	public int tag;
    private String strSql;
    private Connection dbConn;
    private int errNum;
    private String errDesc;
    private SimpleDateFormat dateFormatter;

    public void articlesaudit()
    {
        dateFormatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        ID=0;
        articleID=0;
    	title="";
    	reviewer=0;
    	comment="";
    	point=0;
    	accept=0;
    	commentManager="";   
    	createDatetime=dateFormatter.format(new java.util.Date());    	
		tag=0;        
        strSql="";        
        errNum=0;
        errDesc="";
   }
   
   public void add()
   {
       
        strSql="insert into articlesaudit ";
        strSql=strSql + "(";
        strSql=strSql + "articleID,";
        strSql=strSql + "title,";
        strSql=strSql + "reviewer,";
        strSql=strSql + "comment,";
        strSql=strSql + "point,";
        strSql=strSql + "accept,";
        strSql=strSql + "commentManager,";       
        strSql=strSql + "createDatetime,";
        strSql=strSql + "tag"; 
        strSql=strSql + ") ";
		strSql=strSql + "values(";
		strSql=strSql + "'" + articleID + "',";
		strSql=strSql + "'" + title + "',";
		strSql=strSql + "'" + reviewer + "',";
		strSql=strSql + "'" + comment + "',";
		strSql=strSql + "'" + point + "',";
		strSql=strSql + "'" + accept + "',";
		strSql=strSql + "'" + commentManager + "',";		
		strSql=strSql + "'" + createDatetime + "',";	
		strSql=strSql + "'" + tag + "'";              
		strSql=strSql + ")";  
		exeSql(strSql);
	
   }

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

        exeSql(strSql);

   }  
   
  
   public void updateAudit()
   {
       
        strSql="update articlesaudit set";        
        strSql=strSql + " articleID=" + "'" + articleID + "',";
        strSql=strSql + " title=" + "'" + title + "',";
        strSql=strSql + " reviewer=" + "'" + reviewer + "',";
        strSql=strSql + " comment=" + "'" + comment + "',";
        strSql=strSql + " point=" + "'" + point + "',";
        strSql=strSql + " accept=" + "'" + accept + "',";
        strSql=strSql + " commentManager=" + "'" + commentManager + "',";
        strSql=strSql + " createDatetime=" + "'" + createDatetime + "',";
        strSql=strSql + " tag=" + "'" + tag + "'";
        strSql=strSql + " where ID='" + ID + "'";
		exeSql(strSql);
	
   }


   public boolean isAudited()
   {
       strSql="select * from articlesaudit where articleID=";
       strSql=strSql + "'" + this.articleID + "' and reviewer='"+ this.reviewer + "'";
       try
		{
  			Statement stmt=dbConn.createStatement();
			ResultSet rs =stmt.executeQuery(strSql);
			 if (rs.next())
			 {
			     this.ID=rs.getLong("ID");
			     this.errNum=0;
	             this.errDesc="";
	             return true;
			 }
			 else
			 {
			     this.errNum=0;
	             this.errDesc="no record";
			     return false;
			 }
		}
		 catch(Exception ex)
			{			
	            this.errNum=-1;
	            this.errDesc=ex.toString();
	            return false;
			}

   }  
   
  
   public boolean  init()
   {
    	strSql="select * from articlesaudit where ID=";
        strSql=strSql + "'" + this.ID + "'";
        try
		{
   			Statement stmt=dbConn.createStatement();
			ResultSet rs =stmt.executeQuery(strSql);
            if (rs.next())
            {
                ID=rs.getLong("ID");
                articleID=rs.getLong("articleID");
                title=rs.getString("title");
                comment=rs.getString("comment");
                point=rs.getInt("point");
                accept=rs.getInt("accept");
                commentManager=rs.getString("commentManager");              
                createDatetime=rs.getString("createDatetime");                 
                tag=rs.getInt("tag");
                
                this.errNum=0;
                this.errDesc="";
                return true;
            }
            else
            {
                this.errNum=-1;
                this.errDesc="No record!";
                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)
   {
        Statement stmt=null;
        try
		{
   			stmt=dbConn.createStatement();
			stmt.executeUpdate(strSql);
            this.errNum=0;
            this.errDesc="";
		}
		catch(Exception ex)
		{
			System.out.println(ex.toString());
            this.errNum=-1;
            this.errDesc=ex.toString();

		}
        finally
        {
            stmt=null;
        }
   }

  
    public int getErrNum()
    {
        return errNum;

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