Package org.jtester.module.database.environment

Examples of org.jtester.module.database.environment.DBEnvironment

88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
   * @param fileName
   * @throws SQLException
   * @throws FileNotFoundException
   */
  public static void executeFromFile(String fileName) throws Exception {
    DBEnvironment environment = DBEnvironmentFactory.getCurrentDBEnvironment();
    environment.connectIfNeeded();

    String sqls = ResourceHelper.readFromFile(fileName);
    String[] statements = DBHelper.parseSQL(sqls);
    for (String statment : statements) {
      PreparedStatement st = null;
      try {
        st = environment.createStatementWithBoundFixtureSymbols(statment);
        st.execute();
      } catch (Throwable e) {
        throw new DbFitException("there are some error when execute sql file [" + fileName + "]", e);
      } finally {
        DBHelper.closeStatement(st);
View Full Code Here
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
   *
   * @param is
   * @throws Exception
   */
  public static void executeFromStream(InputStream is) throws Exception {
    DBEnvironment environment = DBEnvironmentFactory.getCurrentDBEnvironment();
    environment.connectIfNeeded();

    String sqls = ResourceHelper.readFromStream(is);
    String[] statements = DBHelper.parseSQL(sqls);
    for (String statment : statements) {
      PreparedStatement st = null;
      try {
        st = environment.createStatementWithBoundFixtureSymbols(statment);
        st.execute();
      } catch (Throwable e) {
        throw new DbFitException("there are some error when execute sql file.", e);
      } finally {
        DBHelper.closeStatement(st);
View Full Code Here
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
   * @param fileName
   * @throws SQLException
   * @throws FileNotFoundException
   */
  public static void executeFromFile(Class clazz, String fileName) {
    DBEnvironment environment = DBEnvironmentFactory.getCurrentDBEnvironment();
    environment.connectIfNeeded();

    String sqls;
    try {
      sqls = ResourceHelper.readFromFile(clazz, fileName);
    } catch (FileNotFoundException e1) {
      throw new RuntimeException(e1);
    }

    String[] statements = DBHelper.parseSQL(sqls);
    for (String statment : statements) {
      PreparedStatement st = null;
      try {
        st = environment.createStatementWithBoundFixtureSymbols(statment);
        st.execute();
      } catch (Throwable e) {
        throw new DbFitException("there are some error when execute sql file [" + fileName + "]", e);
      } finally {
        DBHelper.closeStatement(st);
View Full Code Here
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
   * @param result
   * @return
   * @throws SQLException
   */
  public static <T> T query(String sql, Class<T> claz) {
    DBEnvironment environment = DBEnvironmentFactory.getCurrentDBEnvironment();
    environment.connectIfNeeded();
    PreparedStatement st = null;
    ResultSet rs = null;
    try {
      st = environment.createStatementWithBoundFixtureSymbols(sql);
      rs = st.executeQuery();
      if (rs.next() == false) {
        throw new RuntimeException("there are no result for statement:" + sql);
      }
      ResultSetMetaData rsmd = rs.getMetaData();
View Full Code Here
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
   * @param result
   * @return
   * @throws SQLException
   */
  public static <T> List<T> queryList(String sql, Class<T> clazz) {
    DBEnvironment environment = DBEnvironmentFactory.getCurrentDBEnvironment();
    environment.connectIfNeeded();
    PreparedStatement st = null;
    ResultSet rs = null;
    try {
      st = environment.createStatementWithBoundFixtureSymbols(sql);
      rs = st.executeQuery();

      ResultSetMetaData rsmd = rs.getMetaData();
      if (Map.class.isAssignableFrom(clazz)) {
        List<Map> maps = DBHelper.getListMapFromResult(rs, rsmd, false);
View Full Code Here
27
28
29
30
31
32
33
34
35
36
37
  }

  public IDBOperator useDB(String dataSource) {
    IN_DB_OPERATOR.set(true);
    try {
      DBEnvironment environment = DBEnvironmentFactory.getDBEnvironment(dataSource);
      DBEnvironmentFactory.changeDBEnvironment(environment);
      return this;
    } finally {
      IN_DB_OPERATOR.set(false);
    }
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
  }

  public IDBOperator useDefaultDB() {
    IN_DB_OPERATOR.set(true);
    try {
      DBEnvironment environment = DBEnvironmentFactory.getDBEnvironment();
      DBEnvironmentFactory.changeDBEnvironment(environment);
      return this;
    } finally {
      IN_DB_OPERATOR.set(false);
    }
View Full Code Here
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
      DBHelper.closeStatement(st);
    }
  }

  public static <T> List<T> queryMapList(String sql) {
    DBEnvironment environment = DBEnvironmentFactory.getCurrentDBEnvironment();
    environment.connectIfNeeded();
    PreparedStatement st = null;
    ResultSet rs = null;
    try {
      st = environment.createStatementWithBoundFixtureSymbols(sql);
      rs = st.executeQuery();

      ResultSetMetaData rsmd = rs.getMetaData();
      List<Map> maps = DBHelper.getListMapFromResult(rs, rsmd, false);
      return (List<T>) maps;
View Full Code Here
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
      DBHelper.closeStatement(st);
    }
  }

  public static <T> List<T> queryMapList(String sql, DataMap where) {
    DBEnvironment environment = DBEnvironmentFactory.getCurrentDBEnvironment();
    environment.connectIfNeeded();
    PreparedStatement st = null;
    ResultSet rs = null;
    try {
      st = environment.createStatementWithBoundFixtureSymbols(sql);
      int index = 1;
      for (String key : where.keySet()) {
        try {
          Object value = where.get(key);
          if (value instanceof InputStream) {
View Full Code Here
90
91
92
93
94
95
96
97
  /**
   * 使用默认的数据源执行相关sql操作
   */
  public void useDefaultDataSource() {
    DBEnvironment environment = DBEnvironmentFactory.getDBEnvironment();
    DBEnvironmentFactory.changeDBEnvironment(environment);
  }
View Full Code Here
TOP

Related Classes of org.jtester.module.database.environment.DBEnvironment

  • org.jtester.core.context.JTesterFitnesse
  • org.jtester.core.context.TransactionManager
  • org.jtester.module.database.dbop.DBOperator
  • org.jtester.module.database.util.SqlRunner
  • org.jtester.module.dbfit.DatabaseFixture
    • 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.