frmbrcx.java

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

package myprojects.FrmBRCX;

import org.eclipse.swt.*;
import org.eclipse.swt.widgets.*;
import org.eclipse.swt.layout.*;
import org.eclipse.swt.graphics.Font;
import org.eclipse.swt.graphics.FontData;
import org.eclipse.swt.graphics.Color;
import java.lang.String.*;
import org.eclipse.swt.events.*;
import myprojects.FrmBRCXDb.*;
import myprojects.FrmMenu.*;

public class FrmBRCX {
	
	private Shell shell;
		
	//标签显示颜色
	private static Color colRed,colGreen;
	private static Font font;
	private static String ZYH;
	
	private boolean redraw = true;
	//创建数据库实例
	private static myprojects.FrmBRCXDb.FrmBRCXDb Db = new myprojects.FrmBRCXDb.FrmBRCXDb();
			
	//表格
	private Table table;
	private TableColumn[] colTotal;
	
	private Text txtZYH;
	private Text txtBLH;	
	private Text txtBRXM; 
	private Text txtBRXB;
	private Text txtCSNY;	
	private Text txtSFZH;
	private Text txtZYKS;
	private Text txtBCH;
	private Text txtBRDH;
	private Text txtBRDZ;
	private Text txtLXRXM;
	private Text txtLXRDH;
	private Text txtLXRDZ;
	private Text txtRYRQ;
	private Text txtCYRQ;	
	private Button rdoBRMD;
	private Button rdoBRFY;
	private Button rdoBRJF;
	
	//定义表格列名
	private String[] columns_namesMD = {"",
										"住院号",
										"病历号",
										"病人姓名",
				  						"病人性别",
				  						"出生年月",
				  						"身份证号",
				  						"住院科室",
				  						"病床号",
				  						"病人电话",
				  						"病人地址",
				  						"联系人姓名",
				  						"联系人电话",
				  						"联系人地址",
				  						"入院日期",
				  						"出院日期"};
	private String[] columns_namesFY = {"",
										"发生日期",
		  								"科目",	
		  								"金额",
		  								"单价",
		  								"数量",
		  								"所在科室",
		  								"计价单位",
		  								"规格",
		  								"收费项目",
		  								"分类代码",
		  								"自费比列",
		  								"住院号",
		  								"产地",						  				
		  								"厂家",
		  								""};			  
	
	private	String[] columns_namesJF = {"",
										"交费日期",
		  								"收费员",	
		  								"金额",
		  								"住院号",
		  								"交费形式",
		  								"",
		  								"",
		  								"",
		  								"",
		  								"",
		  								"",
		  								"",
		  								"",						  				
		  								"",
		  								""};				 
			
	public static void main() {
		
		Display display = new Display();
		FrmBRCX brcx=new FrmBRCX();
		
		//设置字体颜色
		font = new Font (display, "NONE", 14, SWT.NORMAL);
		colRed = new Color(display,255,0,0);
		colGreen = new Color(display,0,0,255);	
		
		//创建整体框架	
		brcx.createShell();	
		brcx.shell.open();	
	
		while(!brcx.shell.isDisposed()){
			if(!display.readAndDispatch())
				display.sleep();
		}
		colRed.dispose();
		colGreen.dispose();
		font.dispose();
		display.dispose();
		
		//关闭数据库
		Db.closeDB();
	}	

	private void createShell(){

		shell = new Shell();
		shell.setBounds(240,230,680,480);
		shell.setText("查询病人交费及其费用");
		
		//创建数据库连接
		if(!Db.getConnection())							
        {
            MessageBox msBox = new MessageBox(shell,SWT.OK|SWT.ICON_ERROR);
            msBox.setText("错误");
            msBox.setMessage("数据库连接出错");
            msBox.open();
            return;
        }
		
		//设置布局方式
		GridLayout gridLayout = new GridLayout();
		
		//将shell分为6列，设置shell中组件横向、纵向间隔
		gridLayout.numColumns = 6;
		gridLayout.horizontalSpacing = 25;
		gridLayout.verticalSpacing = 15;
		shell.setLayout(gridLayout);
	
		//调用各方法、创建整体界面		
		createWidgets();
		createTable();				
		createButton(); 
		shell.open();	
	}
	
	private void createWidgets(){	
		
		
		//设置下面标签的布局方式
		GridData gridDataTime = new GridData(GridData.FILL_HORIZONTAL);
    	gridDataTime.horizontalAlignment = GridData.END;
    	gridDataTime.grabExcessHorizontalSpace = true;    	
    	gridDataTime.horizontalSpan =6;    	
     	
     	//创建标签，应用布局方式,设置标签
     	Label lblTime = new Label(shell, SWT.None);		
    	lblTime.setLayoutData(gridDataTime);
    	lblTime.setText(Db.getDate());
    	lblTime.setSize(100,50);
    	lblTime.setVisible(true);
    	    	
  		
  		//设置下面标签的布局方式
    	GridData gridDataBRRYDJ = new GridData();
    	gridDataBRRYDJ.horizontalAlignment = GridData.CENTER;
    	gridDataBRRYDJ.grabExcessHorizontalSpace = true;
    	gridDataBRRYDJ.horizontalSpan =6;    	
		
		//创建标签，应用布局方式，设置字体
		Label lblBRRYDJ = new Label(shell, SWT.None);    
    	lblBRRYDJ.setLayoutData(gridDataBRRYDJ);
    	lblBRRYDJ.setText("查询病人徼费及费用");
    	lblBRRYDJ.setFont(font);
    	lblBRRYDJ.setSize(1,1);
    	lblBRRYDJ.setForeground(colGreen);
    	lblBRRYDJ.setVisible(true);
		
		
		//创建标签，设置标签的布局和颜色
		Label lblZYH=new Label(shell,SWT.None);
		lblZYH.setText("住院号");
		lblZYH.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		lblZYH.setForeground(colGreen);
		
		//创建文本框，设置布局方式
		txtZYH = new Text(shell, SWT.BORDER);
		txtZYH.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		txtZYH.addKeyListener(new KeyAdapter () {
        	public void keyPressed(KeyEvent e) {
            if (e.keyCode == SWT.CR) {
            	CXBR();
            }
          }
        });	
		
		
		//创建标签，设置标签的布局和颜色
		Label lblBLH=new Label(shell,SWT.None);
		lblBLH.setText("病历号");
		lblBLH.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		lblBLH.setForeground(colGreen);
		
		//创建文本框，设置布局方式
		txtBLH = new Text(shell, SWT.BORDER);
		txtBLH.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		txtBLH.addKeyListener(new KeyAdapter () {
        	public void keyPressed(KeyEvent e) {
            if (e.keyCode == SWT.CR) {
            	CXBR();
            }
          }
        });	

				
		
		//创建标签，设置标签的布局和颜色
		Label lblBRXM=new Label(shell,SWT.None);
		lblBRXM.setText("病人姓名");
		lblBRXM.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		lblBRXM.setForeground(colGreen);
		
		//创建文本框，设置布局方式
		txtBRXM = new Text(shell, SWT.BORDER);
		txtBRXM.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		txtBRXM.addKeyListener(new KeyAdapter () {
       		public void keyPressed(KeyEvent e) {
            if (e.keyCode == SWT.CR) {
            	CXBR();
            }
          }
        });	
		
		//创建标签，设置标签的布局和颜色
		Label lblBRXB=new Label(shell,SWT.None);
		lblBRXB.setText("病人性别");
		lblBRXB.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		lblBRXB.setForeground(colGreen);
		
		//创建文本框，设置布局方式
		txtBRXB = new Text(shell, SWT.BORDER);
		txtBRXB.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		txtBRXB.addKeyListener(new KeyAdapter () {
			public void keyPressed(KeyEvent e) {
            if (e.keyCode == SWT.CR) {
            	CXBR();
            }
          }
        });		
		
		
		//创建标签，设置标签的布局和颜色
		Label lblCSNY=new Label(shell,SWT.None);
		lblCSNY.setText("出生年月");
		lblCSNY.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		lblCSNY.setForeground(colGreen);
		
		//创建文本框，设置布局方式
		txtCSNY = new Text(shell, SWT.BORDER);
		txtCSNY.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		txtCSNY.addKeyListener(new KeyAdapter () {
			public void keyPressed(KeyEvent e) {
            if (e.keyCode == SWT.CR) {
            	CXBR();
            }
          }
        });	
	
			
		//创建标签，设置标签的布局和颜色
		Label lblSFZH=new Label(shell,SWT.None);
		lblSFZH.setText("身份证号");
		lblSFZH.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		lblSFZH.setForeground(colGreen);
		
		//创建文本框，设置布局方式
		txtSFZH = new Text(shell, SWT.BORDER);
		txtSFZH.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		txtSFZH.addKeyListener(new KeyAdapter () {
			public void keyPressed(KeyEvent e) {
            if (e.keyCode == SWT.CR) {
            	CXBR();
            }
          }
        });	
	
		
		//创建标签，设置标签的布局和颜色
		Label lblZYKS=new Label(shell,SWT.None);
		lblZYKS.setText("住院科室");
		lblZYKS.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		lblZYKS.setForeground(colGreen);
		
		//创建文本框，设置布局方式
		txtZYKS = new Text(shell, SWT.BORDER);
		txtZYKS.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
		txtZYKS.addKeyListener(new KeyAdapter () {
			public void keyPressed(KeyEvent e) {
            if (e.keyCode == SWT.CR) {
            	CXBR();
            }
          }
        });