qsearch.java

Quick searching of files from the database

package ae;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.io.*;


public class qsearch extends JFrame
{

  JLabel lblsearch, lblresult;
  JTextField txtsearch;
  JButton btnsearch, btnexit;
  JTextArea txtresult;
  Container cp;
  JScrollPane jsp;
  File f;
  String fname;
  Connection con;
  Statement stmt;
  ResultSet rs;
  JComboBox jcb;
 

public qsearch()
{
    setSize(800,500);
    setTitle("Quick Search");
    
    lblsearch = new JLabel("File Name:");
    lblresult = new JLabel("Result:");

    txtsearch = new JTextField(40);

    btnsearch = new JButton("Search");
    
    btnexit = new JButton("Exit");

    jcb = new JComboBox();

    jcb.addItem("By File Name");
    jcb.addItem("by Extension");



try {
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");    
   File f = new File("filelog.mdb");
   String fname= f.getAbsolutePath();
   System.out.println(fname);
   con = DriverManager.getConnection("Jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+fname,"","");
   stmt = con.createStatement();

  }
    catch(Exception e)
     {
	System.out.println(e);
     }

    


    txtsearch.addKeyListener(new KeyAdapter(){
      public void keyReleased(KeyEvent ke){

       txtresult.setText("");
      
        try
        {

         if(jcb.getSelectedIndex()==0)
         {
	  rs = stmt.executeQuery("select * from details where fname like '"+ txtsearch.getText() +"%'");
	  }
           else
             {
	 rs = stmt.executeQuery("select * from details where fext like '"+ txtsearch.getText() +"%'");

             

         }

	  
	  while(rs.next())
	  {

           txtresult.append(rs.getString("fpath").replace("|","'") +"\n");

          }
          

          //txtresult.setText(txtsearch.getText());
        }
        catch(Exception e){System.out.println("invalid key");}
      }
    });


   
   

    txtresult = new JTextArea(10,20);

    jsp = new JScrollPane(txtresult);

    cp = getContentPane();

    cp.setLayout(null);

    cp.add(lblsearch);
    cp.add(txtsearch);
    cp.add(btnexit);
    cp.add(jcb);
    
    cp.add(jsp);

    lblsearch.setBounds(10,10,70,20);
    txtsearch.setBounds(85,10,230,20);
    jcb.setBounds(325,10,100,20);
   
    jsp.setBounds(10,40,780,410);

    

  }



public static void main(String args[])
{
  
   qsearch qs = new qsearch();
   qs.show();
}

}