medicine_information.java
来自「使用Java语言开发的数据库课程设计——医药管理信息系统。」· Java 代码 · 共 589 行 · 第 1/2 页
JAVA
589 行
jPanel1.add(jLabel7, new XYConstraints(358, 306, 66, 34));
jPanel1.add(jTextField9, new XYConstraints(472, 311, 148, 25));
jPanel1.add(jTextField8, new XYConstraints(472, 263, 148, 25));
jPanel1.add(jTextField7, new XYConstraints(472, 215, 148, 25));
jPanel1.add(jTextField5, new XYConstraints(472, 119, 148, 25));
jPanel1.add(jTextField4, new XYConstraints(472, 71, 148, 25));
jPanel2.add(jPanel4, new XYConstraints(0, 0, 672, 54));
jTabbedPane1.add(jPanel1, "数据录入");
jPanel5.add(jLabel25, new XYConstraints(358, 212, -1, -1));
jPanel5.add(jLabel27, new XYConstraints(358, 20, -1, -1));
jPanel5.add(jLabel24, new XYConstraints(358, 67, -1, -1));
jPanel5.add(jLabel28, new XYConstraints(358, 164, -1, -1));
jPanel5.add(jLabel19, new XYConstraints(358, 116, -1, -1));
jPanel5.add(jLabel26, new XYConstraints(358, 260, -1, -1));
jPanel5.add(jTextField26, new XYConstraints(472, 209, 148, 25));
jPanel4.add(jLabel15, new XYConstraints(111, 20, -1, -1));
jPanel4.add(jButton5, new XYConstraints(499, 14, -1, 31));
jPanel4.add(jTextField12, new XYConstraints(371, 18, 105, 23));
jPanel4.add(jLabel16, new XYConstraints(296, 20, -1, -1));
jPanel4.add(jTextField11, new XYConstraints(184, 18, 105, 23));
jPanel5.add(jLabel20, new XYConstraints(16, 12, 66, 34));
jPanel5.add(jLabel23, new XYConstraints(16, 68, -1, -1));
jPanel5.add(jLabel22, new XYConstraints(16, 116, -1, -1));
jPanel5.add(jLabel21, new XYConstraints(16, 164, -1, -1));
jPanel5.add(jLabel18, new XYConstraints(16, 212, -1, -1));
jPanel5.add(jLabel17, new XYConstraints(16, 260, -1, -1));
jPanel5.add(jLabel29, new XYConstraints(16, 308, -1, -1));
jPanel5.add(jTextField13, new XYConstraints(125, 17, 148, 25));
jPanel5.add(jTextField14, new XYConstraints(125, 64, 148, 25));
jPanel5.add(jTextField15, new XYConstraints(125, 113, 148, 25));
jPanel5.add(jTextField16, new XYConstraints(125, 161, 148, 25));
jPanel5.add(jTextField17, new XYConstraints(125, 209, 148, 25));
jPanel5.add(jTextField18, new XYConstraints(125, 257, 148, 25));
jPanel5.add(jTextField19, new XYConstraints(125, 305, 148, 25));
jPanel5.add(jTextField20, new XYConstraints(472, 17, 148, 25));
jPanel5.add(jTextField25, new XYConstraints(472, 161, 148, 25));
jPanel5.add(jTextField21, new XYConstraints(472, 64, 148, 25));
jPanel5.add(jTextField24, new XYConstraints(472, 113, 148, 25));
jPanel5.add(jTextField27, new XYConstraints(472, 257, 148, 25));
jPanel4.add(jButton6, new XYConstraints(579, 14, 69, 31));
jPanel3.add(jLabel14, new XYConstraints(111, 20, -1, -1));
jPanel3.add(jTextField10, new XYConstraints(184, 18, 105, 23));
jPanel3.add(jLabel31, new XYConstraints(296, 20, -1, -1));
jPanel3.add(jButton1, new XYConstraints(489, 14, 80, 31));
jPanel3.add(jTextField22, new XYConstraints(371, 18, 105, 23));
jPanel3.add(jButton2, new XYConstraints(574, 14, 80, 31));
jPanel2.add(jPanel5, new XYConstraints(0, 53, 670, 406));
jPanel1.add(jPanel3, new XYConstraints(0, 0, 672, 54));
jPanel1.add(jPanel6, new XYConstraints( -2, 404, 676, 60));
}
public static void main(String[] args)
{
new medicine_information();
}
public void jButton5_actionPerformed(ActionEvent e)
{
if(jTextField11.getText().equals("")&&jTextField12.getText().equals(""))
{
JOptionPane.showMessageDialog(null,"查询数据不能为空!!!","系统提示",JOptionPane.ERROR_MESSAGE);
}
else
{
if(jTextField11.getText().equals(""))
query = "SELECT * FROM Medicine_Data WHERE 药品名称 ='"+jTextField12.getText()+"'";
else if(jTextField12.getText().equals(""))
query = "SELECT * FROM Medicine_Data WHERE 药品编号 = '"+jTextField11.getText()+"'";
else query = "SELECT * FROM Medicine_Data WHERE 药品名称 ='"+jTextField12.getText()+"'AND 药品编号 = '"+jTextField11.getText()+"'" ;
try
{
Class.forName(Driver);
}
catch(ClassNotFoundException ee)
{
JOptionPane.showMessageDialog(null,"ForName:" + ee.getMessage(),"错误!",
JOptionPane.WARNING_MESSAGE);
}
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
{
jTextField13.setText(rs.getString(1));
jTextField14.setText(rs.getString(2));
jTextField15.setText(rs.getString(3));
jTextField16.setText(rs.getString(4));
jTextField17.setText(rs.getString(5));
jTextField18.setText(rs.getString(6));
jTextField19.setText(rs.getString(7));
jTextField20.setText(rs.getString(8));
jTextField21.setText(rs.getString(9));
jTextField24.setText(rs.getString(10));
jTextField25.setText(rs.getString(11));
jTextField26.setText(rs.getString(12));
jTextField27.setText(rs.getString(13));
}
rs.close();
con.close();
}
catch(SQLException ex)
{
JOptionPane.showMessageDialog(null,"SQLException:" + ex.getMessage(),"警告!",JOptionPane.WARNING_MESSAGE);
}
}
}
public void jButton6_actionPerformed(ActionEvent e)
{
jTextField11.setText("");
jTextField12.setText("");
jTextField13.setText("");
jTextField14.setText("");
jTextField15.setText("");
jTextField16.setText("");
jTextField17.setText("");
jTextField18.setText("");
jTextField19.setText("");
jTextField20.setText("");
jTextField21.setText("");
jTextField24.setText("");
jTextField25.setText("");
jTextField26.setText("");
jTextField27.setText("");
}
public void jButton1_actionPerformed(ActionEvent e)
{
if(jTextField10.getText().equals("")&&jTextField22.getText().equals(""))
{
JOptionPane.showMessageDialog(null,"不能修改空数据，请输入药品编号或药品名称进行修改!!!","系统提示",JOptionPane.ERROR_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()+"'" ;
try
{
Class.forName(Driver);
}
catch(ClassNotFoundException ee)
{
JOptionPane.showMessageDialog(null,"ForName:" + ee.getMessage(),"错误!",
JOptionPane.WARNING_MESSAGE);
}
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
{
jTextField1.setText(rs.getString(1));
jTextField2.setText(rs.getString(2));
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(false);
}
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
{
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(药品名称='" + jTextField2.getText() + "')";
//save="update Medicine_Data set 药品名称 = '感叹号!!!',通用名称='abc' where (药品编号=123)";
try
{
Class.forName(Driver);
}
catch (ClassNotFoundException ee)
{
JOptionPane.showMessageDialog(null, "ForName:" + ee.getMessage(),"错误!",JOptionPane.WARNING_MESSAGE);
}
try
{
Connection con = DriverManager.getConnection(conURL, Username,
Password);
Statement s = con.createStatement();
s.executeUpdate(save);
JOptionPane.showMessageDialog(null, "修改成功", "操作完成!",
JOptionPane.WARNING_MESSAGE);
s.close();
con.close();
}
catch (SQLException ex)
{
JOptionPane.showMessageDialog(null,"SQLException:" + ex.getMessage(),"警告!",JOptionPane.WARNING_MESSAGE);
}
}
}
}
class medicine_information_jButton3_actionAdapter implements ActionListener {
private medicine_information adaptee;
medicine_information_jButton3_actionAdapter(medicine_information adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton3_actionPerformed(e);
}
}
class medicine_information_jButton1_actionAdapter implements ActionListener {
private medicine_information adaptee;
medicine_information_jButton1_actionAdapter(medicine_information adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}
class medicine_information_jButton6_actionAdapter implements ActionListener {
private medicine_information adaptee;
medicine_information_jButton6_actionAdapter(medicine_information adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton6_actionPerformed(e);
}
}
class medicine_information_jButton5_actionAdapter implements ActionListener {
private medicine_information adaptee;
medicine_information_jButton5_actionAdapter(medicine_information adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton5_actionPerformed(e);
}
}
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?