I am working on form which fetches data from database. Now I want to add JButton
open for each fetched record i.e. the button later will open the record. But I got problem that button is not shown in table. I want to add button as a column to each record in table. Thanks in advance.
package addPanel;
import java.sql.*;
import javax.swing.*;
import javax.swing.table.*;
public class panelShowData extends JPanel
{
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
String url = "jdbc:mysql://localhost:3306/records";
String driver = "com.mysql.jdbc.Driver";
String userName = "root";
String password = "";
JScrollPane scrollPane;
JTable table;
DefaultTableModel tableModel;
String nameSearch="";
public panelShowData()
{
this.setLayout(null);
setVisible(true);
setBounds(0, 200, 500, 450);
}
public void searchData( String nameSearch)
{
tableModel = new DefaultTableModel();
try
{
Class.forName( driver ).newInstance( );
connection = DriverManager.getConnection( url, userName, password );
statement = connection.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE );
resultSet = statement.executeQuery( "select * from registration where firstname ='"
+ nameSearch
+ "'or lastname ='"
+ nameSearch + "'" );
System.out.println( "Query executed" );
System.out.println( "nameSearch="+nameSearch );
String firstName;
String lastName;
int id;
//JButton add=new JButton("ADD");
while ( resultSet.next( ) )
{
System.out.print( resultSet.getString( 2 ) + " " );
System.out.print( resultSet.getString( 4 ) + "
" );
firstName = resultSet.getString( 2 );
lastName = resultSet.getString( 4 );
id = resultSet.getInt(1);
String[ ] columnName = { "Id","First Name", "Last Name","" };
Object[ ] data = { id, ""+firstName, "" + lastName, "add" };
System.out.println("Names is:"+firstName);
tableModel.setColumnIdentifiers( columnName );
tableModel.addRow( data );
tableModel.fireTableDataChanged();
}
table = new JTable( tableModel );
table.setEnabled(false);
scrollPane = new JScrollPane( table );
scrollPane.setBounds( 20, 20, 350, 100 );
scrollPane.revalidate();
scrollPane.repaint();
add( scrollPane );
connection.close( );
}
catch (Exception e)
{
e.printStackTrace();
JOptionPane.showMessageDialog( null, "Record Not Found",
"Sorry", JOptionPane.ERROR_MESSAGE );
}
}
}
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…