KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * UnregisteredUserLoginCDR.java
3  *
4  * Created on June 29, 2002, 1:56 PM
5  */
6
7 package com.quikj.application.web.talk.plugin;
8
9 import com.quikj.server.framework.*;
10 import java.sql.*;
11 /**
12  *
13  * @author amit
14  */
15 public class UnregisteredUserLoginCDR implements CDRInterface
16 {
17     // database table name constant
18 private static final String JavaDoc UNREGISTERED_LOGIN_CDR_TABLE_NAME = "cdr_unreg_login_tbl";
19     
20     // database table column name constants
21 private static final String JavaDoc LOGIN_ID = "loginid";
22     private static final String JavaDoc NAME = "name";
23     private static final String JavaDoc ADDRESS = "address";
24     private static final String JavaDoc TIMESTAMP = "time_stamp";
25     private static final String JavaDoc ADDITIONAL_INFO = "addnl_info";
26     
27     private String JavaDoc loginId;
28     private String JavaDoc name;
29     private String JavaDoc email;
30     private String JavaDoc additional;
31     private java.util.Date JavaDoc timestamp;
32     
33     /** Creates a new instance of UnregisteredUserLoginCDR */
34     public UnregisteredUserLoginCDR(String JavaDoc id,
35     String JavaDoc name,
36     String JavaDoc email,
37     String JavaDoc additional)
38     {
39         loginId = id;
40         this.email = email;
41         this.name = name;
42         this.additional = additional;
43         timestamp = new java.util.Date JavaDoc();
44     }
45     
46     public PreparedStatement generateSQLCDR()
47     throws SQLException
48     {
49         String JavaDoc sql = "insert into "
50         + UNREGISTERED_LOGIN_CDR_TABLE_NAME
51         + " values (?, ?, ?, ?, ?)";
52         
53         PreparedStatement ps = CDRHandler.getInstance().getConnection().prepareStatement(sql);
54         ps.setString(1, loginId);
55         ps.setString(2, name == null ? "" : name);
56         ps.setString(3, email == null ? "" : email);
57         ps.setTimestamp(4, new java.sql.Timestamp JavaDoc(timestamp.getTime()));
58         ps.setString(5, additional == null ? "" : additional);
59         return ps;
60     }
61     
62     public String JavaDoc generateXMLCDR()
63     {
64         StringBuffer JavaDoc buffer = new StringBuffer JavaDoc("<CDR type=login id=\""
65         + loginId + "\"");
66         
67         if (name != null)
68         {
69             buffer.append(" name=\"" + AceXMLHelper.encodeXMLString(name) + "\"");
70         }
71         
72         if (email != null)
73         {
74             buffer.append (" email=\"" + AceXMLHelper.encodeXMLString(email) + "\"");
75         }
76         
77         buffer.append(" time-stamp=\"" + timestamp.getTime() + "\">\n");
78         
79         if (additional != null)
80         {
81            buffer.append("<additional-info>" + AceXMLHelper.encodeXMLString(additional)
82            + "</additional-info>\n");
83         }
84         
85         buffer.append("</CDR>\n");
86         return buffer.toString();
87     }
88 }
89
Popular Tags