student.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 javastdapp;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;

/**
 *
 * @author HP
 */
public class student {
      public void insertUpdateDeleteStudent(char operation, Integer id, String fname, 
            String lname, String sex, String phone, String address){
         
         Connection con = MyConnection.getConnection();
            PreparedStatement ps;
        if(operation == 'i') //for insert
        { 
            try 
               {
                   ps = con.prepareStatement("INSERT INTO student(first_name,last_name,sex,phone,address) VALUES (?,?,?,?,?)");
                   ps.setString(1, fname);
                   ps.setString(2, lname);
                   ps.setString(3, sex);
                   ps.setString(4, phone);
                   ps.setString(5, address);
                   
                    if(ps.executeUpdate() > 0){
                       JOptionPane.showMessageDialog(null, "New Student Added");
                     }
                } 
            catch (SQLException ex) 
                {
                     Logger.getLogger(student.class.getName()).log(Level.SEVERE,null,ex);
                }
        
        }
    
        if(operation == 'u') //for update
        { 
            try 
               {
                   ps = con.prepareStatement("UPDATE `student` SET `first_name`= ?,`last_name`= ?,`sex`= ?,`phone`= ?,`address`= ? WHERE `id` = ?");
                   ps.setString(1, fname);
                   ps.setString(2, lname);
                   ps.setString(3, sex);
                   ps.setString(4, phone);
                   ps.setString(5, address);
                   ps.setInt(6, id);
                   
                    if(ps.executeUpdate() > 0){
                       JOptionPane.showMessageDialog(null, "Student Data Updated");
                     }
                } 
            catch (SQLException ex) 
                {
                     Logger.getLogger(student.class.getName()).log(Level.SEVERE,null,ex);
                }
        
        }
        
         if(operation == 'd') //for delete
        { 
             int yesORno=JOptionPane.showConfirmDialog(null, "The score will be also deleted","Delete Student",JOptionPane.OK_CANCEL_OPTION,0);
             if(yesORno == 0){
               try 
               {
                   ps = con.prepareStatement("DELETE FROM `student` WHERE `id`= ?");
                   ps.setInt(1, id);
                   
                    if(ps.executeUpdate() > 0){
                       JOptionPane.showMessageDialog(null, "Student Deleted");
                     }
                } 
            catch (SQLException ex) 
                {
                     Logger.getLogger(student.class.getName()).log(Level.SEVERE,null,ex);
                }
             }
            
        
        }
    
    }
      
      public void Fill_Student_Table(JTable table, String ValueToSearch){
         Connection con = MyConnection.getConnection();
            PreparedStatement ps;
         try{
           ps = con.prepareStatement("SELECT * FROM `student` WHERE CONCAT(`first_name`,`last_name`,`sex`,`phone`,`address`) LIKE ?");
           ps.setString(1,"%"+ValueToSearch+"%");
           ResultSet rs =ps.executeQuery();        
           DefaultTableModel model =(DefaultTableModel) table.getModel();
           Object[] row;
           while(rs.next())
                {
                row = new Object[6];
                row[0] = rs.getInt(1);
                row[1] = rs.getString(2);
                row[2] = rs.getString(3);
                row[3] = rs.getString(4);
                row[4] = rs.getString(5);
                row[5] = rs.getString(6);
                model.addRow(row);
                }
            } catch (SQLException ex) {
              Logger.getLogger(student.class.getName()).log(Level.SEVERE, null, ex);
          }
      }
}