带QQ表情的留言

最新推荐文章于 2021-03-25 20:41:30 发布

facepp

最新推荐文章于 2021-03-25 20:41:30 发布

阅读量1.6k

点赞数

分类专栏： javascript java 文章标签： qq html string function import url

本文链接：https://blog.csdn.net/facepp/article/details/2709089

版权

java 同时被 2 个专栏收录

252 篇文章 0 订阅

订阅专栏

javascript

58 篇文章 0 订阅

订阅专栏

使用ajax从数据库中取qq表情图片对应的快捷方式 /se

USE `demo`;
CREATE TABLE `qq` (
`id` int(11) NOT NULL auto_increment,
`pic` text,
`short` varchar(11) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
INSERT INTO `qq` VALUES (1,'qq/0.gif','wx');

有QQ表情的留言页
<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <title></title>
<script type="text/javascript" src="net.js"></script>
<script type="text/javascript">
function addtoText(oElem){
        var strValue = oElem;
        var oTarget="content";
        var url = 'getShort.jsp';
        var strParams = 'q=' + strValue +
                        "&e=" +oTarget;
        var loader1 = new
        net.ContentLoader(url,FillDropDown,null,
                    "POST",strParams);
      }
      function FillDropDown(){
        var xmlDoc = this.req.responseXML.documentElement;
        var xSel = xmlDoc.getElementsByTagName("selectElement")[0];
        var strEName = xSel.childNodes[0].firstChild.nodeValue;
       var xRows = xmlDoc.getElementsByTagName("entry")[0];
          var theValue = xRows.childNodes[0].firstChild.nodeValue;
  document.getElementById(strEName).value+="/"+theValue;
  document.getElementById(strEName).focus();
      }

</script>
</head>

<body>
<form action="">
<table width="100%">
<tr> <td>
<%
    for(int i=0;i<30;i++)
    {
    %>
    <img src="qq/<%=i%>.gif" οnclick="addtoText(<%=i+1%>)">
    <%
      if(i%17==0&&i!=0)   //18个图标排一行
      {
       out.println("<br>");
      }
     %>
    <%
    }
   %>
   </td>
</tr>
<tr><td>
<textarea name="content" id="content" cols="60" rows="10"></textarea>
</td></tr>
</table>
</form>
   </body>
</html>

getShort.jsp
<%@ page language="java" import="java.util.*,java.sql.*,java.io.*" pageEncoding="GB2312"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <title></title>
</head>
<body>
   <%
String strElem=request.getParameter("e");
    String strQuery =request.getParameter("q");
Class.forName("com.mysql.jdbc.Driver").newInstance();
String   url   ="jdbc:mysql://localhost/demo?user=root&password=";
Connection   conn=   DriverManager.getConnection(url);
Statement   stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
   String   sql="select short from qq where id="+strQuery;
ResultSet   rs=stmt.executeQuery(sql);
        StringBuilder strXML =new StringBuilder("<?xml version='1.0' ?>");
      strXML.append("<selectChoice>");
       strXML.append("<selectElement>");
         strXML.append("<formElem>"+strElem+"</formElem>");
          strXML.append("</selectElement>");
           if(rs.next())
             {
            strXML.append("<entry>");
            strXML.append("<optionValue>"+rs.getString("short")+"</optionValue>");
            strXML.append("</entry>");
             }
             strXML.append("</selectChoice>");
         response.setContentType("text/xml");
         PrintWriter out2= response.getWriter();
         out2.write(strXML.toString());
         out2.close();
    %>
</body>
</html>

facepp

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
带QQ表情的留言

使用ajax从数据库中取qq表情图片对应的快捷方式 /seUSE `demo`;CREATE TABLE `qq` ( `id` int(11) NOT NULL auto_increment, `pic` text, `short` varchar(11) default NULL, PRIMARY KEY (`id`)) TYPE=MyISAM;INSERT INTO `qq`
复制链接

扫一扫

专栏目录