181
java.util.logging.Logger.getLogger(ayliq.class.getName()).log(java
.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new ayliq().setVisible(true);
});
// Variables declaration - do not modify
private javax.swing.JTable cedvel;
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton4;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JScrollPane jScrollPane1;
// End of variables declaration
}
package Esas;
import java.awt.print.PrinterException;
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.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import javax.swing.table.TableModel;
import javax.swing.table.DefaultTableModel;
182
public class bax extends javax.swing.JFrame {
Connection conn = null;
ResultSet rs = null;
PreparedStatement pst = null;
bazaiki con_pac;
public bax() {
initComponents();
conn = Connectdb.ConnectDB();
con_pac = new bazaiki();
con_pac.OpenDB();
con_pac.QuerySQL("SELECT * FROM metbaz");
}
@SuppressWarnings("unchecked")
//<editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
bindingGroup = new
org.jdesktop.beansbinding.BindingGroup();
entityManager = java.beans.Beans.isDesignTime() ? null :
javax.persistence.Persistence.createEntityManagerFactory("cp?zeroD
ateTimeBehavior=convertToNullPU").createEntityManager();
metbazQuery = java.beans.Beans.isDesignTime() ? null :
entityManager.createQuery("SELECT m FROM Metbaz m");
metbazList = java.beans.Beans.isDesignTime() ?
java.util.Collections.emptyList() : metbazQuery.getResultList();
jScrollPane1 = new javax.swing.JScrollPane();
cedvel1 = new javax.swing.JTable();
jToggleButton1 = new javax.swing.JToggleButton();
jToggleButton2 = new javax.swing.JToggleButton();
jButton1 = new javax.swing.JButton();
jButton2 = new javax.swing.JButton();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CL
OSE);
setTitle("Meteoroloji duruma bax");
setResizable(false);
getContentPane().setLayout(new
org.netbeans.lib.awtextra.AbsoluteLayout());
org.jdesktop.swingbinding.JTableBinding jTableBinding =
org.jdesktop.swingbinding.SwingBindings.createJTableBinding(org.jd
esktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE,
metbazList, cedvel1);
org.jdesktop.swingbinding.JTableBinding.ColumnBinding
columnBinding =
jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELPropert
y.create("${idmetbaz}"));
columnBinding.setColumnName("Kod");
columnBinding.setColumnClass(Integer.class);
columnBinding =
183
jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELPropert
y.create("${ad}"));
columnBinding.setColumnName("Ad");
columnBinding.setColumnClass(String.class);
columnBinding =
jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELPropert
y.create("${temperatur}"));
columnBinding.setColumnName("Temperatur");
columnBinding.setColumnClass(String.class);
columnBinding =
jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELPropert
y.create("${rutubet}"));
columnBinding.setColumnName("Rütubət");
columnBinding.setColumnClass(String.class);
columnBinding =
jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELPropert
y.create("${isiq}"));
columnBinding.setColumnName("İşıq");
columnBinding.setColumnClass(String.class);
columnBinding =
jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELPropert
y.create("${kulək}"));
columnBinding.setColumnName("Külək");
columnBinding.setColumnClass(String.class);
columnBinding =
cedvel1.getColumnModel().getColumn(0).setHeaderValue("Kod");
cedvel1.getColumnModel().getColumn(1).setHeaderValue("Ad");
cedvel1.getColumnModel().getColumn(2).setHeaderValue("Temperatur")
;
cedvel1.getColumnModel().getColumn(3).setHeaderValue("Rütubət");
cedvel1.getColumnModel().getColumn(4).setHeaderValue("İşıq");
cedvel1.getColumnModel().getColumn(5).setHeaderValue("Külək");
cedvel1.getColumnModel().getColumn(6).setHeaderValue("Yağış");
}
getContentPane().add(jScrollPane1, new
org.netbeans.lib.awtextra.AbsoluteConstraints(10, 20, 760, 335));
jToggleButton1.setText("Geriyə");
jToggleButton1.addActionListener(new
java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt)
{
jToggleButton1ActionPerformed(evt);
});
getContentPane().add(jToggleButton1, new
org.netbeans.lib.awtextra.AbsoluteConstraints(250, 380, 90, 30));
jToggleButton2.setText("Sil");
jToggleButton2.addActionListener(new
java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent
evt) {
jToggleButton2ActionPerformed(evt);
184
});
getContentPane().add(jToggleButton2, new
org.netbeans.lib.awtextra.AbsoluteConstraints(70, 380, 80, 30));
jButton1.setText("Dəyiş");
jButton1.addActionListener(new
java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt)
{
jButton1ActionPerformed(evt);
getContentPane().add(jButton2, new
org.netbeans.lib.awtextra.AbsoluteConstraints(650, 380, 80, 30));
jLabel1.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/Sekiler/tea-
plantation-close-up-photo-bandung-java-indonesia-DSC-0122.jpg")));
// NOI18N
getContentPane().add(jLabel1, new
org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 700, 420));
jLabel2.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/Sekiler/tea-
plantation-close-up-photo-bandung-java-indonesia-DSC-0122.jpg")));
// NOI18N
getContentPane().add(jLabel2, new
org.netbeans.lib.awtextra.AbsoluteConstraints(700, 0, 100, 420));
bindingGroup.bind();
pack();
}// </editor-fold>
private void
jToggleButton1ActionPerformed(java.awt.event.ActionEvent evt) {
dispose();
}
private void
jToggleButton2ActionPerformed(java.awt.event.ActionEvent evt) {
int Secilen = this.cedvel1.getSelectedRow();
String caynomresi = this.cedvel1.getValueAt(Secilen,
0).toString();
try{
//Busca no banco de dados o código do paciente
selecionado para ser excluido
String secilencay = "SELECT * FROM metbaz WHERE
idmetbaz = '"+caynomresi+"'";
con_pac.QuerySQL(secilencay);
con_pac.rs.next();
//Mensagem de confirmação
String Msg = "Seçilən məlumat silinsin :
"+con_pac.rs.getString("ad")+" ?";
int mesaj = JOptionPane.showConfirmDialog(null, Msg,
"Sil", JOptionPane.YES_NO_OPTION);
185
if(mesaj == JOptionPane.YES_OPTION){
//Excluindo o usuário após a confirmação positiva
String secilenmelumat = "DELETE FROM metbaz WHERE
idmetbaz = "+caynomresi;
int ugurla =
con_pac.stmt.executeUpdate(secilenmelumat);
if(ugurla == 1){
JOptionPane.showMessageDialog(null,"Uğurla
qeydə alındı!","Sil!", JOptionPane.INFORMATION_MESSAGE);
//Atualiza jTable
return;
}
JOptionPane.showMessageDialog(null,"Uğurla
qeydə alındı!","Sil!", JOptionPane.INFORMATION_MESSAGE);
//Atualiza jTable
catch(SQLException erroSQL){
JOptionPane.showMessageDialog(null,"Yenilənə bilməz!
, "+erroSQL, "Xəta!", JOptionPane.ERROR_MESSAGE);
//Atualiza ResultSet
}
}
private void
jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
try {
Boolean complete = cedvel1.print();
if (complete) {
JOptionPane.showMessageDialog(null, "Print olundu");
} else {
JOptionPane.showMessageDialog(null, "Xəta baş verdi");
}
} catch (PrinterException ex) {
Logger.getLogger(bax.class.getName()).log(Level.SEVERE, null, ex);
}
}
public static void main(String args[]) {
try {
for (javax.swing.UIManager.LookAndFeelInfo info :
javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
} catch (ClassNotFoundException ex) {
private org.jdesktop.beansbinding.BindingGroup bindingGroup;
// End of variables declaration.
186
ƏLAVƏ 3
Avtomatlaşdırılmış suvarma sisteminin qeyri-səlis idarəetmə alqoritminin
Matlab Fuzzy-də tərtib olunmuş proqramı
[System]
Name='Meteoroloji durum'
Type='mamdani'
Version=2.0
NumInputs=3
NumOutputs=2
NumRules=5
AndMethod='min'
OrMethod='max'
ImpMethod='min'
AggMethod='max'
DefuzzMethod='centroid'
[Input1]
Name='Hava.temp.'
Range=[10 20]
NumMFs=5
MF1='cox.asaqi':'trimf',[10 11 12]
MF2='asaqi':'trimf',[12 13 14.4]
MF3='uyqun':'trimf',[14.5 15 16.4]
MF4='yuxari':'trimf',[16.4 17 18.4]
MF5='cox.yuqari':'trimf',[18.4 19 20]
[Input2]
Name='Torpaq.su.balans'
Range=[0.113 0.138]
NumMFs=5
MF1='cox.azdir':'trimf',[0.113 0.115 0.117]
MF2='azdir':'trimf',[0.117 0.12 0.123]
MF3='uyqun':'trimf',[0.1231 0.1261 0.128]
MF4='cox':'trimf',[0.128 0.131 0.133]
MF5='daha.cox':'trimf',[0.133 0.135 0.138]
[Input3]
Name='Hava.nisbi.rutub.'
Range=[58 84]
NumMFs=5
MF1='cox.asaqi':'trimf',[58 60.16 63.2]
MF2='asaqi':'trimf',[63.46 65.62 68.98]
MF3='uyqundur':'trimf',[68.98 72.18 75]
MF4='yuksek':'trimf',[75 77.13 80]
MF5='cox.yuks.':'trimf',[80 82 84]
[Output1]
Name='Nsos.is.rejim'
Range=[-3 14]
NumMFs=2
187
MF1='azonlu':'trimf',[0 3 6.5]
MF2='yaqisvari':'trimf',[6.53663793103448 10.0366379310345
14.0366379310345]
[Output2]
Name='Nasos.is.muddet'
Range=[-3 14]
NumMFs=5
MF1='sifir':'trimf',[-3 -1 0]
MF2='cox.qisa.mud.isl.':'trimf',[0 2.56 3.23]
MF3='qisa.mud.isl':'trimf',[3.23 5.1 6.12]
MF4='uzun.mud.isl.':'trimf',[6.12 8.11 10.12]
MF5='cox.uzun.mud.':'trimf',[10.2 12.3 14]
[Rules]
1 5 5, 0 1 (1) : 1
2 4 4, 1 2 (1) : 1
3 3 3, 1 3 (1) : 1
4 2 2, 2 4 (1) : 1
5 1 1, 2 5 (1) : 1
