KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * RegisteredUserLogoutCDR.java
3  *
4  * Created on June 28, 2002, 12: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 LogoutCDR implements CDRInterface
16 {
17     
18     /** Creates a new instance of RegisteredUserLogoutCDR */
19     public LogoutCDR(String JavaDoc loginid)
20     {
21         loginId = loginid;
22         timestamp = new java.util.Date JavaDoc();
23     }
24     
25     public PreparedStatement generateSQLCDR()
26     throws SQLException
27     {
28         String JavaDoc sql = "insert into "
29         + LOGOUT_CDR_TABLE_NAME
30         + " values (?, ?)";
31         
32         PreparedStatement ps = CDRHandler.getInstance().getConnection().prepareStatement(sql);
33         ps.setString(1, loginId);
34         ps.setTimestamp(2, new java.sql.Timestamp JavaDoc(timestamp.getTime()));
35         return ps;
36     }
37     
38     public String JavaDoc generateXMLCDR()
39     {
40         return "<CDR type=logout id=\""
41         + loginId + "\" time-stamp=\"" + timestamp.getTime() + "\"/>\n";
42     }
43     
44     // database table name constant
45 private static final String JavaDoc LOGOUT_CDR_TABLE_NAME = "cdr_logout_tbl";
46     
47     // database table column name constants
48 private static final String JavaDoc LOGIN_ID = "loginid";
49     private static final String JavaDoc TIMESTAMP = "time_stamp";
50
51     
52     private String JavaDoc loginId;
53     private java.util.Date JavaDoc timestamp;
54 }
55
Popular Tags