14 August, 2009
Make local FreeBSD mirror via rsync
rsync -va --delete --progress ftp.nl.FreeBSD.org::FreeBSD/ports/i386/packages-7.2-release/ FreeBSD-7.2-i386
13 August, 2009
Bind XML to Java classes
Just follow this example:
cbr_daily.xml
ValCursType.java
ValuteType.java
CbrCurrencyTask.java
Simple! Isn't it?
cbr_daily.xml
<ValCurs Date="30/05/2009" name="Foreign Currency Market">
<Valute ID="R01035">
<NumCode>826</NumCode>
<CharCode>GBP</CharCode>
<Nominal>1</Nominal>
<Name>Фунт стерлингов Соединенного королевства</Name>
<Value>49,7887</Value>
</Valute>
<Valute ID="R01235">
<NumCode>840</NumCode>
<CharCode>USD</CharCode>
<Nominal>1</Nominal>
<Name>Доллар США</Name>
<Value>30,9843</Value>
</Valute>
<Valute ID="R01239">
<NumCode>978</NumCode>
<CharCode>EUR</CharCode>
<Nominal>1</Nominal>
<Name>Евро</Name>
<Value>43,3780</Value>
</Valute>
</ValCurs>
ValCursType.java
package xqx;
import java.util.List;
import javax.xml.bind.annotation.XmlAttribute;
import javax.xml.bind.annotation.XmlElement;
import javax.xml.bind.annotation.XmlRootElement;
import javax.xml.bind.annotation.XmlType;
@XmlRootElement(name = "ValCurs")
@XmlType(name = "ValCursType")
public class ValCursType {
@XmlElement(name = "Valute")
public List<ValuteType> valuteType;
@XmlAttribute(name = "Date")
public String date;
@XmlAttribute
public String name;
}
ValuteType.java
package xqx;
import javax.xml.bind.annotation.*;
@XmlRootElement(name = "Valute")
@XmlType(name = "ValuteType")
public class ValuteType {
@XmlElement(name = "NumCode")
public String numCode;
@XmlElement(name = "CharCode")
public String charCode;
@XmlElement(name = "Nominal")
public int nominal;
@XmlElement(name = "Name")
public String name;
@XmlElement(name = "Value")
public String value;
@XmlAttribute(name = "ID")
public String id;
}
CbrCurrencyTask.java
package xqx;
import ...;
public class CbrCurrencyTask {
...
//stream - For example FileInputStream created from the "cbr_daily.xml" file
protected ValCursType parse(InputStream stream) throws JAXBException {
JAXBContext jaxbContext = JAXBContext.newInstance(ValCursType.class);
Unmarshaller unmarshaller = jaxbContext.createUnmarshaller();
ValCursType valCursType = (ValCursType) unmarshaller.unmarshal(stream);
return valCursType;
}
...
}
Simple! Isn't it?
27 July, 2009
JDBC: Postgres enums and prepared statements
There is simple way how to map Java enums to PostgreSQL enums via JDBC's prepared statements.
For example we have these PostgreSQL enum and table definitions:
And Java enum:
This form of prepared statement should work:
For example we have these PostgreSQL enum and table definitions:
CREATE TYPE log_level AS ENUM ('INFO', 'WARN', 'ERROR');CREATE TABLE logs (
id SERIAL PRIMARY KEY,
message VARCHAR(255) NOT NULL,
level log_level NOT NULL,
);And Java enum:
public enum LogLevel {
INFO, WARN, ERROR
}
This form of prepared statement should work:
LogLevel logLevel = LogLevel.INFO;
PreparedStatement sql = conn.prepareStatement("INSERT INTO logs (message, log_level) VALUES (?, ?::log_level)");
sql.setString(1, "Hello world");
//sql.setString(2, "INFO");
sql.setString(2, logLevel.name());
28 February, 2009
Get browser language via JavaScript
This is simple cross-browser solution:
And usage example:
var lang = (navigator.language || navigator.systemLanguage || navigator.userLanguage || 'en').substr(0, 2).toLowerCase();
And usage example:
var lang = (navigator.language || navigator.systemLanguage || navigator.userLanguage || 'en').substr(0, 2).toLowerCase();
if (lang == 'ru') {
document.write('Specific Russian text');
} else {
document.write('Common English text');
}
Subscribe to:
Posts (Atom)