Tutusfunny

This tutorial will teach you Records Navigation with image using Java and Mysql.i will teach step by step with in this tutorial which will help you in your future projects.

functional requirements

1. User shall be able to register the employee details along the image.

2. User shall be able to navigate the employee details along the image.

Main

it has two buttons employee registation and navigation.

1.if you want to  register the new employee click Add Employee.

2.if you want check the existing employee details click navigation button.

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt)
   {                                         
        emp e = new emp();
        e.setVisible(true);
    }                                        
    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) 
   {                                         
        empnav n = new empnav();
        n.setVisible(true);
    }

Employee Registation

you must create the following object and variables

String path = null;
Connection con;
PreparedStatement pst;
byte[] userimage = null;

Browse the Image

 JFileChooser picchoose = new JFileChooser();
 picchoose.showOpenDialog(null);
 File pic = picchoose.getSelectedFile();
        
        
 path = pic.getAbsolutePath();
 BufferedImage img;
  try {
        img = ImageIO.read(picchoose.getSelectedFile());
        ImageIcon imageic = new ImageIcon(new ImageIcon(img).getImage().getScaledInstance(250,250,Image.SCALE_DEFAULT));
        imagelabel.setIcon(imageic);
            
            
         File image = new File(path);
         FileInputStream fis = new FileInputStream(image);
         ByteArrayOutputStream bos = new ByteArrayOutputStream();
         byte[] buff = new byte[1024];
            
            
          for(int readNum; (readNum=fis.read(buff)) !=-1;)
          {
                bos.write(buff,0,readNum);
          }
            
           userimage = bos.toByteArray();

        } catch (IOException ex) {
            Logger.getLogger(emp.class.getName()).log(Level.SEVERE, null, ex);
        }

Save Button

 String empname = txtname.getText();
 String salary = txtsal.getText();
        
       
        
        try {
             File image = new File(path);
             FileInputStream fis = new FileInputStream(image);
             Class.forName("com.mysql.jdbc.Driver");
             con = DriverManager.getConnection("jdbc:mysql://localhost/empnav","root","");
             pst = con.prepareStatement("insert into records(empname,salary,photo)values(?,?,?)");
             pst.setString(1, empname);
             pst.setString(2, salary);
              pst.setBytes(3, userimage);
              pst.executeUpdate();
              JOptionPane.showMessageDialog(this, "Record Adddedddddd");
              
            
            
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(emp.class.getName()).log(Level.SEVERE, null, ex);
        } catch (FileNotFoundException ex) {
            Logger.getLogger(emp.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(emp.class.getName()).log(Level.SEVERE, null, ex);
        }

Exit Button

   this.setVisible(false);

Navigation Form

you must create the following object and variables

String path = null;
Connection con;

PreparedStatement pst;
Statement stat = null;
ResultSet rs;

Establish the database Connection

 public void Connection()
   {
       
        try {
            Class.forName("com.mysql.jdbc.Driver");
             con = DriverManager.getConnection("jdbc:mysql://localhost/empnav","root","");
             stat = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
             
             
            rs = stat.executeQuery("select empname,salary,photo from records"); 
             
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(empnav.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(empnav.class.getName()).log(Level.SEVERE, null, ex);
        }
   }

Call the Connection inside the Constructor of class

    public empnav() {
        initComponents();
        Connection();
    }

First  >

 try 
        {
            rs.first();
              txtname.setText(rs.getString(1));
              txtsal.setText(rs.getString(2));
              
              
              Blob blob1 = rs.getBlob("photo");
              byte[] imagebyte = blob1.getBytes(1, (int)blob1.length());
              
              ImageIcon imageic = new ImageIcon(new ImageIcon(imagebyte).getImage().getScaledInstance(250,250,Image.SCALE_DEFAULT));
              
              imagelabel.setIcon(imageic);
               
        } catch (SQLException ex) {
            Logger.getLogger(empnav.class.getName()).log(Level.SEVERE, null, ex);
        }

Previous <<

try {
            if(!rs.isFirst())
            {
            
             rs.previous();
              txtname.setText(rs.getString(1));
              txtsal.setText(rs.getString(2));
              
              
              Blob blob1 = rs.getBlob("photo");
              byte[] imagebyte = blob1.getBytes(1, (int)blob1.length());
              
              ImageIcon imageic = new ImageIcon(new ImageIcon(imagebyte).getImage().getScaledInstance(250,250,Image.SCALE_DEFAULT));
              
              imagelabel.setIcon(imageic);
              
            }
               
               
        } catch (SQLException ex) {
            Logger.getLogger(empnav.class.getName()).log(Level.SEVERE, null, ex);
        }

Next >>

 try {
         
            if(!rs.isLast())
            {
            
             rs.next();
              txtname.setText(rs.getString(1));
              txtsal.setText(rs.getString(2));
              
              
              Blob blob1 = rs.getBlob("photo");
              byte[] imagebyte = blob1.getBytes(1, (int)blob1.length());
              
              ImageIcon imageic = new ImageIcon(new ImageIcon(imagebyte).getImage().getScaledInstance(250,250,Image.SCALE_DEFAULT));
              
              imagelabel.setIcon(imageic);
              
            }
               
               
        } catch (SQLException ex) {
            Logger.getLogger(empnav.class.getName()).log(Level.SEVERE, null, ex);
        }

< last

  try {
          

            rs.last();
              txtname.setText(rs.getString(1));
              txtsal.setText(rs.getString(2));
              
              
              Blob blob1 = rs.getBlob("photo");
              byte[] imagebyte = blob1.getBytes(1, (int)blob1.length());
              
              ImageIcon imageic = new ImageIcon(new ImageIcon(imagebyte).getImage().getScaledInstance(250,250,Image.SCALE_DEFAULT));
              
              imagelabel.setIcon(imageic);
              
               
               
               
        } catch (SQLException ex) {
            Logger.getLogger(empnav.class.getName()).log(Level.SEVERE, null, ex);
        }

i have attached the video link below. which will do this tutorials step by step.