Package gc.base.sql

Examples of gc.base.sql.SqlQuery

227
228
229
230
231
232
233
234
235
236
237
238
    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 {
        readFields(rs);
      }
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
125
    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 {
        readFields(rs);
      }
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
54
    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
71
72
73
74
75
76
77
78
79
80
81
82
    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");
          String shortName = rs.getString("SHORTNAME");
          collections.put(coluuid, shortName);
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
104
    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 {
        readFields(rs);
      }
View Full Code Here
98
99
100
101
102
103
104
105
106
107
108
109
      //if (true) return;
     
      //okIds = null;
      con = gptdb2SolrInstance.makeSqlConnection();
      GptResource r = new GptResource();
      SqlQuery q = new SqlQuery();
      q.query(context,con,r.getSqlQInfo(),this);
      this.walkSolrDocs();
     
    } finally {
      try {if (con != null) con.close();}
      catch (Exception ef) {ef.printStackTrace();}
View Full Code Here
TOP

Related Classes of gc.base.sql.SqlQuery

  • gc.base.task.TaskStats
  • gc.gpt.db.GptCollections
  • gc.gpt.db.GptResource
  • gc.gpt.db.GptResourceXml
  • gc.gpt.db.GptUser
  • gc.solr.task.Gptdb2SolrTask
  • java.sql.PreparedStatement
  • java.sql.ResultSet
    • 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.