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;
}