HashDao.java
2.15 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
package br.com.dao;
import java.security.NoSuchAlgorithmException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import br.com.model.entity.Questionario;
import br.com.util.DateUtil;
import br.com.util.GeradorCodigoHash;
public class HashDao {
public Questionario verificarHash(String path, String valorHash) {
StringBuffer sql = new StringBuffer();
Connection con = Conexao.conecta(path);
Statement estado;
ResultSet rset = null;
Questionario questionario = new Questionario();
try {
//String hashAutenticacao = GeradorCodigoHash.gerarHash(valorHash);
estado = con.createStatement();
estado.execute(sql.toString());
sql.append("SELECT id_questionario, dt_inicio_questionario, dt_fim_questionario,");
sql.append("no_orgao, hash_autenticacao, questionario_respondido");
sql.append(" FROM questionario where hash_autenticacao = '" + valorHash + "'");
sql.append(" and (dt_inicio_questionario <= '" + DateUtil.dataHoraAtual() + "')");
sql.append(" and (dt_fim_questionario >= '" + DateUtil.dataHoraAtual() + "');");
rset = estado.executeQuery(sql.toString());
while (rset.next()) {
questionario.setIdQuestionario(rset.getInt("id_questionario"));
questionario.setDtFimQuestionario(rset.getString("dt_fim_questionario"));
questionario.setDtInicioQuestionario(rset.getString("dt_inicio_questionario"));
questionario.setHashAutenticacao(rset.getString("hash_autenticacao"));
questionario.setNoOrgao(rset.getString("no_orgao").replace("</br>", "").replace("<br>", ""));
questionario.setHashAutenticacao(rset.getString("hash_autenticacao"));
questionario.setQuestionario_respondido(rset.getBoolean("questionario_respondido"));
}
} catch (SQLException e) {
System.out.println("Deu erro!");
e.printStackTrace();
} finally {
if (con != null) {
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
return questionario;
}
}