articledelete.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;

/**
 * @author Meng Yang
 * @version 1.1
 */
public class ArticleDelete
{
    private Connection conn    = null;
		
		public ArticleDelete()
		{
		    try
				{
            this.conn = DBConnection.getConnection();
				}
				catch(Exception e){}
		}
		
		public boolean delete(int id)
		{
		    if(id <= 0)
				  return false;
				
				String query = "DELETE FROM `com_tiandinet_jsp_struts_article_content` WHERE `id`="+id;
				int    ok    = 0;
				try
				{
				    Statement stmt = this.conn.createStatement();
						
						ok   = stmt.executeUpdate(query);

						this.conn.close();
				}
				catch(SQLException sqle)
				{
				}
				
				if(ok == 1)
				  return true;
				else
				  return false;
		}
}