frmblcx.java

用JAVA SWT编写的住院管理系统。用SQLServer数据库

		GridData gridData24 = new GridData(GridData.FILL_HORIZONTAL);
		txtLXRDH = new Text(shell,SWT.BORDER);
		txtLXRDH.setLayoutData(gridData24);
		txtLXRDH.setText("");
		//捕获按键为Enter键的时候
		txtLXRDH.addKeyListener(new KeyAdapter () {
        public void keyPressed(KeyEvent e) {
            if (e.keyCode ==SWT.CR | e.keyCode ==SWT.KEYPAD_CR) {
            	prtBrxx();
            }
          }
        });
		
/*----------------第五行--------------------------------------------------------------------*/				
		GridData gridData25 = new GridData(GridData.GRAB_HORIZONTAL|GridData.HORIZONTAL_ALIGN_CENTER);
		Label lblLXRDZ = new Label(shell,SWT.None);
		lblLXRDZ.setForeground(clrLabel);
		lblLXRDZ.setLayoutData(gridData25);
		lblLXRDZ.setText("联系人地址：");

		GridData gridData26 = new GridData(GridData.FILL_HORIZONTAL);
		txtLXRDZ = new Text(shell,SWT.BORDER);
		txtLXRDZ.setLayoutData(gridData26);
		txtLXRDZ.setText("");
		//捕获按键为Enter键的时候
		txtLXRDZ.addKeyListener(new KeyAdapter () {
        public void keyPressed(KeyEvent e) {
            if (e.keyCode ==SWT.CR | e.keyCode ==SWT.KEYPAD_CR) {
            	prtBrxx();
            }
          }
        });

		GridData gridData27 = new GridData(GridData.GRAB_HORIZONTAL|GridData.HORIZONTAL_ALIGN_CENTER);
		Label lblRYRQ = new Label(shell,SWT.None);
		lblRYRQ.setForeground(clrLabel);
		lblRYRQ.setLayoutData(gridData27);
		lblRYRQ.setText("入院日期：");

		GridData gridData28 = new GridData(GridData.FILL_HORIZONTAL);
		txtRYRQ = new Text(shell,SWT.BORDER);
		txtRYRQ.setLayoutData(gridData28);
		txtRYRQ.setText("");
		//捕获按键为Enter键的时候
		txtRYRQ.addKeyListener(new KeyAdapter () {
        public void keyPressed(KeyEvent e) {
            if (e.keyCode ==SWT.CR | e.keyCode ==SWT.KEYPAD_CR) {
            	prtBrxx();
            }
          }
        });

		GridData gridData29 = new GridData(GridData.GRAB_HORIZONTAL|GridData.HORIZONTAL_ALIGN_CENTER);
		Label lblCYRQ = new Label(shell,SWT.None);
		lblCYRQ.setForeground(clrLabel);
		lblCYRQ.setLayoutData(gridData29);
		lblCYRQ.setText("出院日期：");

		GridData gridData30 = new GridData(GridData.FILL_HORIZONTAL);
		txtCYRQ = new Text(shell,SWT.BORDER);
		txtCYRQ.setLayoutData(gridData30);
		txtCYRQ.setText("");
		//捕获按键为Enter键的时候
		txtCYRQ.addKeyListener(new KeyAdapter () {
        public void keyPressed(KeyEvent e) {
            if (e.keyCode ==SWT.CR | e.keyCode ==SWT.KEYPAD_CR) {
            	prtBrxx();
            }
          }
        });
        clrLabel.dispose();
	}


private void createTblBRXX(){
		
		//创建表格		
		tblBRXX = new Table(shell,SWT.SINGLE | SWT.BORDER | SWT.FULL_SELECTION);
		
		//设置表格表头可见	
		tblBRXX.setHeaderVisible(true);
		
		//设置表框线可见
		tblBRXX.setLinesVisible(true);
					
		//设置表格显示格式
		GridData gridData1 = new GridData(GridData.FILL_BOTH);
		gridData1.horizontalSpan = 6;
		tblBRXX.setLayoutData(gridData1);	
			
		//定义表格列名
		String[] columns={" ",
						  "病历号",
						  "病人姓名",
						  "身份证号",
						  "病人地址",
						  "联系人电话",
						  "住院号"};
						  		
		//添加表格第一列		
		TableColumn col1 = new TableColumn(tblBRXX,SWT.LEFT);
		col1.setText(columns[0]);
		col1.setWidth(50);	
			
		//循环添加表格的后面各列
		for(int i=1;i<7;i++){		
			TableColumn colTotal = new TableColumn(tblBRXX,SWT.LEFT);
			colTotal.setText(columns[i]);
			colTotal.setWidth(120);
		}
		
		 //添加双击行的监听器		
   		 tblBRXX.addSelectionListener(new SelectionAdapter() {		
    	 public void widgetDefaultSelected(SelectionEvent e) {	
    		//获得当前的选中行
 			TableItem[] items = tblBRXX.getSelection();
 			if (items.length == 0) return;
 			//双击事件
 			try {
 			int countBlxx=1;
 			tblBLXX.removeAll();
 			String msgBlxx = db.getBlxx((String)items[0].getText(1));
       		if (msgBlxx == "error") {			
    		MessageBox messageBox = new MessageBox(shell,SWT.OK|SWT.ICON_ERROR);			
    		messageBox.setText("错误！");			
    		messageBox.setMessage("查询病历信息出错");
    		messageBox.open();
    		return;
			}
 			while(db.rsBlxx.next()){
 				TableItem itemBLXX = new TableItem(tblBLXX,0);	
                itemBLXX.setText(new String[]{
                String.valueOf(countBlxx),
                db.rsBlxx.getString("ZDRQ"),
                db.rsBlxx.getString("JBDM"),
                db.rsBlxx.getString("ZDYS"),
                db.rsBlxx.getString("ZD"),
                db.rsBlxx.getString("SFRCY"),
                });
                countBlxx++;
             //System.out.println(BLH);
            }
            }
            catch(Exception se) {		
    			System.err.println(se.getMessage());	
    			}
    	}
    	});		

	}

private void createTblBLXX(){
		
		//创建表格		
		tblBLXX = new Table(shell,SWT.SINGLE | SWT.BORDER | SWT.FULL_SELECTION);
		//设置表格表头可见	
		tblBLXX.setHeaderVisible(true);
		//设置表框线可见
		tblBLXX.setLinesVisible(true);
		//设置表格显示格式
		GridData gridData1 = new GridData(GridData.FILL_BOTH);
		gridData1.horizontalSpan = 6;
		tblBLXX.setLayoutData(gridData1);
		//定义表格列名
		String[] columns={" ",
						  "诊断日期",
						  "ICD号码",
						  "疾病代码",
						  "诊断医师",
						  "是否出院诊断",
						  "备注"};
						  		
		//添加表格第一列		
		TableColumn col1 = new TableColumn(tblBLXX,SWT.LEFT);
		col1.setText(columns[0]);
		col1.setWidth(50);	
			
		//循环添加表格的后面各列
		for(int i=1;i<7;i++){		
			TableColumn colTotal = new TableColumn(tblBLXX,SWT.LEFT);
			colTotal.setText(columns[i]);
			colTotal.setWidth(120);
		}
	}
	
	
	private void createButton(){
		
				
		//创建shell底部标签及按钮
		
		GridData gridData999 = new GridData(GridData.HORIZONTAL_ALIGN_CENTER);
		lblB = new Label(shell,SWT.None);
		lblB.setLayoutData(gridData999);
		
		btnQuery = new Button(shell,SWT.None);
		btnQuery.setText("查询");
		//btnQuery.setFocus();
   		btnQuery.addSelectionListener(	
    	//Adapter适配器作为接口
    	new SelectionAdapter()
        {	
    	//使用widgetSelected方法 发生事件e
    	public void widgetSelected(SelectionEvent e)
    	{   
    	    prtBrxx();		

    	}
    });
    	

		
		btnGiveup = new Button(shell,SWT.None);
		btnGiveup.setText("放弃");
        btnGiveup.setEnabled(true);
		btnGiveup.addSelectionListener(	
    	//Adapter适配器作为接口
    	new SelectionAdapter()
        {	
    	//使用widgetSelected方法 发生事件e
    	public void widgetSelected(SelectionEvent e)
    	{
    	tblBRXX.removeAll();
    	tblBLXX.removeAll();
    	txtZYH.setText("");
		txtBLH.setText("");
		txtBRXM.setText("");
		txtBRXB.setText("");
		txtCSNY.setText("");
		txtSFZH.setText("");
		txtZYKS.setText("");
		txtBCH.setText("");
		txtBRDH.setText("");
		txtBRDZ.setText("");
		txtLXRXM.setText("");
		txtLXRDH.setText("");
		txtLXRDZ.setText("");
		txtRYRQ.setText("");
		txtCYRQ.setText("");
    		}});
		
		
		btnBack = new Button(shell,SWT.None);
		btnBack.setText("返回");
		btnBack.addSelectionListener(new SelectionAdapter(){
		//添加"返回"按钮监听器
		//返回菜单
		public void widgetSelected(SelectionEvent event){
                shell.getDisplay().dispose();
                shell.dispose();
                FrmMenu.main();
                return;			
			
			}
		});
	} 



public void prtBrxx(){
		String[] BrList = new String[15];
 			BrList[0]=txtZYH.getText();
 			BrList[1]=txtBLH.getText();
 			BrList[2]=txtBRXM.getText();
 			BrList[3]=txtBRXB.getText();
 			BrList[4]=txtCSNY.getText();
 			BrList[5]=txtSFZH.getText();
 			BrList[6]=txtZYKS.getText();
 			BrList[7]=txtBCH.getText();
 			BrList[8]=txtBRDH.getText();
 			BrList[9]=txtBRDZ.getText();
 			BrList[10]=txtLXRXM.getText();
 			BrList[11]=txtLXRDH.getText();
 			BrList[12]=txtLXRDZ.getText();
 			BrList[13]=txtRYRQ.getText();
 			BrList[14]=txtCYRQ.getText();
 			try {
 			tblBRXX.removeAll();
    		int countBrxx=1;
       		String msgBrxx = db.getBrxx(BrList);
       		if (msgBrxx == "error") {			
    		MessageBox messageBox = new MessageBox(shell,SWT.OK|SWT.ICON_ERROR);			
    		messageBox.setText("错误！");			
    		messageBox.setMessage("查询病人信息出错");
    		messageBox.open();
    		return;
			}
    		while(db.rsBrxx.next()){
                TableItem itemBRXX = new TableItem(tblBRXX,0);	
                //设置当前行的内容  (取得当前行内容为tblBRXX.getText())	
                itemBRXX.setText(new String[]{	
                String.valueOf(countBrxx),
               	db.rsBrxx.getString("BLH"),
                db.rsBrxx.getString("BRXM"),
                db.rsBrxx.getString("SFZH"),
                db.rsBrxx.getString("BRDZ"),		
               	db.rsBrxx.getString("LXRDH"),
            	db.rsBrxx.getString("ZYH"),
            		
            });
            countBrxx++;
           }
          }
            catch(Exception se) {		
    			System.err.println(se.getMessage());	
    			}		

}
}