try{

        String sql ="select * from customer where num=? ";

        stmt=conn.prepareStatement(sql);
        stmt.setString(1,search.getText());
        rs=stmt.executeQuery(sql);

        String add1 =rs.getString("name");
        name.setText(add1);

        String add2 =rs.getString("address");
        address.setText(add2);



    }catch(Exception e){
        JOptionPane.showMessageDialog(null, "No Data");
    }

}