Jcombobox with mysql database

[kesariramachandran]

package med;

import java.awt.event.*;
import java.sql.Connection;
import javax.swing.*;
import javax.swing.text.*;
import java.sql.*;
import java.util.ArrayList;
import java.util.Vector;

public class Auto2 extends PlainDocument {
JComboBox comboBox;
ComboBoxModel model;
JTextComponent editor;
static Vector al=new Vector();
// flag to indicate if setSelectedItem has been called
// subsequent calls to remove/insertString should be ignored
boolean selecting=false;
boolean hidePopupOnFocusLoss;
boolean hitBackspace=false;
boolean hitBackspaceOnSelection;
boolean listContainsSelectedItem;

public Auto2(final JComboBox comboBox) {
this.comboBox = comboBox;
model = comboBox.getModel();
editor = (JTextComponent) comboBox.getEditor().getEditorComponent();
editor.setDocument(this);
comboBox.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
if (!selecting) highlightCompletedText(0);
}
});
editor.addKeyListener(new KeyAdapter() {
public void keyPressed(KeyEvent e) {
if (comboBox.isDisplayable()) comboBox.setPopupVisible(true);
hitBackspace=false;
switch (e.getKeyCode()) {
// determine if the pressed key is backspace (needed by the remove method)
case KeyEvent.VK_BACK_SPACE : hitBackspace=true;
hitBackspaceOnSelection=editor.getSelectionStart() !=editor.getSelectionEnd();
break;
}
}
});
// Bug 5100422 on Java 1.5: Editable JComboBox won't hide popup when tabbing out
hidePopupOnFocusLoss=System.getProperty("java.vers ion").startsWith("1.5");
// Highlight whole text when gaining focus
editor.addFocusListener(new FocusAdapter() {
public void focusGained(FocusEvent e) {
highlightCompletedText(0);
}
public void focusLost(FocusEvent e) {
// Workaround for Bug 5100422 - Hide Popup on focus loss
if (hidePopupOnFocusLoss) comboBox.setPopupVisible(false);
}
});
// Handle initially selected object
Object selected = comboBox.getSelectedItem();
if (selected!=null) setText(selected.toString());
highlightCompletedText(0);
}

public void remove(int offs, int len) throws BadLocationException {
// return immediately when selecting an item
if (selecting) return;
if (hitBackspace) {
if (listContainsSelectedItem) {
// move the selection backwards
// old item keeps being selected
if (offs>0) {
if (hitBackspaceOnSelection) offs--;
} else {
// User hit backspace with the cursor positioned on the start => beep
comboBox.getToolkit().beep(); // when available use: UIManager.getLookAndFeel().provideErrorFeedback(co mboBox);
}
highlightCompletedText(offs);
return;
} else {
super.remove(offs, len);
String currentText = getText(0, getLength());
// lookup if a matching item exists
Object item = lookupItem(currentText);
if (item != null) {
System.out.println("'" + item + "' matches.");
setSelectedItem(item);
listContainsSelectedItem=true;
} else {
System.out.println("No match. Selecting '" + currentText + "'.");
// no item matches => use the current input as selected item
item=currentText;
setSelectedItem(item);
listContainsSelectedItem=false;
}
// display the completed string
String itemString=item.toString();
setText(itemString);
if (listContainsSelectedItem) highlightCompletedText(offs);
}
} else {
super.remove(offs, len);
setSelectedItem(getText(0, getLength()));
listContainsSelectedItem=false;
}
}

public void insertString(int offs, String str, AttributeSet a) throws BadLocationException {
// return immediately when selecting an item
if (selecting) return;
// insert the string into the document
super.insertString(offs, str, a);
// lookup and select a matching item
Object item = lookupItem(getText(0, getLength()));

listContainsSelectedItem = true;
if (item == null) {
// no item matches => use the current input as selected item
item=getText(0, getLength());
listContainsSelectedItem=false;
}
setSelectedItem(item);
setText(item.toString());
// select the completed part
if (listContainsSelectedItem) highlightCompletedText(offs+str.length());
}

private void setText(String text) {
try {
// remove all text and insert the completed string
super.remove(0, getLength());
super.insertString(0, text, null);
} catch (BadLocationException e) {
throw new RuntimeException(e.toString());
}
}

private void highlightCompletedText(int start) {
editor.setCaretPosition(getLength());
editor.moveCaretPosition(start);
}

private void setSelectedItem(Object item) {
selecting = true;
model.setSelectedItem(item);
selecting = false;
}

private Object lookupItem(String pattern) {
Object selectedItem = model.getSelectedItem();
// only search for a different item if the currently selected does not match
if (selectedItem != null && startsWithIgnoreCase(selectedItem.toString(), pattern) && listContainsSelectedItem) {
return selectedItem;
} else {
// iterate over all items
for (int i=0, n=model.getSize(); i < n; i++) {
Object currentItem = model.getElementAt(i);
// current item starts with the pattern?
if (startsWithIgnoreCase(currentItem.toString(), pattern)) {
return currentItem;
}
}
}
// no item starts with the pattern => return null
return null;
}

// checks if str1 starts with str2 - ignores case
private boolean startsWithIgnoreCase(String str1, String str2) {
return str1.toUpperCase().startsWith(str2.toUpperCase());
}

private static void createAndShowGUI() {
// the combo box (add/modify items if you like to)
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/pharmacy","root","root");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select itname from purchase2");

while(rs.next())
{
al.add(rs.getString(1));
}
}
catch(Exception e)
{
System.out.println("ERROR"+e);
}

JComboBox comboBox = new JComboBox(al);
// has to be editable
comboBox.setEditable(true);
// change the editor's document
new Auto2(comboBox);

// create and show a window containing the combo box
JFrame frame = new JFrame();
frame.setDefaultCloseOperation(3);
frame.getContentPane().add(comboBox);
frame.pack(); frame.setVisible(true);
}


public static void main(String[] args) {
javax.swing.SwingUtilities.invokeLater(new Runnable() {
public void run() {
createAndShowGUI();
}
});
}
}




:cool::cool::cool::cool::cool::

[kesariramachandran]

I am going to develop a job portal and i am in need of the sample DataBase design for it......


Kindly reply anyone...................

[j2me64]

I am going to develop a job portal and i am in need of the sample DataBase design for it

before you design your db you must know which entities you want to store in it and this depends how your portal is looking. please, be a little more specific if you want to get help.