frmbrcy.java

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

package myprojects.FrmBRCY;

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 myprojects.FrmBRCYDb.*;
import myprojects.FrmMenu.*;
import java.sql.*;

public class FrmBRCY{
	
	
	private String USERID = "";
	private String YYYF = "";      
	private String FYYF = "";	
	private String LFDH = ""; 
    private String RQ = "";
	private float ZJE = 0;
	private float tempJE = 0;                                
	private int bc = 1;   //判断保存按钮所在的不同情况
	int t;
	private myprojects.FrmBRCYDb.FrmBRCYDb Db=new myprojects.FrmBRCYDb.FrmBRCYDb();
	
	
	//创建数据库实例
	//private DB.nblfFRMdb db = new DB.nblfFRMdb();
	private Shell shell;
		
	//标签显示颜色
	private static Color colRed,colGreen;
	
	//表格
	private Table table;	
	private Group group;	
	private Label labelA,labelB;
	private Button buttonA,buttonB,buttonC;	
	
	private Text txtZYH;
	private Text txtBRXM;
	private Text txtZYKS;
	private Text txtCH;
	private Text txtRYRQ;
	private Text txtCYRQ;
	private Text txtJFHJ;
	private Text txtFYHJ;
	private Text txtBLH;
	private Text txtJBDM;	
	private Text txtBM;
	private Text txtCYZD;	
	private Combo comboZDYS;



	
	public static void main(){
		Display display = new Display();
		FrmBRCY brcy=new FrmBRCY();	
		
		//设置字体颜色
		colRed = new Color(display,255,0,0);
		colGreen = new Color(display,0,0,255);
		
		//创建整体框架	
		brcy.createShell();	
		brcy.shell.open();
		
		while(!brcy.shell.isDisposed()){
			if(!display.readAndDispatch())
				display.sleep();
		}
		display.dispose();
	}
	private void createShell(){
		shell = new Shell();
		shell.setBounds(240,230,655,480);
		shell.setText("病人出院");
		
		//设置布局方式
		GridLayout gridLayout = new GridLayout();
		
		//将shell分为7列
		gridLayout.numColumns = 6;
		shell.setLayout(gridLayout);
		
		//连接数据库
		try{
			Db.getConnection();
			System.out.println("数据库连接成功！");
		}
		catch(Exception e){
			System.out.println(e.getMessage());
		}
		//调用各方法、创建整体界面		
		createWidgets();
        createTable();
		createGroup();
		createButton(); 
		shell.open();
		
		
	}	
	
	
//===========================================================================	
	
	
	
	private void createWidgets(){
		
		//设置组件对齐方式
		GridData gridData0 = new GridData(GridData.HORIZONTAL_ALIGN_END);
		gridData0.horizontalSpan = 1;
		
		GridData gridData1 = new GridData(GridData.HORIZONTAL_ALIGN_END);		
		gridData1.horizontalSpan = 6;
		
		GridData gridData2 = new GridData(GridData.HORIZONTAL_ALIGN_END);		
		gridData2.horizontalSpan = 6;	
		

		//创建标签0
		
		Label lblBRCY = new Label(shell,SWT.CENTER);
		lblBRCY.setText("病人出院  ");
		lblBRCY.setLayoutData(gridData1);
		lblBRCY.setForeground(colGreen);
		

		


		Label lblZYH = new Label(shell,SWT.None);
		lblZYH.setText("住院号  ");
		lblZYH.setLayoutData(gridData0);
		lblZYH.setForeground(colGreen);
		
//住院号-----------------------------------------------------------------------


		GridData griddataa = new GridData(GridData.HORIZONTAL_ALIGN_FILL);		
		txtZYH = new Text(shell,SWT.BORDER);
		txtZYH.setText(USERID);
		txtZYH.setLayoutData(griddataa);	
		
		txtZYH.addSelectionListener(new SelectionAdapter(){
			public void widgetDefaultSelected(SelectionEvent e) {
				
				
				System.out.println(txtZYH.getText());
				Db.getBRCY(txtZYH.getText());
				try{
					while(Db.rs.next())
					{	
						String strZyks=Db.rs.getString("ZYKS");
						
						String strBch=Db.rs.getString("BCH");
						if(strBch==null)
							strBch="";
						txtZYKS.setText(strZyks);
					    txtCH.setText(strBch);
						txtRYRQ.setText(Db.rs.getString("RYRQ"));
						txtBLH.setText(Db.rs.getString("BLH"));
						

					}
				}
				catch(SQLException e1)
				{
				}	
					//System.out.println("ssssss");
					
		
			}		
		});
			
	txtZYH.addSelectionListener(new SelectionAdapter(){
			public void widgetDefaultSelected(SelectionEvent e) {
					
				System.out.println(txtZYH.getText());
				Db.getBRZYXX(txtZYH.getText());
				try{
					while(Db.rs.next())
					{
						txtBRXM.setText(Db.rs.getString("BRXM"));
					}
				}
				catch(SQLException e1)
				{
				}			
				}		
		});
		
//--------------------------------------------------------------------------
		

		Label lblBRXM = new Label(shell,SWT.None);
		lblBRXM.setText("病人姓名  ");
		lblBRXM.setForeground(colGreen);
		
		GridData brxm = new GridData(GridData.HORIZONTAL_ALIGN_FILL);		
		txtBRXM = new Text(shell,SWT.BORDER);
		txtBRXM.setText(USERID);
		txtBRXM.setLayoutData(brxm);	
		
		Label lblZYKS = new Label(shell,SWT.None);
		lblZYKS.setText("住院科室 ");
		lblZYKS.setForeground(colGreen);
				
		GridData zyks = new GridData(GridData.HORIZONTAL_ALIGN_FILL);		
		txtZYKS = new Text(shell,SWT.BORDER);
		txtZYKS.setText(USERID);
		txtZYKS.setLayoutData(zyks);	
		
		Label lblCH = new Label(shell,SWT.None);
		lblCH.setText("床号 ");
		lblCH.setForeground(colGreen);	
		
		GridData ch = new GridData(GridData.HORIZONTAL_ALIGN_FILL);		
		txtCH = new Text(shell,SWT.BORDER);
		txtCH.setText(USERID);
		txtCH.setLayoutData(ch);	
		
		
		Label lblRYRQ = new Label(shell,SWT.None);
		lblRYRQ.setText("入院日期 ");
		lblRYRQ.setForeground(colGreen);	
		
		GridData ryrq = new GridData(GridData.HORIZONTAL_ALIGN_FILL);		
		txtRYRQ = new Text(shell,SWT.BORDER);
		txtRYRQ.setText(USERID);
		txtRYRQ.setLayoutData(ryrq);	
				

		Label lblCYRQ = new Label(shell,SWT.None);
		lblCYRQ.setText("出院日期 ");
		lblCYRQ.setForeground(colGreen);
		
		GridData cyrq = new GridData(GridData.HORIZONTAL_ALIGN_FILL);		
		txtCYRQ = new Text(shell,SWT.BORDER);
		txtCYRQ.setText(USERID);
		txtCYRQ.setLayoutData(cyrq);
		
		txtCYRQ.setText(Db.getNowDate());
 
 
 //设置group布局	--------------------------------------------------
 
		
     	group = new Group(shell,SWT.SHADOW_ETCHED_IN);
        GridData gridData=new GridData(GridData.FILL_HORIZONTAL);
        group.setLayoutData(gridData);
		group.setText("病人缴费及费用发生情况");
		

		GridLayout gridLayout = new GridLayout();
		
		gridLayout.numColumns=4;
		gridData.horizontalSpan=6; 
		group.setLayout(gridLayout);
		
		

		Label lblJFHJ = new Label(group,SWT.None);
		lblJFHJ.setText("缴费合计 ");
		lblJFHJ.setForeground(colGreen);
		
		
		GridData jfhj = new GridData(GridData.HORIZONTAL_ALIGN_FILL);		
		txtJFHJ = new Text(group,SWT.BORDER);
		txtJFHJ.setText(USERID);
		txtJFHJ.setLayoutData(jfhj);
		
		
			
		
		Label lblFYHJ = new Label(group,SWT.None);
		lblFYHJ.setText("费用合计 ");
		lblFYHJ.setForeground(colGreen);	
		
		
		GridData fyhj = new GridData(GridData.HORIZONTAL_ALIGN_FILL);		
		txtFYHJ = new Text(group,SWT.BORDER);
		txtFYHJ.setText(USERID);
		txtFYHJ.setLayoutData(fyhj);
		
		
		Label label9 = new Label(shell,SWT.None);
		label9.setText(" ");
		label9.setForeground(colGreen);	
		
		
		Label label10 = new Label(shell,SWT.None);
		label10.setText(" ");
		label10.setForeground(colGreen);
		
					
		
		txtBRXM.setEnabled(false);
		txtZYKS.setEnabled(false);
		txtCH.setEnabled(false);
		txtRYRQ.setEnabled(false);
		txtCYRQ.setEnabled(false);
		txtJFHJ.setEnabled(false);
		txtFYHJ.setEnabled(false);		
		
		
			
		
			
      		   	
   }
   
   
   
// 创建表格====================================================================
   
   
   
   	private void createTable(){
		
		//创建表格		
		table = new Table(shell,SWT.SINGLE | SWT.BORDER | SWT.FULL_SELECTION);
		
		//设置表格表头可见	
		table.setHeaderVisible(true);
		
		//设置表框线可见
		table.setLinesVisible(true);
					
		//设置表格显示格式
		GridData gridData2 = new GridData(GridData.FILL_BOTH);
		gridData2.horizontalSpan = 6;
		table.setLayoutData(gridData2);	
		
		setTableBrfy();
		
		
		//创建单选按钮
		final Button radioBRFY =  new Button(shell,SWT.RADIO);
		radioBRFY.setText("病人费用");
		radioBRFY.setSelection(true);
		
//		radio1.addSelectionListener()
		
		
		Button radioBRJF = new Button(shell,SWT.RADIO);
		radioBRJF.setText("病人缴费");	
		
		
		Button radioJBDM = new Button(shell,SWT.RADIO);
		radioJBDM.setText("疾病代码");
		
		
		
//病人费用 ====================================================================	

	
		
		radioBRFY.addSelectionListener(new SelectionAdapter() {
      		public void widgetSelected(SelectionEvent event) {
      			
      		 t=1;	
      			
      		table.removeAll();
      		setTableBrfy();	
      			TableColumn[] columns = table.getColumns();
   				for(int i=0;i<columns.length;i++){
   					columns[i].dispose();
   				}
   				String[] columns1={
   						  "发生日期",
						  "所在科室",
						  "科目",						  
						  "单价",
						  "数量",
						  "记价单位",
						  "金额",
						  };
						  		
				//添加表格第一列		
				TableColumn col11 = new TableColumn(table,SWT.LEFT);
				col11.setText(columns1[0]);
				col11.setWidth(100);
				//循环添加表格的后面各列
				for(int i=1;i<7;i++){		
					TableColumn colTotal = new TableColumn(table,SWT.LEFT);
					colTotal.setText(columns1[i]);
					colTotal.setWidth(80);
				}	


			System.out.println(txtZYH.getText());
     		Db.getWJZFY(txtZYH.getText());
     		
      		try{
      		    while(Db.rs.next())
      		    {
       			 TableItem item2 = new TableItem(table,0);
       			 
       			String strZYH = Db.rs.getString("ZYH"); 
       			String strCFRQ = Db.rs.getString("CFRQ");
       			String strZYKS = Db.rs.getString("ZYKS");
       			String strKM = Db.rs.getString("KM");
       			float DJ = Db.rs.getFloat("DJ");
       			int SL = Db.rs.getInt("SL");
       			String strJJDW = Db.rs.getString("JJDW");
                
      			item2.setData("ZYH index",strZYH);
      			System.out.println(strZYH);
      			
      			
     			item2.setText(new String[]{
     	    		strCFRQ,
      	    		strZYKS,
      	    	    strKM,    	
      	         	String.valueOf(DJ),
      	    	    String.valueOf(SL),
			    	strJJDW,
			    	String.valueOf(DJ*SL)
			    	
//      	    	    Db.rs.getString("JJDW"), 
      			});
      		}
      		}
      		
      		    catch(Exception e) {
      		    	}
      		
      		   // int =table.getItemCount();	
      		    float Fyhj=0; 	
      		    
      		    for (int i=0;i<table.getItemCount();i++)	{
      		    	Fyhj+=Float.valueOf(table.getItem(i).getText(6)).floatValue();
      		    }
      		    txtFYHJ.setText(String.valueOf(Fyhj));
   
      		}
    	});
 
    	
  //  病人缴费=========================================================