java swing 获取数据_Java Swing 查询数据

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

publicclass mainn extends JFrame {

privateJTable jt = null;

private JScrollPane jsp = null;

private JButton jb = null;

public static void main(String[] args) {

// 显示应用 GUI

mainn miann1 = new mainn();

}

public mainn()

{

sqlitedata a = new sqlitedata();

//初始化JTable

a.mainjj();

jt = new JTable(a.rowData,a.columnName);

jsp = new JScrollPane(jt);

this.add(jsp);

this.setTitle(" ");

this.setSize(460, 200); //这是大小

this.setLocation(300,200); //这是位置

this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

this.setResizable(true); //尺寸是否可变

this.setVisible(true); //显示与隐藏

}

}

publicclass sqlitedata {

public Vector rowData, columnName;

public void mainjj() {

Connection c = null;

Statement stmt = null;

rowData = new Vector();

try {

Class.forName("org.sqlite.JDBC");

c =DriverManager.getConnection("jdbc:sqlite:d:\\web\\data.data\\");//tim.data

c.setAutoCommit(false);

System.out.println("Openeddatabase successfully");

stmt = c.createStatement();

ResultSet rs =stmt.executeQuery("SELECT * FROM Meter;");//COMPANY

ResultSetMetaData data =rs.getMetaData();

columnName = new Vector();

System.out.println("dd");

for (int i = 1; i <=data.getColumnCount(); i++) {

columnName.add(data.getColumnName(i));//这里是列名

}

while (rs.next()) {

Vector line1 = newVector();

for (int k = 1; k <=data.getColumnCount(); k++) {

line1.add(rs.getString(data.getColumnName(k)));//这里是添加行数据

}

rowData.add(line1);

}

rs.close();

stmt.close();

c.close();

} catch (Exception e) {

System.err.println(e.getClass().getName() + ": " +e.getMessage());

System.exit(0);

}

System.out.println("Operationdone successfully");

}

}

界面数据

架包jar