package com.csbook.restaurant;import java.awt.*;import javax.swing.*;import com.borland.dx.sql.dataset.*;import com.borland.dbswing.*;import com.borland.dx.dataset.*;import java.awt.event.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2003</p> * <p>Company: </p> * @author pengtao * @version 1.0 */public class SupplierConfiguration extends JInternalFrame {  JPanel panel1 = new JPanel();   BorderLayout borderLayout1 = new BorderLayout();   JPanel jPanel2 = new JPanel();   Database database1 = new Database();   TableScrollPane tableScrollPane1 = new TableScrollPane();   JdbTable jdbTable1 = new JdbTable();   Column column1 = new Column();   Column column3 = new Column();   Column column5 = new Column();   Column column7 = new Column();   QueryDataSet queryDataSet1 = new QueryDataSet();   Column column2 = new Column();   Column column4 = new Column();   Column column6 = new Column();   Column column8 = new Column();   Column column9 = new Column();   Column column10 = new Column();   Column column11 = new Column();   Column column12 = new Column();   Column column13 = new Column();   Column column14 = new Column();   Column column15 = new Column();   JPanel jPanel1 = new JPanel();   JLabel jLabel1 = new JLabel();   JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();   BorderLayout borderLayout2 = new BorderLayout();   JPanel jPanel3 = new JPanel();   JButton close = new JButton();  DBDisposeMonitor dBDisposeMonitor1 = new DBDisposeMonitor();   public SupplierConfiguration(String title,boolean resizable,boolean closable,boolean maximizable,boolean iconifiable) {     super(title,resizable,closable,maximizable,iconifiable);     try {       jbInit();       pack();     }     catch(Exception ex) {       ex.printStackTrace();     }   }   private void jbInit() throws Exception {     panel1.setLayout(borderLayout1);     database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Restaurant", "user", "user", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));     column1.setCaption("名稱");     column1.setColumnName("name");     column1.setDataType(com.borland.dx.dataset.Variant.STRING);     column1.setPrecision(30);     column1.setRowId(true);     column1.setSchemaName("dbo");     column1.setTableName("supplier");     column1.setServerColumnName("name");     column1.setSqlType(1);     column3.setCaption("郵政編碼");     column3.setColumnName("postcode");     column3.setDataType(com.borland.dx.dataset.Variant.STRING);     column3.setPrecision(6);     column3.setSchemaName("dbo");     column3.setTableName("supplier");     column3.setServerColumnName("postcode");     column3.setSqlType(1);     column5.setCaption("主頁");     column5.setColumnName("homepage");     column5.setDataType(com.borland.dx.dataset.Variant.STRING);     column5.setPrecision(50);     column5.setSchemaName("dbo");     column5.setTableName("supplier");     column5.setServerColumnName("homepage");     column5.setSqlType(1);     column7.setCaption("稅號");     column7.setColumnName("taxNo");     column7.setDataType(com.borland.dx.dataset.Variant.STRING);     column7.setPrecision(20);     column7.setSchemaName("dbo");     column7.setTableName("supplier");     column7.setServerColumnName("taxNo");     column7.setSqlType(1);     queryDataSet1.setColumns(new Column[] {column7, column5, column3, column1});     queryDataSet1.setMetaDataUpdate(MetaDataUpdate.NONE);    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT supplier.name,supplier.addr,supplier.postcode,supplier.tel,supplier.homepage,supplier.email,su" +       "pplier.taxNo,supplier.bank,supplier.accountNo,supplier.contact,supplier.remark " +       "FROM Restaurant.dbo.supplier", null, true, Load.ALL));     column2.setCaption("名稱");     column2.setColumnName("name");     column2.setDataType(com.borland.dx.dataset.Variant.STRING);     column2.setPrecision(30);     column2.setRowId(true);     column2.setSchemaName("dbo");     column2.setTableName("supplier");     column2.setServerColumnName("name");     column2.setSqlType(1);     column4.setCaption("地址");     column4.setColumnName("addr");     column4.setDataType(com.borland.dx.dataset.Variant.STRING);     column4.setPrecision(40);     column4.setSchemaName("dbo");     column4.setTableName("supplier");     column4.setServerColumnName("addr");     column4.setSqlType(1);     column6.setCaption("郵政編碼");     column6.setColumnName("postcode");     column6.setDataType(com.borland.dx.dataset.Variant.STRING);     column6.setPrecision(6);     column6.setSchemaName("dbo");     column6.setTableName("supplier");     column6.setServerColumnName("postcode");     column6.setSqlType(1);     column8.setCaption("聯系電話");     column8.setColumnName("tel");     column8.setDataType(com.borland.dx.dataset.Variant.STRING);     column8.setPrecision(40);     column8.setSchemaName("dbo");     column8.setTableName("supplier");     column8.setWidth(10);     column8.setServerColumnName("tel");     column8.setSqlType(1);     column9.setCaption("公司網站");     column9.setColumnName("homepage");     column9.setDataType(com.borland.dx.dataset.Variant.STRING);     column9.setPrecision(50);     column9.setSchemaName("dbo");     column9.setTableName("supplier");     column9.setServerColumnName("homepage");     column9.setSqlType(1);     column10.setCaption("電子郵件");     column10.setColumnName("email");     column10.setDataType(com.borland.dx.dataset.Variant.STRING);     column10.setPrecision(50);     column10.setSchemaName("dbo");     column10.setTableName("supplier");     column10.setWidth(15);     column10.setServerColumnName("email");     column10.setSqlType(1);     column11.setCaption("稅號");     column11.setColumnName("taxNo");     column11.setDataType(com.borland.dx.dataset.Variant.STRING);     column11.setPrecision(20);     column11.setSchemaName("dbo");     column11.setTableName("supplier");     column11.setServerColumnName("taxNo");     column11.setSqlType(1);     column12.setCaption("開戶銀行");     column12.setColumnName("bank");     column12.setDataType(com.borland.dx.dataset.Variant.STRING);     column12.setPrecision(20);     column12.setSchemaName("dbo");     column12.setTableName("supplier");     column12.setWidth(10);     column12.setServerColumnName("bank");     column12.setSqlType(1);     column13.setCaption("銀行賬號");     column13.setColumnName("accountNo");     column13.setDataType(com.borland.dx.dataset.Variant.STRING);     column13.setPrecision(30);     column13.setSchemaName("dbo");     column13.setTableName("supplier");     column13.setServerColumnName("accountNo");     column13.setSqlType(1);     column14.setCaption("聯系人");     column14.setColumnName("contact");     column14.setDataType(com.borland.dx.dataset.Variant.STRING);     column14.setPrecision(8);     column14.setSchemaName("dbo");     column14.setTableName("supplier");     column14.setServerColumnName("contact");     column14.setSqlType(1);     column15.setCaption("備注");     column15.setColumnName("remark");     column15.setDataType(com.borland.dx.dataset.Variant.STRING);     column15.setPrecision(255);     column15.setSchemaName("dbo");     column15.setTableName("supplier");     column15.setServerColumnName("remark");     column15.setSqlType(1);     queryDataSet1.setColumns(new Column[] {column2, column4, column6, column8, column9, column10, column11, column12, column13, column14, column15});     jdbTable1.setDataSet(queryDataSet1);     jLabel1.setText("供應商信息管理");     jPanel1.setLayout(borderLayout2);     close.setText("關閉");     close.addActionListener(new SupplierConfiguration_close_actionAdapter(this));     getContentPane().add(panel1,  BorderLayout.CENTER);     panel1.add(tableScrollPane1, BorderLayout.NORTH);     tableScrollPane1.getViewport().add(jdbTable1, null);     this.getContentPane().add(jPanel2, BorderLayout.NORTH);     jPanel2.add(jLabel1, null);     this.getContentPane().add(jPanel1,  BorderLayout.SOUTH);     jPanel1.add(jdbNavToolBar1, BorderLayout.CENTER);     jPanel1.add(jPanel3,  BorderLayout.SOUTH);     jPanel3.add(close, null);   }   void close_actionPerformed(ActionEvent e) {   this.dispose();   } } class SupplierConfiguration_close_actionAdapter implements java.awt.event.ActionListener {   SupplierConfiguration adaptee;   SupplierConfiguration_close_actionAdapter(SupplierConfiguration adaptee) {     this.adaptee = adaptee;   }   public void actionPerformed(ActionEvent e) {     adaptee.close_actionPerformed(e);   } }