NETBEANS SEARCH CODES

//AYOUB ZAERI POUR

EMPLOYEE SERACH FRAME CODES -

String custname=tf8.getText();
    if(custname.isEmpty())
    {

        tf13.setText("");
        tf14.setText("");
        JOptionPane.showMessageDialog(this,"ENTER THE NAME PLEASE");
    }
    else
    {
        try
        {
        Class.forName("java.sql.DriverManager");
        Connection con =(Connection)
         DriverManager.getConnection("jdbc:mysql://localhost:3306/cbse","root","azp");
        Statement stmt=(Statement)con.createStatement();
        String query="SELECT custname,address ,phone, email FROM CUSTOMER WHERE custname = '"+ custname+"';";

        ResultSet rs=stmt.executeQuery(query);
        if(rs.next())
                {

                    String address=rs.getString("address");
                    String phone=rs.getString("phone");


                    tf13.setText(address);
                    tf14.setText(phone);

                }
        else
            JOptionPane.showMessageDialog(this,"sorry!No such CUSTOMER NAME ");


        }
        catch(Exception e)
        {
        JOptionPane.showMessageDialog(this,e.getMessage());


        }