public ArrayList<String> getFreguesiasByConcelho(String c, String el) {
ArrayList<String> toRet = new ArrayList<>();
try {
conn = SqlConnect.connect();
PreparedStatement ps =
conn.prepareStatement(
"SELECT freguesia FROM `assembleia de voto` where concelho = '"
+ c
+ "' and eleicao = '"
+ el
+ "';");
ResultSet rs = ps.executeQuery();
for (; rs.next(); ) {
toRet.add(rs.getString("freguesia"));
}
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (Exception e) {
e.printStackTrace();
return null;
}
}
return toRet;
}
public void putTemplate(
String codigo,
String eleicao,
String concelho,
String freguesia,
String habertura,
String hencerramento,
String local) {
try {
conn = SqlConnect.connect();
PreparedStatement ps =
conn.prepareStatement(
"DELETE FROM `assembleia de voto` WHERE codigo='"
+ codigo
+ "' AND eleicao ='"
+ eleicao
+ "'");
ps.executeUpdate();
String q =
"INSERT INTO `assembleia de voto` VALUES ('"
+ codigo
+ "','"
+ eleicao
+ "','"
+ concelho
+ "','"
+ freguesia
+ "','"
+ habertura
+ "','"
+ hencerramento
+ "','"
+ local
+ "','"
+ 0
+ "','"
+ 0
+ "','"
+ 0
+ "','"
+ 0
+ "','"
+ 0
+ "');";
PreparedStatement sql = conn.prepareStatement(q);
sql.executeUpdate();
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
public void clear() {
try {
conn = SqlConnect.connect();
PreparedStatement ps = conn.prepareStatement("DELETE FROM `Assembleia de Voto`");
ps.executeUpdate();
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
} finally {
try {
conn.close();
conn = null;
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public boolean isEmpty() {
boolean b = false;
try {
conn = SqlConnect.connect();
PreparedStatement ps = conn.prepareStatement("SELECT * FROM `assembleia de voto`");
ResultSet rs = ps.executeQuery();
b = !rs.next();
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return b;
}
public int size() {
int i = -1;
try {
conn = SqlConnect.connect();
PreparedStatement ps = conn.prepareStatement("Select count(AV_id) from `assembleia de voto`");
ResultSet rs = ps.executeQuery();
if (rs.next()) {
i = rs.getInt(1);
}
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return i;
}
public boolean containsKey(Object key) throws NullPointerException {
boolean c = false;
try {
conn = SqlConnect.connect();
PreparedStatement ps =
conn.prepareStatement(
"Select codigo from `equipas` where codigo = '" + (String) key + "'");
ResultSet rs = ps.executeQuery();
c = rs.next();
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return c;
}
public void remove(String cod, String el) {
try {
conn = SqlConnect.connect();
PreparedStatement ps =
conn.prepareStatement(
"DELETE FROM `assembleia de voto` WHERE codigo =' "
+ cod
+ "' AND eleicao='"
+ el
+ "'");
ps.executeUpdate();
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
public Set<String> keySet() {
Set<String> res = new HashSet<String>();
try {
conn = SqlConnect.connect();
PreparedStatement ps = conn.prepareStatement("SELECT codigo FROM `assembleia de voto`");
ResultSet rs = ps.executeQuery();
for (; rs.next(); ) {
res.add(rs.getString("Codigo"));
}
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return res;
}
public ArrayList<String> getAssembleiasDeVoto(String eleicao) throws SQLException {
ArrayList<String> res = new ArrayList<String>();
try {
conn = SqlConnect.connect();
PreparedStatement ps =
conn.prepareStatement(
"Select codigo from `assembleia de voto` where eleicao ='" + eleicao + "'");
ResultSet rs = ps.executeQuery();
for (; rs.next(); ) {
res.add(rs.getString("codigo"));
}
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return res;
}
public AssembleiaDeVoto get(Object key) {
ArrayList<Eleitor> el = new ArrayList<Eleitor>();
AssembleiaDeVoto av = null;
try {
conn = SqlConnect.connect();
PreparedStatement ps =
conn.prepareStatement(
"Select * from `assembleia de voto` where codigo = '" + (String) key + "'");
ResultSet rs = ps.executeQuery();
if (rs.next()) {
String c = rs.getString("Codigo");
PreparedStatement ps1 =
conn.prepareStatement("Select * from `Eleitor` where assembleia de voto = '" + c + "'");
ResultSet rs2 = ps1.executeQuery();
for (; rs2.next(); ) {
int type = -1;
if (rs.getBoolean("presidente")) type = Eleitor.presidenteType;
if (rs.getBoolean("vice-presidente")) type = Eleitor.vPresidenteType;
if (rs.getBoolean("secretario")) type = Eleitor.secType;
if (rs.getBoolean("escrutinadores")) type = Eleitor.escType;
int typeL = -1;
if (rs.getBoolean("Deputado")) typeL = Eleitor.deputado;
if (rs.getBoolean("delegado")) typeL = Eleitor.delegado;
Eleitor e =
new Eleitor(
rs2.getString("Nr de Eleitor"),
rs2.getString("Nome"),
rs2.getInt("Idade"),
rs2.getDate("Data Recensiamento"),
rs2.getString("Distrito"),
rs2.getString("Concelho"),
rs2.getString("Freguesia"),
type,
typeL);
el.add(e);
}
av =
new AssembleiaDeVoto(
rs.getString("Codigo"),
rs.getString("Eleicao"),
rs.getString("concelho"),
rs.getString("freguesia"),
rs.getString("Hora de Abertura"),
rs.getString("Hora de Encerramento"),
rs.getString("Local"),
rs.getInt("Eleitores Inscritos"),
rs.getInt("Nr de votantes"),
rs.getInt("Votos em Branco"),
rs.getInt("Votos Nulos"),
rs.getInt("Nr de Reclamacoes"),
el);
}
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return av;
}
public void registarAssembleia(String key, AssembleiaDeVoto value) {
try {
conn = SqlConnect.connect();
for (Eleitor e : value.getResponsaveis()) {
if (e.getCargoVP() == Eleitor.vPresidenteType) {
PreparedStatement sql2 =
conn.prepareStatement(
"INSERT INTO `AVConstituintes` VALUES ('"
+ e.getNrEleitor()
+ "','"
+ key
+ "','"
+ value.getEleicao()
+ "',false,true,false,false)");
sql2.executeUpdate();
}
if (e.getCargoVP() == Eleitor.presidenteType) {
PreparedStatement sql2 =
conn.prepareStatement(
"INSERT INTO `AVConstituintes` VALUES ('"
+ e.getNrEleitor()
+ "','"
+ key
+ "','"
+ value.getEleicao()
+ "',true,false,false,false)");
sql2.executeUpdate();
}
if (e.getCargoVP() == Eleitor.secType) {
PreparedStatement sql2 =
conn.prepareStatement(
"INSERT INTO `AVConstituintes` VALUES ('"
+ e.getNrEleitor()
+ "','"
+ key
+ "','"
+ value.getEleicao()
+ "',false,false,true,false)");
sql2.executeUpdate();
}
if (e.getCargoVP() == Eleitor.escType) {
PreparedStatement sql2 =
conn.prepareStatement(
"INSERT INTO `AVConstituintes` VALUES ('"
+ e.getNrEleitor()
+ "','"
+ key
+ "','"
+ value.getEleicao()
+ "',false,false,false,true)");
sql2.executeUpdate();
}
}
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
public AssembleiaDeVoto put(String key, AssembleiaDeVoto value) {
try {
conn = SqlConnect.connect();
String s =
"Replace INTO `assembleia de voto` VALUES ('"
+ key
+ "','"
+ value.getEleicao()
+ "','"
+ value.getConcelho()
+ "','"
+ value.getFreguesia()
+ "','"
+ value.getHabertura()
+ "','"
+ value.getHencerramento()
+ "','"
+ value.getLocal()
+ "','"
+ value.getNrEleitores()
+ "','"
+ value.getNrVotantes()
+ "','"
+ value.getVotosBrancos()
+ "','"
+ value.getVotosNulos()
+ "','"
+ value.getNrReclamacoes()
+ "')";
PreparedStatement sql = conn.prepareStatement(s);
for (Eleitor e : value.getResponsaveis()) {
if (e.getCargoVP() == Eleitor.vPresidenteType) {
PreparedStatement sql2 =
conn.prepareStatement(
"INSERT INTO `AVConstituintes` VALUES ('"
+ e.getNrEleitor()
+ "','"
+ key
+ "','"
+ value.getEleicao()
+ "',false,true,false,false)");
sql2.executeUpdate();
}
if (e.getCargoVP() == Eleitor.presidenteType) {
PreparedStatement sql2 =
conn.prepareStatement(
"INSERT INTO `AVConstituintes` VALUES ('"
+ e.getNrEleitor()
+ "','"
+ key
+ "','"
+ value.getEleicao()
+ "',true,false,false,false)");
sql2.executeUpdate();
}
if (e.getCargoVP() == Eleitor.secType) {
PreparedStatement sql2 =
conn.prepareStatement(
"INSERT INTO `AVConstituintes` VALUES ('"
+ e.getNrEleitor()
+ "','"
+ key
+ "','"
+ value.getEleicao()
+ "',false,false,true,false)");
sql2.executeUpdate();
}
if (e.getCargoVP() == Eleitor.escType) {
PreparedStatement sql2 =
conn.prepareStatement(
"INSERT INTO `AVConstituintes` VALUES ('"
+ e.getNrEleitor()
+ "','"
+ key
+ "','"
+ value.getEleicao()
+ "',false,false,false,true)");
sql2.executeUpdate();
}
}
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (Exception e) {
e.printStackTrace();
return null;
}
}
return value;
}