java mysql查询界面,java Swing 界面化查询数据库表

packagemeterSqllitedataFinal;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.ResultSetMetaData;importjava.sql.Statement;importjava.util.Vector;importjavax.swing.JScrollPane;importjavax.swing.JTable;importorg.omg.CORBA.PRIVATE_MEMBER;public classsqlitedata {publicVector rowData, columnName;private JTable jt = null;private JScrollPane jsp = null;int kk = 2;public voidmainjj() {

Connection c= null;

Statement stmt= null;

String kongge= new String("\t");

String huiche= new String("\n");

String shuchu= "";

rowData= newVector();try{

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

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

c.setAutoCommit(false);

System.out.println("Opened database successfully");

stmt=c.createStatement();

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

ResultSetMetaData data =rs.getMetaData();

columnName= newVector();

System.out.println("dd");for (int i = 1; i <= data.getColumnCount(); i++) {

shuchu=data.getColumnName(i);

columnName.add(shuchu);

}while(rs.next()) {

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

shuchu=rs.getString(data.getColumnName(k));

line1.add(shuchu);

System.out.println("这里在循环没有错"+line1);

}

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("Operation done successfully");

}

}