![]() |
<script language="JavaScript" type="text/javascript" src=".../counter.jsp">
都先導到counter.jsp做資料庫存取
ecND_ADBANNERINFO adinfo = gpcommontk.getAdBannerInfo("代號");
gpcommontk.logAdBannerInfo(adinfo);
但不知道前端(JavaScript)怎麼動態去控制後端(JSP)做存取...
<html>
<head>
<title>AD Click Counter</title>
<script type="text/javascript" src="jquery-1.2.6.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$("a").click(function(event){
var ad = $(this).attr("name");
var target = $(this).text();
$.get('counter.jsp?ad='+ad);
alert("Thanks for visiting "+ target +" !");
});
});
</script>
</head>
<body>
<a href="http://jquery.com/" name="ad1">jQuery</a>
<a href="http://andowson.com/" name="ad2">Andowson</a>
<a href="http://google.com/" name="ad3">Google</a>
<a href="http://yahoo.com/" name="ad4">Yahoo!</a>
<a href="http://microsoft.com/" name="ad5">Microsoft</a>
</body>
</html>
<%@page import="java.util.*" %>
<%!
// we use a Map(key, value) to store each ad's count
static Map counters = new HashMap();
%>
<%
// get the ad's name
String name = request.getParameter("ad");
int count = 0;
// get back the previous count if this ad has been clicked
if (counters.containsKey(name)) {
count = (Integer)counters.get(name);
}
// add this ad's counter into map
if (name != null) {
synchronized (counters) {
counters.put(name, ++count);
counters.notify();
}
}
// print all of the counters' names and values
Iterator iterator = counters.keySet().iterator();
while (iterator.hasNext()) {
String key = (String)iterator.next();
int value = (Integer)counters.get(key);
System.out.println(key+"="+value);
out.println(key+"="+value+"<br>");
}
%>
檔案名稱 | index.html |
描述 | index.html |
檔案大小 | 755 bytes |
下載次數 | 50 次 |
![]() |
檔案名稱 | counter.jsp |
描述 | counter.jsp |
檔案大小 | 922 bytes |
下載次數 | 42 次 |
![]() |
<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"
version="2.4">
<display-name>ajaxDWR</display-name>
<servlet>
<servlet-name>dwr-invoker</servlet-name>
<servlet-class>uk.ltd.getahead.dwr.DWRServlet</servlet-class>
<init-param>
<description></description>
<param-name>debug</param-name>
<param-value>true</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>dwr-invoker</servlet-name>
<url-pattern>/dwr/*</url-pattern>
</servlet-mapping>
</web-app>
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE dwr PUBLIC "-//GetAhead Limited//DTD Direct Web Remoting 1.0//EN"
"http://www.getahead.ltd.uk/dwr/dwr10.dtd">
<dwr>
<allow>
<create creator="new" javascript="Counter">
<param name="class" value="Counter" />
</create>
</allow>
</dwr>
import java.util.*;
import java.io.*;
import org.w3c.dom.*;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import java.net.*;
import java.sql.*;
import java.security.*;
import javax.net.ssl.*;
import java.util.*;
import java.util.zip.*;
import javax.mail.*;
import javax.mail.internet.*;
import javax.activation.*;
import com.gemmyplanet.dbbean.DBOperationBean;
public class Counter {
public void counter( Integer BANNERNO) {
//=====================================================
// 宣告參數
//=====================================================
Integer ADBANNERNO = null;
String SERVICEID = null;
String CHANNELID = "";
String ADBANNERTYPE = null;
String TARGETURL = null;
String CLICKDATETIME = null;
String CHECKSUM = null;
String IMAGEDB = "GP_NEW_DB";
Connection dbCon = null;
Statement stmt = null;
ResultSet rs = null;
//=====================================================
// 日期 14位
//=====================================================
String ft_t = "yyyyMMddHHmmss";
String ft = ft_t.substring(0, 14);
//=====================================================
// 資料庫連線 && 更新資料
//=====================================================
try {
DBOperationBean dbOprBean = new DBOperationBean();
dbOprBean.setDatasource("DS_GP_NEW_DB");
dbCon = dbOprBean.getConnection();
if ( dbCon != null && !dbCon.isClosed() ){
stmt = dbCon.createStatement();
rs = stmt.executeQuery("SELECT * FROM "+ IMAGEDB +".ADBANNERINFO WHERE ADBANNERNO="+ BANNERNO);
if( rs != null ) {
while( rs.next() ) {
stmt.executeUpdate("INSERT INTO "+IMAGEDB+".ADBANNERLOGINFO SET SERVICEID='"+rs.getString("SERVICEID")+"', ADBANNERTYPE='"+rs.getString("ADBANNERTYPE")+"', TARGETURL='"+rs.getString("TARGETURL")+"', CLICKDATETIME='"+util.DateUtil.formatString(new java.util.Date(), ft)+"'");
}
}
stmt.close();
dbCon.close();
}
} catch (Exception ex) {
try {
if ( dbCon != null && !dbCon.isClosed() ){
stmt.close();
dbCon.close();
}
} catch( Exception e ) {}
}
}
}
function counter(num) {
Counter.counter(num);
}
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=BIG5">
<title>第一個DWR程式</title>
//========================================
//dwr/interface/Counter.js是由DWRServlet根據dwr.xml中的設定生成的
//engine.js負責客戶端伺服端溝通
//util.js是一些好用的JavaScript程式,可以讓您少寫很多JavaScript。
//page_counter.js呼叫後端.java檔
//========================================
<script type='text/javascript' src='dwr/interface/Counter.js'></script>
<script type='text/javascript' src='dwr/engine.js'></script>
<script type='text/javascript' src='dwr/util.js'></script>
<script type='text/javascript' src='page_counter.js'></script>
</head>
<script language="Javascript">
function test(num,url) {
counter(num);
location.href = url;
}
function test1(num) {
counter(21);
}
</script>
<body>
<table>
<tr>
<td>測試</td>
</tr>
</table>
<input type='button' value='測試' onclick="test(21,'http://www.yahoo.com.tw')">
</body>
</html>