?? frmbrjz.java
字號(hào):
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("病人結(jié)帳");
//設(shè)置布局方式
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;
//定義一個(gè)標(biāo)簽
lblSFY = new Label(shell, SWT.None);
//應(yīng)用布局方案
lblSFY.setLayoutData(gridData15);
//顯示內(nèi)容
lblSFY.setText(" 收費(fèi)員");
//顯示true/隱藏false
lblSFY.setVisible(true);
txtSFY = new Text(shell, SWT.BORDER);
//應(yīng)用布局方案
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占用兩個(gè)格子
gridData3.horizontalSpan = 2;
//GridData占用格子高度為10
gridData3.verticalSpan = 11;
//定義一個(gè)標(biāo)簽
lblBRJZ = new Label(shell, SWT.None);
//應(yīng)用布局方案
lblBRJZ.setLayoutData(gridData3);
//顯示內(nèi)容
lblBRJZ.setText(" 病人結(jié)帳");
//改變字體顏色
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;
//定義一個(gè)標(biāo)簽
lblDQSJ = new Label(shell, SWT.None);
//應(yīng)用布局方案
lblDQSJ.setLayoutData(gridData4);
//顯示內(nèi)容
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(" 住院號(hào)");
//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(" 床號(hào)");
//顯示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);
//設(shè)置group顯示格式
GridData gridData0 = new GridData(GridData.HORIZONTAL_ALIGN_END);
gridData0.horizontalSpan=2;
gridData0.heightHint = 20;
gridData0.widthHint =120;
group1.setLayoutData(gridData0);
//設(shè)置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("病人繳費(fèi)及費(fèi)用發(fā)生情況");
GridLayout gridLayout1 = new GridLayout();
gridLayout1.numColumns = 6;
group2.setLayout(gridLayout1);
lblJFHJ = new Label(group2,SWT.None);
lblJFHJ.setText(" 繳費(fèi)合計(jì)");
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(" 費(fèi)用合計(jì)");
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(" 應(yīng)退");
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(" 退現(xiàn)金");
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(){
//創(chuàng)建表格
tblBRFY = new Table(shell,SWT.SINGLE | SWT.BORDER | SWT.FULL_SELECTION);
//設(shè)置表格表頭可見
tblBRFY.setHeaderVisible(true);
//設(shè)置表框線可見
tblBRFY.setLinesVisible(true);
//設(shè)置表格顯示格式
GridData gridData1 = new GridData(GridData.FILL_BOTH);
gridData1.horizontalSpan =6;
tblBRFY.setLayoutData(gridData1);
//gridData1.heightHint = 15;
//定義表格列名
colBuild1();
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -