Showing posts with label java veritabanı örneği. Show all posts
Showing posts with label java veritabanı örneği. Show all posts
Java JDBC kütüphanesi ile veritabanından kayıt silme işlemi. Connection nesnesi ile veritabanı bağlantısı oluşturulur. Statement nesnesi ile SQL cümlesi çalıştırılır.
package delete;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class DeleteExample {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/first_example","root","123456");
String deleteSQL = "DELETE FROM person WHERE id = ?";
PreparedStatement state = connection.prepareStatement(deleteSQL);
state.setInt(1, 1);
int result = state.executeUpdate();
if (result > 0) {
System.out.println("Successful");
} else {
System.out.println("Failed");
}
state.setInt(1, 2);
result = state.executeUpdate();
if (result > 0) {
System.out.println("Successful");
} else {
System.out.println("Failed");
}
state.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
Java JDBC kütüphanesi ile veritabanından kayıt çekme işlemi. Connection nesnesi ile veritabanı bağlantısı oluşturulur. Statement nesnesi ile SQL cümlesi çalıştırılır. ResultSet nesnesi ile dönen kayıtlara erişilir.
package select;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
public class SelectExample {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/first_example","root","123456");
ResultSet result;
// SELECT With Dynamic Parameters
String selectSQL = "SELECT * FROM person WHERE id = ?";
PreparedStatement preparedState = connection.prepareStatement(selectSQL);
preparedState.setInt(1, 1);
result = preparedState.executeQuery();
if (result.next()) {
System.out.println(result.getInt("id") + " - "
+ result.getString("name") + " - "
+ result.getString("surname"));
}
System.out.println("-----------------------------------------------");
// SELECT With Static Parameters
Statement state = connection.createStatement();
result = state.executeQuery("SELECT * FROM person WHERE id = 1");
if (result.next()) {
System.out.println(result.getInt("id") + " - "
+ result.getString("name") + " - "
+ result.getString("surname"));
}
System.out.println("-----------------------------------------------");
// SELECT All Records
Statement stateAllRecords = connection.createStatement();
result = stateAllRecords.executeQuery("SELECT * FROM person");
while (result.next()) {
System.out.println(result.getInt("id") + " - "
+ result.getString("name") + " - "
+ result.getString("surname"));
}
preparedState.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
Java JDBC kütüphanesi ile veritabanındaki kayıtları güncelleme işlemi. Connection nesnesi ile veritabanı bağlantısı oluşturulur. Statement nesnesi ile SQL cümlesi çalıştırılır.
Github Linki
package update;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class UpdateExample {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/first_example","root","123456");
String updateSQL = "UPDATE person SET name = ? ,surname = ? WHERE id = ?";
PreparedStatement state = connection.prepareStatement(updateSQL);
state.setString(1, "Update");
state.setString(2, "Example");
state.setInt(3, 5);
int result = state.executeUpdate();
if (result > 0) {
System.out.println("Successful");
} else {
System.out.println("Failed");
}
state.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
Github Linki
package insert;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class InsertExample {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/first_example","root","123456");
String insertSQL = "INSERT INTO person (name,surname) VALUES (?,?)";
PreparedStatement state = connection.prepareStatement(insertSQL);
state.setString(1, "Berkay");
state.setString(2, "DEMİREL");
int result = state.executeUpdate();
if (result > 0) {
System.out.println("Successful");
} else {
System.out.println("Failed");
}
state.setString(1, "Insert");
state.setString(2, "Example");
result = state.executeUpdate();
if (result > 0) {
System.out.println("Successful");
} else {
System.out.println("Failed");
}
state.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}