?? fenbiaoshow1.java
字號:
package train_table;import javax.swing.table.*;import java.awt.*;import javax.swing.*;import com.borland.jbcl.layout.*;import java.sql.*;import java.awt.event.*;import com.borland.dbswing.*;import javax.swing.border.*;import com.borland.dx.sql.dataset.*;import com.borland.dx.dataset.*;public class fenbiaoshow1 extends JFrame{ private XYLayout xYLayout1 = new XYLayout(); private JPanel jPanel1 = new JPanel(); private TitledBorder titledBorder1; private TableScrollPane tableScrollPane1 = new TableScrollPane(); private GridLayout gridLayout1 = new GridLayout(); private JdbTable jdbTable1 = new JdbTable(); private Database database1 = new Database(); private Column column1 = new Column(); private Column column2 = new Column(); private Column column3 = new Column(); private Column column4 = new Column(); private Column column5 = new Column(); private Column column6 = new Column(); private QueryDataSet queryDataSet1 = new QueryDataSet(); //通過傳入車次顯示分表信息,是對主表信息的更詳細的現實 public fenbiaoshow1(String times) { //根據傳入的車次查詢分表 queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT checibiao.\"車次\",checibiao.\"到達車站\",checibiao.\"到站時間\",checibiao.\"硬座票價\",checibiao.\"臥鋪票價\" " + "FROM\"E:\\train_table\\trainmaindb\".checibiao where checibiao.\"車次\"='"+times+"'", null, true, Load.ALL)); jdbTable1.setDataSet(queryDataSet1); //發送結果集 try { jbInit(); } catch(Exception e) { e.printStackTrace(); } } private void jbInit() throws Exception { this.setTitle("分表信息"); titledBorder1 = new TitledBorder(""); this.getContentPane().setLayout(xYLayout1); xYLayout1.setWidth(450); xYLayout1.setHeight(240); jPanel1.setBorder(titledBorder1); jPanel1.setLayout(gridLayout1); database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:traindb", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver")); database1.setDatabaseName(""); queryDataSet1.setEditable(false); jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_LAST_COLUMN); column1.setColumnName("到站時間"); column1.setDataType(com.borland.dx.dataset.Variant.TIME); column1.setReadOnly(true); column1.setWidth(12); column1.setServerColumnName("到站時間"); column1.setSqlType(93); column2.setColumnName("硬座票價"); column2.setDataType(com.borland.dx.dataset.Variant.ASSIGNED_NULL); column2.setPrecision(19); column2.setReadOnly(true); column2.setScale(4); column2.setWidth(10); column2.setServerColumnName("硬座票價"); column2.setSqlType(2); column3.setColumnName("到達車站"); column3.setDataType(com.borland.dx.dataset.Variant.STRING); column3.setPrecision(12); column3.setReadOnly(true); column3.setWidth(10); column3.setServerColumnName("到達車站"); column3.setSqlType(12); column4.setColumnName("臥鋪票價"); column4.setDataType(com.borland.dx.dataset.Variant.ASSIGNED_NULL); column4.setPrecision(19); column4.setReadOnly(true); column4.setScale(4); column4.setWidth(10); column4.setServerColumnName("臥鋪票價"); column4.setSqlType(2); column5.setColumnName("車次"); column5.setDataType(com.borland.dx.dataset.Variant.STRING); column5.setPrecision(6); column5.setReadOnly(true); column5.setServerColumnName("車次"); column5.setSqlType(12); queryDataSet1.setColumns(new Column[] {column5, column3, column1, column2, column4}); column6.setColumnName("硬座票價"); column6.setDataType(com.borland.dx.dataset.Variant.ASSIGNED_NULL); column6.setPrecision(19); column6.setScale(4); column6.setServerColumnName("硬座票價"); column6.setSqlType(2); this.getContentPane().add(jPanel1, new XYConstraints(6, 5, 439, 205)); jPanel1.add(tableScrollPane1, null); tableScrollPane1.getViewport().add(jdbTable1, null); }}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -