Vivek Moyal

Hello I want to make a barcode generator and a reader in java so how i can make it .

Hello no ans from 3 days please help me in this application

I got the whole record but now the problem is this that one database row is in one column another is in another column

like this

FirstName LastName Address
Jhon,Doug Pheliipe,Marsh Katie,Price

Getting the whole record but one record is in one column and another is in another column record is whole but it is not distributed according to the columns

If I use this code i got nothing
while (rs.next()) { record = new String[ColCount]; for (int i = 0; i < ColCount; i++) { record[i] = rs.getString(i); //System.out.println(record); } records.add(record); System.out.println(records); list=Arrays.asList(records); }

And if I use this code

while (rs.next()) { record = new String[ColCount]; for (int i = 0; i < ColCount; i++) { record[i] = rs.getString(i+1); //System.out.println(record); } records.add(record); System.out.println(records); list=Arrays.asList(records); }

I got this
[[Ljava.lang.String;@1bf216a]
[[Ljava.lang.String;@1bf216a, [Ljava.lang.String;@12ac982]
[[Ljava.lang.String;@1bf216a, [Ljava.lang.String;@12ac982, [Ljava.lang.String;@1389e4]
[[Ljava.lang.String;@1bf216a, [Ljava.lang.String;@12ac982, [Ljava.lang.String;@1389e4, [Ljava.lang.String;@c20e24]
[[Ljava.lang.String;@1bf216a, [Ljava.lang.String;@12ac982, [Ljava.lang.String;@1389e4, [Ljava.lang.String;@c20e24, [Ljava.lang.String;@2e7263]
[[Ljava.lang.String;@1bf216a, [Ljava.lang.String;@12ac982, [Ljava.lang.String;@1389e4, [Ljava.lang.String;@c20e24, [Ljava.lang.String;@2e7263, [Ljava.lang.String;@157f0dc]


At last if I use this code than i will get the last record
while (rs.next()) { record = new String[ColCount]; for (int i = 0; i < ColCount; i++) { record[i] = rs.getString(i+1); //System.out.println(record); } //records.add(record); //System.out.println(records); list=Arrays.asList(record); }

You are saying that my database code is ok and in different thread of swing everyone is said that the code is ok so please tell me where is the problem than

You are saying that my Swing code is ok and in different thread of JDBC everyone is said that the code is ok so please tell me where is the problem than

thank you

if it is possible to open the cdrom without pushing the button than it is also possible to on the cpu without pushing the button because restart is also work without the pushing so how I can do this

I have done my codeing and when i run it it shows only last record so please help my database code is this
public ArrayList<String[]> records=new ArrayList<String[]>(); while (rs.next()) { for (int i = 0; i < ColCount; i++) { record = new String[ColCount]; record[i] = rs.getString(i+1); records.add(record); } System.out.println(list); list=Arrays.asList(records); }

My Gui code is this
headers=new BookDatabase().headers; record=new BookDatabase().list; Vector v=new Vector(record); tmodel=new DefaultTableModel(); tmodel.setColumnIdentifiers(headers); tmodel.setRowCount(0); tmodel.addRow(v); jt=MacWidgetFactory.createITunesTable(tmodel); jt.setFillsViewportHeight(true); tableScrollPane=new JScrollPane(jt); tableScrollPane=IAppWidgetFactory.createScrollPaneWithButtonsTogether(jt, vertical, horizontal); jt.setAutoCreateRowSorter(true); TableUtils.SortDelegate sortDelegate = new TableUtils.SortDelegate() { public void sort(int columnModelIndex, TableUtils.SortDirection sortDirection) { } }; TableUtils.makeSortable(jt, sortDelegate);

Sorry sir you take it in a wrong sence because if you see above than I have done with my code and still having the same problem so that at last I have said this I dont want to give you an order i just need your help to complete this because i have same problem what I have on the first day when I have created this topic

so if you want to see the code than you can see it above so now please help me

Sir it will b good if you will write the code that how i will get the whole list in Jtable because i have to submit my assignment because right now i can't wait for more testing and disscussion

[Ljava.lang.String;@1027b4d
[Ljava.lang.String;@1ed2ae8
[Ljava.lang.String;@19c26f5
[Ljava.lang.String;@c1b531
[Ljava.lang.String;@15eb0a9
[Ljava.lang.String;@1a05308

by using your example
Now i am getting only this and table is also showing this not the records

Not getting the whole list just getting the last row and also getting records like that

[Ljava.lang.String;@1bf216a
[Ljava.lang.String;@12ac982
[Ljava.lang.String;@1389e4
[Ljava.lang.String;@c20e24
[Ljava.lang.String;@2e7263
[Ljava.lang.String;@157f0dc
[Ljava.lang.String;@863399
[Ljava.lang.String;@a59698
[Ljava.lang.String;@141d683
[Ljava.lang.String;@16a55fa
[Ljava.lang.String;@32c41a
[Ljava.lang.String;@e89b94
[Ljava.lang.String;@13e205f
[Ljava.lang.String;@1bf73fa
[Ljava.lang.String;@5740bb
[Ljava.lang.String;@5ac072
[Ljava.lang.String;@109a4c
[Ljava.lang.String;@201f9
[Ljava.lang.String;@1cf8583
[Ljava.lang.String;@14693c7
[Ljava.lang.String;@901887
[Ljava.lang.String;@3a6727
[Ljava.lang.String;@4a65e0
[Ljava.lang.String;@665753
[Ljava.lang.String;@ef22f8
[Ljava.lang.String;@1e0cf70
[Ljava.lang.String;@52fe85
[Ljava.lang.String;@c40c80
[Ljava.lang.String;@110d81b
[Ljava.lang.String;@dbe178
[Ljava.lang.String;@1af9e22
[Ljava.lang.String;@b6ece5
[Ljava.lang.String;@17ace8d
[Ljava.lang.String;@18eb9e6
[Ljava.lang.String;@14ed9ff
[Ljava.lang.String;@1ca318a
[Ljava.lang.String;@17a8913
[Ljava.lang.String;@1bd747e
[Ljava.lang.String;@12b3374
[Ljava.lang.String;@13f3789
[Ljava.lang.String;@1571886
[Ljava.lang.String;@10b4199
[Ljava.lang.String;@1ffb8dc
[Ljava.lang.String;@1c184f4
[Ljava.lang.String;@1ffbd68
[Ljava.lang.String;@ec16a4
[Ljava.lang.String;@1c29ab2
[Ljava.lang.String;@13a328f
[Ljava.lang.String;@1cd8669
[Ljava.lang.String;@337838
[Ljava.lang.String;@119cca4
[Ljava.lang.String;@ca2dce
[Ljava.lang.String;@18558d2
[Ljava.lang.String;@18a47e0
[Ljava.lang.String;@174cc1f
[Ljava.lang.String;@1050e1f
[Ljava.lang.String;@e24e2a
[Ljava.lang.String;@179c285
[Ljava.lang.String;@d1e604
[Ljava.lang.String;@54172f

I am new to Jtable its my first time so having difficulties now i have tried to get the list in ArrayList and Vector but still have the same problem
I am using Vector because it is directly accessible to DefaultTableModel.addRow()


public Vector<String[]> records=new Vector<String[]>(); while (rs.next()) { for (int i = 0; i < ColCount; i++) { record = new String[ColCount]; record[i] = rs.getString(i+1); records.add(record); System.out.println(record); } }

I am getting last record only in the jtable my code is here
public class BookDatabase { URL databasePath=getClass().getResource("src/book/Database/ContactBook.mdb"); String databaseName="jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=src/book/Database/ContactBook.mdb;",Driver="sun.jdbc.odbc.JdbcOdbcDriver"; Connection con; ResultSet rs; Statement st; public Object record[]; String a,b,c,d,e,f,g,h,i,j; ResultSetMetaData rsmd; int ColCount; public String[] headers; public String abc; public java.util.List list; public BookDatabase() { try { System.out.println("Loading driver"); Class.forName(Driver); System.out.println("Driver loaded"); System.out.println("Connecting......"); con=DriverManager.getConnection(databaseName); System.out.println("Connection Establised"); st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); rs=st.executeQuery("select * from Book"); System.out.println("Execute"); rsmd=rs.getMetaData(); ColCount=rsmd.getColumnCount(); record = new String[ColCount]; headers = new String[ColCount]; for (int h = 1; h <= ColCount; h++) { headers[h - 1] = rsmd.getColumnName(h); } while (rs.next()) { for (int i = 0; i < ColCount; i++) { record[i] = rs.getString(i+1); System.out.println(record); } } list=Arrays.asList(record); } catch (ClassNotFoundException e) {} catch (SQLException e) {} }

When i put this list in my table model
headers=new BookDatabase().headers; record=new BookDatabase().list; Vector v=new Vector(record); tmodel=new DefaultTableModel(); tmodel.setColumnIdentifiers(headers); tmodel.setRowCount(0); tmodel.addRow(v); jt=MacWidgetFactory.createITunesTable(tmodel);

it shows the last record of the database