JDAdmin program lets
a privileged user view and administer
the user database
for the JabaDot web site shown in Section 18.13. It
doesn’t use the accessors that we so carefully built up in this
chapter, as it needs to be able to make any change at all to the
database, including recovering from corrupted data introduced by
potential bugs in future versions of the accessor. Instead, it makes
extensive use of the
class (see Section 20.7).
The user interface (shown in Figure 20-3) is a
controlled by the
MyTableModel class defined at the end of the
source. This controls the display of the fields and allows and
handles the editing of the password field.
Figure 20-3. JDAdmin user interface
class used here simply defines public
constants for the fields within the database. These field numbers
begin at one; I subtract one from the field number when I need
Example 20-13 shows the first working version of the program. It allows you to reset the password of a forgetful user and to delete a defunct account. One plausible extension is to add a text field and a button to allow you to execute an arbitrary SQL statement, as in Section 20.11.
Example 20-13. JDAdmin.java
package jabadot; import java.util.*; import java.sql.*; import java.awt.*; import java.awt.event.*; import javax.swing.*; import javax.swing.table.*; ...