tuifang.java

java开发的酒店管理系统

class tuiFang extends JFrame
{
	public tuiFang(String tell)
	{
		Toolkit kit =Toolkit.getDefaultToolkit();
		Dimension screenSize=kit.getScreenSize();
		int screenWidth=screenSize.width;
		int screenHeight=screenSize.height;
		setLocation((screenWidth-DEFA_W)/2,(screenHeight-DEFA_H)/2);  //设置窗口位置,位于屏幕中间
		setTitle("空房查询--精确查询");
		setSize(DEFA_W,DEFA_H);
		setResizable(false);  //不允许用户改变窗口大小
	}
	private final int DEFA_W=500;		//设置框架的宽度
	private final int DEFA_H=400;
}

class tuiFangPane extends JPanel
{
	public tuiFangPane(String tell)
	{
		Tell=tell;
		
	}
	
	public void connDBQ() throws SQLException
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e){}
		String URL="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=mdb.mdb";
		conn=DriverManager.getConnection(URL);
		stmt=createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		rs=stmt.executeQuery("select * from ");
	}
	
	private String Tell;
	private Connection conn;
	private Statement stmt;
	private ResultSet rs;
}