mailcontentinterfaceimpl.java

一个画股票曲线并发送邮件的程序。 采用freechart和javamail技术。

package com.shfe.mail;

import java.sql.Connection;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.sql.ResultSet;
import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.util.ArrayList;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class MailContentInterfaceImpl implements MailContentInterface
{
    public MailContentInterfaceImpl()
    {
    }

     SimpleDateFormat format=new SimpleDateFormat("MM月dd日");

    public String getTradeStaticsForm(Connection conn) throws SQLException
    {
        Date date=new Date();
        StringBuffer buffer=new StringBuffer();

        buffer.append("<h4 align=\"center\">表1--"+format.format(date)+"模拟交易统计表</h4>");
        buffer.append("<table border=\"1\" align=\"center\"><tr><td>品种</td><td>品种名称</td> <td>成交量</td>"
                          +"<td> 较昨日变化(%)</td><td> 持仓量</td><td> 较昨日变化(%)</td> <td> 结算价</td><td> 较昨日变化(%)</td> </tr>");
        CallableStatement cs = conn.prepareCall("{call sis_contract_tradesummary}");
        ResultSet rs = cs.executeQuery();
        while(rs.next())
        {
            buffer.append("<tr><td>"+rs.getString(1)+"</td><td>"+rs.getString(2)+"</td> <td>"+rs.getInt(3)+"</td>"
                          +"<td> "+rs.getFloat(4)+"</td><td> "+rs.getInt(5)+"</td><td> "+rs.getFloat(6)
                          +"</td> <td> "+rs.getDouble(7)+"</td><td> "+rs.getFloat(8)+"</td> </tr>");
        }
        rs.close();
        cs.close();
        buffer.append("</table>");
        return buffer.toString();
    }

    public String getTrendGraph(Connection conn) throws SQLException
    {
         PreparedStatement ps=conn.prepareStatement("select contract from daily_quotation where tradedate=convert(char,getdate(),112)");
         ResultSet rs=ps.executeQuery();
         ArrayList ids=new ArrayList();
         while(rs.next())
         {
             ids.add(rs.getString(1));
         }
         rs.close();
         ps.close();
         class SettlePrice
         {

         }
         for(int i=0;i<ids.size();i++)
         {
             ps=conn.prepareStatement("select psettle,openprice from daily_quotation where"
                                     +" tradedate=convert(char,getdate(),112) and contract='"+ids.get(i)+"'");
         }

        return "";
    }

    public String getIndexCloseForm(Connection conn) throws SQLException
    {
        return "";
    }

    public String getFundOrderForm(Connection conn) throws SQLException
    {
        return "";
    }

    public String getDealOrderForm(Connection conn) throws SQLException
    {
        return "";
    }
}