CREATE TABLE `Potravina` (
  `id` MEDIUMINT NOT NULL AUTO_INCREMENT,
  `nazev` varchar(255) DEFAULT NULL,
  `umisteni` int(11) DEFAULT NULL,
  `vlozeni` date DEFAULT NULL,
  `mnozstvi` int(11) DEFAULT NULL, 
   PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARACTER SET = utf8;

SET NAMES utf8;

INSERT INTO Potravina (nazev, umisteni, vlozeni, mnozstvi) VALUES ('Řízek', 1, '2013-12-01', 2);
INSERT INTO Potravina (nazev, umisteni, vlozeni, mnozstvi) VALUES ('Chleba', 2, '2013-11-01', 500);
INSERT INTO Potravina (nazev, umisteni, vlozeni, mnozstvi) VALUES ('Šunka', 1, '2013-11-01', 100);


	Connection db;
    private boolean connect() {
        try {
            String url = "jdbc:mysql://ip:3306/test?useUnicode=true&characterEncoding=UTF-8";
            Class.forName("com.mysql.jdbc.Driver"); //nacteni driveru pro MySQL
            db = DriverManager.getConnection(url, "***", "***"); //pripojeni databaze
        } catch (ClassNotFoundException ex) {
            return false;
        } catch (SQLException ex) {
            return false;
        }
        return true;
    }