Problem nastaje kada pokusam da izvrsim naredbu "INSERT INTO" jer podatke koje su inicijalizovane u Stringu se ne prosledjuju u bazu.INSERT INTO radi kad joj prosledim neku drugu vrednost kao npr. VALUES('asdha','asdsad','asdsad');
Code:
public void baza1() {
MojTokanizer mt=new MojTokanizer("C:\\Pravoslavni_praznici3.txt");
String stDatum = "",danC = "",noviDatum = "";
Connection con;
Statement st;
// ResultSet rs;
String url="jdbc:odbc:Dan";
String sql2="INSERT INTO Dani(stariDatum,dan,noviDatum)VALUES('"
+stDatum
+"','"
+danC
+"','"
+noviDatum +"')";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(url,"","");
st=con.createStatement();
ListIterator list=mt.items.listIterator();
while(list.hasNext()) {
cd=(Dan)list.next();
stDatum=cd.getStDatum();
danC=cd.getDan();
noviDatum=cd.getNoviDatum();
System.out.println(stDatum+","+danC+","+noviDatum);
// do ovde radi jer mi lista
st.executeUpdate(sql2);
}
st.close();
public void baza1() {
MojTokanizer mt=new MojTokanizer("C:\\Pravoslavni_praznici3.txt");
String stDatum = "",danC = "",noviDatum = "";
Connection con;
Statement st;
// ResultSet rs;
String url="jdbc:odbc:Dan";
String sql2="INSERT INTO Dani(stariDatum,dan,noviDatum)VALUES('"
+stDatum
+"','"
+danC
+"','"
+noviDatum +"')";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(url,"","");
st=con.createStatement();
ListIterator list=mt.items.listIterator();
while(list.hasNext()) {
cd=(Dan)list.next();
stDatum=cd.getStDatum();
danC=cd.getDan();
noviDatum=cd.getNoviDatum();
System.out.println(stDatum+","+danC+","+noviDatum);
// do ovde radi jer mi lista
st.executeUpdate(sql2);
}
st.close();