When I press the "show" button it does not show any table and error

In summary, the conversation is about debugging code and the importance of learning how to do it. The speaker asks what tools are being used for debugging and suggests using a debugger or adding print statements to track the code's progress.
  • #1
Suxil_7
1
0
I need help. When I press show button it does not show any table and error.
Here is the code:
Java:
package Demo;

import java.awt.EventQueue;

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import javax.swing.table.DefaultTableModel;
import javax.swing.JTable;
import javax.swing.JScrollPane;
import javax.swing.JButton;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.awt.event.ActionEvent;

@SuppressWarnings("serial")
public class Datatable extends JFrame {

    private JPanel contentPane;
    private JTable table;

    /**
     * Launch the application.
     */
    public static void main(String[] args) {
        EventQueue.invokeLater(new Runnable() {
            public void run() {
                try {
                    Datatable frame = new Datatable();
                    frame.setVisible(true);
                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
        });
    }

    /**
     * Create the frame.
     */
    public Datatable() {
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        setBounds(100, 100, 450, 300);
        contentPane = new JPanel();
        contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));

        setContentPane(contentPane);
        contentPane.setLayout(null);
      
        JScrollPane scrollPane = new JScrollPane();
        scrollPane.setBounds(235, 172, -177, -125);
        contentPane.add(scrollPane);
      
        table = new JTable();
        scrollPane.setViewportView(table);
      
        JButton btnNewButton = new JButton("Show");
        btnNewButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                try {
                    Class.forName("com.mysql.cj.jdbc.Driver");
                    Connection con =DriverManager.getConnection("jdbc:mysql://localhost:3306/mybd","root","");
                    Statement st = con.createStatement();
                    String query = "Select * from student";
                    ResultSet rs =st.executeQuery(query);
                    ResultSetMetaData rsmd=rs.getMetaData();
                    DefaultTableModel model =(DefaultTableModel)table.getModel();
                    int cols =rsmd.getColumnCount();
                    String [] colName = new String[cols];
                    for(int i =0; i<cols;i++) {
                        colName[ i] =rsmd.getColumnName(i+1);
                        model.setColumnIdentifiers(colName);
                        String id,name,course;
                        while(rs.next()) {
                            id= rs.getString(1);
                            name= rs.getString(2);
                            course= rs.getString(3);
                           
                            String[] row = {id,name,course};
                            model.addRow(row);
                        }
                    //    rs.close();
                        //st.close();
                //con.close();
                       
                    }
                } catch (ClassNotFoundException | SQLException e1) {
                    // TODO Auto-generated catch block
                    e1.printStackTrace();
                }
           
            }
        });
        btnNewButton.setBounds(326, 69, 85, 21);
        contentPane.add(btnNewButton);
    }
}
 
Last edited by a moderator:
Technology news on Phys.org
  • #2
One of the most important things to learn in programming anything is how to debug your code. What are you using to debug? Are you running it in a debugger where you can step through the code? Have you tried to place prints or display messages at key locations to see what is happening?
 
  • Like
Likes Mark44, jedishrfu, berkeman and 1 other person

FAQ: When I press the "show" button it does not show any table and error

Why is the table not showing when I press the "show" button?

There could be several reasons why the table is not showing when you press the "show" button. It could be due to a coding error in the JavaScript function that is supposed to display the table, or there may be an issue with the HTML markup of the table itself.

How can I troubleshoot the error and fix the issue?

To troubleshoot the error and fix the issue, you can start by checking the JavaScript console in your browser for any error messages that may provide clues as to what is going wrong. You can also review the code for the "show" button and the table display function to ensure they are working correctly.

Could the issue be related to the data being displayed in the table?

Yes, the issue could potentially be related to the data being displayed in the table. If there is a problem with the data itself, such as missing or incorrect values, it could prevent the table from being displayed properly when the "show" button is pressed.

Is it possible that the table is being hidden or styled in a way that makes it invisible?

It is possible that the table is being hidden or styled in a way that makes it invisible when the "show" button is pressed. Check the CSS styles applied to the table to ensure that it is not being hidden or obscured by other elements on the page.

What steps can I take to prevent this issue from happening in the future?

To prevent this issue from happening in the future, make sure to thoroughly test the functionality of the "show" button and the table display function before deploying your code. Additionally, consider implementing error handling and validation to catch any issues that may arise when displaying the table.

Similar threads

Replies
2
Views
5K
Replies
5
Views
2K
Replies
2
Views
2K
Replies
1
Views
1K
Replies
2
Views
2K
Replies
2
Views
3K
Back
Top