medicine_data_input.java~185~
字号:
jTextField3.setText(rs.getString(3));
jTextField4.setText(rs.getString(8));
jTextField5.setText(rs.getString(9));
jTextField6.setText(rs.getString(10));
jTextField7.setText(rs.getString(11));
jTextField8.setText(rs.getString(12));
jTextField9.setText(rs.getString(13));
jComboBox1.setSelectedItem(rs.getString(4));
jComboBox1.setSelectedItem(rs.getString(5));
jComboBox1.setSelectedItem(rs.getString(6));
jComboBox1.setSelectedItem(rs.getString(7));
jTextField2.setEnabled(true);
jTextField3.setEnabled(true);
jTextField4.setEnabled(true);
jTextField5.setEnabled(true);
jTextField6.setEnabled(true);
jTextField7.setEnabled(true);
jTextField8.setEnabled(true);
jComboBox1.setEnabled(true);
jComboBox2.setEnabled(true);
jComboBox3.setEnabled(true);
jComboBox4.setEnabled(true);
jButton3.setEnabled(true);
}
rs.close();
con.close();
} catch (SQLException ex) {
JOptionPane.showMessageDialog(null,
"SQLException:" + ex.getMessage(),
"警告!",
JOptionPane.WARNING_MESSAGE);
}
}
}
public void jButton2_actionPerformed(ActionEvent e)
{
if(jTextField10.getText().equals("")&&jTextField22.getText().equals(""))
{
JOptionPane.showMessageDialog(null,"请先填写药品编号 (必填)!!","系统提示!",
JOptionPane.WARNING_MESSAGE);
}
else
{
if (jTextField10.getText().equals(""))
query = "SELECT * FROM Medicine_Data WHERE 药品名称 ='" +
jTextField22.getText() + "'";
else if (jTextField22.getText().equals(""))
query = "SELECT * FROM Medicine_Data WHERE 药品编号 = '" +
jTextField10.getText() + "'";
else
query = "SELECT * FROM Medicine_Data WHERE 药品名称 ='" +
jTextField22.getText() + "'AND 药品编号 = '" +
jTextField10.getText() + "'";
new Load_DB_Driver();
try
{
Connection con = DriverManager.getConnection(conURL, Username,
Password);
Statement stm = con.createStatement();
ResultSet rs = stm.executeQuery(query);
if (rs.next())
{
JOptionPane.showMessageDialog(null, "你所要添加的药品已存在！！", "请注意!",
JOptionPane.WARNING_MESSAGE);
}
else
{
jButton2.setEnabled(true);
jButton1.setEnabled(false);
jTextField1.setEnabled(false);
jTextField2.setEnabled(true);
jTextField3.setEnabled(true);
jTextField4.setEnabled(true);
jTextField5.setEnabled(true);
jTextField6.setEnabled(true);
jTextField7.setEnabled(true);
jTextField8.setEnabled(true);
jComboBox1.setEnabled(true);
jComboBox2.setEnabled(true);
jComboBox3.setEnabled(true);
jComboBox4.setEnabled(true);
jButton3.setEnabled(true);
jButton3.setText("添 加");
jTextField1.setText(jTextField10.getText());
jTextField2.setText(jTextField22.getText());
}
rs.close();
con.close();
} catch (SQLException ex)
{
JOptionPane.showMessageDialog(null,
"SQLException:" + ex.getMessage(),
"警告!",
JOptionPane.WARNING_MESSAGE);
}
}
}
public void jButton3_actionPerformed(ActionEvent e)
{
int choice = JOptionPane.showConfirmDialog(null,"真的要保存为现在的数据？","请慎重考虑！",JOptionPane.YES_NO_OPTION);
if(choice==JOptionPane.NO_OPTION) return;
else
{
Is_number num = new Is_number();
if(num.Is_number(jTextField4.getText())==false)
{
JOptionPane.showMessageDialog(null, "包装数量包含非法字符，请重新输入！",
"系统提示!",
JOptionPane.WARNING_MESSAGE);
return;
}
else if(num.Is_number(jTextField6.getText())==false)
{
JOptionPane.showMessageDialog(null, "零售价格包含非法字符，请重新输入！",
"系统提示!",
JOptionPane.WARNING_MESSAGE);
return;
}
else if(num.Is_number(jTextField7.getText())==false)
{
JOptionPane.showMessageDialog(null, "批发价格包含非法字符，请重新输入！",
"系统提示!",
JOptionPane.WARNING_MESSAGE);
return;
}
else if(num.Is_number(jTextField8.getText())==false)
{
JOptionPane.showMessageDialog(null, "进货价格包含非法字符，请重新输入！",
"系统提示!",
JOptionPane.WARNING_MESSAGE);
return;
}
else
{
save = "update Medicine_Data set 药品编号='" + jTextField1.getText() +
"',药品名称='" + jTextField2.getText() +
"',通用名称='" + jTextField3.getText() +
"',药品类别='" + jComboBox1.getSelectedItem().toString() +
"',有效期='" + jComboBox2.getSelectedItem().toString() +
"',单位='" + jComboBox3.getSelectedItem().toString() +
"',剂型='" + jComboBox4.getSelectedItem().toString() +
"',包装数量=" + jTextField4.getText() +
",产地='" + jTextField5.getText() +
"',零售价格=" + jTextField6.getText() +
",进货价格=" + jTextField7.getText() +
",批发价格=" + jTextField8.getText() +
",库存量=" + jTextField9.getText() +
" where(药品编号='" + jTextField1.getText() + "')";
insert_data = "insert into Medicine_Data (药品编号,药品名称,通用名称,药品类别,有效期,单位,剂型,包装数量,产地,零售价格,进货价格,批发价格,库存量) values('"
+ jTextField1.getText() + "','" +
jTextField2.getText() + "','" +
jTextField3.getText() + "','"
+ jComboBox1.getSelectedItem().toString() + "','" +
jComboBox2.getSelectedItem().toString() + "','"
+ jComboBox3.getSelectedItem().toString() + "','" +
jComboBox4.getSelectedItem().toString() + "',"
+ jTextField4.getText() + ",'" +
jTextField5.getText() + "'," +
jTextField6.getText() + ","
+ jTextField7.getText() + "," +
jTextField8.getText() + "," + jTextField9.getText() +
")";
if (jButton3.getText().equals("保 存"))
Update_Data(save);
if (jButton3.getText().equals("添 加"))
Update_Data(insert_data);
clearPane1();
jTextField2.setEnabled(false);
jTextField3.setEnabled(false);
jTextField4.setEnabled(false);
jTextField5.setEnabled(false);
jTextField6.setEnabled(false);
jTextField7.setEnabled(false);
jTextField8.setEnabled(false);
jComboBox1.setEnabled(false);
jComboBox2.setEnabled(false);
jComboBox3.setEnabled(false);
jComboBox4.setEnabled(false);
jTextField10.setText("");
jTextField22.setText("");
jButton2.setEnabled(true);
jButton3.setEnabled(false);
}
}
}
public void jButton4_actionPerformed(ActionEvent e)
{
clearPane1();
jTextField1.setEnabled(false);
jTextField2.setEnabled(false);
jTextField3.setEnabled(false);
jTextField4.setEnabled(false);
jTextField5.setEnabled(false);
jTextField6.setEnabled(false);
jTextField7.setEnabled(false);
jTextField8.setEnabled(false);
jComboBox1.setEnabled(false);
jComboBox2.setEnabled(false);
jComboBox3.setEnabled(false);
jComboBox4.setEnabled(false);
jButton1.setEnabled(true);
jButton2.setEnabled(true);
jButton3.setEnabled(false);
jButton3.setText("保存");
jTextField10.setText("");
jTextField22.setText("");
}
public void jButton5_actionPerformed(ActionEvent e)
{
if (jTextField11.getText().equals("")&&jTextField12.getText().equals(""))
JOptionPane.showMessageDialog(null," 请输入查询条件 !!! ","系统提示",JOptionPane.ERROR_MESSAGE);
else
{
if(jTextField12.getText().equals(""))
check = "select * from Medicine_Data where "
+jComboBox5.getSelectedItem().toString()+"='"+jTextField11.getText()+"'";
else
{
Is_number num = new Is_number();
if(num.Is_number(jTextField12.getText())==false)
{
JOptionPane.showMessageDialog(null, " 库存量包含非法字符 ", "系统提示",
JOptionPane.ERROR_MESSAGE);
return;
}
else
{
if (jTextField11.getText().equals(""))
check = "select * from Medicine_Data where 库存量 >="+jTextField12.getText();
else check = "select * from Medicine_Data where "+jComboBox5.getSelectedItem().toString()+"='"+jTextField11.getText()+"'and 库存量 >="+jTextField12.getText();
}
}
init_model();
new Load_DB_Driver();
try
{
Connection con = DriverManager.getConnection(conURL,Username,Password);
Statement s= con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs = s.executeQuery(check);
if(rs.next()==false)
JOptionPane.showMessageDialog(null," 搜索到 0 个符合条件的条目 !!! ","系统提示",JOptionPane.ERROR_MESSAGE);
else
{rs.beforeFirst();
while(rs.next())
{
data = new Vector();
data.addElement(rs.getString(1));
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -