My Problem With Jtable

[ahmed17]

hi,
i have problem with jtable to display data from db into table and here's the code that diplay data in console so what is the update on code to display data in jtable

import java.sql.*;

public class JdbCgetConnection2{

  public JdbCgetConnection2(){
     getConnection();
     System.out.println("Connection establish");
     System.out.println("---------------------");
  }


  public static void main(String []args){
   new JdbCgetConnection2();

   ResultSet allInfo = null;
   try{
   allInfo = getAllInformation();


   while(allInfo.next()){
   String s = allInfo.getString("id1");
   String s1 = allInfo.getString("name");

   System.out.print(s+"\t");
   System.out.print(s1+"\t");
   System.out.println();

   }//end of while stmt
   }//end of try stmt

   catch(Exception e){
	   System.out.print("no");

   }//end of catch stmt





   }


  //get Connection
  private static Connection getConnection()
		{
		Connection con = null;
		try
		{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		String url = "jdbc:odbc:db1";
		con = DriverManager.getConnection(url);
		}
		catch (ClassNotFoundException e)
		{
		System.out.println(e.getMessage());
		System.exit(0);
		}
		catch (SQLException e)
		{
		System.out.println(e.getMessage());
		System.exit(0);
		}
		return con;
		}


 //get all Information from table
 private static ResultSet getAllInformation()
		{
		Connection con = getConnection();
		try
		{
		Statement s = con.createStatement();
		String select = "Select id1,name "+"from Tb_Info";
		ResultSet rows;
		rows = s.executeQuery(select);
		return rows;
		}
		catch (SQLException e)
		{
		System.out.println(e.getMessage()+"error here");
		}
		return null;
		}


}

[dlorde]

Data for JTable is held in a TableModel. You should create a TableModel for your data (subclass AbstractTableModel) and add it to the table.

See How To Use Tables and Creating A Table Model.

Today, most software exists, not to solve a problem, but to interface with other software...
I.O. Angell

[ahmed17]

can u give me simple update on the previous code?

[dlorde]

can u give me simple update on the previous code?

No. Why would we write your code for you? If you want to learn, follow the tutorial. If you get stuck, or don't understand something, ask and we'll try to help you.

Teachers open the door, but you must enter by yourself...
Chinese proverb.

[ahmed17]

thanks for you, but i will say to you why i want simple example , first i spend 5 days in this problem , i take object from jtable and take row in array and pass array with array of column name to the constructor of jtable but not work and i do the same idea before with jtable to test how jtable work and i do the following , make 2 array one array strore not from db but in array itself and another stroe coulmn name so it work and in this case not work so wat is the problem ?

[dlorde]

I can't tell what your problem is from that garbled description. I suggest you follow the tutorial and get one of the tutorial examples working, then you can modify it for your own requirements.

If you want help on something specific, post up the relevant code and the full text and stack trace of any error messages, and explain what the code was trying to do, what the expected result was, and what happened. Saying your code 'did not work' is just a waste of time without the details above.

They know enough who know how to learn...
J. Adams

[ProgramThis]

Wow, I think that is the longest run-on sentence in the history of man.