Package com.dotmarketing.common.db

Examples of com.dotmarketing.common.db.DotConnect.addParam()

20
21
22
23
24
25
26
27
28
29
30
  public void insertInode(String inode, String owner, String type, String identifier) throws SQLException {
    String sql = "INSERT INTO INODE(INODE, OWNER, IDATE, TYPE, IDENTIFIER) VALUES (?,?,CURRENT TIMESTAMP,?,?)";
    DotConnect dot = new DotConnect();
    dot.setSQL(sql);
    dot.addParam(inode);
    dot.addParam(owner);
    dot.addParam(type);
    dot.addParam(identifier);
    dot.executeStatement(sql);
View Full Code Here
21
22
23
24
25
26
27
28
29
30
31
  public void insertInode(String inode, String owner, String type, String identifier) throws SQLException {
    String sql = "INSERT INTO INODE(INODE, OWNER, IDATE, TYPE, IDENTIFIER) VALUES (?,?,CURRENT TIMESTAMP,?,?)";
    DotConnect dot = new DotConnect();
    dot.setSQL(sql);
    dot.addParam(inode);
    dot.addParam(owner);
    dot.addParam(type);
    dot.addParam(identifier);
    dot.executeStatement(sql);

  }
View Full Code Here
22
23
24
25
26
27
28
29
30
31
32
    String sql = "INSERT INTO INODE(INODE, OWNER, IDATE, TYPE, IDENTIFIER) VALUES (?,?,CURRENT TIMESTAMP,?,?)";
    DotConnect dot = new DotConnect();
    dot.setSQL(sql);
    dot.addParam(inode);
    dot.addParam(owner);
    dot.addParam(type);
    dot.addParam(identifier);
    dot.executeStatement(sql);

  }
 
View Full Code Here
23
24
25
26
27
28
29
30
31
32
33
    DotConnect dot = new DotConnect();
    dot.setSQL(sql);
    dot.addParam(inode);
    dot.addParam(owner);
    dot.addParam(type);
    dot.addParam(identifier);
    dot.executeStatement(sql);

  }
 
  public static synchronized String generateUuid(){
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
    DotConnect dotConnect = new DotConnect();
    StringBuffer sql = new StringBuffer("select * from user_favorites where page_url = ? and user_id = ?");

    dotConnect.setSQL(sql.toString());
    dotConnect.addParam(url_page);
    dotConnect.addParam(user_id);
    ArrayList results =null;
    try {
      results = dotConnect.getResults();
    } catch (DotDataException e) {
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
    DotConnect dotConnect = new DotConnect();
    StringBuffer sql = new StringBuffer("select * from user_favorites where page_url = ? and user_id = ?");

    dotConnect.setSQL(sql.toString());
    dotConnect.addParam(url_page);
    dotConnect.addParam(user_id);
    ArrayList results =null;
    try {
      results = dotConnect.getResults();
    } catch (DotDataException e) {
      Logger.error(FavoritesWebAPI.class,"isUrlFavorite method failed:"+ e, e);
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
      if (UtilMethods.isSet(url_params)) {
        url_page = url_page + "?" + url_params ;
      }

      dotConnect.setSQL(sql.toString());
      dotConnect.addParam(user_id);
      dotConnect.addParam(url_page);
      dotConnect.getResult();
    }
    catch (Exception e) {
      retVal = false;
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
        url_page = url_page + "?" + url_params ;
      }

      dotConnect.setSQL(sql.toString());
      dotConnect.addParam(user_id);
      dotConnect.addParam(url_page);
      dotConnect.getResult();
    }
    catch (Exception e) {
      retVal = false;
    }
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
      DotConnect dotConnect = new DotConnect();

      String sql = "select * from user_favorites where user_id = ?";

      dotConnect.setSQL(sql);
      dotConnect.addParam(user_id);
      ArrayList<HashMap> favorites = (ArrayList<HashMap>) dotConnect.getResults();

      for (HashMap<String, String> favorite : favorites) {
        String page_url = String.valueOf(favorite.get("page_url"));

View Full Code Here
171
172
173
174
175
176
177
178
179
180
181
    }
    DotConnect dc = new DotConnect();
    dc.setSQL(bob.toString().toLowerCase());
    if(params != null){
      for (Object value : params) {
        dc.addParam(value);
      }
    }
    if(query.getStart() > 0){
      dc.setStartRow(query.getStart());
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.