Notes

package veritabanıornek1;
import java.sql.*;
import java.util.Scanner;

import org.apache.derby.impl.sql.execute.CreateConstraintConstantAction;
public class veritabaniornek1 {

public static void main(String[] args) throws Exception {
// TODO Auto-generated method stub
String jdbcurl="jdbc:derby:./.veritabani1;create=true";
Connection veritabanibaglantisi=DriverManager.getConnection(jdbcurl);
System.out.printf("veri tabanına baglandi: %s %n",veritabanibaglantisi.toString());
Statement veritabanikomutu= veritabanibaglantisi.createStatement();

// create table
try {
String sql = "CREATE TABLE ogrenciler(isim varchar(40),yas int)";
veritabanikomutu.executeUpdate(sql);
} catch (Exception e) {
System.out.println("TABLO ZATEN VAR OLDUĞUNDAN HATA ALMIŞ OLABİLİR"+e.getMessage());
}
Scanner konsolokuyucu = new Scanner(System.in);
System.out.println("isim ve yas gir. ornek ali 23");
String kullanicigiris= konsolokuyucu.nextLine();
String[] girdiler=kullanicigiris.split(" ");
String isim=girdiler[0];
int yas =Integer.parseInt(girdiler[1]);
String insetrsql1=String.format("INSERT INTO ogrenciler Values('%s',%d)",isim,yas);
veritabanikomutu.executeUpdate(insetrsql1);
ResultSet sonuclar = veritabanikomutu.executeQuery("SELECT * FROM ogrenciler");
while(sonuclar.next()) {
String sonucIsim=sonuclar.getString("isim");
int sonucYas =sonuclar.getInt(2);
System.out.printf("%s %d",sonucIsim,sonucYas);
}



}

}