帮我看看这段代码! 多谢!就是显示不出数据!
package remoteoperate;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.border.*;
import com.borland.jbcl.layout.*;
import java.util.*;
import java.sql.*;
public class SelectPort_Dialog extends JDialog
{
JPanel panel1 = new JPanel();
JPanel panel2 = new JPanel();
BorderLayout borderLayout1 = new BorderLayout();
XYLayout xYLayout1 = new XYLayout();
JPanel jPanel1 = new JPanel();
XYLayout xYLayout2 = new XYLayout();
JButton jButton1 = new JButton();
JButton jButton2 = new JButton();
JTable jTable1 = new JTable();
JScrollPane jScrollPane1 = new JScrollPane();
Vector columnNames = new Vector();
Vector column = new Vector();
Vector currentRow = new Vector();
Vector rows = new Vector();
String url = "jdbc:sybase:Tds:192.168.100.178:6800/exsydb";
String username = "sa";
String password = "";
String query = "SELECT ofcname,spctype,servport,sdatype,machineip,machine FROM initfile ";
JLabel jLabel1 = new JLabel();
public SelectPort_Dialog(Frame parent)
{
super(parent);
try
{
jbInit();
}
catch(Exception e)
{
e.printStackTrace();
}
pack();
}
/**Component initialization*/
private void jbInit() throws Exception
{
//imageLabel.setIcon(new ImageIcon(MainFrame_AboutBox.class.getResource("[Your Image]")));
this.setTitle("选择端口");
setResizable(false);
panel1.setLayout(borderLayout1);
panel2.setLayout(xYLayout1);
jPanel1.setLayout(xYLayout2);
jButton1.setBorder(BorderFactory.createEtchedBorder());
jButton1.setText("确定");
jButton1.addActionListener(new SelectPort_Dialog_jButton1_actionAdapter(this));
jButton2.setBorder(BorderFactory.createEtchedBorder());
jButton2.setText("取消");
jButton2.addActionListener(new SelectPort_Dialog_jButton2_actionAdapter(this));
jLabel1.setText("jLabel1");
this.getContentPane().add(panel1, BorderLayout.CENTER);
panel1.add(panel2, BorderLayout.CENTER);
panel2.add(jPanel1, new XYConstraints(11, 280, 399, 2));
panel2.add(jTable1, new XYConstraints(1, 0, 421, 228));
panel2.add(jScrollPane1, new XYConstraints(1, 0, 421, 228));
panel2.add(jLabel1, new XYConstraints(8, 235, 402, 20));
panel2.add(jButton1, new XYConstraints(119, 260, 69, -1));
panel2.add(jButton2, new XYConstraints(236, 260, 75, -1));
JViewport port = jScrollPane1.getViewport();
port.add(jTable1);
this.getTable();
jTable1 = new JTable( rows, column );
}
private void getTable()
{
try
{
Driver sybDrv = (Driver) Class.forName( "com.sybase.jdbc2.jdbc.SybDriver" ).newInstance();
Connection connection = DriverManager.getConnection(url, username, password );
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery( query );
displayResultSet( resultSet );
}catch(Exception eDB)
{
}
}
private void displayResultSet(ResultSet rs1)
throws SQLException
{
ResultSet rs = rs1;
this.column.addElement("网元");
this.column.addElement("交换机型号");
this.column.addElement("服务端口");
this.column.addElement("端口类型");
this.column.addElement("接口机IP");
this.column.addElement("接口机名");
try
{
ResultSetMetaData rsmd = rs.getMetaData();
while ( rs.next() )
{
rows.addElement( getNextRow( rs, rsmd ) );
}
}catch(Exception eGetRs)
{
String str = eGetRs.toString();
jLabel1.setText(str);
}
}
private Vector getNextRow( ResultSet rs,ResultSetMetaData rsmd )
throws SQLException
{
for ( int i = 1; i <= rsmd.getColumnCount(); ++i )
currentRow.addElement( rs.getString( i ) );
return currentRow;
}
void jButton1_actionPerformed(ActionEvent e)
{
this.dispose();
}
void jButton2_actionPerformed(ActionEvent e)
{
this.dispose();
}
}
class SelectPort_Dialog_jButton1_actionAdapter implements java.awt.event.ActionListener
{
SelectPort_Dialog adaptee;
SelectPort_Dialog_jButton1_actionAdapter(SelectPort_Dialog adaptee)
{
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e)
{
adaptee.jButton1_actionPerformed(e);
}
}
class SelectPort_Dialog_jButton2_actionAdapter implements java.awt.event.ActionListener
{
SelectPort_Dialog adaptee;
SelectPort_Dialog_jButton2_actionAdapter(SelectPort_Dialog adaptee)
{
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e)
{
adaptee.jButton2_actionPerformed(e);
}
}