Friday, October 26, 2012

Code used in video "Java prog#10. Display jtextfield when select item in jcombobox in Netbeans Java and Sqlite (mysql)"


HERE I AM PROVIDING THE downloadable CODE LINK OF  THE JAVA CODE I HAVE USED IN THE VIDEO  "Java prog#10. Display jtextfield when select item in jcombobox in Netbeans Java and Sqlite (mysql)"  OF MY YOUTUBE CHANNEL PROGRAMMINGKNOWLEDGE



Click Link to watch the video LINK


This code below is for the example of ComboBox_namePopupMenuWillBecomeInvisible  method action perform
 



  private void ComboBox_namePopupMenuWillBecomeInvisible(javax.swing.event.PopupMenuEvent evt) {                                                           
   
        
        
        String tmp =(String)ComboBox_name.getSelectedItem();            
            String sql="select * from Empoyeeinfo where name=?";
           try{
            pst=conn.prepareStatement(sql);
            pst.setString(1, tmp);
            rs=pst.executeQuery();
            if(rs.next()){
            String add1 =rs.getString("Empoyeeid");
            txt_Empoyeeid.setText(add1);
            String add2 =rs.getString("name");
            txt_name.setText(add2);
            String add3 =rs.getString("surname");
            txt_surname.setText(add3);
            String add4 =rs.getString("age");
             combo_age.setSelectedItem(add4);
            
            
            
            
            }
            }        
    
           catch(Exception e)
    {
           JOptionPane.showMessageDialog(null, e);

    }
           
           
    }       

2 comments:

  1. hi,
    i want to get data to be displayed in a combo box when i select from JTable. and after that i want to update the data in the combo box by choosing another valuse from the list. can you show me how to do this.

    ReplyDelete
  2. String tmp=(String)combo.getSelectedItem();
    //JOptionPane.showMessageDialog(null,tmp);
    String driver="sun.jdbc.odbc.JdbcOdbcDriver";
    Class.forName(driver);
    String sql="Select * from Table1";
    String db="jdbc:odbc:ny";
    con=DriverManager.getConnection(db);

    st=con.createStatement();
    st.setString(1, tmp); // it show error message.
    rs=st.executeQuery(sql);
    JOptionPane.showMessageDialog(null,tmp);

    // this is not working. why..??

    ReplyDelete