frmbrcx.java

很全面的包括了住院管理的各项功能。如：管理员登录

					
		
		//创建标签，设置标签的布局和颜色
		Label lblBCH = new Label(shell,SWT.None);
		lblBCH.setText("病床号");
		lblBCH.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		lblBCH.setForeground(colGreen);
		
		//创建文本框，设置布局方式
		txtBCH = new Text(shell, SWT.BORDER);
		txtBCH.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		txtBCH.addKeyListener(new KeyAdapter () {
			public void keyPressed(KeyEvent e) {
            if (e.keyCode == SWT.CR) {
            	CXBR();
            }
          }
        });	
			

		//创建标签，设置标签的布局和颜色
		Label lblBRDH = new Label(shell,SWT.None);
		lblBRDH.setText("病人电话");
		lblBRDH.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		lblBRDH.setForeground(colGreen);
		
		//创建文本框，设置布局方式
		txtBRDH = new Text(shell, SWT.BORDER);
		txtBRDH.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		txtBRDH.addKeyListener(new KeyAdapter () {
			public void keyPressed(KeyEvent e) {
            if (e.keyCode == SWT.CR) {
            	CXBR();
            }
          }
        });	
	
		
		//创建标签，设置标签的布局和颜色
		Label lblBRDZ = new Label(shell,SWT.None);
		lblBRDZ.setText("病人地址");
		lblBRDZ.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		lblBRDZ.setForeground(colGreen);
		
		//创建文本框，设置布局方式
		txtBRDZ = new Text(shell,SWT.BORDER);
		txtBRDZ.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		txtBRDZ.addKeyListener(new KeyAdapter () {
			public void keyPressed(KeyEvent e) {
            if (e.keyCode == SWT.CR) {
            	CXBR();
            }
          }
        });	
	
			
		//创建标签，设置标签的布局和颜色
		Label lblLXRXM = new Label(shell,SWT.None);
		lblLXRXM.setText("联系人姓名");
		lblLXRXM.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		lblLXRXM.setForeground(colGreen);
		
		//创建文本框，设置布局方式
		txtLXRXM = new Text(shell, SWT.BORDER);
		txtLXRXM.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		txtLXRXM.addKeyListener(new KeyAdapter () {
			public void keyPressed(KeyEvent e) {
            if (e.keyCode == SWT.CR) {
            	CXBR();
            }
          }
        });	
	

		//创建标签，设置标签的布局和颜色
		Label lblLXRDH = new Label(shell,SWT.None);
		lblLXRDH.setText("联系人电话");
		lblLXRDH.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		lblLXRDH.setForeground(colGreen);
		
		//创建文本框，设置布局方式
		txtLXRDH = new Text(shell, SWT.BORDER);
		txtLXRDH.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		txtLXRDH.addKeyListener(new KeyAdapter () {
			public void keyPressed(KeyEvent e) {
            if (e.keyCode == SWT.CR) {
            	CXBR();
            }
          }
        });	
				
		//创建标签，设置标签的布局和颜色
		Label lblLXRDZ = new Label(shell,SWT.None);
		lblLXRDZ.setText("联系人地址");
		lblLXRDZ.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		lblLXRDZ.setForeground(colGreen);
		
		//创建文本框，设置布局方式
		txtLXRDZ = new Text(shell, SWT.BORDER);
		txtLXRDZ.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		txtLXRDZ.addKeyListener(new KeyAdapter () {
			public void keyPressed(KeyEvent e) {
            if (e.keyCode == SWT.CR) {
            	CXBR();
            }
          }
        });	
	

		//创建标签，设置标签的布局和颜色
		Label lblRYRQ = new Label(shell,SWT.None);
		lblRYRQ.setText("入院日期");
		lblRYRQ.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		lblRYRQ.setForeground(colGreen);
		
		//创建文本框，设置布局方式
		txtRYRQ = new Text(shell, SWT.BORDER);
		txtRYRQ.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		txtRYRQ.addKeyListener(new KeyAdapter () {
			public void keyPressed(KeyEvent e) {
            if (e.keyCode == SWT.CR) {
            	CXBR();
            }
          }
        });	
	
	
		//创建标签，设置标签的布局和颜色
		Label lblCYRQ = new Label(shell,SWT.None);
		lblCYRQ.setText("出院日期");
		lblCYRQ.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		lblCYRQ.setForeground(colGreen);
		
		//创建文本框，设置布局方式
		txtCYRQ = new Text(shell, SWT.BORDER);
		txtCYRQ.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		txtCYRQ.addKeyListener(new KeyAdapter () {
			public void keyPressed(KeyEvent e) {
            if (e.keyCode == SWT.CR) {
            	CXBR();
            }
          }
        });	
		
	}
	
	private void createTable(){		
	
		//创建表格		
		table = new Table(shell,SWT.SINGLE | SWT.BORDER | SWT.FULL_SELECTION);
		
		//设置表格表头可见	
		table.setHeaderVisible(true);
		
		//设置表框线可见
		table.setLinesVisible(true);
					
		//设置表格显示格式
		GridData gridDataCol = new GridData(GridData.FILL_BOTH);
		gridDataCol.horizontalSpan = 8;
		table.setLayoutData(gridDataCol);	  		

		//循环添加表格的后面各列						  		
		colTotal = new TableColumn[columns_namesMD.length];
		for(int i=0;i<=15;i++) {
			colTotal[i] = new TableColumn(table,SWT.CENTER);
		}
		
		//设置每列的宽度
		colTotal[0].setWidth(20);
		colTotal[1].setWidth(120);
		colTotal[2].setWidth(120);
		colTotal[3].setWidth(80);
		colTotal[4].setWidth(80);
		colTotal[5].setWidth(80);
		colTotal[6].setWidth(120);
		colTotal[7].setWidth(80);
		colTotal[8].setWidth(80);
		colTotal[9].setWidth(120);
		colTotal[10].setWidth(120);
		colTotal[11].setWidth(80);
		colTotal[12].setWidth(120);
		colTotal[13].setWidth(120);
		colTotal[14].setWidth(120);
		colTotal[15].setWidth(120);		
		
		table.addSelectionListener(new SelectionAdapter() {		
    		public void widgetSelected(SelectionEvent event) {	
    			//获得当前的选中行
 				TableItem[] items = table.getSelection();
 				if (items.length == 0) return;
 				ZYH = items[0].getText(1);
 				System.out.println(ZYH);
    		}
    	});
		//添加双击事件
    	table.addSelectionListener(new SelectionAdapter() {		
    		public void widgetDefaultSelected(SelectionEvent e) {
    			if(rdoBRMD.getSelection()){     				
    				//在此添加程序
    				//获得当前的选中行
 					TableItem[] items = table.getSelection();
 					if (items.length == 0) return;
 					ZYH = items[0].getText(1);
 					System.out.println(ZYH);
 					table.removeAll();
					rdoBRFY.setSelection(true);
              		rdoBRJF.setSelection(false);
           			rdoBRMD.setSelection(false);			
					for(int i=0;i<=15;i++) {					
						colTotal[i].setText(columns_namesFY[i]);			
					}
					//设置每列的宽度
					colTotal[0].setWidth(20);
					colTotal[1].setWidth(150);
					colTotal[2].setWidth(120);
					colTotal[3].setWidth(80);
					colTotal[4].setWidth(80);
					colTotal[5].setWidth(80);
					colTotal[6].setWidth(80);
					colTotal[7].setWidth(80);
					colTotal[8].setWidth(80);
					colTotal[9].setWidth(80);
					colTotal[10].setWidth(80);
					colTotal[11].setWidth(120);
					colTotal[12].setWidth(120);
					colTotal[13].setWidth(80);
					colTotal[14].setWidth(80);
					colTotal[15].setWidth(0);
					//计算查询到的数目			
					try {				
						int rsCount = Db.getDataFY(ZYH);
						if(rsCount>0){
							int n = 1;
							while(Db.rsFY.next()){	
        						//创建行
           						TableItem item = new TableItem(table,0);			
            					//设置当前行的内容	
            					item.setText(new String[] {
            						String.valueOf(n),
            						Db.rsFY.getString("CFRQ"),		
          							Db.rsFY.getString("KM"),
          		  					Db.rsFY.getString("SUM"),
            						Db.rsFY.getString("DJ"),
            						Db.rsFY.getString("SL"),
            						Db.rsFY.getString("ZYKS"),
       		     					Db.rsFY.getString("JJDW"),
            						Db.rsFY.getString("GG"),
            						Db.rsFY.getString("KMLB"),
            						Db.rsFY.getString("XMFL"),
            						Db.rsFY.getString("ZFBL"),
            						Db.rsFY.getString("ZYH"),
            						Db.rsFY.getString("CD"),
            						Db.rsFY.getString("CJ"),            			          				          				         			
            					});
            					n++;            			      					
        					}
        				}
        				else if(rsCount<0){
        					MessageBox msBox = new MessageBox(shell,SWT.ICON_ERROR);
            				msBox.setText("错误");
           					msBox.setMessage("没有此病人费用数据!");
            				msBox.open();
        				}
        				else{        					
        					MessageBox msBox = new MessageBox(shell,SWT.ICON_ERROR);
            				msBox.setText("错误");
           					msBox.setMessage("查询语句出错，请仔细检查!");
            				msBox.open();
        				}	
        			}
        			catch(Exception event) {		
    					System.err.println(event.getMessage());	
    				}		  				
    			}
    		}	    	 	
    	 });
	}
	
	private void createButton(){		
		
		//创建提示标签，设置布局方式
		GridData gridDataTS = new GridData(GridData.FILL_HORIZONTAL);
		gridDataTS.horizontalSpan = 6;		
		Label lblTiShi = new Label(shell,SWT.None);
		lblTiShi.setForeground(colRed);
		lblTiShi.setLayoutData(gridDataTS);
		lblTiShi.setText("可以在文本框内输入一个或多个条件然后点《查询》按键条件不必完整");
		
		//创建选择按钮，设置布局方式
		GridData gridDataBRMD = new GridData(GridData.FILL_HORIZONTAL);
		rdoBRMD =  new Button(shell,SWT.RADIO);
		rdoBRMD.setLayoutData(gridDataBRMD);
		rdoBRMD.setText("病人名单");
		//添加监听器		
		addRadioListener(rdoBRMD);
		
		//创建选择按钮，设置布局方式		
		GridData gridDataBRFY = new GridData(GridData.FILL_HORIZONTAL);
		rdoBRFY = new Button(shell,SWT.RADIO);
		rdoBRFY.setLayoutData(gridDataBRFY);
		rdoBRFY.setText("病人费用");
		//添加监听器	
		addRadioListener(rdoBRFY);

		//创建选择按钮，设置布局方式
		GridData gridDataBRJF = new GridData(GridData.FILL_HORIZONTAL);
		rdoBRJF =  new Button(shell,SWT.RADIO);
		rdoBRJF.setLayoutData(gridDataBRJF);
		rdoBRJF.setText("病人缴费");
		//添加监听器
		addRadioListener(rdoBRJF);
		
		//创建《查询》按钮，设置布局方式
		GridData gridDataCX = new GridData(GridData.HORIZONTAL_ALIGN_CENTER);
		Button btnCX = new Button(shell,SWT.None);