带QQ表情的留言

使用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" onclick="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>