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);
- %>