import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.*;
import java.util.*;
import java.sql.*;public class Employee_Management extends JFrame
{
JScrollPane EmployeeScrollPanel=new JScrollPane();
JTable EmployeeTable;
DefaultTableModel model;static ResultSet pid;
static Connection con;
static Statement stat;
static boolean result;
Employee_Management(){
model=new DefaultTableModel();
EmployeeTable=new JTable();
EmployeeTable.setModel(model);
EmployeeScrollPanel.getViewport().add(EmployeeTable);
add(EmployeeTable);
model.addColumn("编号");
model.addColumn("姓名");
model.addColumn("性别");
model.addColumn("年龄");
model.addColumn("学历");
Vector vector=new Vector();
try{
pid=stat.executeQuery("select * from Employees");
if(pid.next())
{
vector.add(pid.getString(1));
vector.add(pid.getString(2));
vector.add(pid.getString(3));
vector.add(pid.getString(4));
vector.add(pid.getString(5));
}
}catch(Exception e){System.out.println(e);}
model.addRow(vector);
setSize(500,450);
setVisible(true);
setDefaultCloseOperation(EXIT_ON_CLOSE);
setLocationRelativeTo(null);
setResizable(false);
}
public static void main(String[] args)
{
Employee_Management Exam=new Employee_Management();
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//注册ODBC-JDBC驱动程序
con=DriverManager.getConnection("jdbc:odbc:Mydatasource","sa","66978061");//连接数据驱动程序
stat=con.createStatement();//执行查询操作
}
catch(Exception e)
{
System.out.println(e);//输出异常
}
}
}
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.*;
import java.util.*;
import java.sql.*;public class Employee_Management extends JFrame
{
JScrollPane EmployeeScrollPanel=new JScrollPane();
JTable EmployeeTable;
DefaultTableModel model;static ResultSet pid;
static Connection con;
static Statement stat;
static boolean result;
Employee_Management(){
model=new DefaultTableModel();
EmployeeTable=new JTable();
EmployeeTable.setModel(model);
EmployeeScrollPanel.getViewport().add(EmployeeTable);
add(EmployeeTable);
model.addColumn("编号");
model.addColumn("姓名");
model.addColumn("性别");
model.addColumn("年龄");
model.addColumn("学历");
Vector vector=new Vector();
try{
pid=stat.executeQuery("select * from Employees");
if(pid.next())
{
vector.add(pid.getString(1));
vector.add(pid.getString(2));
vector.add(pid.getString(3));
vector.add(pid.getString(4));
vector.add(pid.getString(5));
}
}catch(Exception e){System.out.println(e);}
model.addRow(vector);
setSize(500,450);
setVisible(true);
setDefaultCloseOperation(EXIT_ON_CLOSE);
setLocationRelativeTo(null);
setResizable(false);
}
public static void main(String[] args)
{
Employee_Management Exam=new Employee_Management();
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//注册ODBC-JDBC驱动程序
con=DriverManager.getConnection("jdbc:odbc:Mydatasource","sa","66978061");//连接数据驱动程序
stat=con.createStatement();//执行查询操作
}
catch(Exception e)
{
System.out.println(e);//输出异常
}
}
}
http://gceclub.sun.com.cn/Java_Docs/jdk6/html/zh_CN/api/javax/swing/JTable.html
如下试试:public static void main(String[] args)
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//注册ODBC-JDBC驱动程序
con=DriverManager.getConnection("jdbc:odbc:Mydatasource","sa","66978061");//连接数据驱动程序
stat=con.createStatement();//执行查询操作
}
catch(Exception e)
{
System.out.println(e);//输出异常
}
Employee_Management Exam=new Employee_Management();
}
if(pid.next())
{
vector.add(pid.getString(1));
vector.add(pid.getString(2));
vector.add(pid.getString(3));
vector.add(pid.getString(4));
vector.add(pid.getString(5));
}
}catch(Exception e){System.out.println(e);}
model.addRow(vector); 改下,把 model.addRow(vector); 放在循环里。除了这个之外,还有其他地方需要改进。楼主加油。
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.*;
import java.util.*;
import java.sql.*; public class Employee_Management extends JFrame
{
JScrollPane EmployeeScrollPanel=new JScrollPane();
JTable EmployeeTable;
DefaultTableModel model; static ResultSet pid;
static Connection con;
static Statement stat;
static boolean result;
Employee_Management(){
model=new DefaultTableModel();
EmployeeTable=new JTable();
EmployeeTable.setModel(model);
EmployeeScrollPanel.getViewport().add(EmployeeTable);
add(EmployeeTable);
model.addColumn("编号");
model.addColumn("姓名");
model.addColumn("性别");
model.addColumn("年龄");
model.addColumn("学历");
Vector vector=new Vector();
try{
pid=stat.executeQuery("select * from Employees"); if(pid.next()) //while(pid.next())
{
vector.add(pid.getString(1));
vector.add(pid.getString(2));
vector.add(pid.getString(3));
vector.add(pid.getString(4));
vector.add(pid.getString(5)); model.addRow(vector); //加到这里}
}catch(Exception e){System.out.println(e);
}
model.addRow(vector); //这个去掉
setSize(500,450);
setVisible(true);
setDefaultCloseOperation(EXIT_ON_CLOSE);
setLocationRelativeTo(null);
setResizable(false);
}
public static void main(String[] args)
{
Employee_Management Exam=new Employee_Management();
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//注册ODBC-JDBC驱动程序
con=DriverManager.getConnection("jdbc:odbc:Mydatasource","sa","66978061");//连接数据驱动程序
stat=con.createStatement();//执行查询操作
}
catch(Exception e)
{
System.out.println(e);//输出异常
}
}
}另外 你应该把 ModelTable 重写一个类
把取DB的方法也单独写个类
这样清晰