为什么不显示结果？？

daddygirlqiuwf 2002-02-01 04:44:50
执行下查询数据库，在表格中显示查询结果的程序。为什么只出现一个空的Frame，加4个按钮，而没有查询结果呢？


package database;


import java.awt.*;
import java.sql.*;
import java.awt.event.*;
import java.util.Vector;
import java.util.*;
import javax.swing.*;
import javax.swing.table.*;


public class MainFrame extends JFrame {
JPanel contentPane;

//JTable jTable1 = new JTable();

JButton jButton1 = new JButton();
JButton jButton2 = new JButton();
JButton jButton3 = new JButton();
JButton jButton4 = new JButton();
Vector data_vect=new Vector();
PreparedStatement statement;
Connection connection;


final String title[]={"usercode","name","position","department"};


//implement Class AbstractTableModel;
AbstractTableModel tm=new AbstractTableModel(){
public int getColumnCount(){
return title.length;
}
public int getRowCount(){
return data_vect.size();
}
public Object getValueAt(int row,int column){
if(!data_vect.isEmpty())
return ((Vector)data_vect.elementAt(row)).elementAt(column);
else
return null;
}
public String getColumnName(int column){
return title[column];
}
public void setValueAt(Object value,int row,int column){

}
public Class getColumnClass(int c){
return getValueAt(0,c).getClass();
}
public boolean isCellEditable(int row,int column){
return false;//set uneditable is the default mode;
}
public boolean setReadOnly(){
return false;
}
};
JTable jTable1=new JTable(tm);

/**Construct the frame*/
public MainFrame() {
enableEvents(AWTEvent.WINDOW_EVENT_MASK);
try {
jbInit();
Class.forName("oracle.jdbc.driver.OracleDriver");
connection=DriverManager.getConnection("jdbc:oracle:thin:@wg039:1521:grade98","exercise","exercise");
System.out.println("I can connnect the database!");
setJTable();
}
catch(Exception e) {
e.printStackTrace();
}
}
/**Component initialization*/
private void jbInit() throws Exception {

//setIconImage(Toolkit.getDefaultToolkit().createImage(MainFrame.class.getResource("[Your Icon]")));

contentPane = (JPanel) this.getContentPane();
contentPane.setLayout(null);
this.setSize(new Dimension(400, 300));
this.setTitle("database example");


jTable1.setBounds(new Rectangle(36, 45, 282, 128));
jTable1.addFocusListener(new MainFrame_jTable1_focusAdapter(this));

jButton1.setText("add");
jButton1.setBounds(new Rectangle(36, 173, 70, 34));
jButton1.addActionListener(new MaimFrame_button1_actionAdapter(this));

jButton2.setText("modify");
jButton2.setBounds(new Rectangle(105, 174, 73, 33));
jButton2.addActionListener(new MaimFrame_button2_actionAdapter(this));

jButton3.setText("delete");
jButton3.setBounds(new Rectangle(176, 174, 75, 33));
jButton3.addActionListener(new MaimFrame_button3_actionAdapter(this));

jButton4.setText("exit ");
jButton4.setBounds(new Rectangle(250, 174, 69, 33));
jButton4.addActionListener(new MaimFrame_button4_actionAdapter(this));

contentPane.add(jTable1, null);
contentPane.add(jButton1, null);
contentPane.add(jButton2, null);
contentPane.add(jButton3, null);
contentPane.add(jButton4, null);

}

public static void main(String[] args)
{
MainFrame frame=new MainFrame();
frame.setLocation(150,150);
System.out.println("hello________________");
frame.setSize(550,400);
frame.show();
System.out.println("hello________________");
}

void setJTable(){
try{

String sql="select * from QWF_CLERK_YGXXB";
statement=connection.prepareStatement(sql);
ResultSet result=statement.executeQuery();
data_vect.removeAllElements();
tm.fireTableStructureChanged();
while(result.next())
{
Vector data=new Vector();
String userid=result.getString("userid");
String username=result.getString("username");
String zhiwu=result.getString("zhiwu");
String department=result.getString("department");
//System.out.println(department);
data.addElement(userid);
data.addElement(username);
data.addElement(zhiwu);
data.addElement(department);
data_vect.addElement(data);
}
tm.fireTableStructureChanged();
result.close();
statement.close();
/* int len=data.size()/4;
String[][] items=new String[len][4];
for(int i=0;i<len;i++)
{
items[i][0]=(String)data.elementAt(i*4);
items[i][1]=(String)data.elementAt(i*4+1);
items[i][2]=(String)data.elementAt(i*4+2);
items[i][3]=(String)data.elementAt(i*4+3);
}
*/

jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
jTable1.setCellSelectionEnabled(false);
jTable1.setShowVerticalLines(true);
jTable1.setShowHorizontalLines(true);
JScrollPane jsp=new JScrollPane(jTable1);




}
catch(Exception e){
System.out.println(e.toString());
}
}


/**Overridden so we can exit when window is closed*/
protected void processWindowEvent(WindowEvent e) {
super.processWindowEvent(e);
if (e.getID() == WindowEvent.WINDOW_CLOSING) {
System.exit(0);
}
}

void jButton1_actionPerformed(ActionEvent e) {

}

void jButton2_actionPerformed(ActionEvent e) {

}

void jButton3_actionPerformed(ActionEvent e) {

}

void jButton4_actionPerformed(ActionEvent e) {

}

void jTable1_focusGained(FocusEvent e) {

}

}

class MaimFrame_button1_actionAdapter implements java.awt.event.ActionListener {
MainFrame adaptee;

MaimFrame_button1_actionAdapter(MainFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}

class MaimFrame_button2_actionAdapter implements java.awt.event.ActionListener {
MainFrame adaptee;

MaimFrame_button2_actionAdapter(MainFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton2_actionPerformed(e);
}
}

class MaimFrame_button3_actionAdapter implements java.awt.event.ActionListener {
MainFrame adaptee;

MaimFrame_button3_actionAdapter(MainFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton3_actionPerformed(e);
}
}

class MaimFrame_button4_actionAdapter implements java.awt.event.ActionListener {
MainFrame adaptee;

MaimFrame_button4_actionAdapter(MainFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton4_actionPerformed(e);
}
}

class MainFrame_jTable1_focusAdapter extends java.awt.event.FocusAdapter {
MainFrame adaptee;

MainFrame_jTable1_focusAdapter(MainFrame adaptee) {
this.adaptee = adaptee;
}
public void focusGained(FocusEvent e) {
adaptee.jTable1_focusGained(e);
}
}
...全文
89 6 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
6 条回复
切换为时间正序
请发表友善的回复…
发表回复
daddygirlqiuwf 2002-02-01
  • 打赏
  • 举报
 回复
Thank you!
但还是不行？
relive 2002-02-01
  • 打赏
  • 举报
 回复
void setJTable(){
try{

String sql="select * from QWF_CLERK_YGXXB";
statement=connection.prepareStatement(sql);
ResultSet result=statement.executeQuery();
data_vect.removeAllElements();
tm.fireTableStructureChanged();
while(result.next())
{
Vector data=new Vector();
String userid=result.getString("userid");
String username=result.getString("username");
String zhiwu=result.getString("zhiwu");
String department=result.getString("department");
//System.out.println(department);
data.addElement(userid);
data.addElement(username);
data.addElement(zhiwu);
data.addElement(department);
data_vect.addElement(data);
}
tm.fireTableStructureChanged();
result.close();
statement.close();
/* int len=data.size()/4;
String[][] items=new String[len][4];
for(int i=0;i<len;i++)
{
items[i][0]=(String)data.elementAt(i*4);
items[i][1]=(String)data.elementAt(i*4+1);
items[i][2]=(String)data.elementAt(i*4+2);
items[i][3]=(String)data.elementAt(i*4+3);
}
*/

jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
jTable1.setCellSelectionEnabled(false);
jTable1.setShowVerticalLines(true);
jTable1.setShowHorizontalLines(true);
JScrollPane jsp=new JScrollPane(jTable1);



/*>>>>>*/ jTable1.updateUI();




}
catch(Exception e){
System.out.println(e.toString());
}
}


daddygirlqiuwf 2002-02-01
  • 打赏
  • 举报
 回复
还是没有结果！
??
xmvigour 2002-02-01
  • 打赏
  • 举报
 回复
Vector data=new Vector();

while(result.next())
{
data.clear();
String userid=result.getString("userid");
String username=result.getString("username");
String zhiwu=result.getString("zhiwu");
String department=result.getString("department");
//System.out.println(department);
data.addElement(userid);
data.addElement(username);
data.addElement(zhiwu);
data.addElement(department);
data_vect.addElement((Vector)data.clone());
}
daddygirlqiuwf 2002-02-01
  • 打赏
  • 举报
 回复
还是没有显示结果呀！在若干此运行中，有一次显示了一条记录，而事实上数据库该表中有5条记录？？？
xmvigour 2002-02-01
  • 打赏
  • 举报
 回复
public static void main(String[] args)
{
MainFrame frame=new MainFrame();
frame.setLocation(150,150);
System.out.println("hello________________");
frame.setSize(550,400);
frame.setVisible(true);
frame.show();
你必须知道的495个C语言问题
为什么这些问题如此频繁地出现？ 5.15　有没有什么简单点儿的办法理解所有这些与空指针有关的东西呢？ 5.16　考虑到有关空指针的所有这些困惑，要求它们的内部表示都必须为0不是更简单吗？ 5.17　说真的，真有...
oracle数据库查询中文的结果显示为???（中文编码问题，方案大全）
Oracle数据库，NLS_LANG=AERIACN，不支持中文编码，解决方法oracle字符集的介绍关于字符集字符集的构成与设定1. 客户端字符集的构成与设定。客户端的字符集是由当前用户的环境变量NLS_LANG设定的。环境变量NLS_LANG...
MySQL显示中文乱码?????的解决方案
做Web应用最头疼的就是码表的问题了哈，一不注意中文就乱码了哈！ 今天做MySql数据库的时候，插入了一行记录，里面包含了中文字段直接给我显示“？？？？” mysql> select * from table_user; +-----------...
PHP查询数据库第一条数据为何不显示？
为什么呢？ 因为mysql_fetch_row 与mysql_fetch_assoc两者都是读取的r11的结果集。即：mysqlfetchrow先读取了结果集r11的结果集。 即：mysql_fetch_row先读取了结果集r11的结果集。即：mysqlf​etchr​ow先...
SQL 给某字段添加汉字却显示？？
3、将排序规则由默认的SQL_Latin1_General_CP1_CI_AS修改为Chinese_PRC_CI_AS。（仔细查找，要一模一样）4、点击确定就OK。 温馨提示： 如果修改不了可以重新启动下数据库！重启数据库！重启数据库！ 转载于:...
非技术区

23,409

社区成员

70,517

社区内容

发帖
与我相关
我的任务
社区描述
Java 非技术区
社区管理员
  • 非技术区社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章