/*���ܼ�飄1�7
*����ѡ��ؼ�������ݿ���ȡ�����м������ԡ�
*/
package realcix20.guis.components;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;
import javax.swing.JComboBox;
import realcix20.guis.utils.Item;
import realcix20.utils.DAO;
import realcix20.utils.Resources;
public class LanguageChooser extends JComboBox {
private Vector languages;
private DAO dao;
public LanguageChooser() {
super();
languages = new Vector();
dao = DAO.getInstance();
dao.query(Resources.SELECT_ACTIVE_LANGUAGE_SQL);
ResultSet rs = dao.executeQuery();
try {
while (rs.next()) {
Object factValue = rs.getString("LANG");
Object displayValue = rs.getString("TXT");
Item item = new Item(factValue, displayValue);
addItem(item);
}
rs.close();
}
catch (SQLException sqle) {
}
}
public void setSelectedLang(String lang) {
for (int i = 0; i < getItemCount(); i++) {
Item item = (Item)getItemAt(i);
if (lang.equals(item.getFactValue())) {
setSelectedItem(item);
break;
}
}
}
public String getSelectedLang() {
String selectedLang = null;
Object selectedItem = getSelectedItem();
if (selectedItem != null) {
selectedLang = ((Item)selectedItem).getFactValue().toString();
}
return selectedLang;
}
}