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