medicine_information.java~161~
来自「使用Java语言开发的数据库课程设计——医药管理信息系统。」· JAVA~161~ 代码 · 共 889 行 · 第 1/3 页
JAVA~161~
889 行
jPanel5.setLayout(xYLayout6);
jLabel15.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
jLabel15.setText("药品编号");
jLabel16.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
jLabel16.setText("药品名称");
jPanel6.setBackground(Color.orange);
jPanel6.setBorder(BorderFactory.createRaisedBevelBorder());
jPanel6.setLayout(xYLayout5);
jButton3.setText("保 存");
jButton3.setEnabled(false);
jButton3.addActionListener(new
medicine_information_jButton3_actionAdapter(this));
jButton4.setText("取 消");
jButton4.addActionListener(new
medicine_information_jButton4_actionAdapter(this));
jLabel17.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
jLabel17.setForeground(Color.red);
jLabel17.setText(" 单 位 ");
jLabel18.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
jLabel18.setForeground(Color.red);
jLabel18.setText(" 有效期");
jLabel19.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
jLabel19.setForeground(Color.red);
jLabel19.setText("零售价格");
jLabel20.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
jLabel20.setForeground(Color.red);
jLabel20.setText("药品编号");
jLabel21.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
jLabel21.setForeground(Color.red);
jLabel21.setText("药品类别");
jLabel22.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
jLabel22.setForeground(Color.red);
jLabel22.setText("通用名称");
jLabel23.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
jLabel23.setForeground(Color.red);
jLabel23.setText("药品名称");
jLabel24.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
jLabel24.setForeground(Color.red);
jLabel24.setText(" 产 地 ");
jLabel25.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
jLabel25.setForeground(Color.red);
jLabel25.setText("批发价格");
jLabel26.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
jLabel26.setForeground(Color.red);
jLabel26.setText(" 批 号 ");
jLabel27.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
jLabel27.setForeground(Color.red);
jLabel27.setText("包装数量");
jLabel28.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
jLabel28.setForeground(Color.red);
jLabel28.setToolTipText("");
jLabel28.setText("进货价格");
jLabel29.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
jLabel29.setForeground(Color.red);
jLabel29.setText(" 剂 型 ");
jPanel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 10));
jLabel31.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
jLabel31.setForeground(Color.blue);
jLabel31.setText("药品名称");
jButton5.setText("查 询");
jButton5.addActionListener(new
medicine_information_jButton5_actionAdapter(this));
jTextField1.setEnabled(false);
jTextField2.setEnabled(false);
jTextField3.setEnabled(false);
jTextField4.setEnabled(false);
jTextField4.setText("0");
jTextField5.setEnabled(false);
jTextField6.setEnabled(false);
jTextField6.setText("0.0");
jTextField7.setEnabled(false);
jTextField7.setToolTipText("");
jTextField7.setText("0.0");
jTextField8.setEnabled(false);
jTextField8.setText("0.0");
jTextField9.setEnabled(false);
jComboBox1.setEnabled(false);
jComboBox2.setEnabled(false);
jComboBox3.setEnabled(false);
jComboBox4.setEnabled(false);
jTextField13.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
jTextField14.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
jTextField15.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
jTextField16.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
jTextField17.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
jTextField18.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
jTextField19.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
jTextField20.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
jTextField21.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
jTextField24.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
jTextField25.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
jTextField26.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
jTextField27.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
jButton6.setText("清 空");
jButton6.addActionListener(new
medicine_information_jButton6_actionAdapter(this));
jPanel8.setLayout(xYLayout8);
jPanel7.setLayout(xYLayout7);
jPanel8.setBackground(Color.orange);
jButton7.setText("删 除");
jButton7.addActionListener(new
medicine_information_jButton7_actionAdapter(this));
jLabel32.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
jLabel32.setForeground(Color.blue);
jLabel32.setText("药品编号");
jLabel33.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
jLabel33.setForeground(Color.blue);
jLabel33.setText("药品名称");
jTextArea1.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
jTextArea1.setForeground(Color.red);
jTextArea1.setBorder(BorderFactory.createEtchedBorder());
jTextArea1.setLineWrap(true);
jTextArea1.setEnabled(false);
jLabel30.setIcon(pic);
this.getContentPane().add(jTabbedPane1, java.awt.BorderLayout.CENTER);
jPanel6.add(jButton3, new XYConstraints(463, 8, 82, 32));
jPanel6.add(jButton4, new XYConstraints(567, 7, 82, 32));
jPanel1.add(jTextField6, new XYConstraints(472, 167, 148, 25));
jPanel1.add(jLabel1, new XYConstraints(16, 66, 66, 34));
jPanel1.add(jTextField1, new XYConstraints(125, 71, 148, 25));
jPanel1.add(jLabel2, new XYConstraints(16, 114, 66, 34));
jPanel1.add(jTextField2, new XYConstraints(125, 119, 148, 25));
jPanel1.add(jLabel3, new XYConstraints(16, 162, 66, 34));
jPanel1.add(jTextField3, new XYConstraints(125, 167, 148, 25));
jPanel1.add(jLabel13, new XYConstraints(16, 210, 66, 34));
jPanel1.add(jComboBox1, new XYConstraints(125, 215, 148, 25));
jPanel1.add(jLabel8, new XYConstraints(16, 258, 66, 34));
jPanel1.add(jComboBox2, new XYConstraints(125, 263, 148, 25));
jPanel1.add(jLabel4, new XYConstraints(16, 306, 66, 34));
jPanel1.add(jComboBox3, new XYConstraints(125, 311, 148, 25));
jPanel1.add(jComboBox4, new XYConstraints(125, 359, 148, 25));
jPanel1.add(jLabel5, new XYConstraints(16, 354, 66, 34));
jPanel1.add(jLabel6, new XYConstraints(358, 66, 66, 34));
jPanel1.add(jLabel9, new XYConstraints(358, 114, 66, 34));
jPanel1.add(jLabel12, new XYConstraints(358, 162, 66, 34));
jPanel1.add(jLabel10, new XYConstraints(358, 210, 66, 34));
jPanel1.add(jLabel11, new XYConstraints(358, 258, 66, 34));
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));
jTabbedPane1.add(jPanel7, "数据删除");
jPanel7.add(jPanel8, new XYConstraints(0, 0, 672, 54));
jPanel8.add(jTextField23, new XYConstraints(270, 19, 105, 23));
jPanel8.add(jLabel32, new XYConstraints(197, 22, -1, -1));
jPanel8.add(jLabel33, new XYConstraints(388, 22, -1, -1));
jPanel8.add(jTextField28, new XYConstraints(453, 19, 105, 23));
jPanel7.add(jLabel30, new XYConstraints(183, 53, 488, 407));
jTabbedPane1.add(jPanel2, "数据查询");
jPanel7.add(jTextArea1, new XYConstraints(0, 53, 186, 410));
jPanel8.add(jButton7, new XYConstraints(576, 15, -1, 31));
jPanel1.add(jPanel6, new XYConstraints(0, 404, 671, 59));
}
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()+"'" ;
Connect_DB();
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)
{
clearPanel2();
}
public void jButton1_actionPerformed(ActionEvent e)
{
if(jTextField10.getText().equals("")&&jTextField22.getText().equals(""))
{
JOptionPane.showMessageDialog(null,"不能修改空数据，请输入药品编号或药品名称进行修改!!!","系统提示",JOptionPane.ERROR_MESSAGE);
}
else
{
jButton2.setEnabled(false);
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()+"'" ;
Connect_DB();
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);
jButton2.setEnabled(true);
}
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));
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?