articlepost.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 java.util.*;
import com.tiandinet.StrutsArticle.Utils.DBConnection;
import com.tiandinet.StrutsArticle.FormBeans.ArticleForm;

/**
 * @author Meng Yang
 * @version 1.1
 */
public class ArticlePost
{
    private Connection conn    = null;
		
		public ArticlePost()
		{
		    try
				{
            this.conn = DBConnection.getConnection();
				}
				catch(Exception e){}
		}
		
		public boolean post(ArticleForm af)
		{
		    String query = "INSERT INTO `com_tiandinet_jsp_struts_article_content` (`title`,`author`,`time`,`from`,`show`,`class`,`content`) VALUES (?,?,?,?,1,?,?)";
				
				Calendar cal        = Calendar.getInstance();
				long     time       = cal.getTimeInMillis();
				String   timeString = String.valueOf(time);
				int      timeNew    = Integer.parseInt(timeString.substring(0,10));
				
				int      ok         = 0;
				
				try
				{
				    PreparedStatement ps = this.conn.prepareStatement(query);
						ps.setString(1,af.getTitle());
						ps.setString(2,af.getAuthor());
						ps.setInt(3,timeNew);
						ps.setString(4,af.getFrom());
						ps.setString(5,af.getClassId());
						ps.setString(6,af.getContent());
						
						ok = ps.executeUpdate();
				}
				catch(SQLException sqle)
				{}
				
				if(ok == 1)
				    return true;
				else
				    return false;
		}
}