search data from textfield

[mcajavaprogramer]

how to search data from database using jtextfield and display it in jtable..?

[DarrylBurke]

Don't double post the same question, don't wake old dead threads and don't hijack another poster's thread with an unrelated question. The post you made in JTable vs JTextField - which to use for creating "Search" screen has been removed.

db

[DarrylBurke]

That's a very broad question. You need to break that into several steps and tell us which you know and which you don't know how to do.

db

[mcajavaprogramer]

I know about the jtable to display the data ....
but want to try for textbox....

for example : if i write a sting in text box : like a name..
the it display all the record in jtable for a particular name......

[DarrylBurke]

What's a text box?

db

[mcajavaprogramer]

What's a text box?

db

Ohhh Sorry I Mean JTextField..

[DarrylBurke]

Do you know how to retrieve the text from a JTextField as a String?

If you don't break this into several steps and tell us which step(s) you need help with, this is going to take forever.

db

[mcajavaprogramer]

Do you know how to retrieve the text from a JTextField as a String?

If you don't break this into several steps and tell us which step(s) you need help with, this is going to take forever.

db

is it like this...?

// to string
String text = textField.getText();

// to JTextField
textField.setText(text);

[DarrylBurke]

So, what's the next step?

db

[Tolls]

So show us the JDBC code then.
Please don't make this the equivalent of getting blood from a stone.
You want help?
We need information.

[mcajavaprogramer]

db

Hey I m done it...

Hello Friends I m creating one textfield and retrive data from that textfield and display it in JTable.
This is the code for it....

import java.awt.*;
import java.sql.*;
import java.util.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.table.*;

public class Search {

public static void main(String[] args)
{
final Vector columnNames = new Vector();
final Vector data = new Vector();

final JTextField t=new JTextField(20);
JButton b = new JButton("Search");

JPanel p=new JPanel( new GridLayout(2,2));
p.add(t);
p.add(b);

JFrame f = new JFrame();
f.getContentPane().add(p);
f.setVisible(true);

b.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:person");
String sql = "select * from person where name='"+t.getText()+"'";
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery( sql );
ResultSetMetaData md = rs.getMetaData();

int columns = md.getColumnCount();

for (int i = 1; i <= columns; i++)
{

columnNames.addElement( md.getColumnName(i) );
}
while (rs.next())
{
Vector row = new Vector(columns);
for (int i = 1; i <= columns; i++){
row.addElement( rs.getObject(i) );
}
data.addElement( row );
}
rs.close();
stmt.close();
}
catch(Exception ex){
System.out.println(ex);
}

JTable table = new JTable(data, columnNames);
TableColumn col;

for (int i = 0; i < table.getColumnCount(); i--)
{
col = table.getColumnModel().getColumn(i);
col.setMaxWidth(250);
}

JScrollPane scrollPane = new JScrollPane( table );

JFrame f1=new JFrame();
f1.add( scrollPane );
f1.setSize(600,400);
f1.setVisible(true);
} });
}
}


------------------------------------------------

Note : Here In the above code
Database Name = person
Table Name = person.


Thanx Friends
McaJavaProgramer.

[DarrylBurke]

Forum Rules
Guide For New Members
BB Code List - Java Programming Forum

db

[mcajavaprogramer]