{"id":219,"date":"2010-08-28T00:57:00","date_gmt":"1970-01-01T00:00:00","guid":{"rendered":"http:\/\/www.yazilimmutfagi.com\/?p=219"},"modified":"2010-08-28T00:57:00","modified_gmt":"1970-01-01T00:00:00","slug":"java-ile-sql-veritabani-baglantisi","status":"publish","type":"post","link":"https:\/\/www.yazilimmutfagi.com\/index.php\/2010\/08\/28\/java-ile-sql-veritabani-baglantisi\/","title":{"rendered":"Java ile SQL veritabani baglantisi"},"content":{"rendered":"
Merhaba arkadaslar, bu makalede Java ile SQL veritabanina nasil baglanilacagini anlatmaya çalisacagim. <\/span><\/div>\n
Uzun uzadiya teorik bilgiler vermeyecegim. Onun için hemen ise koyuluyorum.<\/span><\/div>\n
Ilk yapacagimiz is bir baglanti driveri olusturmak. Bu driver sayesinde SQL’e baglanip islemlerimizi gerçeklestirebilecegiz.<\/span><\/div>\n
Denetim masasi > Sistem yönetimi<\/span><\/strong>’nden OBDC Veri Kaynagi Yöneticisi (ODBC Data Source Administrator)<\/span><\/strong> tikliyoruz. <\/span><\/span> <\/div>\n
Karsimiza çikan ekrandan dBASE Files <\/b>seçenegini tikliyor ve ekle<\/b> diyoruz (benimkinde toevoegen<\/i> yaziyor). <\/span><\/div>\n
 <\/div>\n
\"\"<\/div>\n
 <\/div>\n
Buradan da SQL Server <\/b>seçenegini tikliyor ve tamam<\/b> diyoruz.<\/span><\/div>\n
.<\/a><\/div>\n
\"\"<\/div>\n
\"\" \"\"<\/div>\n
 <\/div>\n
Karsimiza çikan üçüncü ekranda, altta kullandigimiz server<\/b>’i seçiyoruz ve baglantimiza herhangi bir isim<\/b> veriyoruz (en üstte). Sonra ileri<\/b> diyoruz.<\/span><\/div>\n
\"\" <\/div>\n
 <\/div>\n
Bir sonraki seçenekte serverimize windows oturumu ile mi yoksa sifre ile mi erisecegimizi soruyor. Ben windows oturumunu tercih ediyorum.<\/span><\/div>\n
\"\" <\/div>\n
 <\/div>\n
Bundan sonraki adimda hangi veritabanina baglanacagimizi seçecegiz.<\/span><\/div>\n
\"\" <\/div>\n
 <\/div>\n
En son olarak dil seçimini de yaptiktan sonra islemimiz tamamlanmis olacak.<\/span><\/div>\n
 <\/div>\n
Simdi bunu nasil kullanacagimizi, yani java ile sql’e nasil baglanacagimizi görecegiz.<\/span><\/div>\n
.<\/a><\/div>\n
\n
import<\/span><\/b> java.sql.*;<\/span><\/div>\n
import<\/span><\/b> java.io.*; <\/span><\/div>\n
 <\/div>\n
public <\/span><\/b>class<\/span><\/b> SQLBaglantisi{<\/span><\/div>\n
      <\/span><\/div>\n
      <\/span>public <\/span><\/b>static<\/span><\/b>void<\/span><\/b> main(String[] arg) <\/span>throws<\/span><\/b> IOException, SQLException{<\/span><\/div>\n
            baglan<\/i>();<\/span><\/div>\n
      }<\/span><\/div>\n
 <\/div>\n
     <\/span>public <\/span><\/b>static<\/span><\/b>void<\/span><\/b> baglan() <\/span>throws<\/span><\/b> IOException, SQLException{ <\/span><\/div>\n
            String url = <\/span>"jdbc:odbc:northwind"<\/span>;<\/span><\/div>\n
            Connection con;<\/span><\/div>\n
            Statement stm;<\/span><\/div>\n
            ResultSet sonuc;<\/span><\/div>\n
            String Ssql;<\/span><\/div>\n
             Ssql = <\/span>"SELECT * FROM Orders"<\/span>;<\/span><\/div>\n
 <\/div>\n
            <\/span>try<\/span><\/b>{<\/span><\/div>\n
                  Class.forName<\/i>(<\/span>"sun.jdbc.odbc.JdbcOdbcDriver"<\/span>);<\/span><\/div>\n
            }<\/span><\/div>\n
            <\/span>catch<\/span><\/b>(java.lang.ClassNotFoundException e){ <\/span><\/div>\n
                  System.<\/span>err<\/span><\/i>.print(<\/span>"ClassNotFoundException: "<\/span>);<\/span><\/div>\n
                  System.<\/span>err<\/span><\/i>.print(e.getMessage());<\/span><\/div>\n
            }           <\/span><\/div>\n
            <\/span><\/div>\n
            <\/span>try<\/span><\/b>{<\/span><\/div>\n
                  con = DriverManager.getConnection<\/i>(url);<\/span><\/div>\n
                  stm = con.createStatement();<\/span><\/div>\n
                  sonuc = stm.executeQuery(Ssql);<\/span><\/div>\n
                  <\/span><\/div>\n
                  <\/span>while<\/span><\/b>(sonuc.next()){<\/span><\/div>\n
                        System.<\/span>out<\/span><\/i>.println(sonuc.getString(2));<\/span><\/div>\n
                        <\/span>\/\/Birinci ve ikinci sütundaki verileri seçiyorum<\/span><\/div>\n
                  }<\/span><\/div>\n
                  stm.close();<\/span><\/div>\n
                  con.close();<\/span><\/div>\n
            }<\/span><\/div>\n
            <\/span>catch<\/span><\/b>(SQLException ex){ <\/span><\/div>\n
                  System.<\/span>err<\/span><\/i>.print(<\/span>"SQLException: "<\/span>+ex.getMessage());<\/span><\/div>\n
     }<\/span><\/div>\n
            <\/span><\/div>\n
      }<\/span><\/div>\n
}<\/span><\/div>\n<\/div>\n
 <\/div>\n
\n

Ekran çiktisi olarak ilk iki sütunu göstermis olacagiz.<\/o:p><\/span><\/p>\n<\/div>\n

Insallah bundan sonraki dersimizde de Jtable kullanarak baglandigimiz veritabanimizdan verileri Jtable’de gösterecegiz.<\/span><\/div>\n
Ayrintiliri sorularinizi forum sayfamizda iletebilirsiniz.<\/span><\/div>\n
 <\/div>\n
 <\/div>\n

\n<\/span> <\/div>\n
 <\/div>\n
 <\/div>\n

 <\/p>","protected":false},"excerpt":{"rendered":"

Merhaba arkadaslar, bu makalede Java ile SQL veritabanina nasil baglanilacagini anlatmaya çalisacagim.<\/p>\n","protected":false},"author":519,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[419],"tags":[4592,5559,4925,4189,5326],"_links":{"self":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/219"}],"collection":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/users\/519"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/comments?post=219"}],"version-history":[{"count":0,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/219\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/media?parent=219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/categories?post=219"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/tags?post=219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}