How do I set a jcombobox in a PreparedStatement?

Navigation
0

How do I make a jcombobox in this method? The Combobox would be in the type that the user is supposed to choose, I tried to make one but it did not work very well. And this method is in my main class and how do I set it to a PreparedStatement that is in a Dao class?

My method that is in the Main class 

 public static void inserirEnderecoTeste(){
        Bean viagem = new Bean();

        Object[] opcoes = {"Um","Dois","Tres","Quatro"};  
        viagem.setTipo(JOptionPane.showInputDialog(null, "Escolha um item" , "Selecao de itens" ,  
         JOptionPane.PLAIN_MESSAGE , null ,opcoes,""));


        viagem.setDataInicio(DataHelper.StringToCalendar("dd/MM/yyyy", 
                JOptionPane.showInputDialog("Insira a data de inicio:\n(Deve ser no formato  DD/MM/YYYY)", "30/05/2015")));
        viagem.setDataFim(DataHelper.StringToCalendar("dd/MM/yyyy", 
                JOptionPane.showInputDialog("Insira a data de fim:\n(Deve ser no formato  DD/MM/YYYY)", "01/05/2015")));
        viagem.setCidade(JOptionPane.showInputDialog("Insira a cidade:"));
        viagem.setUf(JOptionPane.showInputDialog("Insira o bairro:"));
        viagem.setValorDiaria(new Double(JOptionPane.showInputDialog("Valor da diária:")));
        viagem.setColaborador(JOptionPane.showInputDialog("Insira um colaborador"));
        viagem.setCliente(JOptionPane.showInputDialog("Insira um cliente"));
        //vb.setCidade(JOptionPane.showInputDialog("Insira a cidade Destino:", "Angra dos Reis"));



        if (Dao.inserir(viagem)){
            JOptionPane.showMessageDialog(null, "Inseriu!");
        } else {
            JOptionPane.showMessageDialog(null, "Não Inseriu!");
        }
    }
 }

This is the Dao class where I supposedly have to set jcombobox 

public static boolean inserir(Bean endereco) {
        boolean executou = false;
        if (ConexaoMySQL.conectar()) {
            try {
                Connection con = ConexaoMySQL.getConexao();
                String sql = "Insert into viagem values (0,?,?,?,?,?,?,?,?)";
                PreparedStatement pstm = con.prepareStatement(sql);

        >>>>>>>     pstm.setString(1,endereco.getTipo()); <<<<<<<<<<<

    
asked by anonymous 29.06.2015 / 22:57

1 answer

2

Apparently, the following works (although the question appears in the title): 

public static void main(String[] args) {
    System.out.println(JOptionPane.showInputDialog("Qual é o seu nome?"));
    JComboBox<String> options = new JComboBox<String>(new String[] {
            "Desenvolvedor", "Colaborador", "Visitante"
    });
    JOptionPane.showMessageDialog(null, options, "Qual é o seu título?", JOptionPane.QUESTION_MESSAGE);
    System.out.println(options.getSelectedItem());
}

The secret was to use JOptionPane.showMessageDialog (see documentation here) .

It's also worth taking a look at this StackOverflow answer in English .

Issue:

In your% w of%, leave the Bean attribute as tipo , instead of String .

    
29.06.2015 / 23:57
drawRect Android Canvas Save data group in Post method