?? 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 + -