KickJava   Java API By Example, From Geeks To Geeks.

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


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 SessionSetupResponseCDR implements CDRInterface
16 {
17     // database table name constant
18 private static final String JavaDoc SESSION_SETUP_RESP_CDR_TABLE_NAME = "cdr_session_setup_resp_tbl";
19     
20     // database table column name constants
21 private static final String JavaDoc SESSION = "session";
22     private static final String JavaDoc CALLED = "loginid";
23     private static final String JavaDoc STATUS = "status";
24     private static final String JavaDoc TIMESTAMP = "time_stamp";
25     
26     private String JavaDoc session;
27     private int status;
28     private java.util.Date JavaDoc timestamp;
29     private String JavaDoc called;
30
31     
32     /** Creates a new instance of SessionCDR */
33     public SessionSetupResponseCDR(String JavaDoc session, String JavaDoc called_name, int status)
34     {
35         timestamp = new java.util.Date JavaDoc();
36         this.session = session;
37         called = called_name;
38         this.status = status;
39     }
40     
41     public PreparedStatement generateSQLCDR()
42     throws SQLException
43     {
44         String JavaDoc sql = "insert into "
45         + SESSION_SETUP_RESP_CDR_TABLE_NAME
46         + " values (?, ?, ?, ?)";
47   
48         PreparedStatement ps = CDRHandler.getInstance().getConnection().prepareStatement(sql);
49         ps.setString(1, session);
50         ps.setString(2, called);
51         ps.setInt(3, status);
52         ps.setTimestamp(4, new java.sql.Timestamp JavaDoc(timestamp.getTime()));
53         return ps;
54     }
55     
56     public String JavaDoc generateXMLCDR()
57     {
58         return "<CDR type=\"session-setup-response\" session=\"" + session
59         + "\" called=\"" + called
60         + "\" status=\"" + status
61         + "\" time-stamp=\"" + timestamp.getTime() + "\"/>\n";
62     }
63 }
64
Popular Tags