Aplikasi Dokter Dengan Netbeans

import javax.swing.JTable.*;

import javax.swing.table.DefaultTableModel;

import javax.swing.JOptionPane;

import java.text.*;

import java.sql.*;

import java.util.Date.*;

import java.awt.HeadlessException;

import java.lang.NullPointerException;

import java.util.logging.Level;

import java.util.logging.Logger;

import java.awt.Dimension;

import java.awt.Toolkit;

import javax.swing.JOptionPane;

import java.io.File;

import net.sf.jasperreports.engine.JasperFillManager;

import net.sf.jasperreports.engine.JasperReport;

import net.sf.jasperreports.engine.JasperPrint;

import net.sf.jasperreports.view.JasperViewer;

import java.util.HashMap;

import java.util.Map;

import net.sf.jasperreports.engine.JasperCompileManager;

import net.sf.jasperreports.engine.JasperPrintManager;

import net.sf.jasperreports.engine.design.JasperDesign;

import net.sf.jasperreports.engine.xml.JRXmlLoader;

import java.sql.DriverManager;

import java.sql.*;

import net.sf.jasperreports.engine.util.JRLoader;

String [] judul={"KODE DOKTER","NAMA","KELAMIN","ALAMAT","SPESIALIS","NO TELP","GAJI"};

    DefaultTableModel DTM;

    /** Creates new form formdokter */

    public formdokter() {

       DTM=new DefaultTableModel(null,judul){

            public boolean isCellEditable(int row,int column){

                return false;}

              };

        initComponents();

        kosong();

        filltable();

    }

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

        // TODO add your handling code here:

        if(rblaki.isSelected()){

            rbperempuan.setSelected(false);

        }  }                                     

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

        // TODO add your handling code here:

        if(rbperempuan.isSelected()){

            rblaki.setSelected(false);

        } }   

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

        // TODO add your handling code here:

        try {

           //Lokasi File Jasper//

            String

        nmFile="./src/dokter/report1.jasper";

    conekDB getcn=new conekDB();

            Connection cn=getcn.konek();

      Statement st=cn.createStatement();

            HashMap parameter=new HashMap();

            File reportFile=new File(nmFile);

            JasperReport jReport= (JasperReport)

                    JRLoader.loadObject(reportFile.getPath());

           JasperPrint jPrint=JasperFillManager.fillReport

                    (jReport, parameter,cn);

            JasperViewer.viewReport(jPrint, false);         JasperViewer.setDefaultLookAndFeelDecorated(true);

           cn.close();

        

               

 }catch (Exception e) {

                JOptionPane.showMessageDialog(null,"Laporan Tidak Dapat Dicetak!\n" +

 e.getMessage(),"Cetak Laporan", JOptionPane.ERROR_MESSAGE);

  }  }                       

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

        // TODO add your handling code here:

        try{

            conekDB getcn=new conekDB();

           Connection cn=getcn.konek();

           Statement st=cn.createStatement();

           String SQL="SELECT * FROM dokter WHERE kode_dokter='"+txtkodedokter.getText().trim()+"'";

           ResultSet rs=st.executeQuery(SQL);

           if(rs.next()){

               JOptionPane.showMessageDialog(null,"MAAF DATA SUDAH ADA");

               txtnamadokter.setText(""+rs.getString("nama_dokter"));

               if(rs.getString("kelamin").equals("L"))

               rblaki.setSelected(true);

               else

               rbperempuan.setSelected(true);

               txtalamat.setText(""+rs.getString("alamat"));

               txtspesialis.setText(""+rs.getString("spesialis"));

               txtnotelp.setText(""+rs.getString("no_tlpn"));

               txtgaji.setText(""+rs.getString("gaji"));

               bsimpan.setText("UPDATE");

               bhapus.setEnabled(true);

           }

           else{

               bsimpan.setText("SIMPAN");

               JOptionPane.showMessageDialog(null,"DATA BARU");

           }

           bsimpan.setEnabled(true);

           bkeluar.setText("BATAL");

           st.close();

           cn.close();

           rs.close();

                  

        }catch(Exception exc){

            System.err.println(exc.getMessage());

        }

        txtnamadokter.requestFocus();

   

    }                                            

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

        // TODO add your handling code here:

        if (txtkodedokter.getText().equals(""))

            JOptionPane.showMessageDialog(null,"ISI DATA DOKTER DENGAN LENGKAP");

        else{

            String kel="";

            if(rblaki.isSelected()==true)

                kel="L";

            else

                kel="P";

           

            data clsData = new data();

            String SQL="";

            if(bsimpan.getText().equals("SIMPAN")){

                SQL="INSERT INTO dokter VALUES('"+txtkodedokter.getText().trim()+"','"+txtnamadokter.getText()

                        .trim()+"','"+kel+"','"+txtalamat.getText().trim()+"','"+txtspesialis.getText().trim()

                        +"','"+txtnotelp.getText().trim()+"','"+txtgaji.getText().trim()+"')";

                clsData.ExecuteSQL(SQL);

            }

                   

       else{

SQL ="UPDATE dokter SET nama_dokter = '"+ txtnamadokter.getText().trim()

                + "',kelamin='" + kel + "',alamat = '"+txtalamat.getText().trim() + "', spesialis='"+txtspesialis.getText().trim()+"',no_tlpn='" + txtnotelp.getText().trim()

+ "'gaji= '"+txtgaji.getText().trim() + "', WHERE kode_dokter = '"+txtkodedokter.getText().trim()+"'";

                 clsData.ExecuteSQL(SQL);

            }

            clsData=null;

            kosong();

                    filltable();

        }

       

    }

        void kosong(){

        txtkodedokter.setText("");

        txtnamadokter.setText("");

        rblaki.setSelected(true);

        rbperempuan.setSelected(false);

        txtalamat.setText("");

        txtspesialis.setText("");

        txtnotelp.setText("");

        txtgaji.setText("");

        bsimpan.setEnabled(false);

        bhapus.setEnabled(false);

        bkeluar.setEnabled(true);

        bsimpan.setText("SIMPAN");

        bkeluar.setText("KELUAR");

        txtkodedokter.requestFocus();

   

    }                                      

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

        // TODO add your handling code here:

        data clsData=new data();

            String SQL="";

            SQL = "DELETE FROM dokter WHERE kode_dokter = '"+ txtkodedokter.getText().trim() + "'";

                clsData.ExecuteSQL(SQL);

          

        clsData=null;

        kosong();

        filltable();

        }                                     

void filltable(){

    String SQL ="SELECT*FROM dokter";

    DTM.setRowCount(0);

    try{

        conekDB getCn=new conekDB();

        Connection cn=getCn.konek();

        Statement st=cn.createStatement();

        ResultSet rs=st.executeQuery(SQL);

        while(rs.next())

        {

            String vkodedokter=rs.getString("kode_dokter");

            String vnamadokter=rs.getString("nama_dokter");

            String valamat=rs.getString("alamat");

            String vkelamin=rs.getString("kelamin");

            String kel="";

            if(vkelamin.equals("L"))

                kel="laki-laki";

            else

                kel="perempuan";

             String vspesialis=rs.getString("spesialis");

              String vnotlpn=rs.getString("no_tlpn");

            String vgaji=rs.getString("gaji");

           String[]data={vkodedokter,vnamadokter,kel,valamat,vspesialis,vnotlpn,vgaji};

            DTM.addRow(data);

        }

        st.close();

        cn.close();

        rs.close();

        tabeldokter.setModel(DTM); 

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

        // TODO add your handling code here:

            if(bkeluar.getText().equals("KELUAR")){

            dispose();

            setVisible(false);}

        else

            kosong();

       

    }