01 package controls.database;
02
03 import java.io.Serializable;
04 import java.sql.SQLException;
05
06 import com.bea.control.DatabaseControl;
07
08 /**
09 * @jc:connection data-source-jndi-name="cgSampleDataSource"
10 */
11 public interface UsersDBControl extends com.bea.control.ControlExtension, DatabaseControl
12 {
13 /**
14 * @jc:sql statement="create table users (username VARCHAR(50), password VARCHAR(50))"
15 */
16 public void createUsersTable() throws SQLException;
17
18 /**
19 * @jc:sql statement::
20 * INSERT INTO USERS (username, password)
21 * VALUES ({username}, {password})
22 * ::
23 */
24 public int insertUser( String username, String password );
25
26 /**
27 * @jc:sql statement::
28 * SELECT * FROM USERS WHERE USERNAME = {username}
29 * ::
30 */
31 public User lookupUser( String username );
32
33 /**
34 * @jc:sql statement::
35 * UPDATE USERS SET USERNAME = {username}, PASSWORD = {password} WHERE USERNAME = {username}
36 * ::
37 */
38 public int updateUser( String username, String password );
39
40 /**
41 * @jc:sql statement::
42 * SELECT * FROM USERS
43 * ::
44 */
45 public User[] getAllUsers();
46
47 /**
48 * @jc:sql statement::
49 * DELETE FROM USERS WHERE USERNAME = {username}
50 * ::
51 */
52 public int deleteUser( String username );
53
54
55 public static class User implements Serializable
56 {
57 public String username;
58 public String password;
59
60 public User()
61 {
62 }
63
64 public User( String username, String password )
65 {
66 this.username = username;
67 this.password = password;
68 }
69 }
70 }
|