1-) Java - MSSQL BASİC
1-) Java - sql.java
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package mssql_basic;
//import java.beans.Statement;
import java.awt.List;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import javax.swing.JOptionPane;
/**
*
* @author Ramazan
*/
public class sql {
public static String connec = "";
public static Connection con = null;
public static PreparedStatement stmt = null;
public static ResultSet rs = null;
public sql() {
}
public static Connection MyGetConnection() {
try {
connec = "jdbc:sqlserver://localhost:1433;databaseName=deneme;user=sa;password=şifreburayagelicek";
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = (Connection) DriverManager.getConnection(connec);
} catch (ClassNotFoundException | SQLException ex) {
JOptionPane.showMessageDialog(null, ex.toString(), "MSSQL Bağlantısında Hata Var!", JOptionPane.INFORMATION_MESSAGE);
}
return con;
}
public static void MyExecuteSQL(String sql) { // Ekleme Silme ve Güncelleme için kullan
try {
MyGetConnection();
stmt = con.prepareStatement(sql);
stmt.execute();
con.close();
stmt.close();
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, ex.toString(), "SQL Sorgusunda Hata Var!", JOptionPane.INFORMATION_MESSAGE);
}
}
public static ArrayList<sqlobje> tableobjes;
public static sqlobje objem;
public static ArrayList<sqlobje> MyGetObject(String sql) { // Ekleme Silme ve Güncelleme için kullan
try {
MyGetConnection();
Statement stmt = con.createStatement();
rs = stmt.executeQuery(sql);
tableobjes = new ArrayList<sqlobje>();
while (rs.next()) {
objem = new sqlobje();
objem.id = rs.getInt("id");
objem.kritik = rs.getString("kritik");
objem.kritik1 = rs.getString("kritik1");
tableobjes.add(objem);
}
return tableobjes;
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, ex.toString(), "SQL Sorgusunda Hata Var!", JOptionPane.INFORMATION_MESSAGE);
return null;
}
}
}
2-) sqlobje.java
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package mssql_basic;
/**
*
* @author Ramazan
*/
public class sqlobje {
public int id;
public String kritik;
public String kritik1;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getKritik() {
return kritik;
}
public void setKritik(String kritik) {
this.kritik = kritik;
}
public String getKritik1() {
return kritik1;
}
public void setKritik1(String kritik1) {
this.kritik1 = kritik1;
}
}
3-) SQL_Deneme.java
...
public SQL_Deneme() {
initComponents();
MyTableDoldur();
}
...
private void EkleActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_EkleActionPerformed
sql.MyExecuteSQL("insert into tablo(kritik,kritik1) values('ramazan','haber')");
MyTableDoldur();
}//GEN-LAST:event_EkleActionPerformed
private void GuncelleActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_GuncelleActionPerformed
sql.MyExecuteSQL("update tablo set kritik='guncel' where kritik='ramazan'");
MyTableDoldur();
}//GEN-LAST:event_GuncelleActionPerformed
private void SilActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_SilActionPerformed
sql.MyExecuteSQL("delete from tablo where kritik='guncel'");
MyTableDoldur();
}//GEN-LAST:event_SilActionPerformed
public void MyTableDoldur() {
tableModel = new DefaultTableModel(col, 0);
ArrayList<sqlobje> listem = sql.MyGetObject("select * from tablo");
for (int i = 0; i < listem.size(); i++) {
int id = listem.get(i).getId();
String kritik = listem.get(i).getKritik();
String kritik1 = listem.get(i).getKritik1();
System.out.println("id : " + id);
System.out.println("kritik : " + kritik);
System.out.println("kritik1 : " + kritik1);
Object[] data = {id, kritik, kritik1};
tableModel.addRow(data);
}
jTable1.setModel(tableModel);
}
String col[] = {"id", "kritik", "kritik1"};
public DefaultTableModel tableModel;
private void GetirActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_GetirActionPerformed
MyTableDoldur();
}//GEN-LAST:event_GetirActionPerformed
4-) deneme(Database) -> tablo.sql
USE [deneme]
GO
/****** Object: Table [dbo].[tablo] Script Date: 8.8.2018 01:23:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tablo](
[id] [int] IDENTITY(1,1) NOT NULL,
[kritik] [nvarchar](50) NULL,
[kritik1] [nvarchar](50) NULL,
CONSTRAINT [PK_tablo] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO