smsstockdz.java

JAVA邮件系统

/*
 *
 */
import java.io.*;
import java.text.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class SMSStockDZ extends SmsDZBase {

    public void doGet(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {
  		response.setContentType("text/html;charset=GB2312");
      PrintWriter out = response.getWriter();

      String sOut="";
	    // 得到手机号和口令
		  String sMobile,sPassword,sUsername;
      sMobile=CommonMethods.GetUserMobile (request);
		  sPassword = CommonMethods.GetUserPass (request);
      sUsername = getUserName(sMobile,sPassword);

      if ((sUsername==null)||(sUsername.trim().length()==0))
      {
          	response.sendRedirect ("/sms/LoginFail.htm");
            return;
      }
      else
      {

        String stockcode =request.getParameter  ("stockcode");
        String warnmax = request.getParameter ("warnmax");
        String warnmin = request.getParameter ("warnmin");
        String action = request.getParameter ("action");//add,delete,update, addnew
        String gpdm = request.getParameter ("gpdm");//股票代码
        if (stockcode==null)
            stockcode="";
        if(warnmax==null)
            warnmax="0";
        if(warnmin==null)
            warnmin="0";
        if(gpdm==null)
            gpdm="";
        if(action==null)
            action="";

        if(action.trim ()=="")//输出
        {
            sOut+=beginString();
            sOut+=middleString(sUsername);
            sOut+=endString();
        }
        if((action.trim ().compareTo ("add")==0)||(action.trim ().compareTo ("addnew")==0))
        {
           if(!checkStockCode(stockcode.trim ()))
          {
             	response.sendRedirect ("/sms/dingzhi/gupiao_error.htm");
              return;
          }
          SaveDZ(sUsername,stockcode,warnmax,warnmin);
          UpdatePerson(sUsername);
          if(action.trim ().compareTo ("add")==0)
          {
              response.sendRedirect ("/sms/selectok.htm");
              return;
          }
          else if(action.trim ().compareTo ("addnew")==0)
          {
              sOut+=beginString();
              sOut+=middleString(sUsername);
              sOut+=endString();
          }

        }
        if(action.trim ().compareTo ("delete")==0)
        {
           if ((gpdm!=null)&&(gpdm.trim ().length ()!=0))
               deleteGpdm(sUsername,gpdm);
           sOut+=beginString();
           sOut+=middleString(sUsername);
           sOut+=endString();

        }
        if(action.trim ().compareTo ("edit")==0)
        {
           sOut+=beginString();
           sOut+=middleString(sUsername);
           sOut+=endString(sUsername,gpdm);
        }
      }
      out.print(sOut);
    }
   public boolean checkStockCode(String stockcode)
	 {
		DBOperater DB = new DBOperater ("stock");

		ResultSet rs = DB.executeQuery ("select ZQID from ZQ_ZQINFO where ZQID='"
										+stockcode+"'");
    System.out.println("select ZQID from ZQ_ZQINFO where ZQID='"
										+stockcode+"'");
		if(rs==null)
		{
			DB.close();
			return false;
		}
		try{
			if(rs.next()){
				DB.close ();
				return true;
			}
		}catch(Exception e){
		}
		DB.close ();
		return false;
	}
    public void doPost(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {
  		doGet(request,response);
    }
    public void SaveDZ(String sUsername,String stockcode,String warnmax,String warnmin)
    {
        if (stockcode==null)
            return;
        else
        {
            int nLength=0,i=0;
            double max=0,min=0;
            try{
                max=Double.valueOf (warnmax).doubleValue ();
            }catch(Exception e){
                max=0;
            }
             try{
                min=Double.valueOf (warnmin).doubleValue ();
            }catch(Exception e){
                min=0;
            }
            deleteGpdm(sUsername,stockcode);
            //将用户定制的城市信息插入userstock表中
        		DBOperater DB = new DBOperater ("userstock");
            System.out.println("INSERT INTO userstock(username, stockcode,warnmax,warnmin) VALUES('"+sUsername+"'"+","+"'"+stockcode+"',"+max+","+min+")");
            DB.executeUpdate ( "INSERT INTO userstock(username, stockcode,warnmax,warnmin) VALUES('"+sUsername+"'"+","+"'"+stockcode+"',"+max+","+min+")");
            DB.close ();
            return;
        }
     }
    public void deleteGpdm(String sUsername,String stockcode)
    {
        if (stockcode==null)
            return;   
        else
        {
            int nLength=0,i=0;
            //将用户定制的城市信息插入userstock表中
        		DBOperater DB = new DBOperater ("userstock");
            DB.executeUpdate ( "delete from userstock where username='"+sUsername+"' and stockcode='"+stockcode+"'");
            DB.close ();
            return;
        }
     }
    public void UpdatePerson(String sUsername)
    {
          	DBOperater DB = new DBOperater ("smsuser");
		        DB.executeUpdate ( "update "+CommonMethods.sTableName+" set stocktx=1  where username='"+ sUsername +"'" );
            DB.close ();
     }
     public String beginString()
     {
          String sOut="";
          sOut+="<html><!-- #BeginTemplate \"/Templates/sms365_01.dwt\" -->\r\n";
      		sOut+="<head>\r\n";
      		sOut+="<!-- #BeginEditable \"doctitle\" --> \r\n";
      		sOut+="<title>欢迎光临365do短信息点播中心</title>\r\n";
      		sOut+="<!-- #EndEditable --> \r\n";
      		sOut+="<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n";
      		sOut+="<link rel=\"stylesheet\" href=\"/sms/style_sms.css\">\r\n";
      		sOut+="</head>\r\n";
      		sOut+="\r\n";
      		sOut+="<body bgcolor=\"#EEEEEE\" leftmargin=\"0\" topmargin=\"0\" marginwidth=\"0\" marginheight=\"0\" background=\"/sms/images/bg1.gif\">\r\n";
          sOut+=" </td>   \r\n";
  				sOut+="                      </tr>   \r\n";
          sOut+="                            <script language=\"JavaScript\">\r\n";
	  			sOut+="function gourl(url){\r\n";
		  		sOut+="location = url;\r\n";
			  	sOut+="}\r\n";
				  sOut+="function openTX(url){  window.open(url,\"\",\r\n";
  				sOut+="  \"resizable=no,scrollbars=no,width=360,height=280\");\r\n";
	  			sOut+="}\r\n";
          //
          sOut+="function check(){\r\n";
    			sOut+="if (document.ok.stockcode.value.length<1)";
		    	sOut+="{\r\n";
    			sOut+="  alert(\"请输入股票代码\");\r\n";
		    	sOut+="  return false;}\r\n";
          sOut+="if ((document.ok.warnmin.value.length<1)&&(document.ok.warnmax.value.length<1))";
		    	sOut+="{\r\n";
    			sOut+="  alert(\"请输入上限或下限价格\");\r\n";
		    	sOut+="  return false;}\r\n";

          sOut+="if((document.ok.warnmin.value.length>=1)&&!isFinite(document.ok.warnmin.value))\r\n";
  				sOut+="{\r\n";
	  			sOut+="	alert(\"请输入正确的下限价格\");\r\n";
		  		sOut+="	return false;\r\n";
			  	sOut+="}\r\n";
				  sOut+="if((document.ok.warnmax.value.length>=1)&&!isFinite(document.ok.warnmax.value))\r\n";
  				sOut+="{\r\n";
	  			sOut+="	alert(\"请输入正确的上限价格\");\r\n";
		  		sOut+="	return false;\r\n";
          sOut+="}";
          sOut+="  return true;\r\n";
    			sOut+="   \r\n";
		    	sOut+="}\r\n";

          //
		  		sOut+="function setaction(action){\r\n";
			  	sOut+="    document.ok.action.value=action;\r\n";
				  sOut+="}\r\n";
  				sOut+="\r\n";
	  			sOut+="</script>\r\n";
      		sOut+="<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"100%\">\r\n";
      		sOut+="  <tr valign=\"top\"> \r\n";
      		sOut+="    <td width=\"167\" bgcolor=\"#3F58D1\"> \r\n";
      		sOut+="      <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n";
      		sOut+="        <tr> \r\n";
      		sOut+="          <td colspan=\"2\">&nbsp;<a href=\"/sms/\"><img src=\"/sms/images/sms.jpg\" width=\"167\" height=\"137\" border=\"0\"></a></td>\r\n";
      		sOut+="        </tr>\r\n";
      		sOut+="        <tr> \r\n";
      		sOut+="          <td><img src=\"/sms/images/a_00.gif\" width=\"96\" height=\"30\"></td>\r\n";
      		sOut+="          <td><a href=\"/sms/tiaokuan.htm\"><img src=\"/sms/images/a_01.gif\" width=\"71\" height=\"30\" border=\"0\"></a></td>\r\n";
      		sOut+="        </tr>\r\n";
      		sOut+="        <tr> \r\n";
      		sOut+="          <td><img src=\"/sms/images/a_00.gif\" width=\"96\" height=\"30\"></td>\r\n";