📄 frmbrcx.java
字号:
btnCX.setText("查询");
btnCX.setLayoutData(gridDataCX);
btnCX.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent event) {
table.removeAll();
rdoBRMD.setSelection(true);
rdoBRJF.setSelection(false);
rdoBRFY.setSelection(false);
for(int i=0;i<=15;i++) {
colTotal[i].setText(columns_namesMD[i]);
}
// When the button is clicked, events happens.
CXBR();
}
});
//创建《放弃钮，设置布局方式
GridData gridDataFQ = new GridData(GridData.HORIZONTAL_ALIGN_CENTER);
Button btnFQ = new Button(shell,SWT.None);
btnFQ.setText("放弃");
btnFQ.setLayoutData(gridDataFQ);
btnFQ.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent event) {
table.removeAll();
rdoBRMD.setSelection(false);
rdoBRJF.setSelection(false);
rdoBRFY.setSelection(false);
for(int i=0;i<=15;i++){
colTotal[i].setText(columns_namesMD[i]);
}
//设置每列的宽度
colTotal[0].setWidth(20);
colTotal[1].setWidth(120);
colTotal[2].setWidth(120);
colTotal[3].setWidth(80);
colTotal[4].setWidth(80);
colTotal[5].setWidth(80);
colTotal[6].setWidth(120);
colTotal[7].setWidth(80);
colTotal[8].setWidth(80);
colTotal[9].setWidth(120);
colTotal[10].setWidth(120);
colTotal[11].setWidth(80);
colTotal[12].setWidth(120);
colTotal[13].setWidth(120);
colTotal[14].setWidth(120);
colTotal[15].setWidth(120);
}
});
//创建《返回钮，设置布局方式
GridData gridDataFH = new GridData(GridData.HORIZONTAL_ALIGN_CENTER);
Button btnFH = new Button(shell,SWT.None);
btnFH.setText("返回");
btnFH.setLayoutData(gridDataFH);
btnFH.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent event) {
shell.getDisplay().dispose();
shell.dispose();
FrmMenu.main();
return;
}
});
}
private void addRadioListener(final Button radio) {
radio.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent e){
//选中"病人名单"
if (radio.getText().equals("病人名单")) {
table.removeAll();
rdoBRMD.setSelection(true);
rdoBRJF.setSelection(false);
rdoBRFY.setSelection(false);
for(int i=0;i<=15;i++){
colTotal[i].setText(columns_namesMD[i]);
}
//设置每列的宽度
colTotal[0].setWidth(20);
colTotal[1].setWidth(120);
colTotal[2].setWidth(120);
colTotal[3].setWidth(80);
colTotal[4].setWidth(80);
colTotal[5].setWidth(80);
colTotal[6].setWidth(120);
colTotal[7].setWidth(80);
colTotal[8].setWidth(80);
colTotal[9].setWidth(120);
colTotal[10].setWidth(120);
colTotal[11].setWidth(80);
colTotal[12].setWidth(120);
colTotal[13].setWidth(120);
colTotal[14].setWidth(120);
colTotal[15].setWidth(120);
}
//选中"病人费用"
else if(radio.getText().equals("病人费用")) {
table.removeAll();
rdoBRMD.setSelection(false);
rdoBRJF.setSelection(false);
rdoBRFY.setSelection(true);
for(int i=0;i<=15;i++) {
colTotal[i].setText(columns_namesFY[i]);
}
//设置每列的宽度
colTotal[0].setWidth(20);
colTotal[1].setWidth(150);
colTotal[2].setWidth(120);
colTotal[3].setWidth(80);
colTotal[4].setWidth(80);
colTotal[5].setWidth(80);
colTotal[6].setWidth(80);
colTotal[7].setWidth(80);
colTotal[8].setWidth(80);
colTotal[9].setWidth(80);
colTotal[10].setWidth(80);
colTotal[11].setWidth(120);
colTotal[12].setWidth(120);
colTotal[13].setWidth(80);
colTotal[14].setWidth(80);
colTotal[15].setWidth(0);
//计算查询到的数目
try {
int rsCount = Db.getDataFY(ZYH);
if(rsCount>0){
int n = 1;
while(Db.rsFY.next()){
//创建行
TableItem item = new TableItem(table,0);
//设置当前行的内容
item.setText(new String[] {
String.valueOf(n),
Db.rsFY.getString("CFRQ"),
Db.rsFY.getString("KM"),
Db.rsFY.getString("SUM"),
Db.rsFY.getString("DJ"),
Db.rsFY.getString("SL"),
Db.rsFY.getString("ZYKS"),
Db.rsFY.getString("JJDW"),
Db.rsFY.getString("GG"),
Db.rsFY.getString("KMLB"),
Db.rsFY.getString("XMFL"),
Db.rsFY.getString("ZFBL"),
Db.rsFY.getString("ZYH"),
Db.rsFY.getString("CD"),
Db.rsFY.getString("CJ"),
});
n++;
}
}
else if(rsCount<0){
MessageBox msBox = new MessageBox(shell,SWT.ICON_ERROR);
msBox.setText("错误");
msBox.setMessage("病人没有费用数据!");
msBox.open();
}
else{
MessageBox msBox = new MessageBox(shell,SWT.ICON_ERROR);
msBox.setText("错误");
msBox.setMessage("查询语句出错，请仔细检查!");
msBox.open();
}
}
catch(Exception event) {
System.err.println(event.getMessage());
}
}
//选中"病人缴费"
else {
if(radio.getText().equals("病人缴费")){
table.removeAll();
rdoBRMD.setSelection(false);
rdoBRJF.setSelection(true);
rdoBRFY.setSelection(false);
for(int i=0;i<=15;i++) {
colTotal[i].setText(columns_namesJF[i]);
}
//设置每列的宽度
colTotal[0].setWidth(20);
colTotal[1].setWidth(150);
colTotal[2].setWidth(120);
colTotal[3].setWidth(80);
colTotal[4].setWidth(120);
colTotal[5].setWidth(80);
colTotal[6].setWidth(0);
colTotal[7].setWidth(0);
colTotal[8].setWidth(0);
colTotal[9].setWidth(0);
colTotal[10].setWidth(0);
colTotal[11].setWidth(0);
colTotal[12].setWidth(0);
colTotal[13].setWidth(0);
colTotal[14].setWidth(0);
colTotal[15].setWidth(0);
try {
int rsCount = Db.getDataJF(ZYH);
if(rsCount>0) {
int n = 1;
while(Db.rsJF.next()){
//创建行
TableItem item = new TableItem(table,0);
//设置当前行的内容
item.setText(new String[] {
String.valueOf(n),
Db.rsJF.getString("JFRQ"),
Db.rsJF.getString("SFY"),
Db.rsJF.getString("JE"),
Db.rsJF.getString("ZYH"),
Db.rsJF.getString("JFXS"),
});
n++;
}
}
else if(rsCount<0){
MessageBox msBox = new MessageBox(shell,SWT.ICON_ERROR);
msBox.setText("错误");
msBox.setMessage("病人没有交费数据!");
msBox.open();
}
else{
MessageBox msBox = new MessageBox(shell,SWT.ICON_ERROR);
msBox.setText("错误");
msBox.setMessage("查询语句出错，请仔细检查!");
msBox.open();
}
}
catch(Exception event) {
System.err.println(event.getMessage());
}
}
}
}
public void widgetDefaultSelected( SelectionEvent e){
widgetSelected(e);
}
});
}
public void CXBR(){
table.removeAll();
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 {
//从药品信息表中取得数据
//查询到的信息条目数
int rsCount = Db.getDataMD(BrList);
if(rsCount>0){
//移动动态集里的光标直至结束
int n = 1;
while(Db.rs.next()){
//创建行
TableItem item = new TableItem(table,0);
//设置当前行的内容
item.setText(new String[] {
String.valueOf(n),
Db.rs.getString("ZYH"),
Db.rs.getString("BLH"),
Db.rs.getString("BRXM"),
Db.rs.getString("BRXB"),
Db.rs.getString("CSNY"),
Db.rs.getString("SFZH"),
Db.rs.getString("ZYKS"),
Db.rs.getString("BCH"),
Db.rs.getString("BRDH"),
Db.rs.getString("BRDZ"),
Db.rs.getString("LXRXM"),
Db.rs.getString("LXRDH"),
Db.rs.getString("LXRDZ"),
Db.rs.getString("RYRQ"),
Db.rs.getString("CYRQ"),
});
n++;
}
}
else if(rsCount<0){
MessageBox msBox = new MessageBox(shell,SWT.ICON_ERROR);
msBox.setText("错误");
msBox.setMessage("没有你所要查询病人!");
msBox.open();
}
else{
MessageBox msBox = new MessageBox(shell,SWT.ICON_ERROR);
msBox.setText("错误");
msBox.setMessage("查询语句出错，请仔细检查!");
msBox.open();
}
}
catch(Exception e) {
System.err.println(e.getMessage());
}
}
} ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -