Package com.ubx1.pdpscanner.server.database

Examples of com.ubx1.pdpscanner.server.database.MySQLConnection.connect()

41
42
43
44
45
46
47
48
49
50
51
     * Login validation
     */
    Validator.validateLogin(username, password);

    MySQLConnection conn = new MySQLConnection();
    conn.connect();

    username = "'" + username + "'";

    ResultSet rs = conn.SQLSelect("SELECT * FROM users WHERE username = "
        + username + " LIMIT 1");
View Full Code Here
113
114
115
116
117
118
119
120
121
122
123
     */
    Validator.validateSignUp(name, email, username, password, password,
        cell);

    MySQLConnection conn = new MySQLConnection();
    conn.connect();

    ResultSet rs = conn.SQLSelect("SELECT * FROM users");

    // Check username unicity
    while (rs.next()) {
View Full Code Here
204
205
206
207
208
209
210
211
212
213
214
      throw new InvalidSessionException();
    }

    MySQLConnection conn = new MySQLConnection();
    conn.connect();

    ResultSet rs = conn.SQLSelect("SELECT password FROM users WHERE id="
        + userId);

    if (rs.next()) {
View Full Code Here
248
249
250
251
252
253
254
255
256
257
258
      throw new InvalidSessionException();
    }

    MySQLConnection conn = new MySQLConnection();
    conn.connect();

    newPassword = "'" + BCrypt.hashpw(newPassword, BCrypt.gensalt()) + "'";

    conn.SQLUpdate("UPDATE users SET password=" + newPassword
        + " WHERE id=" + userId);
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
   */
  @Override
  public Project[] fetchProjects() throws Exception {

    MySQLConnection conn = new MySQLConnection();
    conn.connect();

    ResultSet rs1 = conn
        .SQLSelect("SELECT * FROM projects JOIN users_in_projects ON projects.id = users_in_projects.project "
            + "JOIN users ON "
            + "users_in_projects.user = users.id "
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
      try {
        checkProjectRepository(svnUrl, svnUser, svnPassword);

        MySQLConnection conn = new MySQLConnection();
        conn.connect();

        ResultSet rs = conn.SQLSelect("SELECT * FROM projects");

        // Check project name unicity
        while (rs.next()) {
View Full Code Here
210
211
212
213
214
215
216
217
218
219
220
   * @return a null String object
   */
  public String deleteProject(int id) throws Exception {

    MySQLConnection conn = new MySQLConnection();
    conn.connect();

    // First delete the associated stats
    conn.SQLUpdate("DELETE FROM general_stats "
        + "USING versions,general_stats " + "WHERE versions.project = "
        + id + " AND general_stats.version = versions.id");
View Full Code Here
252
253
254
255
256
257
258
259
260
261
262
   */
  @Override
  public Project fetchStats(Project p) throws Exception {

    MySQLConnection conn = new MySQLConnection();
    conn.connect();

    // Get project's stats for all versions
    ResultSet rs1 = conn
        .SQLSelect("SELECT * FROM versions JOIN general_stats "
            + "ON general_stats.version = versions.id "
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.