Geoffrey Laurens

Greenhorn

+ Follow

news 26 Posts 11 Threads

since Sep 19, 2006

Merit badge: grant badges

For More

Cows and Likes

Cows

Total received

In last 30 days

Forums and Threads

Recent posts by Geoffrey Laurens

Fill JTable from database with SwingWorker

I Have already found the solutions

10 years ago

Swing / AWT / SWT

Fill JTable from database with SwingWorker

Why this code is not working/my JTable won't updated after i click the button

import java.awt.Component;
import java.awt.Dimension;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Date;
import java.util.List;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.SwingWorker;
import javax.swing.table.AbstractTableModel;
import javax.swing.table.DefaultTableCellRenderer;
import javax.swing.table.TableCellRenderer;
import javax.swing.table.TableColumn;
public class TestTableLoad01 {
static MyTableModel model;
static JTable table;
static ResultSet rs;
JFrame frame;
TableSwingWorker worker;
public static void main(String[] args) {
new TestTableLoad01();
}
public TestTableLoad01() {
try {
frame = new JFrame("Testing");
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
table = new JTable(model){
public Component prepareRenderer(TableCellRenderer renderer,
int row, int column) {
Component component = super.prepareRenderer(renderer, row,
column);
int rendererWidth = component.getPreferredSize().width;
TableColumn tableColumn = getColumnModel().getColumn(column);
tableColumn.setPreferredWidth(Math.max(rendererWidth
+ getIntercellSpacing().width,
tableColumn.getPreferredWidth()));
return component;
}
};
table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
table.setDefaultRenderer(Date.class, new TimeCellRenderer());
JButton btnQuery = new JButton("Query");
btnQuery.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
try {
Connection conn = null;
Statement stmt = null;
conn = AS400ConnectionUtils.getConnection();
stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT * FROM XXX.TFMISNG");
ResultSetMetaData meta = rs.getMetaData();
int colCount = meta.getColumnCount();
String[] headers = new String[colCount];
for (int h = 1; h <= colCount; h++) {
headers[h - 1] = meta.getColumnName(h);
}
model = new MyTableModel();
model.setColumnNames(headers);
frame.repaint();
worker = new TableSwingWorker(model, rs);
worker.execute();
} catch (Exception ex) {
}
}
});
JPanel mainPanel = new JPanel();
mainPanel.setLayout(new GridBagLayout());
GridBagConstraints gridStatus1 = new GridBagConstraints();
gridStatus1.gridx = 0;
gridStatus1.gridy = 0;
gridStatus1.gridwidth = 1;
gridStatus1.gridheight = 1;
gridStatus1.anchor = GridBagConstraints.WEST;
gridStatus1.fill = GridBagConstraints.BOTH;
gridStatus1.weightx = 1.0;
gridStatus1.weighty = 4.0;
mainPanel.add(new JScrollPane(table), gridStatus1);
gridStatus1.gridy = 1;
gridStatus1.weighty = 0.3;
mainPanel.add(btnQuery, gridStatus1);
frame.getContentPane().add(mainPanel);
frame.pack();
frame.setLocationRelativeTo(null);
frame.setPreferredSize(new Dimension(400, 200));
frame.setVisible(true);
} catch (Exception ex) {
ex.printStackTrace();
}
}
public class TimeCellRenderer extends DefaultTableCellRenderer {
private DateFormat df;
public TimeCellRenderer() {
df = new SimpleDateFormat("HH:mm:ss");
}
@Override
public Component getTableCellRendererComponent(JTable table, Object value, boolean isSelected, boolean hasFocus, int row, int column) {
if (value instanceof Date) {
value = df.format(value);
}
super.getTableCellRendererComponent(table, value, isSelected, hasFocus, row, column);
return this;
}
}
public class MyTableModel extends AbstractTableModel {
List<List><Object>> result = new ArrayList<List><Object>>();
private String[] columnNames;
public MyTableModel() {
}
public void setColumnNames(String[] headers) {
columnNames = headers;
}
@Override
public Class<?> getColumnClass(int columnIndex) {
return columnIndex == 0 ? Date.class : Integer.class;
}
@Override
public String getColumnName(int col) {
return columnNames[col];
}
@Override
public int getColumnCount() {
return columnNames.length;
}
@Override
public int getRowCount() {
return result.size();
}
@Override
public Object getValueAt(int row, int col) {
return ((List) result.get(row)).get(col);
}
public void addRow(List<Object> value) {
int rowCount = getRowCount();
result.add(value);
fireTableRowsInserted(rowCount, rowCount);
}
public void addRows(List<Object>... value) {
addRows(Arrays.asList(value));
}
private void addRows(List<List><Object>> rows) {
int rowCount = getRowCount();
result.addAll(rows);
fireTableRowsInserted(rowCount, getRowCount() - 1);
}
}
public class TableSwingWorker extends SwingWorker<MyTableModel, List><Object>> {
private final MyTableModel tableModel;
private ResultSet rs;
public TableSwingWorker(MyTableModel tableModel, ResultSet rs) {
this.tableModel = tableModel;
this.rs = rs;
}
@Override
protected MyTableModel doInBackground() throws Exception {
// This is a deliberate pause to allow the UI time to render
Thread.sleep(200);
System.out.println("Start polulating");
int rownum = 0;
int curCol = 0;
int colCount = tableModel.getColumnCount();
while (rs.next()) {
List<Object> row = new ArrayList<Object>(colCount); // new list per row
int i = 1;
while (i <= colCount) { // don't skip the last column, use <=
curCol = i++;
row.add(rs.getObject(curCol));
// }
}
publish(row);
}
return tableModel;
}
@Override
protected void process(List<List><Object>> chunks) {
System.out.println("Adding " + chunks.size() + " rows");
tableModel.addRows(chunks);
}
}
}

But this code is working, but it fill on startup not when click button.

import java.awt.Component;
import java.awt.Dimension;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Date;
import java.util.List;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.SwingWorker;
import javax.swing.table.AbstractTableModel;
import javax.swing.table.DefaultTableCellRenderer;
import javax.swing.table.TableCellRenderer;
import javax.swing.table.TableColumn;
public class TestTableLoad01 {
static MyTableModel model;
static JTable table;
static ResultSet rs;
JFrame frame;
public static void main(String[] args) {
new TestTableLoad01();
}
public TestTableLoad01() {
try {
frame = new JFrame("Testing");
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
Connection conn = null;
Statement stmt = null;
conn = AS400ConnectionUtils.getConnection();
stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT * FROM XXX.TFMISNG");
ResultSetMetaData meta = rs.getMetaData();
int colCount = meta.getColumnCount();
String[] headers = new String[colCount];
for (int h = 1; h <= colCount; h++) {
headers[h - 1] = meta.getColumnName(h);
}
model = new MyTableModel(headers);
table = new JTable(model){
public Component prepareRenderer(TableCellRenderer renderer,
int row, int column) {
Component component = super.prepareRenderer(renderer, row,
column);
int rendererWidth = component.getPreferredSize().width;
TableColumn tableColumn = getColumnModel().getColumn(column);
tableColumn.setPreferredWidth(Math.max(rendererWidth
+ getIntercellSpacing().width,
tableColumn.getPreferredWidth()));
return component;
}
};
table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
table.setDefaultRenderer(Date.class, new TimeCellRenderer());
JPanel mainPanel = new JPanel();
mainPanel.setLayout(new GridBagLayout());
GridBagConstraints gridStatus1 = new GridBagConstraints();
gridStatus1.gridx = 0;
gridStatus1.gridy = 0;
gridStatus1.gridwidth = 1;
gridStatus1.gridheight = 1;
gridStatus1.anchor = GridBagConstraints.WEST;
gridStatus1.fill = GridBagConstraints.BOTH;
gridStatus1.weightx = 1.0;
gridStatus1.weighty = 4.0;
mainPanel.add(new JScrollPane(table), gridStatus1);
gridStatus1.gridy = 1;
gridStatus1.weighty = 0.3;
frame.getContentPane().add(mainPanel);
frame.pack();
frame.setLocationRelativeTo(null);
frame.setPreferredSize(new Dimension(400, 200));
frame.setVisible(true);
TableSwingWorker worker = new TableSwingWorker(model, rs);
worker.execute();
} catch (Exception ex) {
ex.printStackTrace();
}
}
public class TimeCellRenderer extends DefaultTableCellRenderer {
private DateFormat df;
public TimeCellRenderer() {
df = new SimpleDateFormat("HH:mm:ss");
}
@Override
public Component getTableCellRendererComponent(JTable table, Object value, boolean isSelected, boolean hasFocus, int row, int column) {
if (value instanceof Date) {
value = df.format(value);
}
super.getTableCellRendererComponent(table, value, isSelected, hasFocus, row, column);
return this;
}
}
public class MyTableModel extends AbstractTableModel {
List<List><Object>> result = new ArrayList<List><Object>>();
private String[] columnNames;
public MyTableModel(String[] headers) {
columnNames = headers;
}
@Override
public Class<?> getColumnClass(int columnIndex) {
return columnIndex == 0 ? Date.class : Integer.class;
}
@Override
public String getColumnName(int col) {
return columnNames[col];
}
@Override
public int getColumnCount() {
return columnNames.length;
}
@Override
public int getRowCount() {
return result.size();
}
@Override
public Object getValueAt(int row, int col) {
return ((List) result.get(row)).get(col);
}
public void addRow(List<Object> value) {
int rowCount = getRowCount();
result.add(value);
fireTableRowsInserted(rowCount, rowCount);
}
public void addRows(List<Object>... value) {
addRows(Arrays.asList(value));
}
private void addRows(List<List><Object>> rows) {
int rowCount = getRowCount();
result.addAll(rows);
fireTableRowsInserted(rowCount, getRowCount() - 1);
}
}
public class TableSwingWorker extends SwingWorker<MyTableModel, List><Object>> {
private final MyTableModel tableModel;
private ResultSet rs;
public TableSwingWorker(MyTableModel tableModel, ResultSet rs) {
this.tableModel = tableModel;
this.rs = rs;
}
@Override
protected MyTableModel doInBackground() throws Exception {
// This is a deliberate pause to allow the UI time to render
Thread.sleep(200);
System.out.println("Start polulating");
int rownum = 0;
int curCol = 0;
int colCount = tableModel.getColumnCount();
while (rs.next()) {
List<Object> row = new ArrayList<Object>(colCount); // new list per row
int i = 1;
while (i <= colCount) { // don't skip the last column, use <=
curCol = i++;
row.add(rs.getObject(curCol));
// }
}
publish(row);
}
return tableModel;
}
@Override
protected void process(List<List><Object>> chunks) {
System.out.println("Adding " + chunks.size() + " rows");
tableModel.addRows(chunks);
}
}
}

Can anyone help me to fix my code? thanks.

10 years ago

Swing / AWT / SWT

JMX+RMI+GlassFish (Older Thread was in Beginner)

Hai Java Master,

Can anyone help me with JMX+RMI+GlassFish. Where should i start first? can anyone give me a tutorial/step by step simple example? Thanks Befor....

Regards

Geoffrey

16 years ago

Java in General

JMX+RMI+GlassFish

Hai Java Master,

Can anyone help me with JMX+RMI+GlassFish. Where should i start first? can anyone give me a tutorial/step by step simple example? Thanks Befor....

Regards

Geoffrey

16 years ago

Distributed Java

Deploy Spring+Struts+GlassFish

Hello Java Master,

i'm new using GlassFish. this is my first time using GlassFish. Before Using glassfish, i deploy my application using Tomcat 6. Now i'm trying to change it using glassfish. With Tomcat 6 there is no problem. i put all my applicationContext.xml in WEB-INF/classes. but in GlassFish my applicationContext wouldn't be loaded by glassfish, even when i put my applicationContext.xml in WEB-INF/classes. so when i'm trying to call some beanId, then error message appear, said than there is No Bean Name "xxxxx". Is there something that i miss?

i load the applicationContext using this code :

i use "applicationContext-*.xml" because i have more than 1 applicationContext. in Tomcat 6 there is no problem. but in glassfish the applicationContext wouldn't be loaded.

Thanks Before.

16 years ago

Other Application Frameworks

Deploy Spring+Struts+GlassFish

i load the applicationContext using this code :

i use "applicationContext-*.xml" because i have more than 1 applicationContext. in Tomcat 6 there is no problem. but in glassfish the applicationContext wouldn't be loaded.

Thanks.

16 years ago

Struts

Deploy Spring+Struts+GlassFish

16 years ago

Struts

LOCALE in Spring MVC

Can any body tell me how to change LOCALE with spring MVC? in struts we use this "request.getSession().setAttribute(org.apache.struts.Globals.LOCALE_KEY, new java.util.Locale("en", "US")", can any body tell me?

Thanks

16 years ago

Beginning Java

Dynamic Casting?

thanks for all your reply, it works.........

18 years ago

Beginning Java

Dynamic Casting?

Can anybody(Java Master) help me???

How can i cast an object just by send a string parameter.
example :

and i have and Object tipe of Object.

usually we do this.

But how can i do a dynamic casting???

18 years ago

Beginning Java

What is a Container ???

spring context.... they have 2 application. web application and standallone(this application execute batch) the batch application execute update/insert data from table into temp table every day.... Both application using spring framework they talk about putting 2 appliction into 1 container....??? i don't understand that....

or i may be a i have misunderstanding about the meaning/or about what they are talking about what is that mean??? i'm still learning abount spring framework very hard....

18 years ago

Beginning Java

What is a Container ???

to All Java Master...

Hai, i'm new in java.... i have a question....
sometimes i'll heard people talk about container.....
what is a container exactly? can any body give me a full explanations.... (isn't it a stupid question)

Thanks before

18 years ago

Beginning Java

Transfer value between JFrame

ok Mr. Stan i'll add new subject later. i want to try the model and frame first.

thanks for the suggestion.

18 years ago

Beginning Java

Transfer value between JFrame

No Mr. Stan, your not taking it too literally. In a matter of fact, your clue and suggestion already describe all the things that i want to no.

Can i ask another question hehehehe?

i want to create an example like this (web project) that including java applet in it. the problem is when we run applet on a client, the client must download all the signed jar that included in the applet. (If the project is small it's doesn't matter) but when the project is big is a matter....
because i included all the classes in one jar. so i want to separate all the classes, so the client doesn't had to download to much jar. i want to leave the classes that had dependance with a database and a model in server but the classes that had dependance with a view in a client.....

what i don't know is how can i do it/what should i do?

thanks for all your suggestion

18 years ago

Beginning Java

Transfer value between JFrame

so in another word, i should create a class Model with it's attribute. and create FrameA class that had an attribute type of Model, then when i call FrameB i send a Model refer from FrameA to FrameB, if i change any value Model in FrameB it's also infected Model in FrameA. should i send the Model referance from FrameA into DrameB from constructor or there is another way? hehehehe

18 years ago

Beginning Java