getoutupdate.java

企业物资管理系统 为了使物资管理部门的责、权、利得到落实, 以提高总体的经济效益,采用J2EE 技术体系, 设计与实现了B/S 模式下的企业物资管理系统, 依据开发实例,分析了企业物资管理系统的

//QueryDB.java
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
public class GetoutUpdate{
   public GetoutUpdate(){
     JFrame myframe=new UpdateFrame2();
     myframe.setVisible(true);
   }
 }


class UpdateFrame2 extends JFrame{
  public UpdateFrame2(){
     setTitle("数据库更新");
     setSize(600,300);
     addWindowListener(new WindowAdapter() { 
	public void windowClosing(WindowEvent e) { 
		System.exit(0);
	}
     });
    Container contentpane=getContentPane();
	contentpane.add(new  UpdatePanel2());
   }
 }

 
  class UpdatePanel2 extends JPanel implements ActionListener {
    private Connection con=null;
    private Statement stmt=null;
    private JTextField sqlcommand;
    private JButton submit;
    private JTextArea  resultarea;
    private ResultSet rs=null;
    public UpdatePanel2()
   {
     sqlcommand=new JTextField(30);
     resultarea=new JTextArea(10,30);
     resultarea.setEditable(false);
     submit=new JButton("提交");
     add(new JLabel("SQL更新语句:"));
     add(sqlcommand);
     add(submit);
     add(new JLabel ("当前数据表GetoutInformation中的记录"));
     JScrollPane scrollpane=new JScrollPane(resultarea);
     add(scrollpane);
     submit.addActionListener(this);
    try{
   String url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=BasicInfo";
 			String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
      Class.forName(driverName).newInstance();
       //与SQL sever下的BasicInfo数据库的连接
      con=DriverManager.getConnection(url,"SA","");
      System.out.println("已连接到数据库");
      stmt=con.createStatement();
    
       }catch(Exception ex) {
         System.out.println(ex.getMessage());
          return;
       }
   }



 public void showTable(){
   try{
     rs=stmt.executeQuery("SELECT *FROM GetoutInformation");
     resultarea.setText("出库编号");
     for(int i=1;i<(30-2*"出库编号".length());i++)
      resultarea.append(" ");
      resultarea.append("出库物资编号"+"\n");
     while(rs.next())
      {
        String soutid =rs.getString("入库编号");
        resultarea.append(soutid);
        int length=soutid.length();
        //按照不同入库编号的长度，输出相应个数的空格以使后面的名称列能够对齐
        for(int i=1;i<=(30-2*length);i++) resultarea.append(" ");
         resultarea.append(rs.getString("出库物资编号")+"\n"); //输出名称
      }
     } catch(Exception ex){
       System.out.println(ex.getMessage());
     }
  }

 public void actionPerformed(ActionEvent evt)
  {
     try{
     String command=sqlcommand.getText();
   
     stmt.execute(command);
     showTable();
        } catch(Exception ex){
     System.out.println(ex.getMessage());
      }
  }
 }