📄 smsstockdz.java
字号:
sOut+=" <td><a href=\"/sms/login.htm\"><img src=\"/sms/images/a_02.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";
sOut+=" <td><a href=\"/sms/shuoming.htm\"><img src=\"/sms/images/a_04.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";
sOut+=" <td><a href=\"/sms/tiaokuan.htm\"><img src=\"/sms/images/a_05.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";
sOut+=" <td><a href=\"/sms/faq.htm\"><img src=\"/sms/images/a_06.gif\" width=\"71\" height=\"30\" border=\"0\"></a></td>\r\n";
sOut+=" </tr>\r\n";
sOut+=" </table>\r\n";
sOut+=" </td>\r\n";
sOut+=" <td> <a name=\"top\"></a> \r\n";
sOut+=" <table width=\"600\" border=\"0\" cellspacing=\"10\" cellpadding=\"8\">\r\n";
// sOut+=" <tr>\r\n";
// sOut+=" <td><img src=\"/sms/images/ad_temp.gif\" width=\"468\" height=\"60\"></td>\r\n";
// sOut+=" </tr>\r\n";
sOut+=" <tr> \r\n";
sOut+=" <td><!-- #BeginEditable \"1\" --> \r\n";
sOut+=" <table border=\"0\" cellspacing=\"0\" cellpadding=\"4\" bordercolorlight=\"#FFFFFF\" bgcolor=\"#FFFFFF\" width=\"100%\" height=\"273\">\r\n";
sOut+=" <tr> \r\n";
sOut+=" <td colspan=\"2\" bgcolor=\"#3366CC\" height=\"16\"><b><font color=\"#FFFFFF\">股票价位提醒</font></b></td>\r\n";
sOut+=" </tr>\r\n";
sOut+=" <tr> \r\n";
sOut+=" <td bgcolor=\"#3399FF\" colspan=\"2\" height=\"16\">注意：此服务为收费服务，每条信息收费0.1元</td>\r\n";
sOut+=" </tr>\r\n";
sOut+=" <tr bgcolor=\"#DDDDDD\"> \r\n";
sOut+=" <td bgcolor=\"#DDDDDD\" height=\"16\"><img src=\"/sms/images/bell.gif\" width=\"20\" height=\"12\" hspace=\"5\" align=\"absmiddle\" border=\"0\">帮助说明信息</td>\r\n";
sOut+=" <td align=\"right\" height=\"16\">定制信息 帐单查询 <a href=\"/sms/ChangePass.htm\">修改密码</a> \r\n";
sOut+=" <a href=\""+CommonMethods.sCodeBase +"/SMSQuit\">退出定制</a> \r\n";
sOut+=" </td> \r\n";
sOut+=" </tr> \r\n";
sOut+=" <tr bgcolor=\"#FFFFFF\"> \r\n";
sOut+=" <td colspan=\"2\" align=\"center\" background=\"/sms/images/bg1.gif\" bgcolor=\"#EEEEEE\" height=\"193\"> \r\n";
sOut+=" <form name=ok action=\""+CommonMethods.sCodeBase +"/SMSStockDZ\" onsubmit=\"return(check())\"> \r\n";
sOut+=" <table border=\"0\" cellspacing=\"1\" cellpadding=\"3\" height=\"194\" width=\"550\"> \r\n";
sOut+=" <tr> \r\n";
sOut+=" <td align=\"right\" colspan=\"2\" height=\"16\" width=\"538\" bordercolor=\"#876BF3\"> \r\n";
return sOut;
}
public String middleString(String sUserName)
{
String sOut="";
DBOperater DB=new DBOperater ("userstock");
ResultSet rs=DB.executeQuery ("select stockcode,warnmax,warnmin from userstock where username='"+sUserName+"'");
String stockcode="", warnmax="",warnmin="";
if(rs!=null){
sOut+=" <p align=\"left\"><b><font size=\"2\" color=\"#000080\">已定制股票价位提醒信息：</font></b> \r\n";
sOut+=" <table border=\"1\" width=\"100%\" height=\"43\" style=\"border-style: solid\" bordercolorlight=\"#3366CC\" bordercolordark=\"#3F58D1\" cellpadding=\"0\" cellspacing=\"0\" bordercolor=\"#3F58D1\"> \r\n";
sOut+=" <tr> \r\n";
sOut+=" <td width=\"23%\" height=\"13\" align=\"center\" bordercolor=\"#3F58D1\" bordercolorlight=\"#876BF3\" bordercolordark=\"#876BF3\">股票代码</td> \r\n";
sOut+=" <td width=\"26%\" height=\"13\" align=\"center\" bordercolor=\"#3F58D1\" bordercolorlight=\"#876BF3\" bordercolordark=\"#876BF3\">上限价格（元）</td> \r\n";
sOut+=" <td width=\"30%\" height=\"13\" align=\"center\" bordercolor=\"#3F58D1\" bordercolorlight=\"#876BF3\" bordercolordark=\"#876BF3\">下限价格（元）</td> \r\n";
sOut+=" <td width=\"11%\" height=\"13\" bordercolor=\"#3F58D1\" bordercolorlight=\"#876BF3\" bordercolordark=\"#876BF3\"> </td> \r\n";
sOut+=" <td width=\"10%\" height=\"13\" bordercolor=\"#3F58D1\" bordercolorlight=\"#876BF3\" bordercolordark=\"#876BF3\"> </td> \r\n";
sOut+=" </tr> \r\n";
sOut+="\r\n";
try{
while(rs.next ()){
stockcode=rs.getString (1);
warnmax=rs.getString (2);
warnmin=rs.getString (3);
sOut+=" \r\n";
sOut+=" <tr> \r\n";
sOut+=" <td width=\"23%\" height=\"18\" bordercolor=\"#3F58D1\" bordercolorlight=\"#876BF3\" bordercolordark=\"#876BF3\"> \r\n";
sOut+=" <p align=\"right\">"+stockcode+" </td> \r\n";
sOut+=" <td width=\"26%\" height=\"18\" bordercolor=\"#3F58D1\" bordercolorlight=\"#876BF3\" bordercolordark=\"#876BF3\"> \r\n";
sOut+=" <p align=\"right\">"+warnmax+" </td> \r\n";
sOut+=" <td width=\"30%\" height=\"18\" bordercolor=\"#3F58D1\" bordercolorlight=\"#876BF3\" bordercolordark=\"#876BF3\"> \r\n";
sOut+=" <p align=\"right\">"+warnmin+" </td> \r\n";
sOut+=" <td width=\"11%\" height=\"18\" bordercolor=\"#3F58D1\" bordercolorlight=\"#876BF3\" bordercolordark=\"#876BF3\"> \r\n";
sOut+=" <p align=\"center\"><a href=\""+CommonMethods.sCodeBase +"/SMSStockDZ?action=edit&gpdm="+stockcode+"\">编辑</a></td> \r\n";
sOut+=" <td width=\"10%\" height=\"18\" bordercolor=\"#3F58D1\" bordercolorlight=\"#876BF3\" bordercolordark=\"#876BF3\"> \r\n";
sOut+=" <p align=\"center\"><a href=\""+CommonMethods.sCodeBase +"/SMSStockDZ?action=delete&gpdm="+stockcode+"\">删除</a></td> \r\n";
sOut+=" </tr> \r\n";
sOut+="\r\n";
}//end while
}catch(Exception e){
}//end try
sOut+="</table> \r\n";
}//end if
DB.close ();
return sOut;
}
public String endString()
{
String sOut="";
sOut+=" <tr> \r\n";
sOut+=" <td align=\"right\" height=\"25\" width=\"274\">股票代码：</td> \r\n";
sOut+=" <td height=\"25\" width=\"254\"> \r\n";
sOut+=" <input name=stockcode type=text size=\"20\"> \r\n";
sOut+=" </td> \r\n";
sOut+=" </tr> \r\n";
sOut+=" <tr> \r\n";
sOut+=" <td align=\"right\" height=\"30\" width=\"274\">上限价格（元）：<br> \r\n";
sOut+=" (实际价格超出此价格时发出提醒) </td> \r\n";
sOut+=" <td height=\"30\" width=\"254\"> \r\n";
sOut+=" <!--webbot bot=\"Validation\" S-Data-Type=\"Number\"\r\n";
sOut+=" S-Number-Separators=\"x.\" --> \r\n";
sOut+=" <input name=warnmax type=text size=\"20\">\r\n";
sOut+=" </td>\r\n";
sOut+=" </tr>\r\n";
sOut+=" <tr> \r\n";
sOut+=" <td align=\"right\" height=\"30\" width=\"274\"> \r\n";
sOut+=" <p>下限价格（元）：<br>\r\n";
sOut+=" (实际价格低于此价格时发出提醒) </p>\r\n";
sOut+=" </td>\r\n";
sOut+=" <td height=\"30\" width=\"254\"> \r\n";
sOut+=" <!--webbot bot=\"Validation\" S-Data-Type=\"Number\"\r\n";
sOut+=" S-Number-Separators=\"x.\" --> \r\n";
sOut+=" <input name=warnmin type=text size=\"20\">\r\n";
sOut+=" </td>\r\n";
sOut+=" </tr>\r\n";
sOut+=" <tr> \r\n";
sOut+=" <td align=\"center\" height=\"16\" width=\"274\"> </td>\r\n";
sOut+=" <td height=\"16\" width=\"254\"> </td>\r\n";
sOut+=" </tr>\r\n";
sOut+=" <tr> \r\n";
sOut+=" <td align=\"center\" height=\"29\" width=\"274\"> </td>\r\n";
sOut+=" <td height=\"29\" width=\"254\"> \r\n";
sOut+=" <p> \r\n";
sOut+=" <input type=\"hidden\" name=\"action\" size=\"10\" value=\"\"> \r\n";
sOut+="\r\n";
sOut+=" <input type=\"submit\" name=\"Button\" value=\"增加\" onClick=\"setaction('add')\"> \r\n";
sOut+=" <input type=\"submit\" name=\"Button\" value=\"保存并添加\" onClick=\"setaction('addnew')\">\r\n";
sOut+=" \r\n";
sOut+=" <input type=\"button\" name=\"Button1\" value=\"取消\" onClick=\"javascript:gourl('/sms/lanmu.htm');\"> \r\n";
sOut+=" </p> \r\n";
sOut+=" </td> \r\n";
sOut+=" </tr> \r\n";
sOut+=" </table> \r\n";
sOut+=" </form> \r\n";
sOut+=" </td> \r\n";
sOut+=" </tr> \r\n";
sOut+=" </table> \r\n";
sOut+=" <p> </p> \r\n";
sOut+=" <!-- #EndEditable --></td> \r\n";
sOut+=" </tr> \r\n";
sOut+=" </table> \r\n";
sOut+=" \r\n";
sOut+=" </td> \r\n";
sOut+=" </tr> \r\n";
sOut+="</table> \r\n";
sOut+="</body> \r\n";
sOut+="<!-- #EndTemplate --></html> \r\n";
return sOut;
}
public String endString(String sUsername,String stockcode)
{
String warnmax="",warnmin="";
DBOperater DB=new DBOperater ("userstock");
ResultSet rs=DB.executeQuery ("select warnmax,warnmin from userstock where username='"+sUsername+"' and stockcode='"+stockcode+"'");
if(rs!=null){
try{
if(rs.next ()){
warnmax=rs.getString (1);
warnmin=rs.getString (2);
}
}
catch(Exception e){
System.out.println ("get warnmax,warnmin error:"+e.toString ());
}
}
String sOut="";
sOut+=" </td> \r\n";
sOut+=" </tr> \r\n";
sOut+=" <tr> \r\n";
sOut+=" <td align=\"right\" height=\"25\" width=\"274\">股票代码：</td> \r\n";
sOut+=" <td height=\"25\" width=\"254\"> "+stockcode+"\r\n";
sOut+=" <input name=stockcode type=hidden size=\"20\" value=\""+stockcode+"\"> \r\n";
sOut+=" </td> \r\n";
sOut+=" </tr> \r\n";
sOut+=" <tr> \r\n";
sOut+=" <td align=\"right\" height=\"30\" width=\"274\">上限价格（元）：<br> \r\n";
sOut+=" (实际价格超出此价格时发出提醒) </td> \r\n";
sOut+=" <td height=\"30\" width=\"254\"> \r\n";
sOut+=" <!--webbot bot=\"Validation\" S-Data-Type=\"Number\"\r\n";
sOut+=" S-Number-Separators=\"x.\" --> \r\n";
sOut+=" <input name=warnmax type=text size=\"20\" value=\""+warnmax+"\">\r\n";
sOut+=" </td>\r\n";
sOut+=" </tr>\r\n";
sOut+=" <tr> \r\n";
sOut+=" <td align=\"right\" height=\"30\" width=\"274\"> \r\n";
sOut+=" <p>下限价格（元）：<br>\r\n";
sOut+=" (实际价格低于此价格时发出提醒) </p>\r\n";
sOut+=" </td>\r\n";
sOut+=" <td height=\"30\" width=\"254\"> \r\n";
sOut+=" <!--webbot bot=\"Validation\" S-Data-Type=\"Number\"\r\n";
sOut+=" S-Number-Separators=\"x.\" --> \r\n";
sOut+=" <input name=warnmin type=text size=\"20\" value=\""+warnmin+"\">\r\n";
sOut+=" </td>\r\n";
sOut+=" </tr>\r\n";
sOut+=" <tr> \r\n";
sOut+=" <td align=\"center\" height=\"16\" width=\"274\"> </td>\r\n";
sOut+=" <td height=\"16\" width=\"254\"> </td>\r\n";
sOut+=" </tr>\r\n";
sOut+=" <tr> \r\n";
sOut+=" <td align=\"center\" height=\"29\" width=\"274\"> </td>\r\n";
sOut+=" <td height=\"29\" width=\"254\"> \r\n";
sOut+=" <p> \r\n";
sOut+=" <input type=\"hidden\" name=\"action\" size=\"10\" value=\"\"> \r\n";
sOut+="\r\n";
sOut+=" <input type=\"submit\" name=\"Button\" value=\"增加\" onClick=\"setaction('add')\"> \r\n";
sOut+=" <input type=\"submit\" name=\"Button2\" value=\"保存并添加\" onClick=\"setaction('addnew')\">\r\n";
sOut+=" \r\n";
sOut+=" <input type=\"button\" name=\"Button1\" value=\"取消\" onClick=\"javascript:gourl('/sms/lanmu.htm');\"> \r\n";
sOut+=" </p> \r\n";
sOut+=" </td> \r\n";
sOut+=" </tr> \r\n";
sOut+=" </table> \r\n";
sOut+=" </form > \r\n";
sOut+=" </td> \r\n";
sOut+=" </tr> \r\n";
sOut+=" </table> \r\n";
sOut+=" <p> </p> \r\n";
sOut+=" <!-- #EndEditable --></td> \r\n";
sOut+=" </tr> \r\n";
sOut+=" </table> \r\n";
sOut+=" \r\n";
sOut+=" </td> \r\n";
sOut+=" </tr> \r\n";
sOut+="</table> \r\n";
sOut+="</body> \r\n";
sOut+="<!-- #EndTemplate --></html> \r\n";
return sOut;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -