Monday, 20 April 2015

Monday, 9 September 2013

Cronómetro online

Aqui dejo una buena herramienta, sencilla y con buen tamaño

Friday, 7 January 2011

Angry Birds PC

Por fin, este gran juego para pc! Todos aquellos que no tenian un Iphone o un HTC en condiciones, y no la mierda Tattoo que tengo yo, podrán disfruta

Wednesday, 24 November 2010

Homenatge al viatge a Sweden

Homenatge al viatge a Sweden

M'emporto molts bons moments d'aquest viatge.

Thursday, 28 October 2010

The crab

The crab

Tuesday, 26 October 2010

The double accent virus

The double accent virus

Recently, i have caught the double accent virus. The problem was when i press the accent button in my keyboard, the PC, automatically put two accents: e.g. in Spanish, caf´´e instead of café.

If you have this poblem, first, prove in a console if the problem persist. If don't persist you can be sure that you have this virus. Don't worry, simply, download this program, and analyze your PC. Surely you will have to eliminate 4 or 5 virus, do it and restart your computer. Later the problem will have been removed.


Tuesday, 19 October 2010

How to start with SQLite?

How to start with SQLite?

SQLite is very easy to use, simple and very light. The database is saved in an only file.
SQLite works with MySQL syntax.

The easiest mode to create a database is using a client for SQLite. My recommendation is a plugin fo firefox called SQLite Manager.
You can get it here.

If you want connect your SQLite databse with Java, you will need the SQLite Connector:
You can get it here.
Below I explain the first steps to use it.


try {
conn = DriverManager.getConnection("jdbc:sqlite:"+DBpath);
catch(Exception e){

Execute query:

String select = "SELECT * FROM CONTENT WHERE ID=?";
PreparedStatement ps = conn.prepareStatement(select);
ps.setString(1, id);
ResultSet rs = ps.executeQuery();;
String path = rs.getString("CONTENT");

Execute Update:

ResultSet rs = null;
PreparedStatement ps = null;

ps = conn.prepareStatement("UPDATE CONTENT SET SIZE=?, TYPE=?, TIME=? WHERE ID=?");
ps.setInt(1, Integer.valueOf(size));
ps.setString(2, type);
ps.setDate(3, date);
ps.setString(4, id);


Thanks for read me!