Ajax相关代码

来源：互联网发布：ug nx 8.5编程编辑：程序博客网时间：2024/06/01 09:07
a1.html
<script language="javascript" type="text/javascript">
   var request = false;
   try 
   {
      request = new XMLHttpRequest();
   } 
   catch (trymicrosoft) 
   {
      try 
      {
         request = new ActiveXObject("Msxml2.XMLHTTP");
      } 
      catch (othermicrosoft) 
      {
         try 
         {
            request = new ActiveXObject("Microsoft.XMLHTTP");
         } 
         catch (failed) 
         {
            request = false;
         }
      }
   }
   if (!request)
      alert("Error initializing XMLHttpRequest!");
   function queryIt() 
   {
      var campn = document.getElementById("campn").value;
      var url = "/imkt/a2.jsp?campn=" + escape(campn);
      request.open("GET", url, true);
      request.onreadystatechange = updatePage;
      request.send(null);
   }
   function updatePage() 
   {
      if (request.readyState == 4) 
      {
         if (request.status == 200) 
         {
            var response = request.responseText.split("|");
            var tableElement = document.getElementById("not_called_out");
            if (tableElement != null) 
            {
               var trElement=tableElement.insertRow(1);
            
               var txtElement0=document.createTextNode(response[0]);
               var tdElement0=trElement.insertCell(0);
               tdElement0.appendChild(txtElement0);
            
               var txtElement1=document.createTextNode(response[1]);
               var tdElement1=trElement.insertCell(1);
               tdElement1.appendChild(txtElement1);
            
               var txtElement2=document.createTextNode(response[2]);
               var tdElement2=trElement.insertCell(2);
               tdElement2.appendChild(txtElement2);
            
               var txtElement3=document.createTextNode(response[3]);
               var tdElement3=trElement.insertCell(3);
               tdElement3.appendChild(txtElement3);
            }
         }
         else
            alert("status is " + request.status);
      }
   }
</script>
<html>
<head>
<title>
工单实施
</title>
</head>
<body>
  <br/>
  <p>工单池</p>
  <table>
     <tr>
        <td>未呼出工单</td> <td>营销活动名称：<input type="text" size="14" name="campn" id="campn"/></td> 
        <td>联系电话号码：<input type="text" size="14" name="phone" id="phone"/></td> 
        <td><input type="button" value="查询" id="query" onClick="queryIt();"  /></td>
        <td>符合条件总数：</td><td><div id="address"></div>条</td>
        <td><input type="button" value="呼出" id="callout" onClick="getCustomerInfo();"  /></td>
     </tr>
  </table>
  <br/>
  <table border  id="not_called_out">
     <tr>
        <td>活动名称</td> <td>客户名称</td> <td>联系电话</td>  <td>预约时间</td> 
     </tr>
  </table>
  <br/>
  <br/>
</body>
</html>
数据库连接 <%@ page  language="java" contentType="text/html; charset=gb2312"
import = "java.sql.*,com.codestudio.util.*" %>
<%
   String campn = request.getParameter( "campn" );
   String sql_str = "select SALE_PLAN_ID, CUST_ID, STATE, SALE_RST from SALE_ITEM where SALE_PLAN_ID= "+ campn;
   SQLManager myMan = SQLManager.getInstance();
     Connection myConn= myMan.requestConnection();
     Statement stmt   = myConn.createStatement();
     ResultSet myResultSet= stmt.executeQuery(sql_str);
     if (myResultSet != null)
     {
        while (myResultSet.next())
        {
           String plan_id=myResultSet.getString("SALE_PLAN_ID");
           String cust_id=myResultSet.getString("CUST_ID");
           String state=myResultSet.getString("STATE");
           String sale_rst=myResultSet.getString("SALE_RST");
                
                 out.print(plan_id);
                 out.print("|");
                 out.print(cust_id);
                 out.print("|");
                 out.print(state);
                 out.print("|");
                 out.print(sale_rst);
        }
     }
     stmt.close();
     myMan.returnConnection(myConn);
%>