public String getONT() {
Connection con;
String ontid = null;
String JsonStr = "{\"ont\": [";
try {
con = DataSource.getConnection();
PreparedStatement pst = con.prepareStatement("select ont_id from ont");
ResultSet rs = pst.executeQuery();
int flag = 1;
while (rs.next()) {
flag = 0;
ontid = rs.getString("ont_id");
JsonStr += "{\"ont_id\":\"" + ontid + "\"},";
}
if (flag == 1) {
JsonStr += ",";
}
int len = JsonStr.length();
JsonStr = JsonStr.substring(0, len - 1);
JsonStr += "],";
} catch (SQLException | ClassNotFoundException e) {
System.out.println("error connection to the database getponids" + e.getMessage());
return "";
}
System.out.println(JsonStr);
DataSource.returnConnection(con);
return JsonStr;
}
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 QueryManager() {
try {
connector = new PostgisConnector();
statement = connector.getStatement();
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
}
}
public DBWorker() {
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection(HOST, USERNAME, PASSWORD);
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
}
}
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 JSONObject getManufacturers() {
JSONObject result = new JSONObject();
Connection dbConnection = null;
try {
Class.forName("com.mysql.jdbc.Driver");
dbConnection =
DriverManager.getConnection(PathNames.DB_URL, PathNames.USERNAME, PathNames.PASSWORD);
String query =
"SELECT * FROM "
+ PathNames.DB_MANUFACTURER_CATEGORIES
+ " cats, "
+ PathNames.DB_MANUFACTURERS
+ " mans WHERE cats.category_key='"
+ catkey
+ "' AND mans.manufacturer_id=cats.manufacturer_id";
System.out.println(query);
// Execute a query
Statement statement = dbConnection.createStatement();
ResultSet rs = statement.executeQuery(query);
JSONArray typeList = new JSONArray();
while (rs.next()) {
JSONObject curr = new JSONObject();
curr.put("catkey", rs.getString("category_key"));
curr.put("manufacturer_id", rs.getString("manufacturer_id"));
curr.put("manufacturer", rs.getString("manufacturer"));
curr.put("image", rs.getString("image_name"));
typeList.add(curr);
}
result.put("manufacturers", typeList);
manufacturers = result;
} catch (SQLException | ClassNotFoundException ex) {
ex.printStackTrace();
} finally {
try {
dbConnection.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return result;
}
private void connect() {
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(databaseURL, username, password.toString());
// conn = DriverManager.getConnection(tempURL);
conn.setAutoCommit(false);
} catch (SQLException | ClassNotFoundException e) {
System.out.println("error connecting to SQL Database");
e.printStackTrace();
}
}
public static void getTable(PrintWriter out) {
out.println("<!DOCTYPE html>");
out.println("<html lang=\"en\">");
out.println("<head>");
out.println(
"<link rel=\"stylesheet\" href=\"https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css\" integrity=\"sha512-dTfge/zgoMYpP7QbHy4gWMEGsbsdZeCXz7irItjcC3sPUFtf0kuFbDz/ixG7ArTxmDjLXDmezHubeNikyKGVyQ==\"crossorigin=\"anonymous\">");
out.println("</head><body>");
out.println(
"<table class=\"table table-hover\"><thead style = \"color:#4C1818\"><tr><th>Assignment</th><th>Grade</th></tr></thead><tbody>");
try {
// URL of Oracle database server
String url = "jdbc:oracle:thin:system/password@localhost";
Class.forName("oracle.jdbc.driver.OracleDriver");
// properties for creating connection to Oracle database
Properties props = new Properties();
props.setProperty("user", "testuserdb");
props.setProperty("password", "password");
// creating connection to Oracle database using JDBC
Connection conn = DriverManager.getConnection(url, props);
String sql = "Select * from Gradebook";
// creating PreparedStatement object to execute query
PreparedStatement preStatement = conn.prepareStatement(sql);
ResultSet result = preStatement.executeQuery();
// System.out.printf("%15s %15s", "First Name", "Last Name");
// System.out.println();
while (result.next()) {
assignmentname = result.getString("ASSIGNMENT");
assignmentgrade = result.getString("GRADE");
out.println("<tr><td>" + assignmentname + "</td>");
out.println("<td>" + assignmentgrade + "</td></tr>");
}
conn.close();
} catch (SQLException | ClassNotFoundException e) {
System.out.println(e.getMessage());
e.printStackTrace();
}
out.println(
"<br><br><form action = \"ShowAverage\" method \"POST\"><button type=\"Show Average\" class=\"btn btn-primary btn-sm\">Show Average</button></form>");
out.println(
"<script> src=\"https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js\"></script>");
out.println(
"<script src=\"https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js\" integrity=\"sha512-K1qjQ+NcF2TYO/eI3M6v8EiNYZfA95pQumfvcVrTHtwQVDG+aHRqLi/ETn2uB+1JqwYqVG3LIvdm9lj6imS/pQ==\" crossorigin=\"anonymous\"></script>");
out.println("</body></html>");
}
public void updateOntStatus(String ontid, String status) {
Connection con = null;
try {
con = DataSource.getConnection();
PreparedStatement pst = con.prepareStatement("update ont set status=? where ont_id=?");
pst.setString(1, status);
pst.setString(2, ontid);
pst.executeUpdate();
pst.close();
} catch (SQLException | ClassNotFoundException e) {
System.out.println("in update ONT status" + e.getMessage());
}
DataSource.returnConnection(con);
}
/** hace la conexion */
public static void performConnection() {
String host = "localhost";
String user = "******";
String pass = "******";
String dtbs = "polla2";
try {
Class.forName("com.mysql.jdbc.Driver");
String newConnectionURL =
"jdbc:mysql://" + host + "/" + dtbs + "?" + "user="******"&password=" + pass;
con = DriverManager.getConnection(newConnectionURL);
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
}
}
/**
* Retorna um objeto Connection relacionado ao database selecionado.
*
* @return Um objeto Connection se conseguiu criar a conexão
* @throws RuntimeException caso ocorra algum erro
*/
public static Connection getConnetion() {
try {
if (!setted) {
Class.forName("org.postgresql.Driver");
stdConnection =
DriverManager.getConnection("jdbc:postgresql://localhost/testejee", "baby", "123456");
setted = true;
}
return stdConnection;
} catch (SQLException | ClassNotFoundException e) {
log.error("Erro ao criar conexão com o banco de dados! MSG: " + e.getMessage());
throw new RuntimeException(e);
}
}
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 static void updateTable() {
try {
// URL of Oracle database server
String url = "jdbc:oracle:thin:system/password@localhost";
Class.forName("oracle.jdbc.driver.OracleDriver");
// properties for creating connection to Oracle database
Properties props = new Properties();
props.setProperty("user", "testuserdb");
props.setProperty("password", "password");
// creating connection to Oracle database using JDBC
Connection conn = DriverManager.getConnection(url, props);
String sql =
"Insert into GRADEBOOK (ENTRY,ASSIGNMENT,GRADE) values (seq_entry.nextval"
+ ",'"
+ assign
+ "',"
+ grade
+ ")";
// creating PreparedStatement object to execute query
PreparedStatement preStatement = conn.prepareStatement(sql);
ResultSet result = preStatement.executeQuery();
// System.out.printf("%15s %15s", "First Name", "Last Name");
// System.out.println();
// while(result.next()){
//
// CustId = result.getString("CUSTOMER_ID");
// name = result.getString("CUST_FIRST_NAME");
// Lname=result.getString("CUST_LAST_NAME");
//// out.println(name);
//// out.println(Lname);
// name = name + " " + Lname;
// out.println("<tr><td><a href=\"Details?CustId=" + CustId + "\">" + name +
// "</a></td></tr>");
//
// }
conn.close();
} catch (SQLException | ClassNotFoundException e) {
System.out.println(e.getMessage());
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 Boolean identify() throws IOException, SQLException {
Boolean result = false;
try {
resultSet =
hBaseSQLManager.executeSqlGetString(
"SELECT MD5_ID FROM VISITOR WHERE MD5_ID ='" + getMd5Id() + "'");
if (resultSet.next()) result = true;
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
} finally {
if (hBaseSQLManager.statement != null)
try {
hBaseSQLManager.statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return result;
}
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 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;
}
/** controls behaver for save button */
public void onSave() {
try {
dbCon = DBController.getInstance();
dbCon.insertInto(
"Survey_Template",
DBController.appendApo(createSurvey.getSurveyName()),
DBController.appendApo(this.getTemplateName()));
createSurvey
.getSurveyPrevModel()
.getData(
"Survey_Template",
"Survey = " + DBController.appendApo(createSurvey.getSurveyName()),
1,
"Survey",
"Template");
createSurvey.getSurveyTemplateListModel().getData();
} catch (SQLException | ClassNotFoundException 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 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 static void main(String[] args) {
Connection connection = null;
try {
// Register the driver
Class.forName("org.postgresql.Driver");
// Make the connection
connection =
DriverManager.getConnection(
"jdbc:postgresql://cmps180-db.lt.ucsc.edu/ssmcgrat", "ssmcgrat", "calculated33XML");
StoreApplication app = new StoreApplication();
List<String> phoneNumbers =
app.getCustomerPhoneFromFirstLastName(connection, "John", "Smith");
/** ********** Print the phone numbers here: *************** */
List<String> filmTitles = app.getFilmTitlesBasedOnLengthRange(connection, 60, 120);
/** *********** Print the film titles here: **************** */
int count = app.countCustomersInDistrict(connection, "Buenos Aires", false);
/** ********** Print the customer count here: ************* */
// add a film to the database
app.insertFilmIntoInventory(connection, "Sequel to the Prequel", "Memorable", 98, "PG-13");
} catch (SQLException | ClassNotFoundException e) {
System.out.println("Error while connecting to database: " + e);
e.printStackTrace();
} finally {
if (connection != null) {
// Closing Connection
try {
connection.close();
} catch (SQLException e) {
System.out.println("Failed to close connection: " + e);
e.printStackTrace();
}
}
}
}
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;
}
@Override
public synchronized Account newAccount(String name) throws RemoteException, RejectedException {
AccountImpl account = (AccountImpl) accounts.get(name);
if (account != null) {
System.out.println("Account [" + name + "] exists!!!");
throw new RejectedException(
"Rejected: Bank: Account for: " + name + " already exists: " + account);
}
ResultSet result = null;
try {
findAccountStatement.setString(1, name);
result = findAccountStatement.executeQuery();
if (result.next()) {
// account exists, instantiate, put in cache and throw exception.
account = new AccountImpl(name, result.getFloat("balance"), getConnection());
accounts.put(name, account);
throw new RejectedException("Rejected: Account for: " + name + " already exists");
}
result.close();
// create account.
createAccountStatement.setString(1, name);
int rows = createAccountStatement.executeUpdate();
if (rows == 1) {
account = new AccountImpl(name, getConnection());
accounts.put(name, account);
System.out.println("Bank: Account: " + account + " has been created for " + name);
return account;
} else {
throw new RejectedException("Cannot create an account for " + name);
}
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
throw new RejectedException("Cannot create an account for " + name, e);
}
}
public static void main(String[] args) {
try {
Connection connection = BddConnection.getConnection();
String sql = "INSERT INTO Producto VALUES (?,?,?,?,?,?)";
PreparedStatement statement = connection.prepareStatement(sql);
File img = new File("imgPrueba.jpg");
FileInputStream in = new FileInputStream(img);
// ID
statement.setString(1, "1");
// Stock
statement.setInt(2, 111);
// Web clob
statement.setString(3, "www.clob.com");
// Image blob
statement.setBinaryStream(4, in, img.length());
statement.execute();
System.out.println("Insercion realizada");
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
} catch (FileNotFoundException e) {
e.printStackTrace();
}
}
/*
* (non-Javadoc)
* @see de.zbit.Launcher#commandLineMode(de.zbit.AppConf)
*/
@Override
public void commandLineMode(AppConf appConf) {
SBProperties args = appConf.getCmdArgs();
if (args.containsKey(LogOptions.LOG_FILE)) {
LogUtil.addHandler(
new ConsoleHandler() {
/** Formatter */
OneLineFormatter formatter = new OneLineFormatter(false, false, false);
/*
* (non-Javadoc)
* @see java.util.logging.StreamHandler#flush()
*/
@Override
public synchronized void flush() {
System.out.flush();
}
/*
* (non-Javadoc)
* @see
* java.util.logging.ConsoleHandler#publish(java.util.logging.LogRecord)
*/
@Override
public void publish(LogRecord record) {
if (record.getLevel().intValue() == Level.INFO.intValue()) {
try {
String message = formatter.format(record);
System.out.write(message.getBytes());
} catch (IOException exc) {
reportError(null, exc, ErrorManager.FORMAT_FAILURE);
return;
}
}
}
},
getLogPackages());
}
BiGGDB bigg = null;
Parameters parameters = new Parameters();
parameters.annotateWithBiGG = args.getBooleanProperty(ModelPolisherOptions.ANNOTATE_WITH_BIGG);
if (parameters.annotateWithBiGG) {
try {
// Connect to database and launch application:
String passwd = args.getProperty(DBOptions.PASSWD);
bigg =
new BiGGDB(
new PostgreSQLConnector(
args.getProperty(DBOptions.HOST),
args.getIntProperty(DBOptions.PORT),
args.getProperty(DBOptions.USER),
passwd != null ? passwd : "",
args.getProperty(DBOptions.DBNAME)));
} catch (SQLException | ClassNotFoundException exc) {
exc.printStackTrace();
}
}
// Gives users the choice to pass an alternative model notes XHTML file to
// the program.
File modelNotesFile = parseFileOption(args, ModelPolisherOptions.MODEL_NOTES_FILE);
File documentNotesFile = parseFileOption(args, ModelPolisherOptions.DOCUMENT_NOTES_FILE);
String documentTitlePattern = null;
if (args.containsKey(ModelPolisherOptions.DOCUMENT_TITLE_PATTERN)) {
documentTitlePattern = args.getProperty(ModelPolisherOptions.DOCUMENT_TITLE_PATTERN);
}
double[] coefficients = null;
if (args.containsKey(ModelPolisherOptions.FLUX_COEFFICIENTS)) {
String c = args.getProperty(ModelPolisherOptions.FLUX_COEFFICIENTS);
String coeff[] = c.substring(1, c.length() - 1).split(",");
coefficients = new double[coeff.length];
for (int i = 0; i < coeff.length; i++) {
coefficients[i] = Double.parseDouble(coeff[i].trim());
}
}
String fObj[] = null;
if (args.containsKey(ModelPolisherOptions.FLUX_OBJECTIVES)) {
String fObjectives = args.getProperty(ModelPolisherOptions.FLUX_OBJECTIVES);
fObj = fObjectives.substring(1, fObjectives.length() - 1).split(":");
}
parameters.includeAnyURI = args.getBooleanProperty(ModelPolisherOptions.INCLUDE_ANY_URI);
parameters.checkMassBalance = args.getBooleanProperty(ModelPolisherOptions.CHECK_MASS_BALANCE);
parameters.compression =
ModelPolisherOptions.Compression.valueOf(
args.getProperty(ModelPolisherOptions.COMPRESSION_TYPE));
parameters.documentNotesFile = documentNotesFile;
parameters.documentTitlePattern = documentTitlePattern;
parameters.fluxCoefficients = coefficients;
parameters.fluxObjectives = fObj;
parameters.modelNotesFile = modelNotesFile;
parameters.omitGenericTerms = args.getBooleanProperty(ModelPolisherOptions.OMIT_GENERIC_TERMS);
parameters.sbmlValidation = args.getBooleanProperty(ModelPolisherOptions.SBML_VALIDATION);
// run polishing operations in background and parallel.
try {
batchProcess(
bigg,
new File(args.getProperty(IOOptions.INPUT)),
new File(args.getProperty(IOOptions.OUTPUT)),
parameters);
} catch (SBMLException | XMLStreamException | IOException exc) {
exc.printStackTrace();
}
}
/**
* Method which saves visitor. There are listed 4 cases: 1. Visitor's cookiesId & cookiesData are
* equal to visitor's MD5_ID & MD5_DATA into HBase. 2. Visitor's cookiesId are equal to MD5_ID
* from HBase, but DATA is not equal. The we update visitor. 3. Visitor's cookies does not have
* cookiesId or cookiesData. If visitor's md5Data is found into HBase, then we assign visitor to
* existing one. 4. Visitor's cookies does not have cookiesId or cookiesData. Create new visitor
* if nothing similar found into Hbase.
*/
@Override
public void save() {
// JSONObject response = new JSONObject();
String cookiesId = getMd5Id();
String cookiesData = getMd5Data();
String md5IdSearch = "";
String md5DataSearch = "";
int visitorId = 0;
// CASE: WHEN THERE ARE COOKIES BUT THERE ARE NO USER IN DB!!!
/** This if checks if visitor has cookies. */
if (!cookiesId.equals("")) {
try {
resultSet =
hBaseSQLManager.executeSqlGetString(
"SELECT * FROM VISITOR WHERE MD5_ID ='" + cookiesId + "'");
if (resultSet.next()) {
md5IdSearch = resultSet.getString("MD5_ID");
md5DataSearch = resultSet.getString("MD5_DATA");
visitorId = resultSet.getInt("ID");
}
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
} finally {
if (hBaseSQLManager.statement != null)
try {
hBaseSQLManager.statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (cookiesId.equals(md5IdSearch)) {
if (cookiesData.equals(md5DataSearch)) {
} else {
/* Seems user changed something. We'll update visitor. OK */
try {
hBaseSQLManager.executeSqlGetIdOnUpdate(
"UPSERT INTO VISITOR(ID, USER_AGENT, HEADERS, "
+ "TIMEZONE, SCREEN, ENABLED_COOKIES, PLUGINS, FONTS, MD5_ID, MD5_DATA) "
+ "VALUES("
+ visitorId
+ ", '"
+ getUserAgent()
+ "', '"
+ getHeaders()
+ "', "
+ getTimezone()
+ ", '"
+ getScreen()
+ "', '"
+ isEnabledCookies()
+ "'"
+ ", '"
+ getPlugins()
+ "', '"
+ getFonts()
+ "', '"
+ getMd5Id()
+ "', '"
+ getMd5Data()
+ "')");
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
} finally {
if (hBaseSQLManager.statement != null)
try {
hBaseSQLManager.statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
/** This if checks if visitor does not have cookies. */
if (cookiesId.equals("")) {
String md5id = "";
try {
resultSet =
hBaseSQLManager.executeSqlGetString(
"SELECT MD5_DATA FROM VISITOR WHERE MD5_DATA = '" + getMd5Data() + "'");
if (resultSet.next()) md5DataSearch = resultSet.getString("MD5_DATA");
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
} finally {
if (hBaseSQLManager.statement != null)
try {
hBaseSQLManager.statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (md5DataSearch.equals(getMd5Data())) {
try {
resultSet =
hBaseSQLManager.executeSqlGetString(
"SELECT MD5_ID FROM VISITOR WHERE MD5_DATA = '" + md5DataSearch + "'");
if (resultSet.next()) md5id = resultSet.getString("MD5_ID");
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
} finally {
if (hBaseSQLManager.statement != null)
try {
hBaseSQLManager.statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
setMd5Id(md5id);
} else {
try {
hBaseSQLManager.executeSqlGetIdOnUpdate(
"UPSERT INTO VISITOR(ID, USER_AGENT, TIMEZONE, HEADERS, SCREEN, ENABLED_COOKIES, PLUGINS,"
+ " FONTS, MD5_DATA) "
+ "VALUES(NEXT VALUE FOR VISITOR.VISITOR_SEQUENCE, '"
+ getUserAgent()
+ "', "
+ getTimezone()
+ ", '"
+ getHeaders()
+ "', '"
+ getScreen()
+ "', '"
+ isEnabledCookies()
+ "'"
+ ", '"
+ getPlugins()
+ "', '"
+ getFonts()
+ "', '"
+ getMd5Data()
+ "')");
try {
resultSet =
hBaseSQLManager.executeSqlGetString(
"SELECT ID FROM VISITOR WHERE MD5_DATA = '" + getMd5Data() + "'");
if (resultSet.next()) visitorId = resultSet.getInt("ID");
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
} finally {
if (hBaseSQLManager.statement != null) hBaseSQLManager.statement.close();
}
md5id = createMD5(Integer.toString(visitorId));
setMd5Id(md5id);
hBaseSQLManager.executeSqlGetIdOnUpdate(
"UPSERT INTO VISITOR(ID, MD5_ID) VALUES(" + visitorId + ", '" + getMd5Id() + "')");
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
} finally {
if (hBaseSQLManager.statement != null)
try {
hBaseSQLManager.statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
try {
try {
hBaseSQLManager.close();
} catch (SQLException e) {
e.printStackTrace();
}
} catch (ClassNotFoundException 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;
}
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 doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String userAgent = request.getHeader("user-agent");
if (userAgent.matches(".*Android.*")) {
int flag = 0;
try {
Connection con = DBConnectionAdmin.getConnection();
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT email,password FROM admin");
String emailmember = request.getParameter("mail");
String passwordmember = request.getParameter("pass");
while (rs.next()) {
String email = rs.getString("email");
String password = rs.getString("password");
if (email.equals(emailmember) && password.equals(passwordmember)) {
flag = 1; // success in login
break;
}
}
/*if(request.getParameter("remember")!=null ){
if( request.getParameter("remember").equals("yes") ){
Cookie c1 = new Cookie("email", emailmember);
c1.setMaxAge(60*60*24*365);
response.addCookie(c1);
Cookie c2 = new Cookie("password", passwordmember);
c2.setMaxAge(60*60*24*365);
response.addCookie(c2);
}
}
else{
Cookie[] cookies = request.getCookies();
if (cookies != null) {
for(Cookie cookie: cookies) {
if(cookie.getName().equals("email")){
cookie.setMaxAge(0);
response.addCookie(cookie);
}
else if(cookie.getName().equals("password")){
cookie.setMaxAge(0);
response.addCookie(cookie);
}
}
}
}*/
} catch (SQLException | ClassNotFoundException e1) {
e1.printStackTrace();
}
if (flag == 1) {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String docType = "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 " + "Transitional//EN\">\n";
String title = "You Signed In Successfully";
out.println(
docType
+ "<HTML>\n"
+ "<HEAD>"
+ "<script type='text/javascript'>"
+ "function changeweb() {"
+ " AndroidFunction.Second();"
+ "}"
+ "</script>"
+ "<TITLE>"
+ title
+ "</TITLE></HEAD>\n"
+ "<BODY BGCOLOR=\"#FDF5E6\" ><H1 ALIGN=CENTER>"
+ title
+ "</H1>\n"
+ "<button type='button' onclick=\"changeweb()\">Click Me!</button>"
+ "</BODY></HTML>");
HttpSession session = request.getSession(true);
String email = request.getParameter("mail");
session.setAttribute("email", email);
} else {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String docType = "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 " + "Transitional//EN\">\n";
String title = "Wrong password or E-mail.Please try again.";
out.println(
docType
+ "<HTML>\n"
+ "<HEAD><TITLE>"
+ title
+ "</TITLE></HEAD>\n"
+ "<BODY BGCOLOR=\"#FDF5E6\" ><H1 ALIGN=CENTER>"
+ title
+ "</H1>\n</BODY></HTML>");
}
} else {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String docType = "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 " + "Transitional//EN\">\n";
String title = "Main";
out.println(
docType
+ "<HTML>\n"
+ "<HEAD><TITLE>"
+ title
+ "</TITLE>"
+ "<style>"
+ "ul"
+ "{"
+ "list-style-type:none;"
+ "margin:0;"
+ "padding:0;"
+ "overflow:hidden;"
+ "}"
+ "li"
+ "{"
+ "float:left;"
+ "}"
+ "a:link,a:visited"
+ "{"
+ "display:block;"
+ "font-weight:bold;"
+ "font-size:200%;"
+ "color:#FFFFFF;"
+ "background-color:#98bf21;"
+ "text-align:center;"
+ "padding:4px;"
+ "text-decoration:none;"
+ "text-transform:uppercase;"
+ "border: 1px solid black;"
+ "padding:25px"
+ "}"
+ "a:hover,a:active"
+ "{"
+ "background-color:#7A991A;"
+ "}"
+ "</style>"
+ "</HEAD>\n"
+ "<body style='background-color:black' >\n");
out.println("<ul>");
out.println("<li><a href='http://localhost:8083/TestProject/main.html'>New Event!!</a></li>");
out.println("<li><a href='post.Eventlist'>Events</a></li>");
out.println("<li><a href='post.Myeventlist'>My Events</a></li>");
out.println("<li><a href='post.Memberslist'>Members</a></li>");
out.println("<li><a href='post.Profile'>Profile</a></li>");
out.println("<li><a href='post.Help'>Help</a></li>");
out.println("</ul>");
out.println("</BODY></HTML>");
}
}
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();
}
}
}
