testdatabase.java

是适合于使用的管理系统 可以在现实中使用

package mysiloer;

import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import javax.swing.JTable;
import javax.swing.JFrame;
import java.awt.BorderLayout;
import javax.swing.JPanel;

/**
 * <p>Title: MySiloer</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: yskey</p>
 * @author 杨涛
 * @version 1.0
 */

public class TestDataBase {

  public TestDataBase() {
    try{
    DataBase base = new DataBase();
    Connection con = base.getConnection();
    Statement sta = con.createStatement();
    ResultSet set = sta.executeQuery("select * from siloTable");
//    while(set.next()){
//      System.out.println(set.getString(1));
//      System.out.println(set.getString(2));
//      System.out.println(set.getString(3));
//      System.out.println(set.getString(4));
//    }
    MyTableModel model = new MyTableModel(set);
    JTable table = new JTable(model);
    JFrame frame = new JFrame();
    JPanel panel = new JPanel(new BorderLayout());
    panel.add(table);
    frame.setContentPane(panel);
    frame.setSize(600,400);
    frame.setVisible(true);
    frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

    }
    catch(Exception e){
      System.out.print(e.toString());
    }


  }
  public static void main(String[] args) {
    TestDataBase testDataBase1 = new TestDataBase();
  }
}