package Ventanas;

private JPanel contentPane;
private BaseDatos Palomos=null;
private JTextField txtCed;
private JTextField txtNom;
private JTextField txtApe;

private JTextField txtSueldo;
private JTextField txtTel;
private BaseDatos coco;

/**
 * Launch the application.
 */

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

/**
 * Create the frame.
 */
public ingresoMozo() {
    setDefaultCloseOperation(JFrame.HIDE_ON_CLOSE);
    setBounds(100, 100, 650, 650);
    contentPane = new JPanel();
    contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
    setContentPane(contentPane);
    contentPane.setLayout(null);

    JLabel lblCedula = new JLabel("Cu00E9dula");
    lblCedula.setBounds(23, 99, 46, 14);
    contentPane.add(lblCedula);

    JLabel lblNombre = new JLabel("Nombre");
    lblNombre.setBounds(23, 124, 46, 14);
    contentPane.add(lblNombre);

    JLabel lblApellido = new JLabel("Apellido");
    lblApellido.setBounds(23, 150, 46, 14);
    contentPane.add(lblApellido);

    JLabel lblTelfono = new JLabel("Telu00E9fono");
    lblTelfono.setBounds(23, 176, 46, 14);
    contentPane.add(lblTelfono);

    JLabel lblMozoAadidoCorrectamenteerror = new JLabel("Mozo au00F1adido correctamente/error");
    lblMozoAadidoCorrectamenteerror.setFont(new Font("Tahoma", Font.PLAIN, 14));
    lblMozoAadidoCorrectamenteerror.setBounds(23, 239, 219, 20);
    contentPane.add(lblMozoAadidoCorrectamenteerror);

    JLabel lblIngresarMozo = new JLabel("Datos de mozo");
    lblIngresarMozo.setFont(new Font("Tahoma", Font.BOLD, 14));
    lblIngresarMozo.setBounds(49, 52, 112, 20);
    contentPane.add(lblIngresarMozo);

    JLabel lblIngresoDeMozo = new JLabel("Ingreso de mozo");
    lblIngresoDeMozo.setFont(new Font("Tahoma", Font.BOLD, 16));
    lblIngresoDeMozo.setBounds(260, 11, 160, 28);
    contentPane.add(lblIngresoDeMozo);

    txtCed = new JTextField();
    txtCed.setBounds(78, 100, 129, 20);
    contentPane.add(txtCed);
    txtCed.setColumns(10);

    txtNom = new JTextField();
    txtNom.setBounds(78, 125, 129, 20);
    contentPane.add(txtNom);
    txtNom.setColumns(10);

    txtApe = new JTextField();
    txtApe.setBounds(78, 150, 129, 20);
    contentPane.add(txtApe);
    txtApe.setColumns(10);

    String cedula, telefono;
    String nombre, apellido;
    nombre=txtNom.getText().toString();
    apellido=txtApe.getText().toString();
    cedula=txtCed.getText().toString();
    Integer ced=Integer.parseInt(cedula);
    telefono=txtTel.getText().toString();
    Integer tel=Integer.parseInt(telefono);

    String consulta1 = "INSERT INTO `personas`(`nombre`, `apellido`, `telefono`, `ci`) VALUES ('" + nombre + "', '" + apellido + "' ,'" + tel + "', '" + ced + "');";


    JButton btnAceptar = new JButton("Aceptar");
    btnAceptar.addMouseListener(new MouseAdapter() {
        @Override
        public void mouseClicked(MouseEvent e) {



                coco.ejecutar(consulta1);




    }});


    btnAceptar.setBounds(104, 285, 89, 23);
    contentPane.add(btnAceptar);

    JButton btnLimpiarDatos = new JButton("Limpiar datos");
    btnLimpiarDatos.setBounds(260, 285, 112, 23);
    contentPane.add(btnLimpiarDatos);

    JLabel lblSueldo = new JLabel("Sueldo");
    lblSueldo.setBounds(23, 201, 46, 14);
    contentPane.add(lblSueldo);

    txtSueldo = new JTextField();
    txtSueldo.setBounds(78, 198, 129, 20);
    contentPane.add(txtSueldo);
    txtSueldo.setColumns(10);

    txtTel = new JTextField();
    txtTel.setBounds(75, 173, 86, 20);
    contentPane.add(txtTel);
    txtTel.setColumns(10);

}

public Connection getConexion() {
    return conexion;
}
public void setConexion(Connection conexion) {
        this.conexion = conexion;
}

public boolean ejecutar(String sql) {
    try {
        Statement sentencia = getConexion().createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
        sentencia.executeUpdate(sql);
        sentencia.close();
    } catch (SQLException e) {
        e.printStackTrace();
        return false;
    }
    return true;
}