[ghkashyap]

public class TransactionsModel extends DefaultTableModel implements
		ActionListener {
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	JTable table;
	int myColCount;

	// JTextField txtfld;
	// Constructor. This connects to the database retrieves
	// data based on the stored procedure and populates the JTable in TransactionsView

	TransactionsModel() {
	}

	TransactionsModel(JTextField accountnum) {
		// myColCnt stores the columnCount.
		int myColCnt = 0;

		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		ResultSet rs = null;
		Connection con = null;

		try {
			con = DriverManager.getConnection("jdbc:odbc:oracle", "scott",
					"tiger");
		} catch (Exception ignored) {
			System.out.println("Error in getting Connection");
			ignored.printStackTrace();
		}

		try {
			Statement stmt = con.createStatement();
			rs = stmt
					.executeQuery("SELECT * FROM TRANSACTIONS WHERE ACCOUNT_NO='"
							+ accountnum.getText() + "'");
		} catch (Exception ignored) {
		}

		try {
			myColCnt = rs.getMetaData().getColumnCount();
		} catch (SQLException sexcpt) {
			System.out.println("Error in getting column count : "
					+ sexcpt.getMessage());
		}
		try {
			for (int i = 1; i <= myColCnt; i++)

			{
				// System.out.println("entered loop");
				columnIdentifiers.addElement(rs.getMetaData().getColumnName(i));
				// System.out.println("after colidentifiers");
			}
			
		} catch (Exception ignored) {
			System.out.print("Exception caught");
			ignored.printStackTrace();
		}
		
		Vector row = new Vector();
		try {
			while (rs.next()) {
				row = new Vector();
				for (int i = 1; i <= myColCnt; i++) {
					row.addElement(rs.getObject(i));
				}
				
				dataVector.addElement(row);

			}
			
		}

		catch (Exception ignored) {
		}

	}

	public void actionPerformed(ActionEvent ae) {
		
		

	}

}

~edit: code tags PB
*********************
this is the view class which has to display data OF THE JTable.the model is retriving the data but i am facing problem in displaying it. when i print the dataVector its is showing all the retrived values from the table in the DB.but how to display this data is wat that i am concerned about.
please help
thanks in advance...
harish.

This post has been edited by PennyBoki: 08 January 2008 - 11:03 AM

[aliasgon]

ghkashyap, on 8 Jan, 2008 - 12:46 AM, said:

public class TransactionsModel extends DefaultTableModel implements
		ActionListener {
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	JTable table;
	int myColCount;

	// JTextField txtfld;
	// Constructor. This connects to the database retrieves
	// data based on the stored procedure and populates the JTable in TransactionsView

	TransactionsModel() {
	}

	TransactionsModel(JTextField accountnum) {
		// myColCnt stores the columnCount.
		int myColCnt = 0;

		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		ResultSet rs = null;
		Connection con = null;

		try {
			con = DriverManager.getConnection("jdbc:odbc:oracle", "scott",
					"tiger");
		} catch (Exception ignored) {
			System.out.println("Error in getting Connection");
			ignored.printStackTrace();
		}

		try {
			Statement stmt = con.createStatement();
			rs = stmt
					.executeQuery("SELECT * FROM TRANSACTIONS WHERE ACCOUNT_NO='"
							+ accountnum.getText() + "'");
		} catch (Exception ignored) {
		}

		try {
			myColCnt = rs.getMetaData().getColumnCount();
		} catch (SQLException sexcpt) {
			System.out.println("Error in getting column count : "
					+ sexcpt.getMessage());
		}
		try {
			for (int i = 1; i <= myColCnt; i++)

			{
				// System.out.println("entered loop");
				columnIdentifiers.addElement(rs.getMetaData().getColumnName(i));
				// System.out.println("after colidentifiers");
			}
			
		} catch (Exception ignored) {
			System.out.print("Exception caught");
			ignored.printStackTrace();
		}
		
		Vector row = new Vector();
		try {
			while (rs.next()) {
				row = new Vector();
				for (int i = 1; i <= myColCnt; i++) {
					row.addElement(rs.getObject(i));
				}
				
				dataVector.addElement(row);

			}
			
		}

		catch (Exception ignored) {
		}

	}

	public void actionPerformed(ActionEvent ae) {
		
		

	}

}

~edit: code tags PB
*********************
this is the view class which has to display data OF THE JTable.the model is retriving the data but i am facing problem in displaying it. when i print the dataVector its is showing all the retrived values from the table in the DB.but how to display this data is wat that i am concerned about.
please help
thanks in advance...
harish.

 public void searchnow(String cb,String bc) { 
		String string = "SELECT ID,LastName,FirstName,Course,MSince,Status "
				+ "FROM tblPersonal WHERE "
				+cb+  "=" + "'"+bc+"'";
		datacon search = new datacon(); //this I use to connect 2 database
		if (search.db_connection!=null) {
			search.closeConnection(1);
		}
		else {
			search.datacon();
			search.connectToDB();
			search.createStatement(true);
		}
		
		try {
								result = search.db_statement.executeQuery(string);
								 DefaultTableModel dtm = new DefaultTableModel();
								 int ColCnt = result.getMetaData().getColumnCount();

									for (int i = 1; i <= ColCnt; i++)
									{
									 columnIdentifiers.addElement(result.getMetaData().getColumnName(i));
									}
								 Vector row = new Vector();
								 while (result.next()) {
									row = new Vector();
									for (int i = 1; i <= ColCnt; i++) {
									row.addElement(result.getObject(i));
									}
									dataVector.addElement(row);

								 }
								dtm.setDataVector(dataVector, columnIdentifiers);
								new SearchResultForm(dtm).setVisible(true);

							}
							catch (SQLException sqle) {
								JOptionPane.showMessageDialog(null,"Error on SQL "+sqle);
							}
	}//end of searchnow method

dtm.setDataVector(dataVector, columnIdentifiers);
new SearchResultForm(dtm).setVisible(true);

i just use this code to set the new table and pass it to a different form that holds the JTable i already have and set its .setModel to the table "dtm".

the SearchResultForm() accepts a defaulttablemodel, so i just pass "dtm into it.

oh and i set the code nameofjtable.setModel(variable u specify) after the init() if the jtable so it would load immediately the contents.

hope it helps. nways your code helped me a lot. thanks

[m-e-g-a-z]

Why bring a post up from 10 April 2009 ??


If you have any issues/help with your code, we wil be more than happy to help you but in future,
please dont bring up other peoples posts that are a nearly a year old.

This post has been edited by m-e-g-a-z: 03 April 2010 - 07:00 AM

[Dogstopper]

As m-e-g-a-z mentioned, it is a bad habit to post in old topics, even if you may have something to contribute, but this post isn't all that old...just a year. However, I thank you for your contribution.

If you need help, please start your own topic.

[pbl]

As this thread dated from 2008 I'll close it

Just as a comment, YOU DO NOT populate data in a JTable
JTable are just a fancy GUI interface that displays data held by it's model
so you just let the JTable to display the data you want it to display