public static CartItem fromResultSet(ResultSet resultSet) throws SQLException { CartItem cartItem = new CartItem(); cartItem.setProductId(resultSet.getInt(resultSet.findColumn(COLUMN_ID_PRODUCT))); cartItem.setCartId(resultSet.getInt(resultSet.findColumn(COLUMN_ID_CART))); cartItem.setAmount(resultSet.getInt(resultSet.findColumn(COLUMN_AMOUNT))); return cartItem; }
public HashMap<String, Object> xoa() { if (id <= 0) return error("Bản ghi không tồn tại."); String sql = "SELECT * FROM sanpham WHERE id = '" + id + "';"; try { ResultSet rs = statement.executeQuery(sql); if (rs.next()) { if (anh != null) { for (int i = 0; i < anh.size(); i++) { FileUploadUtil.deleteFile(anh.get(i).getAddUrl()); } } sql = "DELETE FROM sanpham_anh WHERE sanpham_id = '" + rs.getInt(rs.findColumn("id")) + "'"; preparedStatement = connection.prepareStatement(sql); preparedStatement.executeUpdate(); sql = "DELETE FROM sanpham WHERE id = '" + rs.getInt(rs.findColumn("id")) + "';"; preparedStatement = connection.prepareStatement(sql); int affectedRows = preparedStatement.executeUpdate(); if (affectedRows != 0) { HashMap<String, Object> success = new HashMap<>(); success.put("success", 1); success.put("error", 0); return success; } else { return error("Sảy ra lỗi."); } } else { return error("Bản ghi không tồn tại."); } } catch (SQLException ex) { Logger.getLogger(SanPham.class.getName()).log(Level.SEVERE, null, ex); } return error("Lỗi hệ thống."); }
private List getSegmentServices(Statement stmt, String instance) throws SQLException { List rtn = new ArrayList(); ResultSet rs = null; try { // Discover tables rs = stmt.executeQuery(SEGMENT_QUERY); int segment_col = rs.findColumn("SEGMENT_NAME"); int ts_col = rs.findColumn("TABLESPACE_NAME"); while (rs.next()) { String segment = rs.getString(segment_col); String tablespace = rs.getString(ts_col); ServiceResource service = new ServiceResource(); service.setType(this, SEGMENT); service.setServiceName(segment); service.setDescription("Segment in the " + instance + " database instance"); ConfigResponse productConfig = new ConfigResponse(); ConfigResponse metricConfig = new ConfigResponse(); productConfig.setValue(OracleMeasurementPlugin.PROP_SEGMENT, segment); productConfig.setValue(OracleMeasurementPlugin.PROP_TABLESPACE, tablespace); service.setProductConfig(productConfig); service.setMeasurementConfig(metricConfig); service.setControlConfig(); rtn.add(service); } } finally { DBUtil.closeResultSet(log, rs); } return rtn; }
public static User fromResultSet(ResultSet resultSet) throws SQLException { User user = new User(); if (resultSet.next()) { user.setId(resultSet.getInt(resultSet.findColumn(COLUMN_ID))); user.setName(resultSet.getString(resultSet.findColumn(COLUMN_NAME))); user.setPassword(resultSet.getString(resultSet.findColumn(COLUMN_PASSWORD))); return user; } else { return null; } }
public HashMap<String, Object> sua() { if (id <= 0) return error("Bản ghi không tồn tại."); if (ten == null || mota == null || diaChi == null || trangThai == null) return error("Không thể gửi lên 1 giá trị \"null\", vui lòng kiểm tra lại."); if (ten.isEmpty() || mota.isEmpty() || diaChi.isEmpty() || trangThai.isEmpty()) return error("Có vẻ như bạn chưa điền đầy đủ thông tin."); if (tinhThanh <= 0) return error("Bạn chưa chọn tỉnh thành."); if (gia <= 0) return error("Giá sản phẩm phải lớn hơn 0."); String sql = "SELECT * FROM sanpham WHERE id = '" + id + "';"; try { ResultSet rs = statement.executeQuery(sql); if (rs.next()) { sql = "UPDATE sanpham SET ten=?, gia=?, mota=?, ngaycapnhat=GETDATE(), diachi=?, tinhthanh_id=?, trangthai=? WHERE id = '" + rs.getInt(rs.findColumn("id")) + "';"; preparedStatement = connection.prepareStatement(sql); preparedStatement.setString(1, ten); preparedStatement.setLong(2, gia); preparedStatement.setString(3, mota); preparedStatement.setString(4, diaChi); preparedStatement.setInt(5, tinhThanh); preparedStatement.setString(6, trangThai); int affectedRows = preparedStatement.executeUpdate(); if (affectedRows != 0) { sql = "SELECT a.*, b.ten as 'tentinhthanh', (SELECT ten FROM tinhthanh WHERE id = b.parent_id) as 'tenvungmien' FROM sanpham a INNER JOIN tinhthanh b ON a.tinhthanh_id = b.id WHERE a.id='" + id + "'"; rs = statement.executeQuery(sql); if (rs.next()) { HashMap<String, Object> success = new HashMap<>(); success.put("success", 1); success.put("error", 0); success.put("ngay_cap_nhat", rs.getString(rs.findColumn("ngaycapnhat"))); success.put("ten_tinh_thanh", rs.getString(rs.findColumn("tentinhthanh"))); success.put("ten_vung_mien", rs.getString(rs.findColumn("tenvungmien"))); return success; } } else { return error("Sảy ra lỗi."); } } else { return error("Bản ghi không tồn tại."); } } catch (SQLException ex) { Logger.getLogger(SanPham.class.getName()).log(Level.SEVERE, null, ex); } return error("Lỗi hệ thống."); }
private List getTablespaceServices(Statement stmt, String instance) throws SQLException { List rtn = new ArrayList(); ResultSet rs = null; try { // Discover tablespaces rs = stmt.executeQuery(TABLESPACE_QUERY); int ts_col = rs.findColumn("TABLESPACE_NAME"); while (rs.next()) { String tablespace = rs.getString(ts_col); ServiceResource service = new ServiceResource(); service.setType(this, TABLESPACE); service.setServiceName(tablespace); service.setDescription("Tablespace on the " + instance + " database instance"); ConfigResponse productConfig = new ConfigResponse(); ConfigResponse metricConfig = new ConfigResponse(); productConfig.setValue(OracleMeasurementPlugin.PROP_TABLESPACE, tablespace); service.setProductConfig(productConfig); service.setMeasurementConfig(metricConfig); ConfigResponse svcProps = new ConfigResponse(); // 9i and 10g only if (!getTypeInfo().getVersion().equals(VERSION_8i)) { svcProps.setValue("block_size", rs.getString("BLOCK_SIZE")); svcProps.setValue("allocation_type", rs.getString("ALLOCATION_TYPE")); svcProps.setValue("space_management", rs.getString("SEGMENT_SPACE_MANAGEMENT")); } svcProps.setValue("contents", rs.getString("CONTENTS")); svcProps.setValue("logging", rs.getString("LOGGING")); service.setCustomProperties(svcProps); rtn.add(service); } } finally { DBUtil.closeResultSet(log, rs); } return rtn; }
// fetch all values from a table and a column // fill the ZaurusChoice zc with the row values for the Choice // and the column values as values private void fillZChoice(ZaurusChoice zc, String tab, String col) { try { if (cConn == null) { return; } Statement stmt = cConn.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM " + tab + " ORDER BY " + col); ResultSetMetaData rsmd = rs.getMetaData(); int numberOfColumns = rsmd.getColumnCount(); int colIndex = rs.findColumn(col); while (rs.next()) { String tmp = ""; for (int i = 1; i <= numberOfColumns; i++) { if (i > 1) { tmp += "; "; } tmp += rs.getString(i); } // end of for (int i=1; i<=numberOfColumns; i++) zc.add(tmp, rs.getString(colIndex)); } rs.close(); } catch (SQLException e) { System.out.println("SQL Exception: " + e.getMessage()); } // end of try-catch }
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 int resolveColumnPosition(String columnName) throws HibernateException { try { return resultSet.findColumn(columnName); } catch (SQLException e) { throw new HibernateException( "Could not resolve column name in result set [" + columnName + "]", e); } }
@Override public Date getDateOrNull(String columnName) { try { column = rs.findColumn(columnName) + 1; return toDate(rs, columnName); } catch (SQLException e) { throw new DatabaseException(e); } }
/** * 向聚合列的补列填充索引值. * * @param resultSet 结果集对象 * @param aggregationColumns 聚合列集合 * @throws SQLException SQL异常 */ public static void fillIndexesForDerivedAggregationColumns( final ResultSet resultSet, final Collection<AggregationColumn> aggregationColumns) throws SQLException { for (AggregationColumn aggregationColumn : aggregationColumns) { for (AggregationColumn derivedColumn : aggregationColumn.getDerivedColumns()) { derivedColumn.setIndex(resultSet.findColumn(derivedColumn.getAlias().get())); } } }
@Override public int findColumn(String columnName) throws SQLException { try { return _res.findColumn(columnName); } catch (SQLException e) { handleException(e); return 0; } }
@Override public InputStream getBlobInputStreamOrNull(String columnName) { try { column = rs.findColumn(columnName) + 1; return rs.getBinaryStream(columnName); } catch (SQLException e) { throw new DatabaseException(e); } }
@Override public byte[] getBlobBytesOrNull(String columnName) { try { column = rs.findColumn(columnName) + 1; return rs.getBytes(columnName); } catch (SQLException e) { throw new DatabaseException(e); } }
@Override public BigDecimal getBigDecimalOrNull(String columnName) { try { column = rs.findColumn(columnName) + 1; return toBigDecimal(rs, columnName); } catch (SQLException e) { throw new DatabaseException(e); } }
@Override public Reader getClobReaderOrNull(String columnName) { try { column = rs.findColumn(columnName) + 1; return rs.getCharacterStream(columnName); } catch (SQLException e) { throw new DatabaseException(e); } }
@Nullable @Override public Boolean getBooleanOrNull(String columnName) { try { column = rs.findColumn(columnName) + 1; return toBoolean(rs, columnName); } catch (SQLException e) { throw new DatabaseException(e); } }
public ColumnInfo(ResultSet rs, int i, Calendar calendar, Format dateFormat, Format aorFormat) throws SQLException { m_fieldIndex = i; m_calendar = calendar; m_rsIndex = rs.findColumn(FIELDS[m_fieldIndex]); m_timestamp = TIME_FIELDS[m_fieldIndex]; if (AOR_FIELDS[m_fieldIndex]) { m_format = aorFormat; } else if (TIME_FIELDS[m_fieldIndex]) { m_format = dateFormat; } }
@Override public String getClobStringOrNull(String columnName) { try { column = rs.findColumn(columnName) + 1; String result = rs.getString(columnName); if (result != null && result.length() == 0) { result = null; } return result; } catch (SQLException e) { throw new DatabaseException(e); } }
/** {@inheritDoc} */ @Override public Object nullSafeGet( final ResultSet rs, final String[] names, final SessionImplementor session, final Object owner) throws SQLException { // Cf io.vertigo.dynamo.impl.database.vendor.core.SQLMappingImpl final String columnName = names[0]; final int index = rs.findColumn(columnName); final DataStream value = SqlDataStreamMappingUtil.getDataStream(rs, index); return value; }
private ArrayList<Anh> getArrAnh(int sanPhamId) { ArrayList<Anh> data = new ArrayList<>(); try { statement = connection.createStatement(); String sql = "SELECT * FROM sanpham_anh WHERE sanpham_id = '" + sanPhamId + "';"; ResultSet rs = statement.executeQuery(sql); while (rs.next()) { Anh anh = new Anh( rs.getInt(rs.findColumn("id")), rs.getString(rs.findColumn("url")), rs.getInt(rs.findColumn("sanpham_id"))); // if(data.size()==0) // data.add(new Anh(-1, "default", sanPhamId)); data.add(anh); } return data; } catch (SQLException ex) { Logger.getLogger(SanPham.class.getName()).log(Level.SEVERE, null, ex); } return data; }
/** * Suprime un répértoire dans la base de données. * * @param url */ public static void deleteRepository(String url) { bd = new BDHelper(); user.getRepos().remove(url); if (user.getPseudo() != null) { ResultSet result = bd.query("SELECT * FROM user WHERE login='******'"); try { result.first(); result = bd.query( "SELECT * FROM repository where id_user="******"id")) + " AND repo_url='" + url + "'"); result.first(); bd.queryUpdate("DELETE FROM repository WHERE id=" + result.getInt(result.findColumn("id"))); } catch (SQLException e) { e.printStackTrace(); } } bd.close(); }
/** * @param user_id * @return La liste des répértoire Git pour un utilisateur donné. */ private static List<String> getRepository(int user_id) { List<String> rep = new ArrayList<String>(); ResultSet result = bd.query("SELECT * FROM repository WHERE id_user="******"repo_url"))); } while (result.next()); } catch (SQLException e) { e.printStackTrace(); } return rep; }
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 AllTypeAttrs(ResultSet rs) throws SQLException { super(); if (!m_indexed) { m_indexed = true; iATTR_NAME = rs.findColumn("ATTR_NAME"); iATTR_NO = rs.findColumn("ATTR_NO"); iATTR_TYPE_MOD = rs.findColumn("ATTR_TYPE_MOD"); iATTR_TYPE_OWNER = rs.findColumn("ATTR_TYPE_OWNER"); iATTR_TYPE_NAME = rs.findColumn("ATTR_TYPE_NAME"); iLENGTH = rs.findColumn("LENGTH"); iPRECISION = rs.findColumn("PRECISION"); iSCALE = rs.findColumn("SCALE"); iCHARACTER_SET_NAME = rs.findColumn("CHARACTER_SET_NAME"); } attrName = rs.getString(iATTR_NAME); attrNo = rs.getInt(iATTR_NO); attrTypeMod = rs.getString(iATTR_TYPE_MOD); attrTypeOwner = rs.getString(iATTR_TYPE_OWNER); attrTypeName = rs.getString(iATTR_TYPE_NAME); attrLength = rs.getInt(iLENGTH); attrPrecision = rs.getInt(iPRECISION); attrScale = rs.getInt(iSCALE); characterSetName = rs.getString(iCHARACTER_SET_NAME); }
/** * Sauvegarde un nouveau répértoire dans la base de données. * * @param url */ public static void saveRepository(String url) { bd = new BDHelper(); user.getRepos().add(url); if (user.getPseudo() != null) { ResultSet result = bd.query("SELECT * FROM user WHERE login='******'"); try { result.first(); bd.queryUpdate( "INSERT INTO repository (id_user,repo_url) VALUES (" + result.getInt(result.findColumn("id")) + ",'" + url + "')"); } catch (SQLException e) { e.printStackTrace(); } } bd.close(); }
/** * Vefifie que le login et le mot de passe est bien dans la base de données. Et met à jour la * liste des répértoires git. * * @param login * @param mdp * @return estConnecter */ public static boolean connect(String login, String mdp) { bd = new BDHelper(); ResultSet result = bd.query("SELECT * FROM User WHERE login = '******' AND mdp = '" + mdp + "'"); try { if (result.next()) { List<String> rep = new ArrayList<String>(); rep = getRepository(result.getInt(result.findColumn("id"))); user = new User(login, rep); bd.close(); return true; } } catch (SQLException e) { e.printStackTrace(); } bd.close(); return false; }
/** @throws Exception If failed. */ public void testFindColumn() throws Exception { final ResultSet rs = stmt.executeQuery(SQL); assertNotNull(rs); assertTrue(rs.next()); assert rs.findColumn("id") == 1; GridTestUtils.assertThrows( log, new Callable<Object>() { @Override public Object call() throws Exception { rs.findColumn("wrong"); return null; } }, SQLException.class, "Column not found: wrong"); }
public AllMethodResults(ResultSet rs) throws SQLException { super(); if (!m_indexed) { m_indexed = true; iRESULT_TYPE_MOD = rs.findColumn("RESULT_TYPE_MOD"); iRESULT_TYPE_OWNER = rs.findColumn("RESULT_TYPE_OWNER"); iRESULT_TYPE_NAME = rs.findColumn("RESULT_TYPE_NAME"); iCHARACTER_SET_NAME = rs.findColumn("CHARACTER_SET_NAME"); iMETHOD_NAME = rs.findColumn("METHOD_NAME"); iMETHOD_NO = rs.findColumn("METHOD_NO"); } resultTypeMod = rs.getString(iRESULT_TYPE_MOD); resultTypeOwner = rs.getString(iRESULT_TYPE_OWNER); resultTypeName = rs.getString(iRESULT_TYPE_NAME); characterSetName = rs.getString(iCHARACTER_SET_NAME); methodName = rs.getString(iMETHOD_NAME); methodNo = rs.getString(iMETHOD_NO); }
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; }