package addresssys;import java.awt.*;import javax.swing.*;import com.borland.dbswing.*;import com.borland.dx.sql.dataset.*;import com.borland.dx.dataset.*;/** * <p>Title: 多用戶通訊系統</p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2007</p> * <p>Company: </p> * @author zhang22 * @version 1.0 */public class AddrMaintainDialog extends JDialog {  JPanel panel1 = new JPanel();  JdbLabel jdbLabel1 = new JdbLabel();  JLabel jLabel1 = new JLabel();  JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();  JLabel jLabel2 = new JLabel();  TableScrollPane tableScrollPane1 = new TableScrollPane();  JdbTable jdbTable1 = new JdbTable();  JdbStatusLabel jdbStatusLabel1 = new JdbStatusLabel();  Database database1 = new Database();  ParameterRow parameterRow1 = new ParameterRow();  Column column1 = new Column();  QueryDataSet queryDataSet1 = new QueryDataSet();    Database db;    QueryDataSet query;  JdbNavField jdbNavField1 = new JdbNavField();  public AddrMaintainDialog(Frame frame, String title, boolean modal,Database database,QueryDataSet querydataset) {    super(frame, title, modal);    this.db= database;    this.query = querydataset;    try {      jbInit();      pack();    }    catch(Exception ex) {      ex.printStackTrace();    }  }  private void jbInit() throws Exception {    panel1.setLayout(null);    this.getContentPane().setLayout(null);    panel1.setBounds(new Rectangle(0, 0, 452, 403));    jdbLabel1.setFont(new java.awt.Font("Dialog", 0, 16));    jdbLabel1.setColumnName("Name");    jdbLabel1.setColumnNameIcon("");    jdbLabel1.setText("");    jdbLabel1.setBounds(new Rectangle(19, 29, 108, 38));    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel1.setText("的通訊錄");    jLabel1.setBounds(new Rectangle(178, 31, 157, 36));    jdbNavToolBar1.setDataSet(queryDataSet1);    jdbNavToolBar1.setBounds(new Rectangle(7, 78, 247, 48));    jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel2.setText("find");    jLabel2.setBounds(new Rectangle(269, 88, 48, 27));    tableScrollPane1.setBounds(new Rectangle(11, 133, 428, 210));    jdbTable1.setFont(new java.awt.Font("Dialog", 0, 16));    jdbTable1.setColumnHeaderVisible(true);    jdbTable1.setDataSet(queryDataSet1);    jdbStatusLabel1.setText("jdbStatusLabel1");    jdbStatusLabel1.setDataSet(queryDataSet1);    jdbStatusLabel1.setBounds(new Rectangle(7, 358, 432, 39));    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=addresslist", "sa", "sa", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));    column1.setColumnName("UserName");    column1.setDataType(com.borland.dx.dataset.Variant.STRING);    column1.setPreferredOrdinal(0);    column1.setServerColumnName("NewColumn1");    column1.setSqlType(0);    parameterRow1.setColumns(new Column[] {column1});    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from address_users where username=:username ", parameterRow1, true, Load.ALL));    jdbNavField1.setText("jdbNavField1");    jdbNavField1.setColumnName("UserName");    jdbNavField1.setDataSet(queryDataSet1);    jdbNavField1.setBounds(new Rectangle(311, 84, 125, 37));    getContentPane().add(panel1, null);    panel1.add(jdbLabel1, null);    panel1.add(jLabel1, null);    panel1.add(jdbNavToolBar1, null);    panel1.add(jLabel2, null);    panel1.add(tableScrollPane1, null);    panel1.add(jdbStatusLabel1, null);    panel1.add(jdbNavField1, null);    tableScrollPane1.getViewport().add(jdbTable1, null);    this.parameterRow1.setString("username",query.getString("username"));       this.jdbLabel1.setText(query.getString("username"));       //刷新數據集       this.query.refresh();  }}