JAVA VERİTABANI BAĞLANTISI - SQL SERVER

Java ile veritabanindan veri listeleme islemi yapacagiz. Bunun icin oncelikle JDBC drivera ihtiyacimiz var. Buradan indirebilirsiniz. .exe uzantili olan linki indirip unzipliyoruz. Daha sonra uygun jar file i kullanabiliriz. Ben sqljdbc4.jar i kullandim.

Eclipse de yeni bir proje olusturup sag tiklayarak -> Properties -> Java Build Path kisminda add external jar diyerek indirdigimiz jar i projemize dahil ediyoruz.

Simdi classimizi olusturup kod kismina gecelim.

import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;

public class Dbop {

 public static void main(String args[]){
  try{
   Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
   System.out.println("Driver loaded");
   
   String server= "localhost\\sqlexpress";
   int port = 1433;
   String user= "TestUser";
   String pass = "123456";
   String db = "ExampleDb";
   
   String jbcUrl = "jdbc:sqlserver://"+ server+ ":"+port+";user="+user+"; password="+pass +"; databaseName="+db+"";
   
   Connection con = DriverManager.getConnection(jbcUrl);
   System.out.println("connection obtained");
   
   Statement stmt = con.createStatement();
   System.out.println("Statement created");
   
   ResultSet rs = stmt.executeQuery("Select Username, Phone from [User]");
   System.out.println("Query executed");
   
   while(rs.next()){
    System.out.println("Username "+ rs.getString(1) + " Phone "+ rs.getString(2));
   }
   rs.close();
   stmt.close();
   con.close();
   
   System.out.println("Resource released");
   
  }catch(Exception ex){
   System.out.println("Error: " + ex);
  }
  
 }
}

ResultSet sonuclari indeks 1 den baslar. O yuzden Username i gostermek icin getString(1) i kullandik. Istersek indeks yerine sutun adini da yazarak verilere ulasabiliriz.

rs.getString("Username") seklinde.

Outputum su sekilde olacak:

Driver loaded
connection obtained
Statement created
Query executed
Username Mary Phone 05348784250
Username John Phone 05987545123
Username Joe Phone 23654178925
Username Peter Phone 78963254101
Resource released

Yararlandigim kaynak burdadir.