allinfpane.java

学生宿舍管理系统

import java.awt.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.swing.*;

public class AllInfPane extends JPanel{
  
  
	Box basebox,box1,box2;
	JDBCAdapter database=new JDBCAdapter("jdbc:odbc:information",
			"sun.jdbc.odbc.JdbcOdbcDriver",
			"",
			"");
	AllInfPane(){
		int totalhtol=0;
	box1=Box.createVerticalBox();
	box1.add(new Label("学生总人数:"));
	box1.add(Box.createVerticalStrut(8));
	box1.add(new Label("寝室总数:"));
	box1.add(Box.createVerticalStrut(8));
	box1.add(new Label("寝室平均人数:"));
	box2=Box.createVerticalBox();
	box2.add(new Label("'"+database.totalSNumber()+"'"));
	box2.add(Box.createVerticalStrut(8));
	box2.add(new Label("'"+database.totalHNumber()+"'"));
	box2.add(Box.createVerticalStrut(8));
	box2.add(new Label("'"+database.totalSNumber()/database.totalHNumber()+"'"));
	basebox=Box.createHorizontalBox();
	basebox.add(box1);
	basebox.add(Box.createHorizontalStrut(10));
	basebox.add(box2);
	add(basebox);
	setVisible(true);
	this.validate();
	}
  
}