📄 modifyleechdominfo.java~8~
字号:
package cliniquemanager;
import java.awt.*;
import javax.swing.*;
import java.sql.*;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
/**
* <p>Title: CliniqueManager</p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2007</p>
*
* <p>Company: shine</p>
*
* @author robin
* @version 1.0
*/
public class ModifyLeechdomInfo extends JDialog {
Container c=this.getContentPane();
String strID=new String();//保存要修改的药品的id
JLabel jLabel1 = new JLabel();
JButton jButton2 = new JButton();
JLabel jLabel2 = new JLabel();
JTextField jTextField1 = new JTextField();
JButton jButton1 = new JButton();
JLabel jLabel3 = new JLabel();
JLabel jLabel4 = new JLabel();
JTextField jTextField2 = new JTextField();
JButton jButton3 = new JButton();
JTextField jTextField3 = new JTextField();
JTextField jTextField4 = new JTextField();
public ModifyLeechdomInfo(Frame owner, String title, boolean modal,String strID) {
super(owner, title, modal);
try {
setDefaultCloseOperation(DISPOSE_ON_CLOSE);
jbInit(strID);
pack();
} catch (Exception exception) {
exception.printStackTrace();
}
}
public ModifyLeechdomInfo(String strID) {
this(new Frame(), "修改药品信息", false,strID);
}
private void jbInit(String strID) throws Exception {
this.strID=strID;
c.setLayout(null);
this.setPreferredSize(new Dimension(350, 330));
this.setSize(new Dimension(350, 300));
jLabel1.setText("药品名称(*):");
jLabel1.setBounds(new Rectangle(32, 84, 100, 31));
jButton2.setBounds(new Rectangle(129, 254, 89, 29));
jButton2.setText("置空");
jButton2.addActionListener(new
ModifyLeechdomInfo_jButton2_actionAdapter(this));
jLabel2.setText("药品编号(*):");
jLabel2.setBounds(new Rectangle(32, 32, 97, 31));
jTextField1.setBounds(new Rectangle(131, 30, 190, 30));
jButton1.setBounds(new Rectangle(28, 255, 88, 29));
jButton1.setText("添加");
jButton1.addActionListener(new
ModifyLeechdomInfo_jButton1_actionAdapter(this));
jLabel3.setText("生产商(*):");
jLabel3.setBounds(new Rectangle(30, 138, 101, 30));
jLabel4.setText("价格(*):");
jLabel4.setBounds(new Rectangle(30, 190, 101, 31));
jTextField2.setBounds(new Rectangle(131, 84, 190, 30));
jButton3.setBounds(new Rectangle(231, 253, 91, 31));
jButton3.setText("取消");
jButton3.addActionListener(new ModifyLeechdomInfo_jButton3_actionAdapter(this));
jTextField3.setBounds(new Rectangle(131, 139, 190, 30));
jTextField4.setBounds(new Rectangle(131, 191, 190, 30));
jTextField1.setEnabled(false);
c.add(jLabel1);
c.add(jLabel2);
c.add(jLabel3);
c.add(jLabel4);
c.add(jTextField3);
c.add(jTextField4);
c.add(jButton2);
c.add(jButton3);
c.add(jButton1);
c.add(jTextField2);
c.add(jTextField1);
Database db= new Database();
ResultSet rs=db.getResultSet("SELECT * FROM leechdom WHERE lch_id='"+strID+"'");
if(rs.next()){
jTextField1.setText(rs.getString("lch_id"));
jTextField2.setText(rs.getString("name"));
jTextField3.setText(rs.getString("factory"));
jTextField4.setText(String.valueOf(rs.getInt("price")));
}
db.close();
this.setResizable(false);
}
int checkData(){ //检察数据是否有效
if(jTextField2.getText().equals("")==true || jTextField3.getText().equals("")==true || jTextField4.getText().equals("")==true){
JOptionPane.showMessageDialog(null,"请输入完整的数据!","系统提示",JOptionPane.ERROR_MESSAGE);
return 0;
}
Database db=new Database();
ResultSet rs=db.getResultSet("SELECT * FROM leechdom WHERE name='"+jTextField2.getText()+"'");
Boolean flag=false;
try{
flag=rs.next();
}catch(SQLException se){
se.printStackTrace();
}
db.close();
if(flag){
JOptionPane.showMessageDialog(null,"你输入的药品名已存在,请重新输入!","系统提示",JOptionPane.ERROR_MESSAGE);
return 0;
}
return 1;
}
public void jButton3_actionPerformed(ActionEvent e) {
dispose();
}
public void jButton2_actionPerformed(ActionEvent e) {
jTextField2.setText("");
jTextField3.setText("");
jTextField4.setText("");
jTextField1.setText("");
}
public void jButton1_actionPerformed(ActionEvent e) {
if(checkData()==1){
Database db= new Database();
Statement stm=db.getStatement();
String url=new String();
String strValue=new String();
url="UPDATE leechdom set name='"+jTextField2.getText()+"',factory='"+jTextField3.getText()+"',price="+jTextField4.getText()+"'";
url=url+" WHERE lch_id='"+strID+"'";
try{
stm.executeUpdate(url);
}catch(SQLException se){
se.printStackTrace();
}
db.close();
JOptionPane.showMessageDialog(null,"修改成功!","系统提示",JOptionPane.INFORMATION_MESSAGE);
}
}
}
class ModifyLeechdomInfo_jButton1_actionAdapter implements ActionListener {
private ModifyLeechdomInfo adaptee;
ModifyLeechdomInfo_jButton1_actionAdapter(ModifyLeechdomInfo adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}
class ModifyLeechdomInfo_jButton2_actionAdapter implements ActionListener {
private ModifyLeechdomInfo adaptee;
ModifyLeechdomInfo_jButton2_actionAdapter(ModifyLeechdomInfo adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton2_actionPerformed(e);
}
}
class ModifyLeechdomInfo_jButton3_actionAdapter implements ActionListener {
private ModifyLeechdomInfo adaptee;
ModifyLeechdomInfo_jButton3_actionAdapter(ModifyLeechdomInfo adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton3_actionPerformed(e);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -