frmbrjz.java

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

package myProject.FrmBRJZ;
import org.eclipse.swt.events.*;
import org.eclipse.swt.*;
import org.eclipse.swt.graphics.*;
import org.eclipse.swt.layout.*;
import org.eclipse.swt.widgets.*;

import java.sql.*;
import java.text.*;
import myprojects.FrmMenu.*;


public class FrmBRJZ {
    private Shell shell;
    private Display display;
	private Label lblSFY,lblBRJZ,lblDQSJ,lblZYH,lblBRXM,lblZYKS,lblBCH,lblRYRQ,lblJFHJ,lblFYHJ,lblYT,lblTXJ,lblTZP;
	private Text txtSFY,txtZYH,txtBRXM,txtZYKS,txtBCH,txtRYRQ,txtJFHJ,txtFYHJ,txtYT,txtTXJ,txtTZP;
	private Button btnCY,btnZT,btnBRFY,btnBRJF,btnBC,btnFQ,btnFH;
	private Table tblBRFY;
	private TableColumn colBRFY1,colBRFY2,colBRFY3,colBRFY4,colBRFY5,colBRFY6,colBRFY7,colBRJF1,colBRJF2,colBRJF3,colBRJF4,colBRJF5;
	

    private  FrmBRJZDb db = new FrmBRJZDb();

public static void main() {
    Display display = new Display ();
    FrmBRJZ Item=new FrmBRJZ();
   


try{
	Item.db.getConnection();
	System.out.print("Done");
}
catch(Exception ex)
{
	System.out.print(ex.toString());
}
    
    Item.createshell(); 
    while( !Item.shell.isDisposed())
    {
        if(!display.readAndDispatch())
            display.sleep();
    }    
    display.dispose();
    
    }

public void createshell()
{
    shell = new Shell ();
    shell.setSize(550,500);
    shell.setText("病人结帐");
    //设置布局方式
    GridLayout gridLayout = new GridLayout();
    //shell分成六格
    gridLayout.numColumns = 6;
    shell.setLayout(gridLayout);


    
    createItem();
    createGroup();
    createTable();
    createGroup2();
    createbutton();
    shell.open();
    
}

private  void createItem() {
	
    GridData gridData1 = new GridData(GridData.HORIZONTAL_ALIGN_BEGINNING);

    //GridData占用格子高度为10
    gridData1.verticalSpan = 11;
    
    
    
    GridData gridData15 = new GridData(GridData.VERTICAL_ALIGN_CENTER);

    gridData15.verticalSpan = 11;    
    //定义一个标签
    lblSFY = new Label(shell, SWT.None);	
    //应用布局方案
    lblSFY.setLayoutData(gridData15);
    //显示内容 
    lblSFY.setText("       收费员");	
    //显示true/隐藏false
    lblSFY.setVisible(true);
	



    
    txtSFY = new Text(shell, SWT.BORDER);	
    //应用布局方案
    txtSFY.setLayoutData(gridData1);
    txtSFY.setText("                        ");	
    //显示true/隐藏false
    txtSFY.setVisible(true);
    txtSFY.setEnabled(false);
    txtSFY.setText(db.getUserID());

	


    GridData gridData3= new GridData(GridData.HORIZONTAL_ALIGN_CENTER);

    //GridData占用两个格子
    gridData3.horizontalSpan = 2;    
    //GridData占用格子高度为10
    gridData3.verticalSpan = 11;

    //定义一个标签
    lblBRJZ = new Label(shell, SWT.None);	
    //应用布局方案
    lblBRJZ.setLayoutData(gridData3);
    //显示内容 
    lblBRJZ.setText("           病人结帐");	
    //改变字体颜色
    lblBRJZ.setForeground(new Color(display,0,0,255));
    //显示true/隐藏false
    lblBRJZ.setVisible(true);
    
    GridData gridData4= new GridData(GridData.HORIZONTAL_ALIGN_END);    
    gridData4.horizontalSpan = 2;     
    gridData4.verticalSpan = 11;
    //定义一个标签
    lblDQSJ = new Label(shell, SWT.None);	
    //应用布局方案
    lblDQSJ.setLayoutData(gridData4);
    //显示内容 
    lblDQSJ.setText("                             ");	
    //显示true/隐藏false   
    lblDQSJ.setVisible(true);
    

	lblDQSJ.setText(db.getNowDate());
	
   
    
    
    GridData gridData5= new GridData(GridData.HORIZONTAL_ALIGN_BEGINNING);
    lblZYH = new Label(shell, SWT.NONE);
    lblZYH.setLayoutData(gridData5);
    lblZYH.setText("       住院号");
    //GridData占用格子高度为10
    //gridData5.verticalSpan = 7;    
    //显示true/隐藏false 
    lblZYH.setVisible(true);

    GridData gridData6= new GridData(GridData.HORIZONTAL_ALIGN_BEGINNING);
    //GridData占用格子高度为10
    //gridData6.verticalSpan =7;  
    txtZYH = new Text(shell, SWT.BORDER);
    txtZYH.setLayoutData(gridData6);
    txtZYH.setText("");	
    //显示true/隐藏false
    txtZYH.setVisible(true);
	txtZYH.addKeyListener(new KeyAdapter() 
	  {
        public void keyPressed(KeyEvent event) {
        switch (event.keyCode)
        {
        	case SWT.CR:
         	btnBC.setEnabled(true);
            btnFQ.setEnabled(true);
            txtYT.setEnabled(true);        	
         	String zyh = new String();
         	zyh = txtZYH.getText();
//         	System.out.println(zyh);
         	dispose();
         	colBuild1();
         	btnBRFY.setSelection(true);
         	btnBRJF.setSelection(false);         	

         	
         	
     
         	try{db.getBrxx(zyh);

        	txtBRXM.setText(db.rs.getString("BRXM"));
        	txtBCH.setText(db.rs.getString("BCH"));
        	txtRYRQ.setText(db.rs.getString("RYRQ"));
        	txtZYKS.setText(db.rs.getString("ZYKS"));
        	
        	
        	}
        	
        	
        	catch(SQLException e){	    
        	System.out.println(e.getMessage());
		    e.printStackTrace();
		}
            
           
            try{
                db.getBrfy(zyh);

                
                while(db.prs.next()){
                	

            	     String[] items=new String[7];	

            	     items[0]=db.prs.getString("CFRQ");
            	     items[5]=db.prs.getString("ZYKS");
            	     items[1]=db.prs.getString("KM");
            	     float lfDJ=db.prs.getFloat("DJ");
            	     int liSL=db.prs.getInt("SL");
           	     	 float lfJE=lfDJ*liSL;
            	     items[2]=String.valueOf(lfJE);
            	     items[3]=String.valueOf(lfDJ);
            	     items[4]=String.valueOf(liSL);
            	     
            	     items[6]=db.prs.getString("JJDW");
            	     TableItem item1 = new TableItem(tblBRFY,SWT.NONE);
            	     item1.setText(items);

            	}
            }
        	catch(SQLException e){	    
        	System.out.println(e.getMessage());
		    e.printStackTrace();            		
            }
            
            try {
             	db.getBrfy(zyh);
             	float sum=0;
             	while(db.prs.next()){
             		float lfDJ=db.prs.getFloat("DJ");
            		int liSL=db.prs.getInt("SL");
           	    	float lfJE=lfDJ*liSL;           	
            		float i=lfJE;
            	

                	sum+=i;                	

            	
            

            }
            txtFYHJ.setText(String.valueOf(sum));
            	}
        	catch(SQLException e){	    
        	System.out.println(e.getMessage());
		    e.printStackTrace();            		
            }
            
            try{
            	db.getBrjf(zyh);
            	float sum1=0;
            	while(db.rst.next()){
            		float j = db.rst.getFloat("JE");
            		sum1+=j;
            		}
            txtJFHJ.setText(String.valueOf(sum1));	
                }
            catch(SQLException e){	    
        		System.out.println(e.getMessage());
		   		e.printStackTrace();            		
            }
            
            String x = txtFYHJ.getText();
            float fyhj = Float.parseFloat(x);
            String y = txtJFHJ.getText();
            float jfhj = Float.parseFloat(y); 
            float yt = fyhj - jfhj;
            txtYT.setText(String.valueOf(yt));
            
            
            
            
        	break;
        	
        	}
       
      }
    });

    GridData gridData7= new GridData(GridData.HORIZONTAL_ALIGN_BEGINNING);
    lblBRXM = new Label(shell, SWT.NONE);
    lblBRXM.setLayoutData(gridData7);
    lblBRXM.setText("        病人姓名");
   
    //显示true/隐藏false
    lblBRXM.setVisible(true);    
   
    GridData gridData8= new GridData(GridData.HORIZONTAL_ALIGN_BEGINNING);

    txtBRXM = new Text(shell, SWT.BORDER);
    txtBRXM.setLayoutData(gridData8);
    txtBRXM.setText("                          ");	
    //显示true/隐藏false
    txtBRXM.setVisible(true);   
    txtBRXM.setEnabled(false);
     
    
    
    GridData gridData9= new GridData(GridData.HORIZONTAL_ALIGN_BEGINNING);
    lblZYKS = new Label(shell, SWT.NONE);
    lblZYKS.setLayoutData(gridData9);
    lblZYKS.setText("         住院科室");
 
    //显示true/隐藏false
    lblZYKS.setVisible(true);    
   
    GridData gridData10= new GridData(GridData.HORIZONTAL_ALIGN_BEGINNING);
  
    txtZYKS = new Text(shell, SWT.BORDER);
    txtZYKS.setLayoutData(gridData10);
    txtZYKS.setText("                            ");	
    //显示true/隐藏false
    txtZYKS.setVisible(true);   
    txtZYKS.setEnabled(false);    
    
    GridData gridData11= new GridData(GridData.HORIZONTAL_ALIGN_BEGINNING);
    lblBCH = new Label(shell, SWT.NONE);
    lblBCH.setLayoutData(gridData11);
    lblBCH.setText("        床号");

    //显示true/隐藏false
    lblBCH.setVisible(true);    
   
    GridData gridData12= new GridData(GridData.HORIZONTAL_ALIGN_BEGINNING);
 
    txtBCH = new Text(shell, SWT.BORDER);
    txtBCH.setLayoutData(gridData12);
    txtBCH.setText("                        ");	
    //显示true/隐藏false
    txtBCH.setVisible(true);   
    txtBCH.setEnabled(false);
    
    GridData gridData13= new GridData(GridData.HORIZONTAL_ALIGN_BEGINNING);
    lblRYRQ = new Label(shell, SWT.NONE);
    lblRYRQ.setLayoutData(gridData13);
    lblRYRQ.setText("       入院日期");
   
    //显示true/隐藏false
    lblRYRQ.setVisible(true);    
   
    GridData gridData14= new GridData(GridData.HORIZONTAL_ALIGN_BEGINNING);
  
    txtRYRQ = new Text(shell, SWT.BORDER);
    txtRYRQ.setLayoutData(gridData14);
    txtRYRQ.setText("                          ");	
    //显示true/隐藏false
    txtRYRQ.setVisible(true);   
    txtRYRQ.setEnabled(false);       
}    
private void createGroup(){
		Group group1 = new Group(shell,SWT.SHADOW_ETCHED_IN);
		
		//设置group显示格式
		GridData gridData0 = new GridData(GridData.HORIZONTAL_ALIGN_END);
		gridData0.horizontalSpan=2;
		gridData0.heightHint = 20;
		gridData0.widthHint =120;
		
		group1.setLayoutData(gridData0);
		
		//设置group布局
		GridLayout gridLayout0 = new GridLayout();
		gridLayout0.numColumns = 2;
	    group1.setLayout(gridLayout0);    

		btnCY =  new Button(group1,SWT.RADIO);
		btnCY.setText("出院");
		btnCY.setSelection(true);
		
    	btnZT =  new Button(group1,SWT.RADIO);
	    btnZT.setText("中途");
				
        Group group2 = new Group(shell,SWT.SHADOW_ETCHED_IN);
		GridData gridData1 = new GridData(GridData.FILL_HORIZONTAL);
		gridData1.horizontalSpan=6;
		gridData1.heightHint = 60;
		group2.setLayoutData(gridData1);		
		group2.setText("病人缴费及费用发生情况");

		GridLayout gridLayout1 = new GridLayout();
		gridLayout1.numColumns = 6;
	    group2.setLayout(gridLayout1); 
	    
		lblJFHJ = new Label(group2,SWT.None);
		lblJFHJ.setText("    缴费合计");
        

		txtJFHJ = new Text(group2,SWT.BORDER);
		txtJFHJ.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_BEGINNING));
        txtJFHJ.setEnabled(false);
        
		lblFYHJ = new Label(group2,SWT.None);
		lblFYHJ.setText("                 费用合计");
		
        
		txtFYHJ = new Text(group2,SWT.BORDER);
		txtFYHJ.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_BEGINNING));
		txtFYHJ.setEnabled(false);

		new Label(group2,SWT.None);
		new Label(group2,SWT.None);
        
		lblYT = new Label(group2,SWT.None);
		lblYT.setText("    应退");

		txtYT = new Text(group2,SWT.BORDER);
		txtYT.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_BEGINNING));
		txtYT.setEnabled(false);

		lblTXJ = new Label(group2,SWT.None);
		lblTXJ.setText("                 退现金");

		txtTXJ = new Text(group2,SWT.BORDER);
		txtTXJ.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_BEGINNING));
		

		lblTZP = new Label(group2,SWT.None);
		lblTZP.setText("            退支票");

	    txtTZP = new Text(group2,SWT.BORDER);
		txtTZP.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_BEGINNING));
		
 
}    
private void createTable(){
		
		//创建表格		
	    tblBRFY = new Table(shell,SWT.SINGLE | SWT.BORDER | SWT.FULL_SELECTION);
		
		//设置表格表头可见	
		tblBRFY.setHeaderVisible(true);
		
		//设置表框线可见
		tblBRFY.setLinesVisible(true);
					
		//设置表格显示格式
		GridData gridData1 = new GridData(GridData.FILL_BOTH);
		gridData1.horizontalSpan =6;
		tblBRFY.setLayoutData(gridData1);	
		//gridData1.heightHint = 15;	
		//定义表格列名
	    colBuild1();