{"id":243,"date":"2012-01-10T11:58:00","date_gmt":"1970-01-01T00:00:00","guid":{"rendered":"http:\/\/www.yazilimmutfagi.com\/?p=243"},"modified":"2012-01-10T11:58:00","modified_gmt":"1970-01-01T00:00:00","slug":"java-ile-mysql-veritabanina-baglanmak","status":"publish","type":"post","link":"https:\/\/www.yazilimmutfagi.com\/index.php\/2012\/01\/10\/java-ile-mysql-veritabanina-baglanmak\/","title":{"rendered":"Java ile MySQL Veritabanina Baglanmak"},"content":{"rendered":"\n<p>Veri Tabani ile ilgili derslerimizin ilkinde java ile <a href=\"http:\/\/www.yazilimmutfagi.com\/MakaleOku.aspx?Makale=Java%20ile%20SQL%20veritabani%20baglantisi&#038;MakaleKey=ae24d810-205e-4299-9d00-81aeb77dcfe4\">MS-SQL baglantisini yapmistik<\/a>. Bu derste ise java ile mysql baglantisini yapacagiz insallah.\n<\/p>\n<p>\nIlk olarak yapmamiz gereken bilgisayarimiza mysql server kurmak. Kurulum i\u00e7in <a href=\"http:\/\/www.yazilimmutfagi.com\/MakaleOku.aspx?Makale=PHPye%20Giris%20-%20Kurulum&#038;MakaleKey=80acc727-73fb-49b8-a001-889d6d18b8be\">su dersten<\/a> yararlanabilirsiniz.<\/p>\n<p>\nEger mysql&#8217;imizi kurduysak baglanti yapmak i\u00e7in bir veritabani olusturuyoruz. <\/p>\n<p>\nBenim olusturdugum veritabaninin adi &#8220;testdatabase&#8221;. I\u00e7erisinde bir tane &#8220;calisanlar&#8221; adinda tablo var; bu tabloda 3 tane s\u00fctun var: id, isim, sehir. Siz elbette istediginiz gibi bir tablo olusturabilirsiniz. Tabi bu olusturdugunuz tabloya denemek i\u00e7in veriler eklemeyi unutmuyoruz.\n<\/p>\n<p>\nEger tablomuz da hazirsa sira geldi en \u00f6nemli adimlardan birine: ODBC Connector hazirlamaya. http:\/\/www.mysql.com\/downloads\/connector\/odbc\/ adresinden sisteminize uygun olanini indiriniz. \n<\/p>\n<a href='www.yazilimmutfagi.com'>.<\/a>\n<p>\n\u00d6ncelikle zipli olan bu dosyayi bir yere \u00e7ikariyoruz. Sonra Eclips&#8217;i a\u00e7iyoruz.<\/p>\n<ul>\n<li>Yeni bir java projesi a\u00e7iyoruz.<\/li>\n<li>JRE System Library&#8217;e sag tiklayip Configure Build Path diyoruz. <\/li>\n<\/ul>\n<img decoding=\"async\" src=\"http:\/\/www.yazilimmutfagi.com\/yuklenendosyalar\/image\/ahmet\/java\/java_MySQL\/java_mysql_baglantisi_1.png\" alt=\"mysql and java\" longdesc=\"http:\/\/www.yazilimmutfagi.com\" \/>\n<ul>\n  <li>Karsimiza \u00e7ikan pencereden Add External JARs se\u00e7enegini tikliyoruz.<\/li>\n\n<\/ul>\n\n\n<img decoding=\"async\" src=\"http:\/\/www.yazilimmutfagi.com\/yuklenendosyalar\/image\/ahmet\/java\/java_MySQL\/java_mysql_baglantisi_2.png\" alt=\"mysql and java\" longdesc=\"http:\/\/www.yazilimmutfagi.com\" \/>\n\n<p>\nBuraya kadar her sey tamamsa isin yarisindan fazlasini yaptik demektir.\n<\/p>\n<p>\nSimdi sira geldi kodlarimiza. Yeni bir paket ve sinif a\u00e7iyoruz ve su kodlari yaziyoruz:\n<\/p>\n<a href='www.yazilimmutfagi.com'>.<\/a>\n<code>\n<div  class=\"code\">\n import java.sql.Connection;<br \/>\nimport java.sql.DriverManager;<br \/>\nimport java.sql.PreparedStatement;<br \/>\nimport java.sql.ResultSet;<br \/>\n&nbsp;\npublic class Main <br \/>\n{<br \/>\n&nbsp;&nbsp; public static void main(String[] args) throws Exception <br \/>\n&nbsp;&nbsp; {<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Class.forName(&quot;com.mysql.jdbc.Driver&quot;);<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Connection con = DriverManager.getConnection(&quot;jdbc:mysql:\/\/localhost\/testdatabase&quot;,&quot;root&quot;,&quot;&quot;);<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PreparedStatement statement = con.prepareStatement(&quot;select * from calisanlar&quot;);<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ResultSet result = statement.executeQuery();<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;while(result.next()) <br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;System.out.println(result.getString(1)+&quot; &quot;+result.getString(2)+&quot; &quot;+result.getString(3));<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br \/>\n&nbsp;&nbsp; }<br \/>\n}\n\n<\/div>\n<\/code>\n<code>\n<div  class=\"code\">Class.forName(\"com.mysql.jdbc.Driver\");\n<\/div>\n<\/code>\n\n\n<p>\ncom.mysql.jdbc.Driver ekledigimiz ODBC Connector i\u00e7erisinde bulunan bir sinif. \n<\/p>\n<code>\n<div  class=\"code\"> Connection con = DriverManager.getConnection(\"jdbc:mysql:\/\/localhost\/testdatabase\",\"root\",\"\");\n<\/div>\n<\/code>\n\n \n<p>\nBuradaki con degiskeni veritabanina baglanti i\u00e7in gerekli. \ntestdatabase, yukarida da belirttigim gibi olusturdugum veritabaninin adi.<\/p>\n<ul>\n<li>root, kullanici adi.<\/li>\n<li>&#8221; &#8220;, ise sifrem. Yani sifre yok.<\/li>\n\n<\/ul> \n\n<code>\n<div  class=\"code\">PreparedStatement statement = con.prepareStatement(\"select * from calisanlar\");<br \/>\n\n<\/div>\n<\/code>\n    &#8211;Bir sorgu olusturuyoruz. \n          \n<br \/>\n<code>\n<div  class=\"code\">ResultSet result = statement.executeQuery();<br \/>\n\n<\/div>\n<\/code>\n&#8211;D\u00f6nen degeri result degiskenine atiyoruz.\n<br \/>\n<code>\n<div  class=\"code\">\nwhile(result.next()) <br \/>\n    {<br \/>\n&nbsp;&nbsp;&nbsp;System.out.println(result.getString(1)+&quot; &quot;+result.getString(2)+&quot; &quot;+result.getString(3));<br \/>\n    }\n    <br \/>\n\n<\/div>\n<\/code>\n      &#8211;Ve son olarak da 1&#8217;inci, 2&#8217;inci ve 3&#8217;\u00fcnc\u00fc s\u00fctunlardaki verileri ekrana yazdiriyoruz. <br \/>\n<a href='www.yazilimmutfagi.com'>.<\/a>","protected":false},"excerpt":{"rendered":"<p>Veri Tabani ile ilgili derslerimizin ilkinde java ile MS-SQL baglantisini yapmistik. Bu derste ise java ile mysql baglantisini yapacagiz insallah. Ilk olarak yapmamiz gereken bilgisayarimiza mysql server kurmak. <\/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":[4946,3934,4570,5307,5577],"_links":{"self":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/243"}],"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=243"}],"version-history":[{"count":0,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/243\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/media?parent=243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/categories?post=243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/tags?post=243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}