KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > acl > db > queries > GetLoginByName


1 package de.webman.acl.db.queries;
2
3 import java.sql.Connection JavaDoc;
4 import java.sql.Types JavaDoc;
5 import com.teamkonzept.db.TKPrepQuery;
6
7 /**
8  * retrieves an login by Name
9  *
10  * used to check whether Login already exists
11  *
12  * @param login, USER-ID (for the User witch login is ignored,set to 0 if not required)
13  * @return USER-ID with the given login
14  * @version 0.10
15  * @since 0.10
16  * @author © 2000 Team-Konzept
17  */
18 public class GetLoginByName
19     extends TKPrepQuery
20 {
21
22     /** @see TKPrepQuery */
23     public static final String JavaDoc[] PARAMORDER =
24     {
25         "LOGIN",
26         "USER_ID"
27     };
28
29     /** @see TKPrepQuery */
30     public static final Object JavaDoc[][] TYPES =
31     {
32         {"LOGIN", new Integer JavaDoc(Types.VARCHAR)},
33         {"USER_ID", new Integer JavaDoc(Types.INTEGER)}
34     };
35     
36     /** @see TKPrepQuery */
37     public static final boolean[] RELEVANTS =
38     {
39         false
40     };
41
42     /** the sql-query */
43     public static final String JavaDoc SQL = "SELECT * " +
44                                      "FROM WM_USER " +
45                                      "WHERE LOGIN = ? " +
46                                      "AND WM_USER_ID <> ? ";
47
48     
49     /** @see TKPrepQuery */
50     public void initQuery (Connection JavaDoc connection)
51     {
52         super.initQuery(connection,
53                         true,
54                         PARAMORDER,
55                         TYPES,
56                         RELEVANTS,
57                         SQL);
58     }
59
60 }
61
Popular Tags