|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectsbd.baseCommand
public class baseCommand
Field Summary | |
---|---|
java.lang.String |
Filename
|
protected java.lang.String |
help
|
protected boolean |
isAdminCommand
|
protected boolean |
isUserCommand
|
protected java.util.Vector<java.lang.String> |
parameterList
|
java.lang.String |
password
|
boolean |
toFile
|
java.lang.String |
userName
|
Constructor Summary | |
---|---|
baseCommand()
Creates a new baseCommand |
Method Summary | |
---|---|
void |
addParameter(java.lang.String parameter)
Add's a parameter in the command parameterList |
java.lang.String |
execute()
Executes the command |
boolean |
executeDelete(java.lang.String SQL)
Executes a delete SQL command |
java.lang.String |
executeInsert(java.lang.String SQL)
Exdecutes a insert SQL command |
boolean |
executeUpdate(java.lang.String SQL)
Executes a update SQL command |
boolean |
existBug(int bugCode)
Check if the bugCode exist in the table |
boolean |
existUser(java.lang.String user)
Check's if the username exist in the users table |
int |
getBugMaxCodeValue()
Get bug inserTode |
java.lang.String |
getBugProgrammer(int bugCode)
Get the programmer asociated to a bug code |
protected java.sql.Connection |
getConnection()
Get a conexión to the database |
java.lang.String |
getFilename()
|
java.lang.String |
getHelp()
return the help String associated to the command |
java.lang.String |
getParameterAt(int index)
return a parameter from the Command |
java.lang.String |
getPassword()
|
java.lang.String |
getResultSetLines(java.sql.ResultSet rs)
Get a resultSet formated for print in the screen |
java.lang.String |
getResultSetMetaDataHeader(java.sql.ResultSetMetaData rsmd)
Get the resultSet fieldNames for screen print |
java.lang.String |
getSelectQuery(java.lang.String SQL)
Get's a select SQL query |
java.lang.String |
getUserName()
|
boolean |
havePermisionstoExecuteCommand()
Check if the command has permisions to be exuted |
boolean |
isAdminUsername(java.lang.String user)
Check if a username is admin |
boolean |
isBugSolved(int bugCode)
check if the bugCode is solved |
boolean |
isToFile()
|
boolean |
isValidUsername(java.lang.String user)
Check if the username exist in the database |
boolean |
isValidUsernamePassword(java.lang.String user,
java.lang.String password)
Check if a username and password is valid |
boolean |
saveToFile()
Check if the command need to be saved in a File |
void |
setPassword(java.lang.String pass)
|
void |
setUserName(java.lang.String user)
|
boolean |
verifyLogin()
check if the username and password is valid |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
protected java.util.Vector<java.lang.String> parameterList
public java.lang.String userName
public java.lang.String password
public java.lang.String Filename
protected java.lang.String help
public boolean toFile
protected boolean isAdminCommand
protected boolean isUserCommand
Constructor Detail |
---|
public baseCommand()
Method Detail |
---|
public java.lang.String execute()
public boolean saveToFile()
public void addParameter(java.lang.String parameter)
parameter
- protected java.sql.Connection getConnection()
public int getBugMaxCodeValue()
public boolean isValidUsername(java.lang.String user)
user
- the username
public boolean verifyLogin()
public boolean isValidUsernamePassword(java.lang.String user, java.lang.String password)
user
- the username to verifypassword
- the password to verify
public boolean existUser(java.lang.String user)
user
- the username to check
public boolean executeUpdate(java.lang.String SQL)
SQL
- the SQL instruccion
public boolean executeDelete(java.lang.String SQL)
SQL
- the SQL delete command
public java.lang.String executeInsert(java.lang.String SQL)
SQL
- the SQL inser command
public java.lang.String getSelectQuery(java.lang.String SQL)
SQL
- the SQL query
public java.lang.String getResultSetLines(java.sql.ResultSet rs)
rs
- the resultset for print
public java.lang.String getResultSetMetaDataHeader(java.sql.ResultSetMetaData rsmd)
rsmd
- the resultserMetaData
public boolean isBugSolved(int bugCode)
bugCode
- the bugCode id
public boolean existBug(int bugCode)
bugCode
- the bugcode to check
public java.lang.String getBugProgrammer(int bugCode)
bugCode
- the bugCode ID
public boolean isAdminUsername(java.lang.String user)
user
- the username
public java.lang.String getUserName()
public void setUserName(java.lang.String user)
user
- the user to setpublic java.lang.String getPassword()
public void setPassword(java.lang.String pass)
pass
- the pass to setpublic java.lang.String getHelp()
public boolean havePermisionstoExecuteCommand()
public java.lang.String getParameterAt(int index)
index
- the index of parameter
public boolean isToFile()
public java.lang.String getFilename()
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |