articleclassmanage.java

sample struct article, ... ...

/**
 * Copyright (C) 2003-2006 TiandiNet.com
 * 
 * Struts 文章系统 1.1
 * 
 * release-date: 2006-02-25
 */

package com.tiandinet.StrutsArticle.FunctionBeans;

import java.sql.*;
import com.tiandinet.StrutsArticle.Utils.DBConnection;
import com.tiandinet.StrutsArticle.FormBeans.ArticleClassForm;

/**
 * @author Meng Yang
 * @version 1.1
 */
public class ArticleClassManage
{
    private Connection conn    = null;
		
		public ArticleClassManage()
		{
		    try
				{
            this.conn = DBConnection.getConnection();
				}
				catch(Exception e){}
		}
		
		//Add new class
		public boolean addNewClass(ArticleClassForm acf)
		{
		    if(acf == null || acf.getClassName() == null || acf.getClassId() == null)
				    return false;
				
				String query = "INSERT INTO `com_tiandinet_jsp_struts_article_class` (`class`,`name`) VALUES (?,?)";
				int    ok    = 0;
				try
				{
				    PreparedStatement ps = this.conn.prepareStatement(query);
						ps.setString(1,acf.getClassId());
						ps.setString(2,acf.getClassName());
						ok = ps.executeUpdate();
				}
				catch(SQLException sqle)
				{
				    ok = 0;
				}
				
				try
				{
				    this.conn.close();
				}
				catch(SQLException sqle2)
				{
				}
				
				if(ok == 1)
				    return true;
				else
				    return false;
		}
		
		//delete a class
		public boolean deleteClass(String classId)
		{
		    if(classId == null || classId.equals(""))
				    return false;
				
				String delArticle = "DELETE FROM `com_tiandinet_jsp_struts_article_content` WHERE `class`='"+classId+"'";
				String delClass   = "DELETE FROM `com_tiandinet_jsp_struts_article_class` WHERE `class`='"+classId+"'";
				
				int ok = 0;
				
				try
				{
				    Statement stmt = this.conn.createStatement();
						
						ok =  stmt.executeUpdate(delArticle);
						ok += stmt.executeUpdate(delClass);
				}
				catch(SQLException sqle)
				{
				    ok = 0;
				}

				try
				{
				    this.conn.close();
				}
				catch(SQLException sqle2)
				{
				}
				
				if(ok <= 0)
				    return false;
				else
				    return true;
		}
}