import javax.swing.*;
import java.awt.*;
import javax.swing.table.*;
import javax.swing.JTable.*;
import java.sql.*;
import java.awt.event.*;
import java.util.*;
public class tableTest
{
public static void main(String[] args)
{
JTable table;
JFrame frame=new JFrame("FancyTable");
TableModel myTable=new DefaultTableModel();
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager. getConnection("jdbc:mysql://localhost:3306/wxf","root","26533621");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from usekey");
ResultSetMetaData metaData;
metaData = rs. getMetaData();
int number=metaData. getColumnCount();
Vector columnNames=new Vector();
Vector rows=new Vector();
for(int num=0;num<number;num++)
{
columnNames.addElement(metaData. getColumnLabel(num+1));
}
rows.addElement(columnNames);
while(rs.next())
{
Vector newRow = new Vector();
for (int i = 1; i <= number; i++) {
newRow.addElement(rs. getObject(i));
}
rows.addElement(newRow);
myTable=new DefaultTableModel(rows,columnNames);//(vector,vector)
}
}
catch (ClassNotFoundException ex) {
System.err.println("Cannot find the database driver classes.");
System.err.println(ex);
}
catch (SQLException ex) {
System.err.println("Cannot connect to this database.");
System.err.println(ex);
}
table=new JTable(myTable);
frame.setLayout(new BorderLayout());
frame.add(table,BorderLayout.CENTER);
frame.addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent e){System.exit(0);}});
frame.setBounds(0,0,200,300);
frame.setVisible(true);
}
}
import java.awt.*;
import javax.swing.table.*;
import javax.swing.JTable.*;
import java.sql.*;
import java.awt.event.*;
import java.util.*;
public class tableTest
{
public static void main(String[] args)
{
JTable table;
JFrame frame=new JFrame("FancyTable");
TableModel myTable=new DefaultTableModel();
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager. getConnection("jdbc:mysql://localhost:3306/wxf","root","26533621");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from usekey");
ResultSetMetaData metaData;
metaData = rs. getMetaData();
int number=metaData. getColumnCount();
Vector columnNames=new Vector();
Vector rows=new Vector();
for(int num=0;num<number;num++)
{
columnNames.addElement(metaData. getColumnLabel(num+1));
}
rows.addElement(columnNames);
while(rs.next())
{
Vector newRow = new Vector();
for (int i = 1; i <= number; i++) {
newRow.addElement(rs. getObject(i));
}
rows.addElement(newRow);
myTable=new DefaultTableModel(rows,columnNames);//(vector,vector)
}
}
catch (ClassNotFoundException ex) {
System.err.println("Cannot find the database driver classes.");
System.err.println(ex);
}
catch (SQLException ex) {
System.err.println("Cannot connect to this database.");
System.err.println(ex);
}
table=new JTable(myTable);
frame.setLayout(new BorderLayout());
frame.add(table,BorderLayout.CENTER);
frame.addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent e){System.exit(0);}});
frame.setBounds(0,0,200,300);
frame.setVisible(true);
}
}