oos.java

来自「JAVA超市管理系统」· Java 代码 · 共 43 行

package project1;

import java.io.*;
import java.sql.*;

public class Oos
{
    String str;
    public Oos()
    {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }

    }
    public void oosRegister()
    {

    }
    public void provide(String str)
    {
        this.str=str;
        String RL = "jdbc:microsoft:sqlserver://localhost;DatabaseName=pos_mis";
        String user ="sa";
        String password = "220300124";
        String sqlStr="delete from 缺货表 where 商品编码='"+str+"'";
        try{
                   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
                   Connection con = DriverManager.getConnection(RL,user,password);
                   Statement st = con.createStatement();
                   ResultSet rs =st.executeQuery( sqlStr );
                   rs.close();
                   st.close();
                   con.close();
            }catch(Exception err){}
    }

    private void jbInit() throws Exception {
    }
}