Searching

[Jorah Espa�ol]

hi!, I'm just new to java swing and jdbc... I'm the pace of searching records... I was making a code which can search for a record by typing a certain letter.. when I type 'j' all the letters that begins with 'j' appears etc. and I made it right..

here's the problem, I wanted to make a search which is better than that.. if I'm looking for a record example name: "john" when I type 'j' of course all the records that starts with 'j' will appear and then 'o' and all the records that starts with 'j' and has a second character 'o' will appear.. and so on... until it found "john"... I don't know how to make each character I type into one string...

can anybody correct my code or can give me any idea on how to make that.. hope to hear from all of you soon.. thanks

import java.awt.*; 
import java.awt.event.*; 
import javax.swing.*; 
import javax.swing.event.*; 
import java.sql.*; 
 
public class MySearch extends JFrame 
{ 
  private Dimension size = Toolkit.getDefaultToolkit().getScreenSize(); 
  private JPanel JPContainer = new JPanel(); 
  private JTextField capture = new JTextField( 100 ); 
 
  private String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; 
  private String DBSource = "jdbc:odbc:Search"; 
 
  private Connection connect; 
  private ResultSet rs; 
  private Statement state; 
 
  private ListSelectionModel searchSelector, searchSelected; 
 
  private JTable searchTable, createdSearchTable; 
  private JScrollPane searchScroller = new JScrollPane(); 
  private int searchTotal, searchRow; 
  private String[][] searchRecord = new String[ 0 ][ 0 ]; 
  private String queryName = "SELECT * FROM tblNames"; 
 
  private boolean verifySearch; 
 
  public MySearch() 
  { 
 
    JPContainer.setLayout( null ); 
 
    try 
    { 
      Class.forName( DBDriver ); 
      connect = DriverManager.getConnection( DBSource, "", "" ); 
    }catch( SQLException sql ) { System.out.println( sql.getMessage() ); } 
     catch( ClassNotFoundException notFound ) { System.out.println( notFound.getMessage() ); } 
 

    searchTable = createSearchTable(); 
    searchScroller.getViewport().add( searchTable ); 
    searchScroller.setBounds( 10, 10, 150, 250 ); 
    JPContainer.add( searchScroller ); 
 
    capture.setBounds( 1, 1, 1, 1 ); 
    capture.addKeyListener( searchKey ); 
    JPContainer.add( capture ); 
 
    getContentPane().add( JPContainer ); 
    setLocation( ( size.width - 200 ) / 2, ( ( size.height - 300 ) / 2 ) - 45 ); 
    setSize( 200, 300 ); 
    setVisible( true ); 
 
  } 
 
  protected JTable createSearchTable() 
  { 
    String[] searchColumn = { "Name" }; 
 
    try 
    { 
      state = connect.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE ); 
      rs = state.executeQuery( queryName ); 
 
      rs.afterLast(); 
      if( rs.previous() ) searchTotal = rs.getRow(); 
      rs.beforeFirst(); 
 
      if( searchTotal > 0 ) 
      { 
        searchRecord = new String[ searchTotal ][ 1 ]; 
        while( rs.next() ) 
        { 
          searchRecord[ searchRow ][ 0 ] = ""+ rs.getString( "Names" ); 
          searchRow++; 
        } 
      } 
      else 
      { 
        searchRecord = new String[ 0 ][ 1 ]; 
        while( rs.next() ) 
        { 
          searchRecord[ 0 ][ 0 ] = ""+ rs.getString( "Names" ); 
        } 
      } 
    }catch( SQLException sql ) { System.out.println( sql.getMessage() ); } 
 
    createdSearchTable = new JTable( searchRecord, searchColumn ) 
    { 
      public boolean isCellEditable( int row, int cols ) 
      { return false; } 
    }; 
 
    createdSearchTable.setSelectionMode( ListSelectionModel.SINGLE_SELECTION ); 
    searchSelector = createdSearchTable.getSelectionModel(); 
    searchSelector.addListSelectionListener( searchListener ); 
 
    searchColumn = null; 
    searchRecord = null; 
    searchRow = 0; 
 
    return createdSearchTable; 
  } 
 
  ListSelectionListener searchListener = new ListSelectionListener() 
  { 
    public void valueChanged( ListSelectionEvent listEvent ) 
    { 
      searchSelected = ( ListSelectionModel ) listEvent.getSource(); 
 
      if( searchSelected.getValueIsAdjusting() ) return; 
 
      if( searchSelected.isSelectionEmpty() ) 
      { 
        verifySearch = true; 
      } 
      else 
      { 
        verifySearch = false; 
      } 
 
    } 
  }; 
 
  KeyListener searchKey = new KeyListener() 
  { 
    public void keyTyped( KeyEvent keyEvent ) 
    { 
       getKeyTyped( keyEvent ); 
    } 
 
    public void keyPressed( KeyEvent keyEvent ) { } 
    public void keyReleased( KeyEvent keyEvent ) { } 
 
  }; 
 
  protected void getKeyTyped( KeyEvent eventKey ) 
  { 
    char accumulate = eventKey.getKeyChar(); 
    System.out.println( accumulate ); 
    reloadSearch( "SELECT * FROM tblNames WHERE Names LIKE '"+accumulate+"%"+"' " ); 
  } 
 
  protected void reloadSearch() 
  { 
    searchScroller.getViewport().remove( searchTable ); 
    searchTable = createSearchTable(); 
    searchScroller.getViewport().add( searchTable ); 
  } 
 
  protected void reloadSearch( String namesQuery ) 
  { 
    queryName = namesQuery; 
    searchScroller.getViewport().remove( searchTable ); 
    searchTable = createSearchTable(); 
    searchScroller.getViewport().add( searchTable ); 
  } 
 

  public static void main( String[] args ) 
  { 
    MySearch app = new MySearch(); 
    app.setDefaultCloseOperation( JFrame.EXIT_ON_CLOSE ); 
  } 
} 

[Ulf Dittmer]

Welcome to JavaRanch.

I'm not sure what this has to do with JDBC (which is what this forum is all about), but if you want to accumulate the characters typed, something like this might do the trick:

String accumulate = "";
 
protected void getKeyTyped (KeyEvent eventKey) { 
    accumulate += ("" + eventKey.getKeyChar());
    System.out.println( accumulate );

Note that this doesn't handle the case where the user presses backspace, where you'd need to remove characters from the accumulated string. You'd also need to think about what should happen if the arrow keys or the mouse are used to position the insert cursor to someplace other than the very end of the input field.

[Jorah Espa�ol]

hi sir!!! it worked... wooohoooooo thanks for your reply... woohooooo I don't regret I joined this forum.. I hope I would learn lots from you thank you sooooooooooo much..

[Jeanne Boyarsky]

Jorah,
Welcome to JavaRanch!

Since this isn't about JDBC, I'm going to move it to our GUI forum.

[Jorah Espa�ol]

it's ok sir! sorry about posting in the wrong thread...

I still have a problem ... how can I make the string null again after I searched the record? coz it continues on adding all the characters I'm typing

[Jorah Espa�ol]

nevermind!! I just fixed the problem.. thanks