Quadcap Bug Database

com.quadcap.app.bugdb.BugSession Class Reference

Inheritance diagram for com.quadcap.app.bugdb.BugSession:

HttpSessionBindingListener List of all members.

Detailed Description

A session bean encapsulating access to the Quadcap Bug Database.

JSP pages use methods of this bean to perform the various functions of the bug database application.

Author:
Stan Bailes

Definition at line 78 of file BugSession.java.

Public Member Functions

 BugSession ()
 Create a new session.

Connection getConnection () throws SQLException
 Return the JDBC connection for this session.

void valueBound (HttpSessionBindingEvent event)
 This application object has just been bound into an HttpSession.

void valueUnbound (HttpSessionBindingEvent event)
 This application object has just been removed from an HttpSession.

boolean isUser ()
 Is this session associated with a valid user?

boolean isDeveloper ()
 Is this session associated with a user with 'developer' privileges?

boolean isManager ()
 Is this session associated with a user with 'manager' privileges?

boolean isAdmin ()
 Is this session associated with a user with 'administrator' privileges?

String getQuery (String name) throws ServletException
 Return the saved bug search query with the specified name.

void saveQuery (String name, String query) throws ServletException
 Save a bug search query.

boolean logout (Properties props)
 Execute the 'logout' action.

boolean login (Properties props) throws SQLException
 Execute the 'login' action.

boolean addUser (Properties props) throws SQLException, ServletException
 Execute the 'addUser' action.

boolean updateUser (Properties p) throws SQLException
 Execute the 'updateUser' action.

boolean deleteUser (Properties p) throws SQLException
 Execute the 'deleteUser' action.

String listOptions (String type) throws ServletException
 Generate an HTML <SELECT> element listing all elements in the specified table.

String listOptions (String type, String sel) throws ServletException
 Generate an HTML <SELECT> element listing all elements in the specified table.

String listOptions (String table, String type, String sel) throws ServletException
 Generate an HTML <SELECT> element listing all elements in the specified table.

String listOptions (String seltype, String table, String type, String sel) throws ServletException
 Generate an HTML <SELECT> element listing all elements in the specified table.

String listUsers (String type, String sel) throws ServletException
 Generate an HTML <SELECT> element listing all users.

String getComponentOwner (String component) throws SQLException, ServletException
 Return the name of the user who owns the specified component.

boolean addBug (Properties props) throws ServletException
 Execute the 'addBug' action.

boolean updateBug (Properties props) throws ServletException
 Execute the 'updateBug' action.

final String urlDecode (String s)
 Utility to do URL decoding without any exception handling.

Vector searchBugs (String query, String ob) throws ServletException
 Perform the bug search operation.

Vector getUsers () throws SQLException
 Return a list of valid users, as a Vector of Properties objects, where each Hashtable object contains all of the user's properties (except the password!).

Vector getProjects () throws SQLException
 Return a list of valid project/components, as a Vector of Hashtable objects, where each Hashtable object contains all of the user's properties (except the password!).

Hashtable getUser (String user) throws SQLException
 Return the properties for a single user.

Hashtable getProject (String user) throws SQLException
 Return the properties for a single component.

boolean newProject (Properties p) throws SQLException
 Execute the 'newProject' action.

boolean updateProject (Properties p) throws SQLException
 Execute the 'updateProject' action.

boolean deleteProject (Properties p) throws SQLException
 Execute the 'deleteProject' action.

Hashtable getBug (String bug_id) throws ServletException
 Return the current information and history for the specified bug.

String htmlEncode (String s)
 Replace occurrences of <, >, and & with their HTML entity-representation equivalents.

void handleRequest (HttpServletRequest req) throws ServletException, SQLException
 The main request handler.

Properties getRequestProperties (HttpServletRequest req)
 Build a Properties object containing all of the request parameters.


Package Functions

int getNextId (String type) throws SQLException
 Return the next integer in the specified sequence.

int getBugHistSize (int bug_id) throws SQLException
 Return the number of records in the bug history for the specified bug.

final Hashtable getProps (ResultSet rs) throws SQLException
 Turn the current row in the result set into a Hashtable.

Hashtable diffProps (Hashtable a, Hashtable b)
 Given two bug history records, return a hashtable containing entries for each field which changed between the two records.


Static Package Functions

int getInt (Properties props, String name) throws ServletException
 Return an integer valued property.

String getString (Properties props, String name)
 Return a string-valued property.

final java.sql.Timestamp now ()
 Make a sql timestamp value representing the current time.

 [static initializer]

Package Attributes

Connection conn
String me = "nobody"
 My user name.

String my_person_type = null
boolean isAdmin = false
boolean isManager = false
boolean isDeveloper = false
boolean isUser = false
Vector debug_history = new Vector()
PreparedStatement getComponentOwner
PreparedStatement insertBugHist
PreparedStatement insertPerson
PreparedStatement getBugHist
PreparedStatement getBug
PreparedStatement getQuery
PreparedStatement saveQuery
PreparedStatement getUser
PreparedStatement updateUser
PreparedStatement deleteUser
PreparedStatement getProject
PreparedStatement newProject
PreparedStatement deleteProject
PreparedStatement updateProject
final String driverName = "com.quadcap.jdbc.JdbcDriver"
final String dbUrl = "jdbc:qed:bugdb;create=true"
final String dbUser = "bugdb"
final String dbPass = "bugdb"

Static Package Attributes

Object lock = new Object()
Hashtable nonDeltas = new Hashtable()
 The properties that we ignore when computing deltas between successive bug history records.


Private Member Functions

final void prepareStatements () throws SQLException
 Prepare the various SQL statements we'll be using.

final void checkSchema () throws SQLException
 Check to make sure the database schema exists.

Constructor & Destructor Documentation

com.quadcap.app.bugdb.BugSession.BugSession (   ) 
 

Create a new session.

Definition at line 117 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.checkSchema(), com.quadcap.app.bugdb.BugSession.driverName, com.quadcap.app.bugdb.BugSession.getConnection(), and com.quadcap.app.bugdb.BugSession.prepareStatements().

Member Function Documentation

com.quadcap.app.bugdb.BugSession.[static initializer] (   )  [static, package]
 

boolean com.quadcap.app.bugdb.BugSession.addBug (  Properties  props  )  throws ServletException
 

Execute the 'addBug' action.

Parameters:
props the request properties, contains values for the various fields in the 'bug' and 'bug_history' tables.
Returns:
true if this action succeeded.
Exceptions:
ServletException may be thrown.

Definition at line 695 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.addBug(), com.quadcap.app.bugdb.BugSession.conn, com.quadcap.app.bugdb.BugSession.insertBugHist, com.quadcap.app.bugdb.BugSession.isUser(), com.quadcap.app.bugdb.BugSession.me, and com.quadcap.app.bugdb.BugSession.now().

Referenced by com.quadcap.app.bugdb.BugSession.addBug().

boolean com.quadcap.app.bugdb.BugSession.addUser (  Properties  props  )  throws SQLException, ServletException
 

Execute the 'addUser' action.

Parameters:
props the request properties for this action:<p>
name
The user's login name
password
The user's password
password2
The user's password confirmation
email
The user's email address
person_type
The user's 'class', one of
  • User
  • Developer
  • Manager
  • Administrator
Exceptions:
SQLException may be thrown

Definition at line 451 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.addUser(), com.quadcap.app.bugdb.BugSession.getString(), and com.quadcap.app.bugdb.BugSession.insertPerson.

Referenced by com.quadcap.app.bugdb.BugSession.addUser().

final void com.quadcap.app.bugdb.BugSession.checkSchema (   )  throws SQLException [private]
 

Check to make sure the database schema exists.

If not, load it from the bugdb.sql file.

Exceptions:
SQLException may be thrown.

Definition at line 225 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.conn, com.quadcap.app.bugdb.Loader.loadStream(), com.quadcap.app.bugdb.BugSession.lock, and com.quadcap.app.bugdb.Loader.setConnection().

Referenced by com.quadcap.app.bugdb.BugSession.BugSession().

boolean com.quadcap.app.bugdb.BugSession.deleteProject (  Properties  p  )  throws SQLException
 

Execute the 'deleteProject' action.

Exceptions:
SQLException may be thrown

Definition at line 1026 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.deleteProject.

boolean com.quadcap.app.bugdb.BugSession.deleteUser (  Properties  p  )  throws SQLException
 

Execute the 'deleteUser' action.

Exceptions:
SQLException may be thrown

Definition at line 518 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.deleteUser.

Hashtable com.quadcap.app.bugdb.BugSession.diffProps (  Hashtable  a,
Hashtable  b
)  [package]
 

Given two bug history records, return a hashtable containing entries for each field which changed between the two records.

Parameters:
a the newer history record
b the older history record
Returns:
a Hashtable where the keys are the names of the changed fields and the values are strings of the form:<p> 
Changed from bval to aval

Definition at line 1052 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.diffProps(), and com.quadcap.app.bugdb.BugSession.nonDeltas.

Referenced by com.quadcap.app.bugdb.BugSession.diffProps().

Hashtable com.quadcap.app.bugdb.BugSession.getBug (  String  bug_id  )  throws ServletException
 

Return the current information and history for the specified bug.

Parameters:
bug_id 
Returns:
a Hashtable where the keys are the names of the bug properties and the values are the current (i.e., most recent) values for those properties. The special key "history" has a Vector of Hashtables value containing the reverse-chronological history deltas for the bug.
Exceptions:
ServletException may be thrown

Definition at line 1084 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.getBug.

int com.quadcap.app.bugdb.BugSession.getBugHistSize (  int  bug_id  )  throws SQLException [package]
 

Return the number of records in the bug history for the specified bug.

Parameters:
bug_id the bug number
Returns:
the number of history records for this bug.
Exceptions:
SQLException may be thrown

Definition at line 414 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.getBugHist, and com.quadcap.app.bugdb.BugSession.getBugHistSize().

Referenced by com.quadcap.app.bugdb.BugSession.getBugHistSize().

String com.quadcap.app.bugdb.BugSession.getComponentOwner (  String  component  )  throws SQLException, ServletException
 

Return the name of the user who owns the specified component.

Parameters:
component the component name
Returns:
the component's owner
Exceptions:
SQLException may be thrown
ServletException may be thrown

Definition at line 635 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.getComponentOwner.

Connection com.quadcap.app.bugdb.BugSession.getConnection (   )  throws SQLException
 

Return the JDBC connection for this session.

Returns:
this session's connection.

Definition at line 136 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.conn, com.quadcap.app.bugdb.BugSession.dbPass, com.quadcap.app.bugdb.BugSession.dbUrl, and com.quadcap.app.bugdb.BugSession.dbUser.

Referenced by com.quadcap.app.bugdb.BugSession.BugSession(), and com.quadcap.app.bugdb.BugSession.login().

int com.quadcap.app.bugdb.BugSession.getInt (  Properties  props,
String  name
)  throws ServletException [static, package]
 

Return an integer valued property.

Parameters:
props a properties object
name the name of the property to retrieve.
Returns:
the property value
Exceptions:
ServletException is thrown if the property isn't a valid integer.

Definition at line 663 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.getInt().

Referenced by com.quadcap.app.bugdb.BugSession.getInt().

int com.quadcap.app.bugdb.BugSession.getNextId (  String  type  )  throws SQLException [package]
 

Return the next integer in the specified sequence.

Returns:
the next integer in this sequence.
Exceptions:
SQLException may be thrown

Definition at line 383 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.conn, and com.quadcap.app.bugdb.BugSession.getNextId().

Referenced by com.quadcap.app.bugdb.BugSession.getNextId().

Hashtable com.quadcap.app.bugdb.BugSession.getProject (  String  user  )  throws SQLException
 

Return the properties for a single component.

Parameters:
name the component name
Returns:
the component's properties
Exceptions:
SQLException may be thrown

Definition at line 960 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.getProject.

Vector com.quadcap.app.bugdb.BugSession.getProjects (   )  throws SQLException
 

Return a list of valid project/components, as a Vector of Hashtable objects, where each Hashtable object contains all of the user's properties (except the password!).

Returns:
a list of valid components
Exceptions:
SQLException may be thrown

Definition at line 910 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.conn.

final Hashtable com.quadcap.app.bugdb.BugSession.getProps (  ResultSet  rs  )  throws SQLException [package]
 

Turn the current row in the result set into a Hashtable.

Parameters:
rs a result set
Returns:
a Hashtable where the keys are the string-valued column labels of the result set and the values are the string-valued column values from the current row of the result set.
Exceptions:
SQLException may be thrown

Definition at line 862 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.getProps().

Referenced by com.quadcap.app.bugdb.BugSession.getProps().

String com.quadcap.app.bugdb.BugSession.getQuery (  String  name  )  throws ServletException
 

Return the saved bug search query with the specified name.

Parameters:
name the name of the query
Returns:
the query string
Exceptions:
ServletException may be thrown

Definition at line 281 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.getQuery, and com.quadcap.app.bugdb.BugSession.me.

Properties com.quadcap.app.bugdb.BugSession.getRequestProperties (  HttpServletRequest  req  ) 
 

Build a Properties object containing all of the request parameters.

Parameters:
req the http request
Returns:
the request parameters

Definition at line 1202 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.getRequestProperties().

Referenced by com.quadcap.app.bugdb.BugSession.getRequestProperties(), and com.quadcap.app.bugdb.BugSession.handleRequest().

String com.quadcap.app.bugdb.BugSession.getString (  Properties  props,
String  name
)  [static, package]
 

Return a string-valued property.

Parameters:
props a properties object
name the name of the property to retrieve.
Returns:
the property value, or the empty string if the property isn't defined.

Definition at line 680 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.getString().

Referenced by com.quadcap.app.bugdb.BugSession.addUser(), com.quadcap.app.bugdb.BugSession.getString(), and com.quadcap.app.bugdb.BugSession.login().

Hashtable com.quadcap.app.bugdb.BugSession.getUser (  String  user  )  throws SQLException
 

Return the properties for a single user.

Parameters:
user the user name
Returns:
the user's properties (except the password)
Exceptions:
SQLException may be thrown

Definition at line 936 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.getUser.

Vector com.quadcap.app.bugdb.BugSession.getUsers (   )  throws SQLException
 

Return a list of valid users, as a Vector of Properties objects, where each Hashtable object contains all of the user's properties (except the password!).

Returns:
a list of valid users
Exceptions:
SQLException may be thrown

Definition at line 881 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.conn.

void com.quadcap.app.bugdb.BugSession.handleRequest (  HttpServletRequest  req  )  throws ServletException, SQLException
 

The main request handler.

Determine which action is to be invoked and dispatch the appropriate routine.

Parameters:
req the http request
Exceptions:
ServletException may be thrown
SQLException may be thrown

Definition at line 1148 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.getRequestProperties(), com.quadcap.app.bugdb.BugSession.handleRequest(), and com.quadcap.app.bugdb.BugSession.isUser().

Referenced by com.quadcap.app.bugdb.BugSession.handleRequest().

String com.quadcap.app.bugdb.BugSession.htmlEncode (  String  s  ) 
 

Replace occurrences of <, >, and & with their HTML entity-representation equivalents.

Parameters:
the the string to encode
Returns:
the encoded string

Definition at line 1125 of file BugSession.java.

References com.quadcap.app.bugdb.HtmlWriter.flush(), com.quadcap.app.bugdb.BugSession.htmlEncode(), and com.quadcap.app.bugdb.HtmlWriter.write().

Referenced by com.quadcap.app.bugdb.BugSession.htmlEncode().

boolean com.quadcap.app.bugdb.BugSession.isAdmin (   ) 
 

Is this session associated with a user with 'administrator' privileges?

Returns:
true if the user is valid and has administrator privileges.

Definition at line 271 of file BugSession.java.

boolean com.quadcap.app.bugdb.BugSession.isDeveloper (   ) 
 

Is this session associated with a user with 'developer' privileges?

Returns:
true if the user is valid and has developer privileges.

Definition at line 257 of file BugSession.java.

boolean com.quadcap.app.bugdb.BugSession.isManager (   ) 
 

Is this session associated with a user with 'manager' privileges?

Returns:
true if the user is valid and has manager privileges.

Definition at line 264 of file BugSession.java.

boolean com.quadcap.app.bugdb.BugSession.isUser (   ) 
 

Is this session associated with a valid user?

Returns:
true if the user is valid.

Definition at line 250 of file BugSession.java.

Referenced by com.quadcap.app.bugdb.BugSession.addBug(), com.quadcap.app.bugdb.BugSession.handleRequest(), and com.quadcap.app.bugdb.BugSession.updateBug().

String com.quadcap.app.bugdb.BugSession.listOptions (  String  seltype,
String  table,
String  type,
String  sel
)  throws ServletException
 

Generate an HTML <SELECT> element listing all elements in the specified table.

Parameters:
selType the name of the SELECT widget.
table the table (e.g., priority, state, etc.)
type the name of the column containing the enumerated values.
sel if non null, the value to be initially selected
Returns:
the HTML string.

Definition at line 578 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.conn.

String com.quadcap.app.bugdb.BugSession.listOptions (  String  table,
String  type,
String  sel
)  throws ServletException
 

Generate an HTML <SELECT> element listing all elements in the specified table.

Parameters:
table the table (e.g., priority, state, etc.) Also the name of the SELECT element.
type the name of the column containing the enumerated values.
sel if non null, the value to be initially selected
Returns:
the HTML string.

Definition at line 562 of file BugSession.java.

String com.quadcap.app.bugdb.BugSession.listOptions (  String  type,
String  sel
)  throws ServletException
 

Generate an HTML <SELECT> element listing all elements in the specified table.

Parameters:
type the table (e.g., priority, state, etc.) Also the name of the SELECT element, and the name of the column.
sel if non null, the value to be initially selected
Returns:
the HTML string.

Definition at line 546 of file BugSession.java.

String com.quadcap.app.bugdb.BugSession.listOptions (  String  type  )  throws ServletException
 

Generate an HTML <SELECT> element listing all elements in the specified table.

Parameters:
type the table (e.g., priority, state, etc.)
Returns:
the HTML string.

Definition at line 531 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.listOptions().

Referenced by com.quadcap.app.bugdb.BugSession.listOptions().

String com.quadcap.app.bugdb.BugSession.listUsers (  String  type,
String  sel
)  throws ServletException
 

Generate an HTML <SELECT> element listing all users.

Parameters:
type the name of the SELECT element.
sel the value (if any) to be initially selected.

Definition at line 623 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.listUsers().

Referenced by com.quadcap.app.bugdb.BugSession.listUsers().

boolean com.quadcap.app.bugdb.BugSession.login (  Properties  props  )  throws SQLException
 

Execute the 'login' action.

Parameters:
props the request properties for this action.
username
The user's login name
password
The user's password
Exceptions:
SQLException may be thrown

Definition at line 349 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.conn, com.quadcap.app.bugdb.BugSession.getConnection(), com.quadcap.app.bugdb.BugSession.getString(), com.quadcap.app.bugdb.BugSession.login(), com.quadcap.app.bugdb.BugSession.me, and com.quadcap.app.bugdb.BugSession.my_person_type.

Referenced by com.quadcap.app.bugdb.BugSession.login().

boolean com.quadcap.app.bugdb.BugSession.logout (  Properties  props  ) 
 

Execute the 'logout' action.

Parameters:
props the request properties for this action. Ignored.

Definition at line 326 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.conn, com.quadcap.app.bugdb.BugSession.logout(), and com.quadcap.app.bugdb.BugSession.me.

Referenced by com.quadcap.app.bugdb.BugSession.logout(), and com.quadcap.app.bugdb.BugSession.valueUnbound().

boolean com.quadcap.app.bugdb.BugSession.newProject (  Properties  p  )  throws SQLException
 

Execute the 'newProject' action.

Parameters:
props the request properties for this action:<p>
component
The name of the project
owner
The owner of the project.
Exceptions:
SQLException may be thrown

Definition at line 987 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.newProject.

final java.sql.Timestamp com.quadcap.app.bugdb.BugSession.now (   )  [static, package]
 

Make a sql timestamp value representing the current time.

Returns:
a timestamp value.

Definition at line 782 of file BugSession.java.

Referenced by com.quadcap.app.bugdb.BugSession.addBug(), and com.quadcap.app.bugdb.BugSession.updateBug().

final void com.quadcap.app.bugdb.BugSession.prepareStatements (   )  throws SQLException [private]
 

Prepare the various SQL statements we'll be using.

Exceptions:
SQLException may be thrown

Definition at line 178 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.conn, com.quadcap.app.bugdb.BugSession.deleteProject, com.quadcap.app.bugdb.BugSession.deleteUser, com.quadcap.app.bugdb.BugSession.getBug, com.quadcap.app.bugdb.BugSession.getBugHist, com.quadcap.app.bugdb.BugSession.getComponentOwner, com.quadcap.app.bugdb.BugSession.getProject, com.quadcap.app.bugdb.BugSession.getQuery, com.quadcap.app.bugdb.BugSession.getUser, com.quadcap.app.bugdb.BugSession.insertBugHist, com.quadcap.app.bugdb.BugSession.insertPerson, com.quadcap.app.bugdb.BugSession.newProject, com.quadcap.app.bugdb.BugSession.saveQuery, com.quadcap.app.bugdb.BugSession.updateProject, and com.quadcap.app.bugdb.BugSession.updateUser.

Referenced by com.quadcap.app.bugdb.BugSession.BugSession().

void com.quadcap.app.bugdb.BugSession.saveQuery (  String  name,
String  query
)  throws ServletException
 

Save a bug search query.

Parameters:
name the query name
query the query string
Exceptions:
ServletException may be thrown

Definition at line 308 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.me, and com.quadcap.app.bugdb.BugSession.saveQuery.

Vector com.quadcap.app.bugdb.BugSession.searchBugs (  String  query,
String  ob
)  throws ServletException
 

Perform the bug search operation.

Parameters:
query the query string, a boolean predicate selecting bugs to be returned.
ob an optional column name to use with an 'order by' clause, to cause the list of bugs to be sorted based on that column.
Returns:
a Vector of Properties objects, where each Properties element contains entries for each column in the search result.
Exceptions:
ServletException may be thrown

Definition at line 813 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.conn, and com.quadcap.app.bugdb.BugSession.searchBugs().

Referenced by com.quadcap.app.bugdb.BugSession.searchBugs().

boolean com.quadcap.app.bugdb.BugSession.updateBug (  Properties  props  )  throws ServletException
 

Execute the 'updateBug' action.

Parameters:
props the request properties, contains values for the various fields in the 'bug' and 'bug_history' tables.
Returns:
true if this action succeeded.
Exceptions:
ServletException may be thrown.

Definition at line 746 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.insertBugHist, com.quadcap.app.bugdb.BugSession.isUser(), com.quadcap.app.bugdb.BugSession.me, com.quadcap.app.bugdb.BugSession.now(), and com.quadcap.app.bugdb.BugSession.updateBug().

Referenced by com.quadcap.app.bugdb.BugSession.updateBug().

boolean com.quadcap.app.bugdb.BugSession.updateProject (  Properties  p  )  throws SQLException
 

Execute the 'updateProject' action.

Parameters:
props the request properties for this action:<p>
component
The name of the project
owner
The owner of the project.
Exceptions:
SQLException may be thrown

Definition at line 1004 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.updateProject.

boolean com.quadcap.app.bugdb.BugSession.updateUser (  Properties  p  )  throws SQLException
 

Execute the 'updateUser' action.

Parameters:
props the request properties for this action:<p>
name
The user's login name
password
The user's password
email
The user's email address
person_type
The user's 'class', one of
  • User
  • Developer
  • Manager
  • Administrator
Exceptions:
SQLException may be thrown

Definition at line 492 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.updateUser.

final String com.quadcap.app.bugdb.BugSession.urlDecode (  String  s  ) 
 

Utility to do URL decoding without any exception handling.

Lazy bastard.

Parameters:
s the url to decode
Returns:
the decoded url

Definition at line 792 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.urlDecode().

Referenced by com.quadcap.app.bugdb.BugSession.urlDecode().

void com.quadcap.app.bugdb.BugSession.valueBound (  HttpSessionBindingEvent  event  ) 
 

This application object has just been bound into an HttpSession.

Parameters:
event identifies the session and the name in the session of this object.

Definition at line 154 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.valueBound().

Referenced by com.quadcap.app.bugdb.BugSession.valueBound().

void com.quadcap.app.bugdb.BugSession.valueUnbound (  HttpSessionBindingEvent  event  ) 
 

This application object has just been removed from an HttpSession.

Parameters:
event identifies the session and the name in the session of this object.

Definition at line 165 of file BugSession.java.

References com.quadcap.app.bugdb.BugSession.conn, com.quadcap.app.bugdb.BugSession.logout(), and com.quadcap.app.bugdb.BugSession.valueUnbound().

Referenced by com.quadcap.app.bugdb.BugSession.valueUnbound().

Member Data Documentation

Connection com.quadcap.app.bugdb.BugSession.conn [package]
 

Definition at line 79 of file BugSession.java.

Referenced by com.quadcap.app.bugdb.BugSession.addBug(), com.quadcap.app.bugdb.BugSession.checkSchema(), com.quadcap.app.bugdb.BugSession.getConnection(), com.quadcap.app.bugdb.BugSession.getNextId(), com.quadcap.app.bugdb.BugSession.getProjects(), com.quadcap.app.bugdb.BugSession.getUsers(), com.quadcap.app.bugdb.BugSession.listOptions(), com.quadcap.app.bugdb.BugSession.login(), com.quadcap.app.bugdb.BugSession.logout(), com.quadcap.app.bugdb.BugSession.prepareStatements(), com.quadcap.app.bugdb.BugSession.searchBugs(), and com.quadcap.app.bugdb.BugSession.valueUnbound().

final String com.quadcap.app.bugdb.BugSession.dbPass = "bugdb" [package]
 

Definition at line 112 of file BugSession.java.

Referenced by com.quadcap.app.bugdb.BugSession.getConnection().

final String com.quadcap.app.bugdb.BugSession.dbUrl = "jdbc:qed:bugdb;create=true" [package]
 

Definition at line 110 of file BugSession.java.

Referenced by com.quadcap.app.bugdb.BugSession.getConnection().

final String com.quadcap.app.bugdb.BugSession.dbUser = "bugdb" [package]
 

Definition at line 111 of file BugSession.java.

Referenced by com.quadcap.app.bugdb.BugSession.getConnection().

Vector com.quadcap.app.bugdb.BugSession.debug_history = new Vector() [package]
 

Definition at line 92 of file BugSession.java.

PreparedStatement com.quadcap.app.bugdb.BugSession.deleteProject [package]
 

Definition at line 106 of file BugSession.java.

Referenced by com.quadcap.app.bugdb.BugSession.deleteProject(), and com.quadcap.app.bugdb.BugSession.prepareStatements().

PreparedStatement com.quadcap.app.bugdb.BugSession.deleteUser [package]
 

Definition at line 103 of file BugSession.java.

Referenced by com.quadcap.app.bugdb.BugSession.deleteUser(), and com.quadcap.app.bugdb.BugSession.prepareStatements().

final String com.quadcap.app.bugdb.BugSession.driverName = "com.quadcap.jdbc.JdbcDriver" [package]
 

Definition at line 109 of file BugSession.java.

Referenced by com.quadcap.app.bugdb.BugSession.BugSession().

PreparedStatement com.quadcap.app.bugdb.BugSession.getBug [package]
 

Definition at line 98 of file BugSession.java.

Referenced by com.quadcap.app.bugdb.BugSession.getBug(), and com.quadcap.app.bugdb.BugSession.prepareStatements().

PreparedStatement com.quadcap.app.bugdb.BugSession.getBugHist [package]
 

Definition at line 97 of file BugSession.java.

Referenced by com.quadcap.app.bugdb.BugSession.getBugHistSize(), and com.quadcap.app.bugdb.BugSession.prepareStatements().

PreparedStatement com.quadcap.app.bugdb.BugSession.getComponentOwner [package]