oos.java~13~

JAVA超市管理系统

package project1;

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

public class Oos
{
    public Oos()
    {

    }
    public void oosRegister()
    {

    }
    public void provide(String str)
    {
        String str1=str;
        String RL = "jdbc:microsoft:sqlserver://localhost;DatabaseName=pos_mis";
        String user ="sa";
        String password = "220300124";
        String sqlStr="delete from 缺货单 where 商品编码='"+str1+"'";
        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){}
    }
}