KickJava   Java API By Example, From Geeks To Geeks.

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


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