metodu InsertToDatabase som dokoncil takto
Kód: Vybrať všetko
public void InsertToDatabase(VlozitelnyDoDatabazy i){
StringBuilder SQLCommand = new StringBuilder();
SQLCommand.append("INSERT INTO TABLE_");
SQLCommand.append(i.getClass().getName());
SQLCommand.append(" (");
for (String s : i.AttNames().split("\n")){
SQLCommand.append(s).append(",");
}
SQLCommand.deleteCharAt(SQLCommand.length()-1);
SQLCommand.append(") VALUES (");
for (String s : i.vypisAtributy().split("\n")){
SQLCommand.append(s).append(",");
}
SQLCommand.append(")");
String url = "jdbc:derby://localhost:1527/sample";
String user = "user";
String password = "user";
try {
Class.forName("org.apache.derby.jdbc.ClientDriver");
Connection connection = DriverManager.getConnection(url, user, password);
String sql = "insert into TABLE_AUTO (ZNACKA, MODEL, FARBA) values ('BMW', 'M6', 'zlta')";
Statement s = connection.createStatement();
s.executeUpdate(SQLCommand.toString());
connection.close();
} catch(Exception ex){
System.out.println(ex.toString());
}
}Kód: Vybrať všetko
InsertToDatabase(Auto audi);EDIT2: uz som zistil preco... hodnoty ktore sa mali vkladat do databazy neboli v uvodzovkach, tak som to upravil a uz to funguje, ale mam este jednu mini otazku....
triedy som mal povodne v package-i a prikaz SQLCommand.append(i.getClass().getName()); mi do SQLCommandu neulozil nazov triedy, ale nazov packagu, preco??? alebo ako potom ziskam nazov tiredy???
ale inak ked tiredy nemam v balickoch uz to komplet funguje, tak dakujem za tvoju pomoc a trpezlivost