sun139
新新人类
帖子
1
精华
0
无忧币 15
积分 15
阅读权限 20
|
发表于:2007-9-27 08:43
标题：TABLE 查询显示重复数据重复表格???郁闷中中
＜上一帖 |
下一帖＞
下面是代码\真有点不懂,为什么每次我点查询后.数据会在表格里面增加.而且表格的行与列都同时增加.就像下面一样
第一次点查询
id name type
1 001 1
第二次查询就变成下面这样了
id name type id name type id name type
1 001 1
2 002 2
3 003 3
为什么会这样呢.请高手指点一下啊
谢谢了
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.Vector;
public class chaxunFrame extends JInternalFrame
{
/**
*
*/
private static final long serialVersionUID = 1L;
static int frameNo = 1;
static final int xOffset = 50, yOffset = 50;
public chaxunFrame()
{
super("信息" + (frameNo++), true, true, true, true);
setSize(800, 600);
setLocation(xOffset * frameNo, yOffset * frameNo);
try
{
jbInit();
} catch (Exception e)
{
e.printStackTrace();
}
}
private void jbInit() throws Exception
{
setLayout(null);
jTextField1.setFont(new java.awt.Font("Dialog", 0, 16));
jTextField1.setText("");
jTextField1.addMouseListener(new chaxunFrame_jTextField1_mouseAdapter(
this));
jButton1.setFont(new java.awt.Font("Dialog", 0, 14));
jButton1.setText("查询");
jButton1
.addActionListener(new chaxunFrame_jButton1_actionAdapter(this));
table.setFont(new java.awt.Font("Dialog", 0, 20));
jScrollPane.setFont(new java.awt.Font("Dialog", 0, 20));
jscrollbar.setFont(new Font("Dialog", 0, 20));
jButton1.setBounds(100, 100, 65, 25);
add(jButton1);
jTextField1.setBounds(180, 100, 65, 25);
jTextField1.setForeground(Color.MAGENTA);
jTextField1.setColumns(2);
add(jTextField1);
Container con = getContentPane();
con.add(panel);
panel.setBounds(5, 135, 1000, 700);
// panel.add(jscrollbar);
panel.add(jScrollPane);
jScrollPane.getViewport().add(table, null);
// jscrollbar.add(table);
}
JPanel panel = new JPanel();
JTextField jTextField1 = new JTextField();
JScrollPane jScrollPane = new JScrollPane();
JScrollBar jscrollbar = new JScrollBar();
JTable table = new JTable();
JButton jButton1 = new JButton();
int Count;
int[] Types;
String[] TypeNames;
Vector Identifiers = new Vector();
Vector dataVector = new Vector();
PreparedStatement pstd;
ResultSet rSet;
void jButton1_actionPerformed(ActionEvent e)
{
try
{
Connection conn = FileDataBases.getConnection();
Statement stat = conn.createStatement();
String sql = "select * from admin";
ResultSet rSet = stat.executeQuery(sql);
Count = rSet.getMetaData().getColumnCount();
Types = new int Count ;
TypeNames = new String Count ;
for (int i = 0; i row = new Vector(Count + 1);
for (int i = 0; i < Count; i++)
{
Object object = rSet.getObject(i + 1);
row.add(object);
}
dataVector.add(row);
}
rSet.close();
table = new JTable(dataVector, Identifiers);
table.setDoubleBuffered(true);
table.setColumnSelectionAllowed(false);
table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
jScrollPane.getViewport().add(table, null);
} catch (java.lang.Exception exec)
{
JOptionPane.showMessageDialog(null, "dd");
exec.printStackTrace();
}
}
/*
* void
* jTextField1_mousePressed(MouseEvent
* e) { jTextField2.setText("");
* jTextField3.setText(""); }
*/
class chaxunFrame_jButton1_actionAdapter implements
java.awt.event.ActionListener
{
chaxunFrame adaptee;
chaxunFrame_jButton1_actionAdapter(chaxunFrame adaptee)
{
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e)
{
adaptee.jButton1_actionPerformed(e);
}
}
class chaxunFrame_jTextField1_mouseAdapter extends
java.awt.event.MouseAdapter
{
chaxunFrame adaptee;
chaxunFrame_jTextField1_mouseAdapter(chaxunFrame adaptee)
{
this.adaptee = adaptee;
}
public void mousePressed(MouseEvent e)
{
// adaptee.jTextField1_mousePressed(e);
}
}
}
|
论坛活动：测测你对IT技术大会的了解指数(赠微软礼品、无忧币) |
|
| 诚征版主 | 版主堂 | 意见建议 | 大史记 | 论坛地图