public static void main(String args[]) { try { String urlBD = "jdbc:odbc:FOSA"; String usuarioBD = "SYSDBA"; String passwordBD = "masterkey"; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conexion = DriverManager.getConnection(urlBD, usuarioBD, passwordBD); Statement select = conexion.createStatement(); ResultSet resultadoSelect = select.executeQuery("SELECT MAX(NUM_REG) AS numreg FROM FACT01"); System.out.println("COMANDO EXITOSO"); System.out.println("numreg"); System.out.println("------"); int col = resultadoSelect.findColumn("numreg"); for (boolean seguir = resultadoSelect.next(); seguir; seguir = resultadoSelect.next()) System.out.println(resultadoSelect.getInt(col)); resultadoSelect.close(); select.close(); conexion.close(); } catch (SQLException ex) { System.out.println("Error: SQLException"); while (ex != null) { System.out.println( (new StringBuilder()).append("SQLState: ").append(ex.getSQLState()).toString()); System.out.println( (new StringBuilder()).append("Mensaje: ").append(ex.getMessage()).toString()); System.out.println( (new StringBuilder()).append("Vendedor: ").append(ex.getErrorCode()).toString()); ex = ex.getNextException(); System.out.println(""); } } catch (Exception ex) { System.out.println("Se produjo un error inesperado"); } }
public static String getIPContainer(Connection con, String mail) { String recherche = ""; try { Statement smt = con.createStatement(); ResultSet resultset = smt.executeQuery("SELECT * FROM container WHERE email='" + mail + "' "); int nbr = 0; while (resultset.next()) { recherche = resultset.getString(resultset.findColumn("ip")); } } catch (SQLException ex) { Logger.getLogger(DatabaseManager.class.getName()).log(Level.SEVERE, null, ex); } return recherche; }
public static String getBDD(Connection con, String mail) { String recherche = ""; try { Statement smt = con.createStatement(); ResultSet resultset = smt.executeQuery("SELECT * FROM members WHERE email='" + mail + "' "); int nbr = 0; recherche = "<div class=\"form-group\" align=\"center\">\n" + " <div><SELECT name=\"Bdd\" id=\"required\" align=\"center\">"; recherche += "<option value=\"123456test**123456\" >Your databases</option>\n"; while (resultset.next()) { String nom = resultset.getString(resultset.findColumn("bdd")); String s = "_"; String s2 = "-"; String s1 = "" + nom; if (s.equals(s1)) { // nothing rest = "."; } else if (s2.equals(s1)) { // nothing rest = "."; } else { recherche += "<option VALUE=\"" + nom + "\">" + nom + "</option>\n"; } nbr++; } if (nbr > 0) { recherche += "</SELECT>\n" + " </div>\n" + " </div>"; } } catch (SQLException ex) { Logger.getLogger(DatabaseManager.class.getName()).log(Level.SEVERE, null, ex); } return recherche; }
private boolean executeQuery() { boolean returnVaue = true; int beginRow = 0; boolean moveIF = true; String lineOne = ""; ResultSet rst = null; ResultSetMetaData rstMetaData = null; int columnCount = 0; String temp = ""; rowNum = 0; if (querySQL == "") { writeLog("??????????"); quickField = ""; quickValue = ""; quickRow = -1; return false; } quickRow = -1; try { if (isProcedure) { rst = cstmt.executeQuery(); } else { if (stmt == null) init2(); rst = stmt.executeQuery(querySQL); } } catch (Exception e) { writeLog( (new StringBuilder("??��???????")) .append(e.toString()) .append(",sql=") .append(querySQL) .toString()); try { if (isProcedure && cstmt != null) cstmt.close(); else if (stmt != null) stmt.close(); } catch (SQLException sqlexception) { } returnVaue = false; return returnVaue; } try { rst.last(); totalRowCount = rst.getRow(); rst.beforeFirst(); } catch (Exception ex) { totalRowCount = 0; writeLog((new StringBuilder("??��???????")).append(ex.toString()).toString()); return returnVaue; } pageCount = BigInteger.valueOf(totalRowCount).divide(BigInteger.valueOf(perPage)).intValue(); if (BigInteger.valueOf(totalRowCount).mod(BigInteger.valueOf(perPage)).intValue() > 0) pageCount++; if (pageCount == 0) nextPage = 0; else if (nextPage > pageCount) nextPage = 0; beginRow = nextPage * perPage; beginRow++; curPage = nextPage; if (pageCount <= 1) { ifNext = false; nextPage = 0; } else if (nextPage > pageCount) { ifNext = false; nextPage = 0; } else { ifNext = true; } if (nextPage < 0) nextPage = 0; if (quickField != null && quickField.compareTo("") != 0 && pageCount != 0 && quickValue != null && quickValue.compareTo("") != 0) try { int colIndex = 0; String quickFieldName = ""; String quickFieldType = ""; String quickFieldTmp[] = (String[]) null; boolean haveFound = false; int findRow = 0; quickFieldTmp = StringUtil.split(quickField, ","); if (quickFieldTmp == null) throw new Exception((new StringBuilder("??????��??")).append(quickField).toString()); quickFieldName = quickFieldTmp[0]; quickFieldType = quickFieldTmp[1]; colIndex = rst.findColumn(quickFieldName); rst.beforeFirst(); while (!haveFound && rst.next()) { String tmpValue = ""; if (rst.getObject(colIndex) != null) { tmpValue = rst.getObject(colIndex).toString(); if (quickFieldType.compareToIgnoreCase("date") == 0) { int indexPos = -1; tmpValue = StringUtil.mk_date(tmpValue, 2); indexPos = tmpValue.indexOf(quickValue); if (indexPos == -1) { haveFound = false; } else { haveFound = true; findRow = rst.getRow(); } } else if (quickFieldType.compareToIgnoreCase("long") == 0) { int indexPos = -1; indexPos = tmpValue.compareTo(quickValue); if (indexPos == 0) { haveFound = true; findRow = rst.getRow(); } else { haveFound = false; } } else if (quickFieldType.compareToIgnoreCase("char") == 0) { int indexPos = -1; indexPos = tmpValue.indexOf(quickValue); if (indexPos == -1) { haveFound = false; } else { haveFound = true; findRow = rst.getRow(); } } } } if (findRow > 0) { int pageTmp = 0; int modTmp = 0; pageTmp = BigInteger.valueOf(findRow).divide(BigInteger.valueOf(perPage)).intValue(); modTmp = BigInteger.valueOf(findRow).mod(BigInteger.valueOf(perPage)).intValue(); if (modTmp == 0) { nextPage = pageTmp - 1; quickRow = perPage; } else { nextPage = pageTmp; quickRow = modTmp; } beginRow = nextPage * perPage; beginRow++; curPage = nextPage; if (nextPage >= pageCount - 1) { ifNext = false; nextPage = 0; } else { ifNext = true; nextPage = nextPage + 1; } } } catch (Exception exx) { writeLog(exx.toString()); quickRow = -1; } quickField = ""; quickValue = ""; try { rstMetaData = rst.getMetaData(); } catch (Exception e) { writeLog((new StringBuilder("???????")).append(e.toString()).toString()); returnVaue = false; } try { columnCount = rstMetaData.getColumnCount(); } catch (Exception e) { writeLog((new StringBuilder("??��??")).append(e.toString()).toString()); returnVaue = false; } Object object = null; for (int i = 1; i <= columnCount; i++) try { fieldVector.add(rstMetaData.getColumnName(i)); } catch (Exception e) { writeLog( (new StringBuilder("Exception while getColumnName?G")).append(e.toString()).toString()); } try { if (pageCount > 0) { try { rst.absolute(beginRow); moveIF = true; } catch (Exception exx) { moveIF = false; } if (moveIF) { for (int i = 1; i <= columnCount; i++) { try { object = rst.getObject(i); if (object == null) temp = ""; else temp = object.toString(); } catch (Exception e) { temp = ""; } if (temp == null) temp = ""; lineOne = (new StringBuilder(String.valueOf(lineOne))).append(temp).toString(); valueVector.add(temp); } if (lineOne.equals("")) { valueVector = new ArrayList(); rowNum = 0; } else { rowNum = 1; } for (int i = 1; i < perPage; i++) if (rst.next()) { rowNum++; for (int k = 1; k <= columnCount; k++) { try { if (rst.getObject(k) == null) temp = ""; else temp = rst.getObject(k).toString(); } catch (Exception e) { temp = ""; } if (temp == null) temp = ""; valueVector.add(temp); } } } } } catch (Exception e) { writeLog((new StringBuilder("??????")).append(e.toString()).toString()); returnVaue = false; } try { rst.close(); } catch (Exception exception) { } try { if (stmt != null) stmt.close(); } catch (Exception exception1) { } if (!returnVaue) resetBean(); colCount = columnCount; close(); return returnVaue; }
public static String getProfil(Connection con, String mail, int port) { String recherche = ""; try { Statement smt = con.createStatement(); ResultSet resultset = smt.executeQuery("SELECT * FROM members WHERE email='" + mail + "' "); int nbr = 0; while (resultset.next()) { String nom = resultset.getString(resultset.findColumn("bdd")); String s = "_"; String s2 = "-"; String s1 = "" + nom; String rest = ""; if (s.equals(s1)) { // nothing rest = "."; } else if (s2.equals(s1)) { // nothing rest = "."; } else if (port == 0) { // nothing rest = "."; } else { rest = nom; MongoAPI m = new MongoAPI(); m.initClient("root", "1*smart-db*2", port, "admin"); float x = m.getDBSize(rest); if (x <= 1000000) // ko { float y = x / 1000; recherche += "<tr>\n" + " <th>" + rest + "</th>\n" + " <th>" + y + " ko</th> \n" + " <th>" + port + "</th> \n" + " </tr>"; } else if (x >= 1000000000) // Go { float y = x / 1000000000; recherche += "<tr>\n" + " <th>" + rest + "</th>\n" + " <th>" + y + " Go</th> \n" + " <th>" + port + "</th> \n" + " </tr>"; } else // Mo { float y = x / 1000000; recherche += "<tr>\n" + " <th>" + rest + "</th>\n" + " <th>" + y + " Mo</th> \n" + " <th>" + port + "</th> \n" + " </tr>"; } } nbr++; } if (nbr > 0) { recherche += "</SELECT>\n" + " </div>\n" + " </div>"; } } catch (SQLException ex) { Logger.getLogger(DatabaseManager.class.getName()).log(Level.SEVERE, null, ex); } return recherche; }
protected void setUp() throws SQLException { conControl = MockControl.createControl(Connection.class); con = (Connection) conControl.getMock(); con.isClosed(); conControl.setDefaultReturnValue(false); rsmdControl = MockControl.createControl(ResultSetMetaData.class); rsmd = (ResultSetMetaData) rsmdControl.getMock(); rsmd.getColumnCount(); rsmdControl.setReturnValue(4, 1); rsmd.getColumnLabel(1); rsmdControl.setReturnValue("name", 1); rsmd.getColumnType(1); rsmdControl.setReturnValue(Types.VARCHAR, 1); rsmd.getColumnLabel(2); rsmdControl.setReturnValue("age", 1); rsmd.getColumnType(2); rsmdControl.setReturnValue(Types.NUMERIC, 1); rsmd.getColumnLabel(3); rsmdControl.setReturnValue("birth_date", 1); rsmd.getColumnType(3); rsmdControl.setReturnValue(Types.TIMESTAMP, 1); rsmd.getColumnLabel(4); rsmdControl.setReturnValue("balance", 1); rsmd.getColumnType(4); rsmdControl.setReturnValue(Types.DECIMAL, 1); rsmdControl.replay(); rsControl = MockControl.createControl(ResultSet.class); rs = (ResultSet) rsControl.getMock(); rs.getMetaData(); rsControl.setReturnValue(rsmd, 1); rs.next(); rsControl.setReturnValue(true, 1); rs.getString("name"); rsControl.setReturnValue("Bubba", 1); rs.getLong("age"); rsControl.setReturnValue(22, 1); rs.findColumn("birth_date"); rsControl.setReturnValue(3, 1); rs.getObject(3); rsControl.setReturnValue(new java.sql.Timestamp(1221222L), 1); rs.getBigDecimal("balance"); rsControl.setReturnValue(new BigDecimal("1234.56"), 1); rs.next(); rsControl.setReturnValue(false, 1); rs.close(); rsControl.setVoidCallable(1); rsControl.replay(); stmtControl = MockControl.createControl(Statement.class); stmt = (Statement) stmtControl.getMock(); con.createStatement(); conControl.setReturnValue(stmt, 1); stmt.executeQuery("select name, age, birth_date, balance from people"); stmtControl.setReturnValue(rs, 1); stmt.getWarnings(); stmtControl.setReturnValue(null, 1); stmt.close(); stmtControl.setVoidCallable(1); conControl.replay(); stmtControl.replay(); jdbcTemplate = new JdbcTemplate(); jdbcTemplate.setDataSource(new SingleConnectionDataSource(con, false)); jdbcTemplate.setExceptionTranslator(new SQLStateSQLExceptionTranslator()); jdbcTemplate.afterPropertiesSet(); }