?? frmypxm.java
字號:
Label labelCD = new Label(group,SWT.None);
labelCD.setText(" 產地 ");
ComboCD = new Combo(group,SWT.BORDER);
getCmb(ComboCD,"CD");
ComboCD.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
new Label(group,SWT.None);
Label labelCJ = new Label(group,SWT.None);
labelCJ.setText(" 廠家 ");
ComboCJ = new Combo(group,SWT.BORDER);
getCmb(ComboCJ,"CJ");
ComboCJ.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
Label labelBZ = new Label(group,SWT.None);
labelBZ.setText(" 備注 ");
textBZ = new Text(group,SWT.BORDER);
textBZ.setLayoutData(new GridData(GridData.HORIZONTAL_ALIGN_FILL));
new Label(group,SWT.None);
GridData gridData1 = new GridData(GridData.FILL_HORIZONTAL);
gridData1.horizontalSpan = 4;
Label label12 = new Label(group,SWT.None);
label12.setLayoutData(gridData1);
GridData gridData2 = new GridData(GridData.HORIZONTAL_ALIGN_END);
button1 = new Button(group,SWT.None);
button1.setText("保存");
button1.setLayoutData(gridData2);
button1.setEnabled(false);
//保存按鈕監聽器
button1.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent e) {
save();
table.removeAll();
addTableData();
}
});
button2 = new Button(group,SWT.None);
button2.setText("放棄");
button2.setEnabled(false);
button2.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent e) {
getNumber();
txtYPNBDM.setEditable(true);
txtYPFN.setText("");
textYM.setText("");
textGG.setText("");
ComboCD.setText("");
ComboCJ.setText("");
textYPSR.setText("");
comboJJDW.setText("");
textYPDJ.setText("");
ComboJX.setText("");
textZFBL.setText("");
textYPWM.setText("");
textBZ.setText("");
}
});
button3 = new Button(group,SWT.None);
button3.setText("返回");
button3.addSelectionListener(new SelectionAdapter(){
//添加"返回"按鈕監聽器
//返回菜單
public void widgetSelected(SelectionEvent event){
shell.getDisplay().dispose();
shell.dispose();
FrmMenu.main();
return;
}
});
}
private void createButton(){
//創建shell底部標簽及按鈕
GridData gridData1 = new GridData(GridData.FILL_HORIZONTAL);
gridData1.horizontalSpan = 8;
labelA = new Label(shell,SWT.None);
labelA.setForeground(colRed);
labelA.setLayoutData(gridData1);
labelA.setText("可以開始直接輸入藥品信息 可以雙擊分類框從分類開始入手 也可以雙擊編號框顯示已經輸入的藥品已資參考");
GridData gridData0 = new GridData(GridData.FILL_HORIZONTAL);
gridData0.horizontalSpan = 8;
labelB = new Label(shell,SWT.None);
labelB.setForeground(colBule);
labelB.setLayoutData(gridData0);
labelB.setText("修改藥品信息");
}
private void getCmb(Combo temp1, String temp2)
{
try
{
int temp = Db.getCmb(temp2); //調用查詢數據庫中用戶類別方法
if(temp == 0)
{
System.out.println("Error");
}
if(temp == 1)
{
String lbItems;
while(Db.rs.next()) //若成功，執行下面操作
{
lbItems = Db.rs.getString(temp2);
if(lbItems != null)
temp1.add(lbItems); //填加進COMBO框
}
}
}
catch(Exception e) //捕獲異常
{
System.err.println(e.getMessage());
e.printStackTrace();
}
}
private void save()
{
String YPNM = "";
String YM = ""; //申明字符串變量
String GG = "";
String CD = "";
String CJ = "";
String YPSR = "";
String JJDW = "";
Double YPDJ;
YPDJ = Double.valueOf("0");
String JX = "";
String ZFBL = "";
String YPWM = "";
String BZ = "";
try
{
int temp1 = Db.getData();
if(temp1 == 1) //判斷，若存在，執行下面操作
{
try
{
if(Db.rs.next())
{
YM = Db.rs.getString("YM");
GG = Db.rs.getString("GG");
CD = Db.rs.getString("CD");
CJ = Db.rs.getString("CJ");
YPSR = Db.rs.getString("YPSR");
JJDW = Db.rs.getString("JJDW");
YPDJ = Double.valueOf(Db.rs.getString("YPDJ"));
JX = Db.rs.getString("JX");
ZFBL = Db.rs.getString("ZFBL");
YPWM = Db.rs.getString("YPWM");
BZ = Db.rs.getString("BZ");
if(textYM.getText().equals(YM)
&&textGG.getText().equals(GG)
&&ComboCD.getText().equals(CD)
&&ComboCJ.getText().equals(CJ)
&&textYPSR.getText().equals(YPSR)
&&comboJJDW.getText().equals(JJDW)
&&textYPDJ.getText().equals(YPDJ)
&&ComboJX.getText().equals(JX)
&&textZFBL.getText().equals(ZFBL)
&&textYPWM.getText().equals(YPWM)
&&textBZ.getText().equals(BZ))
{
//若都沒有修改，則什么也不執行不操作
}
else //若作了改動，則執行一下操作，存如數據庫
{
YPNM = txtYPNBDM.getText();
if(textYM.getText().equals("")
||textYPDJ.getText().equals("")
||ComboJX.getText().equals("")
||textZFBL.getText().equals(""))
{
if(textYM.getText().equals(""))
{
//報錯提示消息
checkBox("藥名不能為空");
textYM.setFocus(); //設置焦點
textYM.selectAll();
}
if(textYPDJ.getText().equals(""))
{
//報錯提示消息
checkBox("藥品單價不能為空");
textYPDJ.setFocus(); //設置焦點
textYPDJ.selectAll();
}
if(ComboJX.getText().equals("")) //數據庫不允許為空，若劑型為空，則提示出錯
{
checkBox("劑型不能為空"); //調用報告消息方法，并顯示此內容
ComboJX.setFocus();
}
if(textZFBL.getText().equals("")) //數據庫不允許為空,若自費比例為空,則提示出錯
{
checkBox("自費比例不能為空"); //報錯
textZFBL.setFocus(); //設置此框為焦點，以便操作的友好性
textZFBL.selectAll();
}
}
else //檢查完全合法后執行一下操作
{
YM = textYM.getText();
YPDJ = Double.valueOf(textYPDJ.getText());
JX = ComboJX.getText();
ZFBL = textZFBL.getText();
if(textGG.getText().equals("")) //判斷是否為空，數據庫允許為空
GG = "null"; //為空則賦NULL
else
GG = textGG.getText(); //否則獲取它的值
if(ComboCD.getText().equals("")) //判斷是否為空，數據庫允許為空
CD = "null"; //為空則賦NULL
else
CD = ComboCD.getText(); //否則獲取它的值
if(ComboCJ.getText().equals(""))
CJ = "null";
else
CJ = ComboCJ.getText();
if(textYPSR.getText().equals(""))
YPSR = "null";
else
YPSR = textYPSR.getText(); //為空則賦NULL
if(comboJJDW.getText().equals(""))
JJDW = "null";
else
JJDW = comboJJDW.getText();
//完成賦值操作后，調用更新信息方法
if(textYPWM.getText().equals(""))
YPWM = "null";
else
YPWM = textYPWM.getText();
if(textBZ.getText().equals(""))
BZ = "null";
else
BZ = textBZ.getText();
try
{
int temp2 = Db.updata(YPNM,YM,GG,CD,CJ,YPSR,JJDW,
YPDJ,JX,ZFBL,YPWM,BZ); //調用更新函數
if(temp2 == 1) //若返回1，則成功
{
succBox(); //調用報告成功消息框
}
else //如返回0，則失敗
{
unsuccBox(); //調用報錯消息框
}
}
catch(Exception e) //捕獲異常
{
System.err.println(e.getMessage());
e.printStackTrace();
}
}
}
}
else
{
if(textYM.getText().equals("")
||textYPDJ.getText().equals("")
||ComboJX.getText().equals("")
||textZFBL.getText().equals(""))
{
if(textYM.getText().equals(""))
{
//報錯提示消息
checkBox("藥名不能為空");
textYM.setFocus(); //設置焦點
textYM.selectAll();
}
if(textYPDJ.getText().equals(""))
{
//報錯提示消息
checkBox("藥品單價內輸入了非法字符英文狀態下的單引號");
textYPDJ.setFocus(); //設置焦點
textYPDJ.selectAll();
}
if(ComboJX.getText().equals("")) //數據庫不允許為空，若姓名為空，則提示出錯
{
checkBox("劑型不能為空，請輸入劑型！"); //調用報告消息方法，并顯示此內容
ComboJX.setFocus();
}
if(textZFBL.getText().equals("")) //判斷是否輸入電話號碼不是數字
{
checkBox("非法輸入，請輸入自費比例！"); //報錯
textZFBL.setFocus(); //設置此框為焦點，以便操作的友好性
textZFBL.selectAll();
}
}
else //檢查完全合法后執行一下操作
{
YM = textYM.getText(); //獲取劑型，賦予JX
YPDJ = Double.valueOf(textYPDJ.getText());
JX = ComboJX.getText();
ZFBL = textZFBL.getText();
if(textGG.getText().equals("")) //判斷是否為空，數據庫允許為空
GG = "null"; //為空則賦NULL
else
GG = textGG.getText(); //否則獲取它的值
if(ComboCD.getText().equals("")) //判斷是否為空，數據庫允許為空
CD = "null"; //為空則賦NULL
else
CD = ComboCD.getText(); //否則獲取它的值
if(ComboCJ.getText().equals(""))
CJ = "null";
else
CJ = ComboCJ.getText();
if(textYPSR.getText().equals(""))
YPSR = "null";
else
YPSR = textYPSR.getText(); //為空則賦NULL
if(comboJJDW.getText().equals(""))
JJDW = "null";
else
JJDW = comboJJDW.getText();
//完成賦值操作后，調用更新信息方法
if(textYPWM.getText().equals(""))
YPWM = "null";
else
YPWM = textYPWM.getText();
if(textBZ.getText().equals(""))
BZ = "null";
else
BZ = textBZ.getText();
try
{
int temp3 = Db.insert(YPNM,YM,GG,CD,CJ,YPSR,JJDW,
YPDJ,JX,ZFBL,YPWM,BZ); //調用更新函數
if(temp3 == 1) //若返回1，則成功
{
succBox(); //調用報告成功消息框
}
else //如返回0，則失敗
{
unsuccBox(); //調用報錯消息框
}
}
catch(Exception e) //捕獲異常
{
System.err.println(e.getMessage());
e.printStackTrace();
}
}
}
}
catch(Exception e) //捕獲異常
{
System.err.println(e.getMessage());
e.printStackTrace();
}
}
}
catch(Exception e) //捕獲異常
{
System.err.println(e.getMessage());
e.printStackTrace();
}
}
private void checkBox(String temp) //顯示消息框方法
{
MessageBox checkBox = new MessageBox(shell,SWT.ICON_INFORMATION | SWT.OK);
checkBox.setText("提示");
checkBox.setMessage(temp); //顯示從temp傳來的消息
checkBox.open();
}
private void unsuccBox() //顯示查詢數據庫成功消息框方法
{
MessageBox unsuccBox = new MessageBox(shell,SWT.OK | SWT.ICON_ERROR);
unsuccBox.setText("錯誤！");
unsuccBox.setMessage("更新數據庫出錯");
unsuccBox.open();
return;
}
public void succBox() //顯示更新數據庫成功消息框
{
MessageBox succBox = new MessageBox(shell,SWT.ICON_INFORMATION | SWT.OK);
succBox.setText("成功");
succBox.setMessage("更新數據庫成功");
succBox.open();
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -