org.ifeth.sehr.beans
Class UserData

java.lang.Object
  |
  +--org.ifeth.sehr.lib.DAOBase
        |
        +--org.ifeth.sehr.beans.UserData

Direct Known Subclasses:

SessionData

public class UserData

extends DAOBase

Data handle for processing users, their services and administrative data.

Implemented as a bean with some methods that return preformatted data for suitable access, e.g. as HTML table for JSP/JWS pages.

Version:

$Id: UserData.java,v 1.13 2005/01/16 12:15:57 hansjhaase Exp $

Author:

hansjhaase

Constructor Summary

UserData()

UserData(int usrid, int uid, int gid, java.lang.String usrname, java.lang.String surname, java.lang.String firstname, java.lang.String info, java.lang.String notes, java.lang.String home, java.lang.String reqmail, int usrtype, int usrsts)

Method Summary

boolean	addAccess() Add new contact record for current opened user.
boolean	addContact() Add new contact record for current opened user.
static boolean	addRecord(UserData ud) Save a new user record using the SEHR wrapper module 'accadmin.pl'.
void	clearContactData() Clear and init new contact data fields in current UserData object
int	countUsers()
boolean	deleteRecord(UserData rec) Deletes a user record from USR_MAIN which was never used.
boolean	deleteUsrAccess(int recid) Delete PPP record.
boolean	deleteUsrContact(int adrid) Delete the contact record given by id.
boolean	deleteUsrService(int usrid, int svid) Delete servicerecord given by id.
UserData	findUser(java.lang.String usrname) Deprecated. use 'selectRecord(String)'
java.lang.String	getAdr_adr1()
java.lang.String	getAdr_adr2()
java.lang.String	getAdr_adr3()
java.lang.String	getAdr_city()
int	getAdr_defid()
java.lang.String	getAdr_email1()
java.lang.String	getAdr_fax1()
java.lang.String	getAdr_fon1()
java.lang.String	getAdr_match()
java.lang.String	getAdr_mobil1()
java.lang.String	getAdr_street()
java.lang.String	getAdr_title()
java.lang.String	getAdr_zip()
int	getAdrid()
SEHRCfg	getCfg()
java.sql.Connection	getCon()
int	getContactCount(int usrid) Get number of contacts for current dataset or given usrid
java.lang.String	getContactDefs() Get contact definitions by table DEF_CONTACT
static java.lang.String	getContactsSelect() Get a SELECT list of each(!)
static java.lang.String	getContactsSelect(SEHRCfg cfg) Get a SELECT list of each(!)
java.lang.String	getFilter_usrname()
java.lang.String	getFirstname()
java.lang.String	getFullname()
int	getGid()
java.lang.String	getHome()
int	getHomezone()
java.lang.String	getInfo()
boolean	getLogin()
java.lang.String	getMsgstatus()
java.lang.String	getNotes()
java.lang.String	getPpp_dns1()
java.lang.String	getPpp_dns2()
java.lang.String	getPpp_login()
java.lang.String	getPpp_node()
java.lang.String	getPpp_nodeip()
java.lang.String	getPpp_passwd()
int	getPpp_recid()
java.lang.String	getPpp_rip()
int	getPpp_usrid()
int	getPPPCount(int usrid) Get number of accesspoints for current dataset or given usrid
java.lang.String	getReqmail()
int	getStatus()
java.lang.String	getSurname()
int	getSv_count(int usrid) Get number of services for current dataset or given usrid
java.lang.String	getSv_ftpdir()
java.lang.String	getSv_login()
java.lang.String	getSv_menutitle()
java.lang.String	getSv_passwd()
int	getSv_status()
java.lang.String	getSv_urlstart()
int	getSvid()
int	getUid()
UserData	getUserByID(int usrid) Deprecated. use selectRecord(...
UserData	getUserByID(int usrid, UserData udrec) Deprecated. use selectRecord(...
UserData	getUserByID(java.lang.String usrid)
java.util.List	getUserList()
java.lang.String	getUserListPlain()
java.lang.String	getUserListPlain(java.lang.String search)
java.sql.ResultSet	getUserResultSet() Get a resultset of all records of table USR_MAIN
void	getUsrAccess(int recid) Get access data USR_PPP for given recid
java.lang.String	getUsrAccounts(int fmt, int id) Get services where user by 'usrid' is registered in a usable format 'fmt'
java.lang.String	getUsrAccountsHTMLSelect() Get services of current record as HTML SELECT...OPTION This method requires a valid instance with data loaded in memory.
java.lang.String	getUsrAccountsHTMLTable() Get services of current record as HTML table.
boolean	getUsrContact(int adrid) Get address record from USR_CONTACT
java.lang.String	getUsrContactHTML() Get preformated address of class
java.lang.String	getUsrContactsSelect() Get a SELECT list only presenting the category of each address record assigned to the given user.
static java.lang.String	getUsrContactsSelect(int usrid, int adrid, SEHRCfg cfg, boolean catlistonly)
int	getUsrid()
java.lang.String	getUsrname()
java.lang.String	getUsrpass()
void	getUsrService(int svid) Get one record (svid >=0 ) or all records (svid = -1) for user from USR_SERVICES
void	getUsrService(int svid, UserData ud) Get one record (svid >=0 ) or all records (svid = -1) for user from USR_SERVICES for handle 'userdata'
java.lang.String	getUsrServices(int fmt, int id) Get services where user by 'usrid' is registered in a usable format 'fmt'
java.lang.String	getUsrServicesHTMLSelect() Get services of current record as HTML SELECT...OPTION This method requires a valid instance with data loaded in memory.
java.lang.String	getUsrServicesHTMLTable() Get services of current record as HTML table.
int	getUsrtype()
void	init()
void	init(java.lang.String cfgf)
void	initConnection()
void	initUserData(SEHRCfg cfg)
boolean	insertUsrServices(int usrid)
boolean	is_cfg()
boolean	isLoggedIn()
boolean	isNULLOrEmpty(java.lang.String s) Check if a String is null or empty.
static void	main(java.lang.String[] args) for testing only....
static java.sql.ResultSet	readUserList(SEHRCfg sehrcfg, java.lang.String whereclause)
static java.util.List	readUserList(UserData ud)
static java.sql.ResultSet	readUserList(UserData ud, java.lang.String whereclause) Deprecated.
boolean	selectRecord(int usrid) Load user record from db for given usrid into current UD object
static UserData	selectRecord(int usrid, SEHRCfg cfg) This method selects a user by 'usrid' from db and put the record data into a given UserData object using a given SEHR configuration object.
static UserData	selectRecord(int usrid, UserData ud) Load user record for given usrid into given UserData object.
void	selectRecord(java.lang.String usrname) Load user record for given username into current UserData object.
UserData	selectRecord(java.lang.String usrname, UserData ud) Load user record for given user into the given UserData object.
static void	sendAccountRequest(java.lang.String usrname, java.lang.String reqmail, java.lang.String text)
static java.lang.String	sendAccountServices(UserData ud)
void	setAdr_adr1(java.lang.String adr1)
void	setAdr_adr2(java.lang.String adr2)
void	setAdr_adr3(java.lang.String adr3)
void	setAdr_city(java.lang.String string)
void	setAdr_defid(int i)
void	setAdr_email1(java.lang.String email)
void	setAdr_fax1(java.lang.String fax)
void	setAdr_fon1(java.lang.String fon)
void	setAdr_match(java.lang.String match)
void	setAdr_mobil1(java.lang.String mobile)
void	setAdr_street(java.lang.String street)
void	setAdr_title(java.lang.String string)
void	setAdr_zip(java.lang.String string)
void	setAdrid(int i)
void	setCfg(SEHRCfg cfg)
void	setFilter_usrname(java.lang.String filter_usrname)
void	setFirstname(java.lang.String string)
void	setGid(int i)
void	setHome(java.lang.String string)
void	setHomezone(int i)
void	setInfo(java.lang.String string)
void	setLoggedIn(boolean login)
void	setLogin(boolean b)
void	setMsgstatus(java.lang.String string)
void	setNotes(java.lang.String string)
void	setPpp_dns1(java.lang.String string)
void	setPpp_dns2(java.lang.String string)
void	setPpp_login(java.lang.String string)
void	setPpp_node(java.lang.String string)
void	setPpp_nodeip(java.lang.String string)
void	setPpp_passwd(java.lang.String string)
void	setPpp_recid(int i)
void	setPpp_rip(java.lang.String string)
void	setPpp_usrid(int i)
void	setReqmail(java.lang.String string)
void	setStatus(int i)
void	setSurname(java.lang.String string)
void	setSv_ftpdir(java.lang.String string)
void	setSv_login(java.lang.String string)
void	setSv_menutitle(java.lang.String string)
void	setSv_passwd(java.lang.String string)
void	setSv_status(int i)
void	setSv_urlstart(java.lang.String s)
void	setSvid(int i)
void	setUid(int i)
void	setUsrid(int i)
void	setUsrname(java.lang.String string)
void	setUsrpass(java.lang.String usrpass)
void	setUsrtype(int i)
boolean	updateAccess(int recid) Update an existing PPP record.
int	updateBasicServices(int svid) Assign the given basic service to each(!)
static int	updateBasicServices(int svid, SEHRCfg cfg)
boolean	updateContact(int adrid) Update an existing contact record.
boolean	updateRecord() Update an existing user record.
boolean	updateUsrServices(int usrid)

Methods inherited from class org.ifeth.sehr.lib.DAOBase

getOptionList, getResList, setSEHRDataSource

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

UserData

public UserData()

UserData

public UserData(int usrid,
                int uid,
                int gid,
                java.lang.String usrname,
                java.lang.String surname,
                java.lang.String firstname,
                java.lang.String info,
                java.lang.String notes,
                java.lang.String home,
                java.lang.String reqmail,
                int usrtype,
                int usrsts)

Method Detail

init

public void init()

init

public void init(java.lang.String cfgf)

initUserData

public void initUserData(SEHRCfg cfg)

initConnection

public void initConnection()

isLoggedIn

public boolean isLoggedIn()

setLoggedIn

public void setLoggedIn(boolean login)

getFirstname

public java.lang.String getFirstname()

getSurname

public java.lang.String getSurname()

getFullname

public java.lang.String getFullname()

getGid

public int getGid()

getHome

public java.lang.String getHome()

getInfo

public java.lang.String getInfo()

getNotes

public java.lang.String getNotes()

getReqmail

public java.lang.String getReqmail()

getUid

public int getUid()

getUsrid

public int getUsrid()

getUsrname

public java.lang.String getUsrname()

getUsrpass

public java.lang.String getUsrpass()

setUsrpass

public void setUsrpass(java.lang.String usrpass)

getUsrtype

public int getUsrtype()

setFirstname

public void setFirstname(java.lang.String string)

Parameters:

string -

setGid

public void setGid(int i)

Parameters:

i -

setHome

public void setHome(java.lang.String string)

Parameters:

string -

setInfo

public void setInfo(java.lang.String string)

Parameters:

string -

setNotes

public void setNotes(java.lang.String string)

Parameters:

string -

setReqmail

public void setReqmail(java.lang.String string)

Parameters:

string -

setSurname

public void setSurname(java.lang.String string)

Parameters:

string -

setUid

public void setUid(int i)

Parameters:

i -

setUsrid

public void setUsrid(int i)

Parameters:

i -

setUsrname

public void setUsrname(java.lang.String string)

Parameters:

string -

setUsrtype

public void setUsrtype(int i)

Parameters:

i -

getLogin

public boolean getLogin()

getStatus

public int getStatus()

getSvid

public int getSvid()

setLogin

public void setLogin(boolean b)

setStatus

public void setStatus(int i)

setSvid

public void setSvid(int i)

getSv_count

public int getSv_count(int usrid)

Get number of services for current dataset or given usrid

getContactCount

public int getContactCount(int usrid)

Get number of contacts for current dataset or given usrid

getPPPCount

public int getPPPCount(int usrid)

Get number of accesspoints for current dataset or given usrid

getMsgstatus

public java.lang.String getMsgstatus()

setMsgstatus

public void setMsgstatus(java.lang.String string)

Parameters:

string -

getAdr_email1

public java.lang.String getAdr_email1()

getAdr_fax1

public java.lang.String getAdr_fax1()

getAdr_fon1

public java.lang.String getAdr_fon1()

getAdr_mobil1

public java.lang.String getAdr_mobil1()

setAdr_email1

public void setAdr_email1(java.lang.String email)

setAdr_fax1

public void setAdr_fax1(java.lang.String fax)

setAdr_fon1

public void setAdr_fon1(java.lang.String fon)

setAdr_mobil1

public void setAdr_mobil1(java.lang.String mobile)

isNULLOrEmpty

public boolean isNULLOrEmpty(java.lang.String s)

Check if a String is null or empty.

getUsrServicesHTMLTable

public java.lang.String getUsrServicesHTMLTable()

Get services of current record as HTML table. This method requires a valid instance with data loaded in memory.

getUsrServicesHTMLSelect

public java.lang.String getUsrServicesHTMLSelect()

Get services of current record as HTML SELECT...OPTION This method requires a valid instance with data loaded in memory.

getUsrServices

public java.lang.String getUsrServices(int fmt,
                                       int id)

Get services where user by 'usrid' is registered in a usable format 'fmt'

Parameters:

fmt - 0=CSV, 1=HTML table, 2=HTML SELECTION

Returns:

String

deleteRecord

public boolean deleteRecord(UserData rec)

Deletes a user record from USR_MAIN which was never used.

The purpose of this method is to clean up pending registrations etc.

addRecord

public static boolean addRecord(UserData ud)

Save a new user record using the SEHR wrapper module 'accadmin.pl'.

'accadmin.pl' takes the data as args and creates a useraccount at

/etc/passwd

the SEHR account database, table USR_MAIN;

NB:
The SAMBA flag is set to 0 here; SAMBA is a local service and should be managed by local administration toos like WEBMIN for LAN users only
The UID and GID is generated by the system to prevent double values. Due to this procedure the db record will be insertet AFTER the system process.

updateRecord

public boolean updateRecord()

Update an existing user record.

Note:
It is not allowed to change the system account identification, defined by usrname. This is a lifelong identification (like SSN) :)

addContact

public boolean addContact()

Add new contact record for current opened user.

updateContact

public boolean updateContact(int adrid)

Update an existing contact record.

getUsrAccountsHTMLTable

public java.lang.String getUsrAccountsHTMLTable()

Get services of current record as HTML table. This method requires a valid instance with data loaded in memory.

getUsrAccountsHTMLSelect

public java.lang.String getUsrAccountsHTMLSelect()

Get services of current record as HTML SELECT...OPTION This method requires a valid instance with data loaded in memory.

getUsrAccounts

public java.lang.String getUsrAccounts(int fmt,
                                       int id)

Get services where user by 'usrid' is registered in a usable format 'fmt'

Parameters:

fmt - 0=CSV, 1=HTML table, 2=HTML SELECTION

Returns:

String

getUserResultSet

public java.sql.ResultSet getUserResultSet()

Get a resultset of all records of table USR_MAIN

readUserList

public static java.sql.ResultSet readUserList(UserData ud,
                                              java.lang.String whereclause)

Deprecated.

readUserList

public static java.sql.ResultSet readUserList(SEHRCfg sehrcfg,
                                              java.lang.String whereclause)

readUserList

public static java.util.List readUserList(UserData ud)

getUserList

public java.util.List getUserList()

getUserListPlain

public java.lang.String getUserListPlain()

getUserListPlain

public java.lang.String getUserListPlain(java.lang.String search)

getUsrAccess

public void getUsrAccess(int recid)

Get access data USR_PPP for given recid

getUsrContactHTML

public java.lang.String getUsrContactHTML()

Get preformated address of class

Returns:

String

getUsrContact

public boolean getUsrContact(int adrid)

Get address record from USR_CONTACT

Parameters:

adrid - -1: try to get a user matching record for user in UserData object

Returns:

true contact record for given adrid successfully loaded

getUserByID

public UserData getUserByID(java.lang.String usrid)

getUserByID

public UserData getUserByID(int usrid)

Deprecated. use selectRecord(...

Parameters:

usrid -

Returns:

UserData_Object

getUserByID

public UserData getUserByID(int usrid,
                            UserData udrec)

Deprecated. use selectRecord(...

Parameters:

usrid -

Returns:

UserData_Object

selectRecord

public boolean selectRecord(int usrid)

Load user record from db for given usrid into current UD object

Parameters:

usrid -

Returns:

true or false

selectRecord

public static UserData selectRecord(int usrid,
                                    UserData ud)

Load user record for given usrid into given UserData object.

Use static method selectRecord(int usrid, UserData ud, SEHRcfg cfg) if a SEHR configuration object is known otherwise

Parameters:

usrid -

Returns:

UserData_Object 'null' if failed or no record

selectRecord

public static UserData selectRecord(int usrid,
                                    SEHRCfg cfg)

This method selects a user by 'usrid' from db and put the record data into a given UserData object using a given SEHR configuration object.

Parameters:

usrid -

cfg -

Returns:

UserData_Object

selectRecord

public void selectRecord(java.lang.String usrname)

Load user record for given username into current UserData object.

selectRecord

public UserData selectRecord(java.lang.String usrname,
                             UserData ud)

Load user record for given user into the given UserData object.

Returns:

'null' (failed) or dataset;

findUser

public UserData findUser(java.lang.String usrname)

Deprecated. use 'selectRecord(String)'

Loads the user record into the current object

Parameters:

usrname -

Returns:

UserData

See Also:

selectRecord(String)

getUsrService

public void getUsrService(int svid)

Get one record (svid >=0 ) or all records (svid = -1) for user from USR_SERVICES

getUsrService

public void getUsrService(int svid,
                          UserData ud)

Get one record (svid >=0 ) or all records (svid = -1) for user from USR_SERVICES for handle 'userdata'

updateUsrServices

public boolean updateUsrServices(int usrid)
                          throws java.lang.Exception

java.lang.Exception

countUsers

public int countUsers()

insertUsrServices

public boolean insertUsrServices(int usrid)
                          throws java.lang.Exception

java.lang.Exception

updateBasicServices

public int updateBasicServices(int svid)

Assign the given basic service to each(!) user in USR_MAIN.

By SEHR convention there are basic services offered by the zone:
1 = News/Infos (by client or WEB based service'HCO Desktop')
2 = Mailservice (by POP3/IMAP clients and WEB service 'SEHR-UMS')

Returns:

no_of_inserts or -1 if failed

updateBasicServices

public static int updateBasicServices(int svid,
                                      SEHRCfg cfg)

See Also:

updateBasicServices(int)

sendAccountServices

public static java.lang.String sendAccountServices(UserData ud)

sendAccountRequest

public static void sendAccountRequest(java.lang.String usrname,
                                      java.lang.String reqmail,
                                      java.lang.String text)

getAdr_adr1

public java.lang.String getAdr_adr1()

getAdr_adr2

public java.lang.String getAdr_adr2()

getAdr_adr3

public java.lang.String getAdr_adr3()

getAdr_match

public java.lang.String getAdr_match()

getAdr_street

public java.lang.String getAdr_street()

getAdr_title

public java.lang.String getAdr_title()

setAdr_adr1

public void setAdr_adr1(java.lang.String adr1)

setAdr_adr2

public void setAdr_adr2(java.lang.String adr2)

setAdr_adr3

public void setAdr_adr3(java.lang.String adr3)

setAdr_match

public void setAdr_match(java.lang.String match)

setAdr_street

public void setAdr_street(java.lang.String street)

setAdr_title

public void setAdr_title(java.lang.String string)

Parameters:

string -

getAdrid

public int getAdrid()

setAdrid

public void setAdrid(int i)

clearContactData

public void clearContactData()

Clear and init new contact data fields in current UserData object

getAdr_city

public java.lang.String getAdr_city()

getAdr_zip

public java.lang.String getAdr_zip()

setAdr_city

public void setAdr_city(java.lang.String string)

Parameters:

string -

setAdr_zip

public void setAdr_zip(java.lang.String string)

Parameters:

string -

getPpp_dns1

public java.lang.String getPpp_dns1()

getPpp_dns2

public java.lang.String getPpp_dns2()

getPpp_login

public java.lang.String getPpp_login()

getPpp_node

public java.lang.String getPpp_node()

getPpp_nodeip

public java.lang.String getPpp_nodeip()

getPpp_passwd

public java.lang.String getPpp_passwd()

getPpp_recid

public int getPpp_recid()

getPpp_usrid

public int getPpp_usrid()

setPpp_dns1

public void setPpp_dns1(java.lang.String string)

Parameters:

string -

setPpp_dns2

public void setPpp_dns2(java.lang.String string)

Parameters:

string -

setPpp_login

public void setPpp_login(java.lang.String string)

Parameters:

string -

setPpp_node

public void setPpp_node(java.lang.String string)

Parameters:

string -

setPpp_nodeip

public void setPpp_nodeip(java.lang.String string)

Parameters:

string -

setPpp_passwd

public void setPpp_passwd(java.lang.String string)

Parameters:

string -

setPpp_recid

public void setPpp_recid(int i)

Parameters:

i -

setPpp_usrid

public void setPpp_usrid(int i)

Parameters:

i -

getContactDefs

public java.lang.String getContactDefs()

Get contact definitions by table DEF_CONTACT

getContactsSelect

public static java.lang.String getContactsSelect()

Get a SELECT list of each(!) address in the contact table.

The intention of the SELECT list is to present all addresses to assign a address recursive to a center record etc.

The required configuration data will be received from a local running SEHRServer on Tomcat! This method do not work on local testing...
Use getContactsSelect(SEHRCfg cfg) for local testings

getContactsSelect

public static java.lang.String getContactsSelect(SEHRCfg cfg)

Get a SELECT list of each(!) address in the contact table.

getUsrContactsSelect

public java.lang.String getUsrContactsSelect()

Get a SELECT list only presenting the category of each address record assigned to the given user.

This list is usable to present a list nearby address fields of a user to indicate that there are more addresses, e.g. office, home.

getUsrContactsSelect

public static java.lang.String getUsrContactsSelect(int usrid,
                                                    int adrid,
                                                    SEHRCfg cfg,
                                                    boolean catlistonly)

deleteUsrContact

public boolean deleteUsrContact(int adrid)

Delete the contact record given by id.

deleteUsrAccess

public boolean deleteUsrAccess(int recid)

Delete PPP record.

deleteUsrService

public boolean deleteUsrService(int usrid,
                                int svid)

Delete servicerecord given by id.

addAccess

public boolean addAccess()

Add new contact record for current opened user.

updateAccess

public boolean updateAccess(int recid)

Update an existing PPP record.

getSv_ftpdir

public java.lang.String getSv_ftpdir()

getSv_login

public java.lang.String getSv_login()

getSv_menutitle

public java.lang.String getSv_menutitle()

getSv_passwd

public java.lang.String getSv_passwd()

getSv_urlstart

public java.lang.String getSv_urlstart()

setSv_ftpdir

public void setSv_ftpdir(java.lang.String string)

Parameters:

string -

setSv_login

public void setSv_login(java.lang.String string)

Parameters:

string -

setSv_menutitle

public void setSv_menutitle(java.lang.String string)

Parameters:

string -

setSv_passwd

public void setSv_passwd(java.lang.String string)

Parameters:

string -

setSv_urlstart

public void setSv_urlstart(java.lang.String s)

getSv_status

public int getSv_status()

setSv_status

public void setSv_status(int i)

getPpp_rip

public java.lang.String getPpp_rip()

setPpp_rip

public void setPpp_rip(java.lang.String string)

Parameters:

string -

getAdr_defid

public int getAdr_defid()

setAdr_defid

public void setAdr_defid(int i)

Parameters:

i -

getHomezone

public int getHomezone()

setHomezone

public void setHomezone(int i)

Parameters:

i -

is_cfg

public boolean is_cfg()

getCfg

public SEHRCfg getCfg()

getFilter_usrname

public java.lang.String getFilter_usrname()

Returns:

Returns the filter_usrname.

setFilter_usrname

public void setFilter_usrname(java.lang.String filter_usrname)

Parameters:

filter_usrname - The filter_usrname to set.

setCfg

public void setCfg(SEHRCfg cfg)

Parameters:

cfg -

getCon

public java.sql.Connection getCon()

Returns:

Returns the con.

main

public static void main(java.lang.String[] args)

for testing only....