1-) Java - MYSQL İLE NETBEANS 8.0.2 DE BAĞLANTI KURMA EKLEME SİLME VB İŞLEMLER

KOD BAŞLANGICI 2

import com.mysql.jdbc.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.logging.Level;

import java.util.logging.Logger;

import javax.swing.JOptionPane;

public class ra extends javax.swing.JFrame {

public Connection GetConnection() {

Connection con;

con = null;

try {

Class.forName("com.mysql.jdbc.Driver");

String database = "jdbc:mysql://localhost:3306/java_mysq";

con = (Connection) DriverManager.getConnection(database, "root", "");

} catch (ClassNotFoundException | SQLException e) {

JOptionPane.showMessageDialog(null, e.toString(), "student DataBase", JOptionPane.INFORMATION_MESSAGE); }

return con; }

//VERİ TABANINA SİLER TABLODAKİ İSME GÖRE

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {

Connection con = GetConnection();

try {

Statement stmt;

String strSQL, ad, yas;

ad = jTextField1.getText();

yas = jTextField2.getText();

strSQL = "DELETE FROM kisi where ad='" + ad + "'";

stmt = con.createStatement();

stmt.execute(strSQL);

stmt.close();

JOptionPane.showMessageDialog(null, "veriler silindi");

} catch (Exception e) {

JOptionPane.showMessageDialog(null, e.getMessage()); } }

//YAŞI TEXTFİELDE GİRİLEN DEGERDEN BUYUK OLANLARI TABLOYA GETİRİR

private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {

try {

Connection con2 = GetConnection();

Statement stmt = con2.createStatement();

Object[][] obj;

ResultSet rs = stmt.executeQuery("SELECT COUNT(*) AS rowcount FROM kisi where yas>" + jTextField3.getText());//kisi tablosunda secim yap ne war ne yoksa sayisini al satir sayisini al

rs.next();

int icount = rs.getInt("rowcount");

rs.close();

rs = stmt.executeQuery("SELECT * FROM kisi where yas>" + jTextField3.getText());//kisi tablosunun hepsini getir

obj = new Object[icount][3];

icount = 0;

while ((rs != null) && rs.next()) {

obj[icount][0] = icount + 1;

obj[icount][1] = rs.getString("ad");

obj[icount][2] = rs.getString("yas");

icount = icount + 1; }

con2.close();

jTable1.setModel(new javax.swing.table.DefaultTableModel(obj, new String[]{"S.no :", "ad:", "yas:"}));

} catch (SQLException ex) {

Logger.getLogger(ra.class.getName()).log(Level.SEVERE, null, ex); } }

//TÜM KAYITLARI GÖSTERİR VERİTABANINDAKİ

private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {

try {

Connection con2 = GetConnection();

Statement stmt = con2.createStatement();

Object[][] obj;

ResultSet rs = stmt.executeQuery("SELECT COUNT(*) AS rowcount FROM kisi");//kisi tablosunda secim yap ne war ne yoksa sayisini al satir sayisini al

rs.next();

int icount = rs.getInt("rowcount");

rs.close();

rs = stmt.executeQuery("SELECT * FROM kisi");//kisi tablosunun hepsini getir

obj = new Object[icount][3];

icount = 0;

while ((rs != null) && rs.next()) {

obj[icount][0] = icount + 1;

obj[icount][1] = rs.getString("ad");

obj[icount][2] = rs.getString("yas");

icount = icount + 1; }

con2.close();

jTable1.setModel(new javax.swing.table.DefaultTableModel(obj, new String[]{"S.no :", "ad:", "yas:"}));

} catch (SQLException ex) {

Logger.getLogger(ra.class.getName()).log(Level.SEVERE, null, ex); } }

//VERİ TABANINA KAYDEDER

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {

Connection con = GetConnection();

try {

Statement stmt;

String strSQL, ad, yas;

ad = jTextField1.getText();

yas = jTextField2.getText();

strSQL = "INSERT INTO kisi(ad,yas) VALUES('" + ad + "'," + yas + ")";

stmt = con.createStatement();

stmt.execute(strSQL);

stmt.close();

JOptionPane.showMessageDialog(null, "veriler kaydedildi");

} catch (Exception e) {

JOptionPane.showMessageDialog(null, e.getMessage()); } } KOD BİTİŞİ 2?