Package com.mysql.jdbc

Examples of com.mysql.jdbc.Connection$UltraDevWorkAround

71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
    return id;
  }
 
  @Override
  public void ajouterBon(Bon b) {
    Connection connex;
    connex = getConnection();
    String insert = "INSERT INTO `bon`(`id`) VALUES (?)";
    try {
      PreparedStatement preStat = (PreparedStatement) connex.prepareStatement(insert);   
      preStat.setInt(1, b.getId());
      preStat.executeUpdate();
    }catch (SQLException ignore) {     
      System.out.println("erreur ajouterBon : " + ignore);
    }
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
   * retourne une arraylist composée des id des achat de l'utilisateur passé en paramètre
   * @see com.netflox.dao.GestionVente#venteUtilisateur(com.netflox.model.Utilisateur)
   */
  public ArrayList<Vente> venteUtilisateur(Utilisateur c) {
    ArrayList<Vente> l = new ArrayList<Vente>();
    Connection connex;
    connex = getConnection();
    String select = "SELECT * FROM `vente` WHERE `idClient` = ?";
    try {
      PreparedStatement preStat = (PreparedStatement) connex.prepareStatement(select);   
      preStat.setInt(1, c.getId());       
      ResultSet rs = preStat.executeQuery();
      while(rs.next()){
        Vente v = new Vente();
        v.setId(rs.getInt(1));
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
  }
 
  @Override
  public ArrayList<String[]> filmLoueUtilisateur(Utilisateur c) {
    ArrayList<String[]> l = new ArrayList<String[]>();
    Connection connex;
    connex = getConnection();
    String select = "SELECT `idFilm`,`date` FROM `vente` WHERE `idClient` = ? AND `type` = ?";
    try {
      PreparedStatement preStat = (PreparedStatement) connex.prepareStatement(select);   
      preStat.setInt(1, c.getId());
      preStat.setString(2, "l");
      ResultSet rs = preStat.executeQuery();
      while(rs.next()){
        String loc[] = {rs.getString(1) , String.valueOf(rs.getLong(2))};
View Full Code Here
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
   * retourne la liste des films vendu
   * @see com.netflox.dao.GestionVente#filmVendu()
   */
  public ArrayList<String> filmsInfosVenteLoueBon(String type) {
    ArrayList<String> l = new ArrayList<String>();
    Connection connex;
    connex = getConnection();
    String select = "SELECT  `idFilm` FROM `vente` WHERE `type` = ?";
    try {
      PreparedStatement preStat = (PreparedStatement) connex.prepareStatement(select);   
      preStat.setString(1, type);       
      ResultSet rs = preStat.executeQuery();
      while(rs.next()){
        l.add(rs.getString(1));
      }
View Full Code Here
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
    return l;
  }

  @Override
  public int bonValide(int id) {
    Connection connex;
    connex = getConnection();
    String select = "SELECT `utilise` FROM `bon` WHERE `id`= ?";
    try {
      PreparedStatement preStat = (PreparedStatement) connex.prepareStatement(select);   
      preStat.setInt(1, id);       
      ResultSet rs = preStat.executeQuery();
      while(rs.next()){
        if(rs.getInt(1) == 0){
          int montant = -1;
          String select2 = "SELECT `prix` FROM `vente` WHERE `id` = ?";
          PreparedStatement preStat2 = (PreparedStatement) connex.prepareStatement(select2);   
          preStat2.setInt(1, id);       
          ResultSet rs2 = preStat2.executeQuery();
          while(rs2.next()){
            montant = rs2.getInt(1);
          }
View Full Code Here
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
    return -1;
  }

  @Override
  public void updateBon(Bon b) {
    Connection connex;
    connex = getConnection();
    String select = "UPDATE `bon` SET `idFilm`=?,`dateU`=?,`type`=?,`idClientU`=?,`utilise`=? WHERE `id` = ?";
    try {
      PreparedStatement preStat = (PreparedStatement) connex.prepareStatement(select);   
      preStat.setString(1, b.getIdFilm());
      preStat.setLong(2, b.getDateU());
      preStat.setString(3, b.getType());
      preStat.setInt(4, b.getIdClientU());
      preStat.setInt(5, b.getUtilise());
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
48
        this.detailDao = detailDao;
    }

    public List getPipeLineListByObjectInspectionId(Integer id, Properties props) throws SQLException {

        Connection dbConn = getConnection(props);
        Statement st = (Statement) dbConn.createStatement();
        ResultSet rs = (ResultSet) st.executeQuery("select * from pipeLineElement where objectId=" + id);
        List plList = setValues(rs);
        rs.close();
        return plList;

View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
61
    }

    public List getPipeLineListByObjectInspectionAndDetailType(Integer typeId, Integer objectId, Properties props) throws SQLException {


        Connection dbConn = getConnection(props);
        Statement st = (Statement) dbConn.createStatement();
        ResultSet rs = (ResultSet) st.executeQuery("select * from pipeLineElement where objectId=" + objectId + " and detailTypeId=" + typeId);
        List plList = setValues(rs);
        rs.close();

        return plList;
View Full Code Here
168
169
170
171
172
173
174
175
176
177
178
    }

    private Connection getConnection(Properties props) {

        String driverURL = "jdbc:mysql://localhost/vstbase?useUnicode=true&amp;characterEncoding=UTF-8";
        Connection dbConn = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            dbConn = (Connection) DriverManager.getConnection(driverURL, props);
            return dbConn;
        }
View Full Code Here
7
8
9
10
11
12
13
14
15
16
17
import junit.framework.TestCase;

public class ContextTest extends TestCase {

  public void testDBConnection() throws Exception {
    Connection conS =  Context.getSourceConnection();
    assertFalse(conS.isClosed());
   
    Connection conD =  Context.getDestinationConnection();
    assertFalse(conD.isClosed());
  }
View Full Code Here
TOP

Related Classes of com.mysql.jdbc.Connection$UltraDevWorkAround

  • accountService.AccountServiceTest
  • br.edu.Calcados.Dao.UsuarioDao
  • co.edu.eafit.ejemplopersistencia.dao.ClienteDAO
  • co.edu.eafit.ejemplopersistencia.dao.CuentaDAO
  • com.github.kristofa.brave.mysql.MySQLStatementInterceptorTest
  • com.mysql.jdbc.profiler.ProfilerEvent
  • com.mysql.jdbc.util.LRUCache
  • com.netflox.dao.MysqlGestionUtilisateur
  • com.netflox.dao.MysqlGestionVente
  • com.vst.dao.hibernate.ConstructionDefectDaoHibernate
    • 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.