private JPanel contentPane;
private JTextField jtfNome;
private JTextField jtfId;
private JTextField jtfSalario;
  private Connection connection = null;
  private Statement statement = null;
  private ResultSet resultset = null;


    public void conectar() {
        String servidor = "jdbc:mysql://localhost:3306/bermudas?useTimezone=true&serverTimezone=UTC";
        String usuario = "root";
        String senha = "13@2da";
        String driver = "com.mysql.cj.jdbc.Driver";

            try {
                Class.forName(driver);
                this.connection = DriverManager.getConnection(servidor, usuario, senha);
                this.statement = this.connection.createStatement();
                JOptionPane.showMessageDialog(null,"Conectou");
            } catch (ClassNotFoundException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
    }

    public void insFun(int id1,String name,float sal) {
         int id2=id1;
         String name2=name;
         float sal2=sal;

        try {
            String sql = "INSERT INTO funcionarios(RegistroFuncionarios,Nome,Salario) VALUES ("+id2+","+name2+","+sal2+")";
            JOptionPane.showMessageDialog(null,"a+  "+id2+name2+sal2+"    +a");
            statement.executeUpdate(sql);

        } catch (SQLException e1) {
                e1.printStackTrace();}

    }



/**
 * Launch the application.
 */
public static void main(String[] args) {
    EventQueue.invokeLater(new Runnable() {
        public void run() {
            try {
                Intgrafica frame = new Intgrafica();
                frame.setVisible(true);
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    });
}

/**
 * Create the frame.
 */
public Intgrafica() {
    setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    setBounds(100, 100, 450, 300);
    contentPane = new JPanel();
    contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
    setContentPane(contentPane);
    contentPane.setLayout(null);

    JLabel lblNome = new JLabel("nome");
    lblNome.setBounds(29, 50, 46, 14);
    contentPane.add(lblNome);

    JLabel lblId = new JLabel("id");
    lblId.setBounds(29, 94, 46, 14);
    contentPane.add(lblId);

    JLabel lblSalario = new JLabel("salario");
    lblSalario.setBounds(29, 138, 46, 14);
    contentPane.add(lblSalario);

    jtfNome = new JTextField();
    jtfNome.setBounds(68, 47, 86, 20);
    contentPane.add(jtfNome);
    jtfNome.setColumns(10);

    jtfId = new JTextField();
    jtfId.setBounds(68, 91, 86, 20);
    contentPane.add(jtfId);
    jtfId.setColumns(10);

    jtfSalario = new JTextField();
    jtfSalario.setBounds(68, 135, 86, 20);
    contentPane.add(jtfSalario);
    jtfSalario.setColumns(10);

    JButton btnAdicionarFuncionario = new JButton("adicionar funcionario");
    btnAdicionarFuncionario.addActionListener(new ActionListener() {
        public void actionPerformed(ActionEvent e) {

            Intgrafica x = new Intgrafica();
            x.conectar();
            x.insFun(Integer.parseInt(jtfId.getText()), jtfNome.getText(), Float.parseFloat(jtfSalario.getText()));
            //try {
            //  String sql = "INSERT INTO funcionarios(RegistroFuncionarios,Nome,Salario) VALUES ("+Integer.parseInt(jtfId.getText())+","+jtfNome.getText()+","+Float.parseFloat(jtfSalario.getText())+")";
            //  statement.executeUpdate(sql);
            //} catch (SQLException e1) {
            //      e1.printStackTrace();}

        }
    });
    btnAdicionarFuncionario.setBounds(68, 194, 191, 23);
    contentPane.add(btnAdicionarFuncionario);
}