Total members 11890 |It is currently Fri Apr 19, 2024 10:43 am Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka





JComboBox usage example which is filling JComboBox from database, connection is passed to ComboBox.
java code
/*
* MyComboBox.java
*

*/

package connectingdatabase.Search;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JComboBox;

/**
*
* @author sami
*/
class MyComboBox extends JComboBox
{
public MyComboBox(Connection conn,String TableName)
{
if(conn==null) {
return;
}
Statement stat;
try {
stat = conn.createStatement();
ResultSet rs=stat.executeQuery("Select * from "+TableName+"; ");
ResultSetMetaData rsmd= rs.getMetaData();
int size=rsmd.getColumnCount();
for(int i=0;i<size;i++)
{
addItem(rsmd.getColumnName(i+1));
}
} catch (SQLException ex) {
ex.printStackTrace();
}

}
}




_________________
M. S. Rakha, Ph.D.
Queen's University
Canada


Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time
Post new topic Reply to topic  [ 1 post ] 

  Related Posts  to : Filling JComboBox from database
 filling two comboboxes     -  
 ASP.NET code for filling and displaying a DataGrid     -  
 2 different database     -  
 Selecting a Database in php     -  
 database connection     -  
 List all database in php     -  
 information about database     -  
 need help building table in my database!     -  
 array in oracle database     -  
 Close database connections in php     -  



Topic Tags

Java Swing






Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com