001.
package
com.java.myapp;
002.
003.
import
java.awt.EventQueue;
004.
import
java.sql.Connection;
005.
import
java.sql.DriverManager;
006.
import
java.sql.ResultSet;
007.
import
java.sql.SQLException;
008.
import
java.sql.Statement;
009.
import
javax.swing.JOptionPane;
010.
import
javax.swing.JFrame;
011.
import
javax.swing.JTable;
012.
import
javax.swing.JScrollPane;
013.
import
javax.swing.table.DefaultTableModel;
014.
import
javax.swing.table.TableRowSorter;
015.
016.
public
class
MyForm
extends
JFrame {
017.
018.
019.
020.
021.
public
static
void
main(String[] args) {
022.
EventQueue.invokeLater(
new
Runnable() {
023.
public
void
run() {
024.
MyForm frame =
new
MyForm();
025.
frame.setVisible(
true
);
026.
}
027.
});
028.
}
029.
030.
031.
032.
033.
public
MyForm() {
034.
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
035.
setBounds(
100
,
100
,
580
,
242
);
036.
setTitle(
"ThaiCreate.Com Java GUI Tutorial"
);
037.
getContentPane().setLayout(
null
);
038.
039.
040.
JScrollPane scrollPane =
new
JScrollPane();
041.
scrollPane.setBounds(
64
,
44
,
440
,
89
);
042.
getContentPane().add(scrollPane);
043.
044.
045.
JTable table =
new
JTable();
046.
scrollPane.setViewportView(table);
047.
048.
049.
DefaultTableModel model = (DefaultTableModel)table.getModel();
050.
model.addColumn(
"CustomerID"
);
051.
model.addColumn(
"Name"
);
052.
model.addColumn(
"Email"
);
053.
model.addColumn(
"CountryCode"
);
054.
model.addColumn(
"Budget"
);
055.
model.addColumn(
"Used"
);
056.
057.
058.
TableRowSorter<DefaultTableModel> sorter =
new
TableRowSorter<DefaultTableModel> (model);
059.
table.setRowSorter(sorter);
060.
061.
Connection connect =
null
;
062.
Statement s =
null
;
063.
064.
try
{
065.
Class.forName(
"com.mysql.jdbc.Driver"
);
066.
068.
"?user=root&password=root"
);
069.
070.
s = connect.createStatement();
071.
072.
String sql =
"SELECT * FROM customer ORDER BY CustomerID ASC"
;
073.
074.
ResultSet rec = s.executeQuery(sql);
075.
int
row =
0
;
076.
while
((rec!=
null
) && (rec.next()))
077.
{
078.
model.addRow(
new
Object[
0
]);
079.
model.setValueAt(rec.getString(
"CustomerID"
), row,
0
);
080.
model.setValueAt(rec.getString(
"Name"
), row,
1
);
081.
model.setValueAt(rec.getString(
"Email"
), row,
2
);
082.
model.setValueAt(rec.getString(
"CountryCode"
), row,
3
);
083.
model.setValueAt(rec.getFloat(
"Budget"
), row,
4
);
084.
model.setValueAt(rec.getFloat(
"Used"
), row,
5
);
085.
row++;
086.
}
087.
088.
rec.close();
089.
090.
}
catch
(Exception e) {
091.
092.
JOptionPane.showMessageDialog(
null
, e.getMessage());
093.
e.printStackTrace();
094.
}
095.
096.
try
{
097.
if
(s !=
null
) {
098.
s.close();
099.
connect.close();
100.
}
101.
}
catch
(SQLException e) {
102.
103.
e.printStackTrace();
104.
}
105.
106.
107.
}
108.
}