public class assetMessageDialog extends JDialog {
    JPanel panel1 = new JPanel();
    Vector assetMessageSql=new Vector();
    Vector assetMessageHead=new Vector();
    DefaultTableModel model=new DefaultTableModel(assetMessageSql,assetMessageHead){
        public boolean isCellEditable(int row,int column){
            return false;
        }
    };
    JTable jTableAssetMessage = new JTable(model);
    JScrollPane jScrollPaneAssetMessage = new JScrollPane();
    public assetMessageDialog(Frame owner, String title, boolean modal) {
        super(owner, title, modal);
        try {
            setDefaultCloseOperation(DISPOSE_ON_CLOSE);      
            jbInit();
            pack();
            showAssetMessage();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }    public assetMessageDialog() {
        this(new Frame(), "assetMessageDialog", false);
    }    private void jbInit() throws Exception {
        panel1.setLayout(null);
        jScrollPaneAssetMessage.setBounds(new Rectangle(0, 0,500, 400));
        getContentPane().add(panel1);
        panel1.add(jScrollPaneAssetMessage);
        jScrollPaneAssetMessage.getViewport().add(jTableAssetMessage);
    }
    void showAssetMessage(){
        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        }catch(ClassNotFoundException ce){
            System.out.println(ce);
        }
        try{
            Connection con=DriverManager.getConnection("jdbc:odbc:assetManage");
            Statement s=con.createStatement();
            ResultSet rs=s.executeQuery("select * from assetMessage");
            assetMessageSql.removeAllElements();
            while(rs.next()){
                Vector temp=new Vector();
                temp.add(rs.getString(1));
                temp.add(rs.getString(2));
                temp.add(rs.getString(3));
                temp.add(rs.getString(4));
                temp.add(rs.getString(5));
                temp.add(rs.getString(6));
                temp.add(rs.getString(7));
                temp.add(rs.getString(8));
                temp.add(rs.getString(9));
                temp.add(rs.getString(10));
                assetMessageSql.add(temp);
            }
            model.setDataVector(assetMessageSql,assetMessageHead);
            rs.close();
            s.close();
            con.close();
        }catch(SQLException se){
            System.out.println(se);
        }
    }
}

解决方案 »

  1.   

    此回复为自动发出,仅用于显示而已,并无任何其他特殊作用
    楼主【yuyistar】截止到2008-07-01 17:42:16的历史汇总数据(不包括此帖):
    发帖数:62                 发帖分:1390               
    结贴数:36                 结贴分:720                
    未结数:26                 未结分:670                
    结贴率:58.06 %            结分率:51.80 %            
    楼主加油
      

  2.   

    此回复为自动发出,仅用于显示而已,并无任何其他特殊作用 
    楼主【yuyistar】截止到2008-07-01 09:58:01的历史汇总数据(不包括此帖): 
    发帖数:61                发帖分:1370              
    结贴数:55                结贴分:1210              
    未结数:6                  未结分:160                
    结贴率:90.16 %            结分率:88.32 %            
    值得尊敬
    怎么统计差这么多