frmblcx.java

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

package myprojects.FrmBlcx;

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 db.FrmBlcxDb.*;
import myprojects.FrmMenu.*;

public class FrmBlcx
{
	private static Shell shell;
	private static FrmBlcxDb db = new FrmBlcxDb();
	
	private Table tblBRXX;
	private Table tblBLXX;
	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 Label lblA;
	private Label lblB;

	private Button btnQuery;
	private Button btnGiveup;
	private Button btnBack;
									

	public static void main() {
		Display display = new Display();
		shell = new Shell(display);
        FrmBlcx item = new FrmBlcx();
	
		GridLayout gl = new GridLayout();
		gl.numColumns = 6;
		//设置间距，
		gl.horizontalSpacing = -20;
		shell.setLayout(gl);
		shell.setSize(800,600);
		shell.setText("查询历次诊断病历");

		
		
		 //创建数据库连接
        if(!db.getConnection())
        {
            MessageBox msBox = new MessageBox(shell,SWT.OK|SWT.ICON_ERROR);
            msBox.setText("错误");
            msBox.setMessage("数据库连接出错");
            msBox.open();
            return;
        }

		
		//创建表单控件
        item.createText();
		//创建病人信息表
        item.createTblBRXX();
		//创建病历信息表
        item.createTblBLXX();
		//创建动作按扭
        item.createButton();

		shell.open();
		while(!shell.isDisposed())
		{
			if(!display.readAndDispatch())
				display.sleep();
		}
		display.dispose();
		db.closeDB();
	}
	
	
	private void createText() {
		Color clrLabel = new Color(shell.getDisplay(),new RGB(40,25,231));
		
/*----------------第一行--------------------------------------------------------------------*/
		GridData gridData1 = new GridData(GridData.GRAB_HORIZONTAL|GridData.HORIZONTAL_ALIGN_CENTER);
		Label lblZYH = new Label(shell,SWT.None);
		lblZYH.setForeground(clrLabel);
		lblZYH.setLayoutData(gridData1);
		lblZYH.setText("住院号：");
		
		GridData gridData2 = new GridData(GridData.FILL_HORIZONTAL);
		txtZYH = new Text(shell,SWT.BORDER);
		txtZYH.setLayoutData(gridData2);
		txtZYH.setText("");
		//捕获按键为Enter键的时候
		txtZYH.addKeyListener(new KeyAdapter () {
        public void keyPressed(KeyEvent e) {
            if (e.keyCode ==SWT.CR | e.keyCode ==SWT.KEYPAD_CR) {
            	prtBrxx();
            }
          }
        });
		
		GridData gridData3 = new GridData(GridData.GRAB_HORIZONTAL|GridData.HORIZONTAL_ALIGN_CENTER);
		Label lblBLH = new Label(shell,SWT.None);
		lblBLH.setForeground(clrLabel);	
		lblBLH.setLayoutData(gridData3);
		lblBLH.setText("病历号：");
		
		GridData gridData4 = new GridData(GridData.FILL_HORIZONTAL);
		txtBLH = new Text(shell,SWT.BORDER);
		txtBLH.setLayoutData(gridData4);
		txtBLH.setText("");
		//捕获按键为Enter键的时候
		txtBLH.addKeyListener(new KeyAdapter () {
        public void keyPressed(KeyEvent e) {
            if (e.keyCode ==SWT.CR | e.keyCode ==SWT.KEYPAD_CR) {
            	prtBrxx();
            }
          }
        });

		GridData gridData5 = new GridData(GridData.GRAB_HORIZONTAL|GridData.HORIZONTAL_ALIGN_CENTER);
		Label lblBRXM = new Label(shell,SWT.None);
		lblBRXM.setForeground(clrLabel);
		lblBRXM.setLayoutData(gridData5);
		lblBRXM.setText("病人姓名：");
		
		GridData gridData6 = new GridData(GridData.FILL_HORIZONTAL);
		txtBRXM = new Text(shell,SWT.BORDER);
		txtBRXM.setLayoutData(gridData6);
		txtBRXM.setText("");
		//捕获按键为Enter键的时候
		txtBRXM.addKeyListener(new KeyAdapter () {
        public void keyPressed(KeyEvent e) {
            if (e.keyCode ==SWT.CR | e.keyCode ==SWT.KEYPAD_CR) {
            	prtBrxx();
            }
          }
        });

/*----------------第二行--------------------------------------------------------------------*/		
		GridData gridData7 = new GridData(GridData.GRAB_HORIZONTAL|GridData.HORIZONTAL_ALIGN_CENTER);
		Label lblBRXB = new Label(shell,SWT.None);
		lblBRXB.setForeground(clrLabel);
		lblBRXB.setLayoutData(gridData7);
		lblBRXB.setText("病人性别：");

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

		GridData gridData9 = new GridData(GridData.GRAB_HORIZONTAL|GridData.HORIZONTAL_ALIGN_CENTER);
		Label lblCSNY = new Label(shell,SWT.None);
		lblCSNY.setForeground(clrLabel);
		lblCSNY.setLayoutData(gridData9);
		lblCSNY.setText("出生年月：");

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

		GridData gridData11 = new GridData(GridData.GRAB_HORIZONTAL|GridData.HORIZONTAL_ALIGN_CENTER);
		Label lblSFZH = new Label(shell,SWT.None);
		lblSFZH.setForeground(clrLabel);
		lblSFZH.setLayoutData(gridData11);
		lblSFZH.setText("身份证号：");

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

/*----------------第三行--------------------------------------------------------------------*/				
		GridData gridData13 = new GridData(GridData.GRAB_HORIZONTAL|GridData.HORIZONTAL_ALIGN_CENTER);
		Label lblZYKS = new Label(shell,SWT.None);
		lblZYKS.setForeground(clrLabel);
		lblZYKS.setLayoutData(gridData13);
		lblZYKS.setText("住院科室：");

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

		GridData gridData15 = new GridData(GridData.GRAB_HORIZONTAL|GridData.HORIZONTAL_ALIGN_CENTER);
		Label lblBCH = new Label(shell,SWT.None);
		lblBCH.setForeground(clrLabel);
		lblBCH.setLayoutData(gridData15);
		lblBCH.setText("病床号：");

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

		GridData gridData17 = new GridData(GridData.GRAB_HORIZONTAL|GridData.HORIZONTAL_ALIGN_CENTER);
		Label lblBRDH = new Label(shell,SWT.None);
		lblBRDH.setForeground(clrLabel);
		lblBRDH.setLayoutData(gridData17);
		lblBRDH.setText("病人电话：");

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

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

		GridData gridData21 = new GridData(GridData.GRAB_HORIZONTAL|GridData.HORIZONTAL_ALIGN_CENTER);
		Label lblLXRXM = new Label(shell,SWT.None);
		lblLXRXM.setForeground(clrLabel);
		lblLXRXM.setLayoutData(gridData21);
		lblLXRXM.setText("联系人姓名：");

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

		GridData gridData23 = new GridData(GridData.GRAB_HORIZONTAL|GridData.HORIZONTAL_ALIGN_CENTER);
		Label lblLXRDH = new Label(shell,SWT.None);
		lblLXRDH.setForeground(clrLabel);
		lblLXRDH.setLayoutData(gridData23);
		lblLXRDH.setText("联系人电话：");