Package gc.base.sql

Examples of gc.base.sql.SqlQInfo

78
79
80
81
82
83
84
85
86
87
88
  public String    synchronizable;
 
  /** Default constructor. */
  public GptResource() {
    super();
    SqlQInfo info = getSqlQInfo();
    info.setTableSuffix("RESOURCE");
    info.setFields(new String[]{"*"});
    info.setOrderBy(null);
    info.setWhere(null);
  }
 
View Full Code Here
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
   * @param docuuid the document uuid
   * @throws Exception if an exception occurs
   */
  public void querySqlDB(TaskContext context, Connection con, String docuuid) throws Exception {
    key = null;
    SqlQInfo info = getSqlQInfo();
    info.setWhere("DOCUUID=?");
    List<Object> bindings = new ArrayList<Object>();
    bindings.add(docuuid);
    info.setQueryBindings(bindings);
    SqlQuery q = new SqlQuery();
    q.query(context,con,info, new SqlRowHandler() {
      @Override
      public void handleSqlRow(TaskContext context, Connection con, ResultSet rs,
          long rowNum) throws Exception {
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
52
  public String xml;
 
  /** Default constructor. */
  public GptResourceXml() {
    super();
    SqlQInfo info = this.getSqlQInfo();
    info.setTableSuffix("RESOURCE_DATA");
    info.setFields(new String[]{"DOCUUID,XML"});
    info.setOrderBy(null);
    info.setWhere(null);
    info.setFetchSize(1);
  }
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
   * @throws Exception if an exception occurs
   */
  public void querySqlDB(TaskContext context, Connection con, String docuuid) throws Exception {
    key = null;
    xml = null;
    SqlQInfo info = getSqlQInfo();
    info.setWhere("DOCUUID=?");
    List<Object> bindings = new ArrayList<Object>();
    bindings.add(docuuid);
    info.setQueryBindings(bindings);
    SqlQuery q = new SqlQuery();
    q.query(context,con,info, new SqlRowHandler() {
      @Override
      public void handleSqlRow(TaskContext context, Connection con, ResultSet rs,
          long rowNum) throws Exception {
View Full Code Here
21
22
23
24
25
26
27
28
public class GptHarvestingSite extends GptResource {
 
  /** Default constructor. */
  public GptHarvestingSite() {
    super();
    SqlQInfo info = getSqlQInfo();
    info.setWhere("PROTOCOL IS NOT NULL");
  }
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
   * @throws Exception if an exception occurs
   */
  public void querySqlDB(TaskContext context, Connection con, String docuuid) throws Exception {
    init(context, con);
   
    SqlQInfo info = getSqlQInfo();
    info.setTableSuffix("COLLECTION_MEMBER");
    info.setWhere("DOCUUID=?");
    List<Object> bindings = new ArrayList<Object>();
    bindings.add(docuuid);
    info.setQueryBindings(bindings);
    SqlQuery q = new SqlQuery();
    q.query(context, con, info, new SqlRowHandler() {
      @Override
      public void handleSqlRow(TaskContext context, Connection con, ResultSet rs, long rowNum) throws Exception {
        readFields(rs);
View Full Code Here
69
70
71
72
73
74
75
76
77
78
79
80
 
  private void init(TaskContext context, Connection con) throws Exception {
    if (collections==null) {
      collections = new TreeMap<String, String>(String.CASE_INSENSITIVE_ORDER);
     
      SqlQInfo info = getSqlQInfo();
      info.setTableSuffix("COLLECTION");
      SqlQuery q = new SqlQuery();
      q.query(context, con, info, new SqlRowHandler() {
        @Override
        public void handleSqlRow(TaskContext context, Connection con, ResultSet rs, long rowNum) throws Exception {
          String coluuid = rs.getString("COLUUID");
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
  public String  dn;
 
  /** Default constructor. */
  public GptUser() {
    super();
    SqlQInfo info = getSqlQInfo();
    info.setTableSuffix("USER");
    info.setFields(new String[]{"*"});
    info.setOrderBy(null);
    info.setWhere(null);
  }
 
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
   * @param userid the user id
   * @throws Exception if an exception occurs
   */
  public void querySqlDB(TaskContext context, Connection con, int userid) throws Exception {
    key = null;
    SqlQInfo info = getSqlQInfo();
    info.setWhere("USERID=?");
    List<Object> bindings = new ArrayList<Object>();
    bindings.add(new Integer(userid));
    info.setQueryBindings(bindings);
    SqlQuery q = new SqlQuery();
    q.query(context,con,info, new SqlRowHandler() {
      @Override
      public void handleSqlRow(TaskContext context, Connection con, ResultSet rs,
          long rowNum) throws Exception {
View Full Code Here
TOP

Related Classes of gc.base.sql.SqlQInfo

  • gc.gpt.db.GptCollections
  • gc.gpt.db.GptHarvestingSite
  • gc.gpt.db.GptResource
  • gc.gpt.db.GptResourceXml
  • gc.gpt.db.GptUser
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.