Results 1 to 3 of 3
  1. #1
    Join Date
    May 2010
    Posts
    2
    Rep Power
    0

    Default Jcombobox with mysql database

    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::

  2. #2
    Join Date
    May 2010
    Posts
    2
    Rep Power
    0

    Question Database Design

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


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

  3. #3
    j2me64's Avatar
    j2me64 is offline Senior Member
    Join Date
    Sep 2009
    Location
    Zurich, Switzerland
    Posts
    962
    Rep Power
    5

    Default

    Quote Originally Posted by kesariramachandran View Post
    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.

Similar Threads

  1. populate jCombobox with database data
    By joeyxaza in forum JDBC
    Replies: 2
    Last Post: 01-06-2014, 10:09 AM
  2. Help Pls!! Jcombobox populate with mysql
    By kwink in forum AWT / Swing
    Replies: 1
    Last Post: 03-23-2009, 04:11 AM
  3. Replies: 2
    Last Post: 02-11-2009, 04:43 AM
  4. populate jCombobox with database data
    By joeyxaza in forum JDBC
    Replies: 0
    Last Post: 01-19-2009, 04:30 PM
  5. jComboBox and database
    By pravin2008 in forum AWT / Swing
    Replies: 3
    Last Post: 08-25-2008, 04:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •