KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > quikj > application > web > talk > plugin > SessionLeaveCDR


1 /*
2  * SessionCDR.java
3  *
4  * Created on June 29, 2002, 3:38 PM
5  */
6
7 package com.quikj.application.web.talk.plugin;
8
9 import java.sql.*;
10
11 /**
12  *
13  * @author amit
14  */
15 public class SessionLeaveCDR implements CDRInterface
16 {
17     // database table name constant
18 private static final String JavaDoc SESSION_LEAVE_CDR_TABLE_NAME = "cdr_session_leave_tbl";
19     
20     // database table column name constants
21 private static final String JavaDoc SESSION = "session";
22     private static final String JavaDoc ENDPOINT = "endpoint";
23     private static final String JavaDoc TIMESTAMP = "time_stamp";
24     
25     private String JavaDoc session;
26     private String JavaDoc endpoint;
27     private java.util.Date JavaDoc timestamp;
28
29     
30     /** Creates a new instance of SessionCDR */
31     public SessionLeaveCDR(String JavaDoc session, String JavaDoc endpoint)
32     {
33         timestamp = new java.util.Date JavaDoc();
34         this.session = session;
35         this.endpoint = endpoint;
36     }
37     
38     public PreparedStatement generateSQLCDR()
39     throws SQLException
40     {
41         String JavaDoc sql = "insert into "
42         + SESSION_LEAVE_CDR_TABLE_NAME
43         + " values (?, ?, ?)";
44         
45         PreparedStatement ps = CDRHandler.getInstance().getConnection().prepareStatement(sql);
46         ps.setString(1, session);
47         ps.setString(2, endpoint);
48         ps.setTimestamp(3, new java.sql.Timestamp JavaDoc(timestamp.getTime()));
49         return ps;
50     }
51     
52     public String JavaDoc generateXMLCDR()
53     {
54         return "<CDR type=\"session-leave\" session=\"" + session
55         + "\" id=\"" + endpoint
56         + "\" time-stamp=\"" + timestamp.getTime() + "\"/>\n";
57     }
58 }
59
Popular Tags