01: /*
02: * SalomeTMF is a Test Management Framework
03: * Copyright (C) 2005 France Telecom R&D
04: *
05: * This library is free software; you can redistribute it and/or
06: * modify it under the terms of the GNU Lesser General Public
07: * License as published by the Free Software Foundation; either
08: * version 2 of the License, or (at your option) any later version.
09: *
10: * This library is distributed in the hope that it will be useful,
11: * but WITHOUT ANY WARRANTY; without even the implied warranty of
12: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
13: * Lesser General Public License for more details.
14: *
15: * You should have received a copy of the GNU Lesser General Public
16: * License along with this library; if not, write to the Free Software
17: * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
18: *
19: * @author Fayçal SOUGRATI
20: *
21: * Contact: mikael.marche@rd.francetelecom.com
22: */
23:
24: package org.objectweb.salome_tmf.api.api2ihm.adminProject;
25:
26: import java.sql.PreparedStatement;
27: import java.sql.SQLException;
28: import java.util.Properties;
29:
30: import org.objectweb.salome_tmf.api.api2db.DataBase;
31: import org.objectweb.salome_tmf.api.api2db.DataSet;
32:
33: /**
34: * Classe contenant les fonctions communes aux classes de l'aire fonctionnelle "Administrer un projet"
35: */
36: public class APCommun {
37:
38: public static int getIdEnv(DataBase database, Properties prop,
39: int idProjet, String envName) {
40: int idEnv = 0;
41:
42: try {
43: PreparedStatement prep = database.prepareStatement(prop
44: .getProperty("selectIdEnv"));
45: prep.setInt(1, idProjet);
46: prep.setString(2, envName);
47:
48: DataSet DS = new DataSet(prep.executeQuery());
49:
50: if (DS.hasMoreElements()) {
51: idEnv = DS.getResults().getInt("id_env");
52: } else {
53: org.objectweb.salome_tmf.api.Api
54: .addException(new Exception("id not exist"));
55: }
56: } catch (SQLException e) {
57: e.printStackTrace();
58: }
59:
60: return idEnv;
61: }
62: }
|