medicine_data_input.java~180~
字号:
jLabel9.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
jLabel9.setForeground(Color.black);
jLabel9.setText(" 产 地 ");
jLabel10.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
jLabel10.setForeground(Color.black);
jLabel10.setText("进货价格");
jLabel11.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
jLabel11.setForeground(Color.black);
jLabel11.setText("批发价格");
jLabel12.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
jLabel12.setForeground(Color.black);
jLabel12.setText("零售价格");
jLabel13.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
jLabel13.setForeground(Color.black);
jLabel13.setText("药品类别");
jPanel3.setBackground(new Color(236, 233, 173));
jPanel3.setBorder(BorderFactory.createEtchedBorder());
jPanel3.setLayout(xYLayout2);
jPanel1.setLayout(xYLayout1);
jLabel1.setText("药品编号");
jLabel14.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
jLabel14.setForeground(Color.black);
jLabel14.setText("药品编号");
jButton1.setText("修 改");
jButton1.addActionListener(new
medicine_data_input_jButton1_actionAdapter(this));
jButton2.setText("新资料");
jButton2.addActionListener(new
medicine_data_input_jButton2_actionAdapter(this));
jPanel2.setLayout(xYLayout4);
jPanel6.setBackground(new Color(236, 233, 173));
jPanel6.setBorder(BorderFactory.createEtchedBorder());
jPanel6.setLayout(xYLayout5);
jButton3.setText("保 存");
jButton3.addActionListener(new
medicine_data_input_jButton3_actionAdapter(this));
jButton3.setEnabled(false);
jButton4.setText("取 消");
jButton4.addActionListener(new
medicine_data_input_jButton4_actionAdapter(this));
jPanel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 10));
jLabel31.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
jLabel31.setForeground(Color.black);
jLabel31.setText("药品名称");
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);
jTextField9.setText("0");
jComboBox1.setEnabled(false);
jComboBox2.setEnabled(false);
jComboBox3.setEnabled(false);
jComboBox4.setEnabled(false);
jPanel8.setLayout(xYLayout8);
jPanel7.setLayout(xYLayout7);
jPanel8.setBackground(new Color(236, 233, 173));
jButton7.setText("删 除");
jButton7.addActionListener(new
medicine_data_input_jButton7_actionAdapter(this));
jLabel32.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
jLabel32.setForeground(Color.black);
jLabel32.setText("药品编号");
jLabel33.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
jLabel33.setForeground(Color.black);
jLabel33.setText("药品名称");
jTextArea1.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
jTextArea1.setForeground(Color.black);
jTextArea1.setBorder(BorderFactory.createEtchedBorder());
jTextArea1.setLineWrap(true);
jLabel30.setIcon(pic);
jPanel5.setBackground(new Color(236, 233, 173));
jPanel5.setMinimumSize(new Dimension(10, 200));
jPanel5.setOpaque(false);
jPanel5.setPreferredSize(new Dimension(10, 200));
jPanel5.setLayout(xYLayout3);
jPanel4.setLayout(borderLayout3);
jScrollPane1.setHorizontalScrollBarPolicy(JScrollPane.
HORIZONTAL_SCROLLBAR_ALWAYS);
jLabel15.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
jLabel15.setForeground(Color.green);
jLabel15.setText("请输入查询条件");
jButton5.addActionListener(new
medicine_data_input_jButton5_actionAdapter(this));
jButton6.addActionListener(new
medicine_data_input_jButton6_actionAdapter(this));
jLabel17.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
jLabel17.setForeground(Color.green);
jLabel17.setText("库存量大于或等于");
jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
jButton1.setCursor(new Cursor(Cursor.HAND_CURSOR));
jButton2.setCursor(new Cursor(Cursor.HAND_CURSOR));
jButton3.setCursor(new Cursor(Cursor.HAND_CURSOR));
jButton4.setCursor(new Cursor(Cursor.HAND_CURSOR));
jButton5.setCursor(new Cursor(Cursor.HAND_CURSOR));
jButton5.setIcon(null);
jButton5.setText("查 询");
jButton6.setCursor(new Cursor(Cursor.HAND_CURSOR));
jButton6.setIcon(null);
jButton6.setText("取 消");
jButton7.setCursor(new Cursor(Cursor.HAND_CURSOR));
jButton8.setCursor(new Cursor(Cursor.HAND_CURSOR));
jButton8.setIcon(null);
jButton8.setText("查 询");
jButton8.addActionListener(new
medicine_data_input_jButton8_actionAdapter(this));
jLabel16.setForeground(Color.green);
jLabel16.setText("精确查询");
jLabel18.setForeground(Color.green);
jLabel18.setText("分类查询");
jTextField10.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
jTextField22.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
jTextField23.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
jTextField28.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
jTextField13.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
jTextField11.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
jTextField12.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
jPanel9.setLayout(borderLayout2);
jLabel19.setIcon(bg);
this.getContentPane().add(jTabbedPane1, java.awt.BorderLayout.CENTER);
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(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));
jTabbedPane1.add(jPanel1, "数据录入");
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, "数据查询");
jScrollPane1.getViewport().add(jTable1);
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));
jPanel5.add(jLabel15, new XYConstraints(15, 16, -1, -1));
jPanel1.add(jLabel7, new XYConstraints(367, 311, 49, 25));
jPanel4.add(jScrollPane1, java.awt.BorderLayout.CENTER);
jPanel5.add(jComboBox6, new XYConstraints(97, 46, -1, -1));
jPanel5.add(jLabel16, new XYConstraints(25, 50, -1, -1));
jPanel5.add(jLabel18, new XYConstraints(27, 104, -1, -1));
jPanel5.add(jTextField12, new XYConstraints(199, 143, 136, 28));
jPanel2.add(jPanel4, new XYConstraints(0, 0, 670, 260));
jPanel2.add(jPanel5, new XYConstraints(0, 260, 673, 203));
jPanel6.add(jButton3, new XYConstraints(430, 8, 90, 35));
jPanel6.add(jButton4, new XYConstraints(545, 8, 90, 35));
jPanel3.add(jButton1, new XYConstraints(480, 8, 90, 35));
jPanel3.add(jButton2, new XYConstraints(574, 8, 90, 35));
jPanel3.add(jTextField22, new XYConstraints(371, 14, 105, 23));
jPanel3.add(jLabel31, new XYConstraints(296, 17, -1, -1));
jPanel3.add(jTextField10, new XYConstraints(184, 14, 105, 23));
jPanel3.add(jLabel14, new XYConstraints(111, 17, -1, -1));
jPanel2.add(jPanel9, new XYConstraints(0, 260, 673, 203));
jPanel9.add(jLabel19, java.awt.BorderLayout.CENTER);
jPanel5.add(jTextField13, new XYConstraints(197, 43, 136, 28));
jPanel5.add(jButton8, new XYConstraints(391, 40, 69, 34));
jPanel5.add(jComboBox5, new XYConstraints(99, 100, -1, -1));
jPanel5.add(jTextField11, new XYConstraints(198, 97, 136, 28));
jPanel5.add(jButton5, new XYConstraints(393, 94, 69, 34));
jPanel5.add(jLabel17, new XYConstraints(51, 149, -1, -1));
jPanel5.add(jButton6, new XYConstraints(393, 140, 69, 34));
header = new Vector();
this.validate();
}
public static void main(String[] args)
{
new medicine_data_input();
}
public void init_model()
{
header = new Vector();
for(int i=0;i<header_name.length;i++)
{
header.addElement(header_name[i]);
}
tableModel1 = new DefaultTableModel(header,0);
jTable1.setModel(tableModel1);
}
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() + "'";
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);
jButton2.setEnabled(true);
}
else
{
jTextField1.setText(rs.getString(1));
jTextField2.setText(rs.getString(2));
jTextField3.setText(rs.getString(3));
jTextField4.setText(rs.getString(8));
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -