package 项目;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import org.eclipse.swt.graphics.Color;
import org.eclipse.swt.graphics.Point;
import org.eclipse.swt.widgets.Display;
import org.eclipse.swt.widgets.Shell;
import org.eclipse.swt.widgets.Label;
import org.eclipse.swt.SWT;
import org.eclipse.swt.graphics.Rectangle;
import org.eclipse.swt.graphics.Font;
import org.eclipse.swt.widgets.Text;
import org.eclipse.swt.widgets.Button;
import org.eclipse.swt.widgets.Combo;
public class 修改 {
Shell sShell = null;
private Label labelbt = null;
private Label labelbh = null;
private Text text1 = null;
private Button buttonqd = null;
private Label labelts = null;
private Label labelm = null;
private Label labelzl = null;
private Label labesl = null;
private Label labeljg = null;
private Label labelp = null;
private Text textm = null;
private Text textsl = null;
private Text textjg = null;
private Text textp = null;
private Combo combozl = null;
private Button buttonxg = null;
private Button buttonfh = null;
private Label labelts2 = null;
private Label labelsc = null;
private Text textArea = null;
void createSShell() {
sShell = new Shell();
sShell.setText("机械仓库管理系统");
sShell.setBackground(new Color(Display.getCurrent(), 255, 160, 100));
sShell.setSize(new Point(832, 598));
sShell.setLayout(null);
labelbt = new Label(sShell, SWT.NONE);
labelbt.setBounds(new Rectangle(324, 34, 164, 55));
labelbt.setBackground(new Color(Display.getCurrent(), 255, 160, 100));
labelbt.setFont(new Font(Display.getDefault(), "华文行楷", 24, SWT.BOLD));
labelbt.setText("修改信息");
labelbh = new Label(sShell, SWT.NONE);
labelbh.setBounds(new Rectangle(90, 112, 78, 26));
labelbh.setFont(new Font(Display.getDefault(), "微软雅黑", 10, SWT.NORMAL));
labelbh.setBackground(new Color(Display.getCurrent(), 255, 160, 100));
labelbh.setText("商品编号");
text1 = new Text(sShell, SWT.BORDER);
text1.setBounds(new Rectangle(169, 107, 192, 34));
buttonqd = new Button(sShell, SWT.NONE);
buttonqd.setBounds(new Rectangle(412, 104, 86, 38));
buttonqd.setText("确定");
labelts = new Label(sShell, SWT.NONE);
labelts.setBounds(new Rectangle(202, 158, 355, 34));
labelts.setBackground(new Color(Display.getCurrent(), 255, 160, 100));
labelm = new Label(sShell, SWT.NONE);
labelm.setBounds(new Rectangle(72, 307, 104, 27));
labelm.setBackground(new Color(Display.getCurrent(), 255, 160, 100));
labelm.setFont(new Font(Display.getDefault(), "微软雅黑", 10, SWT.NORMAL));
labelm.setText("新商品名称");
labelzl = new Label(sShell, SWT.NONE);
labelzl.setBounds(new Rectangle(93, 364, 62, 24));
labelzl.setBackground(new Color(Display.getCurrent(), 255, 160, 100));
labelzl.setFont(new Font(Display.getDefault(), "微软雅黑", 10, SWT.NORMAL));
labelzl.setText("新种类");
labesl = new Label(sShell, SWT.NONE);
labesl.setBounds(new Rectangle(420, 306, 71, 25));
labesl.setFont(new Font(Display.getDefault(), "微软雅黑", 10, SWT.NORMAL));
labesl.setBackground(new Color(Display.getCurrent(), 255, 160, 100));
labesl.setText("新数量");
labeljg = new Label(sShell, SWT.NONE);
labeljg.setBounds(new Rectangle(426, 365, 57, 25));
labeljg.setBackground(new Color(Display.getCurrent(), 255, 160, 100));
labeljg.setText("新价格");
labelp = new Label(sShell, SWT.NONE);
labelp.setBounds(new Rectangle(96, 418, 57, 25));
labelp.setBackground(new Color(Display.getCurrent(), 255, 160, 100));
labelp.setText("经手人");
textm = new Text(sShell, SWT.BORDER);
textm.setBounds(new Rectangle(179, 303, 175, 34));
textsl = new Text(sShell, SWT.BORDER);
textsl.setBounds(new Rectangle(512, 301, 189, 34));
textjg = new Text(sShell, SWT.BORDER);
textjg.setBounds(new Rectangle(515, 360, 192, 34));
textp = new Text(sShell, SWT.BORDER);
textp.setBounds(new Rectangle(171, 414, 192, 34));
createCombozl();
buttonxg = new Button(sShell, SWT.NONE);
buttonxg.setBounds(new Rectangle(267, 475, 96, 34));
buttonxg.setText("修改");
buttonxg.addSelectionListener(new org.eclipse.swt.events.SelectionAdapter() {
public void widgetSelected(org.eclipse.swt.events.SelectionEvent e) {
int i=0;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D://仓库管理.mdb","","");
PreparedStatement stmt3 = con.prepareStatement("update 库存信息 set 商品名称=?,所属的种类=?,库存数量=?,单价=?,经手人=? where 商品编号=? ");
stmt3.setString(1, textm.getText());
stmt3.setString(2, combozl.getText());
stmt3.setString(3, textsl.getText());
stmt3.setString(4, textjg.getText());
stmt3.setString(5, textp.getText());
stmt3.setString(6, text1.getText());
stmt3.executeUpdate(); //执行添加
con.close();
i=1;
if(textm.getText().equals("")){
labelts2.setText("请完善数据！");
}
if(i==1){
labelts2.setText("数据更新成功！");
}
else{
labelts2.setText("数据更新失败！");
}
}
catch(Exception e2){
e2.printStackTrace();
}
}
});
buttonfh = new Button(sShell, SWT.NONE);
buttonfh.setBounds(new Rectangle(429, 475, 96, 34));
buttonfh.setText("返回主菜单");
buttonfh.addSelectionListener(new org.eclipse.swt.events.SelectionAdapter() {
public void widgetSelected(org.eclipse.swt.events.SelectionEvent e) {
主页面 zhuye=new 主页面();
zhuye.createSShell();
zhuye.sShell.open();
sShell.setVisible(false);//隐藏当前的窗口
}
});
labelts2 = new Label(sShell, SWT.NONE);
labelts2.setBounds(new Rectangle(412, 419, 365, 34));
labelts2.setBackground(new Color(Display.getCurrent(), 255, 160, 100));
labelts2.setText("");
labelsc = new Label(sShell, SWT.NONE);
labelsc.setBounds(new Rectangle(75, 207, 627, 30));
textArea = new Text(sShell, SWT.MULTI | SWT.WRAP | SWT.V_SCROLL);
textArea.setBounds(new Rectangle(75, 237, 627, 44));
buttonqd.addSelectionListener(new org.eclipse.swt.events.SelectionAdapter() {
public void widgetSelected(org.eclipse.swt.events.SelectionEvent e) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D://仓库管理.mdb","","");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from 库存信息 ");
while(rs.next())
{
String id=rs.getString("商品编号");
String mc=rs.getString("商品名称");
String zl=rs.getString("所属的种类");
String sl=rs.getString("库存数量");
String jg=rs.getString("单价");
String p=rs.getString("经手人");
if(text1.getText().trim().equals(id)){
labelsc.setText("商品编号 商品名称 所属的种类 库存数量 单价 经手人 ");
textArea.append('\t'+id+'\t'+'\t'+mc+'\t'+'\t'+zl+'\t'+'\t'+sl+'\t'+'\t'+'\t'+'\t'+jg+'\t'+'\t'+p);
labelts.setText("找到该商品的相关信息！");
}
else{
labelts.setText("未该商品的相关信息，请重新输入！");
}
}
}
catch(Exception e1){
e1.printStackTrace();
}
}
});
}
private void createCombozl() {
combozl = new Combo(sShell, SWT.NONE);
combozl.setText("零件");
combozl.setBounds(new Rectangle(174, 363, 172, 35));
combozl.add("零件");
combozl.add("成品");
combozl.add("成品材料");
combozl.add("辅助材料");
}
}
