frmsel.java

来自「现代社会离不开手机和电话」· Java 代码 · 共 47 行

import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.*;

// Referenced classes of package telmanagersystem:
//            SQL

public class frmSel extends JInternalFrame
{

    public frmSel()
    {
        super("查询信息", true, true, true, true);
        sql = new SQL();
        Object aobj[] = {
            "序号", "姓名", "地址", "电话号码"
        };
        Object aobj1[][] = new Object[100][4];
        ResultSet resultset = sql.selectall();
        int i = 0;
        try
        {
            while(resultset.next()) 
            {
                aobj1[i][0] = (new StringBuilder()).append("<").append(i + 1).append(">").toString();
                aobj1[i][1] = resultset.getString("name");
                aobj1[i][2] = resultset.getString("add");
                aobj1[i][3] = resultset.getString("tel");
                i++;
            }
        }
        catch(SQLException sqlexception)
        {
            System.out.println(sqlexception.getMessage());
        }
        jt = new JTable(aobj1, aobj);
        jt.setRowHeight(20);
        getContentPane().removeAll();
        getContentPane().add(new JScrollPane(jt));
        setDefaultCloseOperation(2);
        setSize(400, 300);
        setVisible(true);
    }

    SQL sql;
    JTable jt;
}