stockmanagementdata.java

一个使用java 写的进销存代码 使用了ejb 等技术 是学习j2ee的好

package data;

import javax.naming.*;
import stockmanagementpro.*;
import user.*;
import javax.rmi.*;
import java.util.*;

public class StockManagementData {
  private StockManagementDataHome stockManagementDataHome = null;
  private stockmanagementpro.StockManagementData stockManagementData = null;

  public StockManagementData() {
    try{
      initialize();
    }catch(Exception ex){
      ex.printStackTrace();
    }
  }
  //EJB的初始化方法
  public void initialize() throws Exception {
    //创建服务器对象查找类
    Context context = getInitialContext();
    //取得EJB在服务器的对象
    Object ref = context.lookup("StockManagementData");
    //取得StockManagementData EJB的创建接口
    stockManagementDataHome = (StockManagementDataHome)PortableRemoteObject.narrow(ref,
        StockManagementDataHome.class);
    //取得StockManagementData EJB的远程接口
    create();
  }
  //服务器对象查找类的创建方法
  private Context getInitialContext() throws Exception {
    String url = "t3://bemyfriend:7001";
    String user = null;
    String password = null;
    Properties properties = null;
    //初始化联接服务器的属性
    try {
      properties = new Properties();
      properties.put(Context.INITIAL_CONTEXT_FACTORY,
                     "weblogic.jndi.WLInitialContextFactory");
      properties.put(Context.PROVIDER_URL, url);
      if (user != null) {
        properties.put(Context.SECURITY_PRINCIPAL, user);
        properties.put(Context.SECURITY_CREDENTIALS, password == null ? "" : password);
      }
      return new InitialContext(properties);
    }
    catch(Exception e) {
      System.out.println("Unable to connect to WebLogic server at " + url);
      System.out.println("Please make sure that the server is running.");
      throw e;
    }
  }
  //创建StockManagementData EJB的远程接口
  public stockmanagementpro.StockManagementData create() throws Exception {
    stockManagementData = stockManagementDataHome.create();
    return stockManagementData;
  }
  //检查用户的方法
  public int[] checkUser(String userName, String userPassword){
    int[] functions = new int[4];
    try{
      functions = stockManagementData.checkUser(userName, userPassword);
    }catch(Exception ex){
      functions[0] = -1;
      functions[1] = -1;
      functions[2] = -1;
      functions[3] = -1;
    }
    return functions;
  }
  //创建用户
  public int createUser(User user) {
    int result = 0;
    try{
      result = stockManagementData.createUser(user);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return result;
  }
  //更新用户
  public int updateUser(User user) {
    int result = 0;
    try{
      result = stockManagementData.updateUser(user);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return result;
  }
  //删除用户
  public int deleteUser(User user) {
    int result = 0;
    try{
      result = stockManagementData.deleteUser(user);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return result;
  }
  //根据用户名查询用户
  public String[][] getUserByUserName(String userName){
    //创建存取用户数据的数组
    String[][] detail = null;
    try{
      detail = stockManagementData.getUserByUserName(userName);
    }catch(Exception ex){
      detail = new String[0][6];
      ex.printStackTrace();
    }
    //返回数组
    return detail;
  }
  //日志数据表记录的创建方法
  public int createUserLog(String programName, String operationContent,
                            String userName) {
    int result = 0;
    try{
      result = stockManagementData.createUserLog(programName, operationContent, userName);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return result;
  }
  //日志数据表记录的删除方法
  public int deleteUserLog(Integer id){
    int result = 0;
    try{
      result = stockManagementData.deleteUserLog(id);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return result;
  }
  //返回数据库所有数据表名字的方法
  public String[] getTableNames() {
    String[] tableNames = new String[0];
    try{
      tableNames = stockManagementData.getTableNames();
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return tableNames;
  }
  //返回数据表数据的方法
  public String[][] getDataByTableName(String tableName) {
    String[][] data = new String[0][0];
    try{
      data = stockManagementData.getDataByTableName(tableName);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return data;
  }
  //将数组写入数据表的方法
  public int setDataByTableName(String tableName, String[][] data) {
    int result = 0;
    try{
      result = stockManagementData.setDataByTableName(tableName, data);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return result;
  }
  //取得账套名字的方法
  public String[] getLedgerNames() {
    String[] ledgerNames = new String[0];
    try{
      ledgerNames = stockManagementData.getLedgerNames();
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return ledgerNames;
  }
  //创建账套的方法
  public int createLedger(String ledgerDate) {
    int result = 0;
    try{
      result = stockManagementData.createLedger(ledgerDate);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return result;
  }
  //删除账套的方法
  public int deleteLedger(String ledgerDate) {
    int result = 0;
    try{
      result = stockManagementData.deleteLedger(ledgerDate);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return result;
  }
  //创建商品类别的方法
  public int createGoodsCategory(int parentId, String categoryName, String categoryDescription) {
    int result = 0;
    try {
      result = stockManagementData.createGoodsCategory(parentId,
        categoryName, categoryDescription);
    }catch (Exception ex) {
      ex.printStackTrace();
    }
    return result;
  }
  //更新商品类别的方法
  public int updateGoodsCategory(int categoryId, int parentId,
                                 String categoryName,
                                 String categoryDescription) {
    int result = 0;
    try {
      result = stockManagementData.updateGoodsCategory(categoryId, parentId,
        categoryName, categoryDescription);
    }catch (Exception ex) {
      ex.printStackTrace();
    }
    return result;
  }
  //删除商品类别的方法
  public int deleteGoodsCategory(int categoryId) {
    int result = 0;
    try {
      result = stockManagementData.deleteGoodsCategory(categoryId);
    }catch (Exception ex) {
      ex.printStackTrace();
    }
    return result;
  }
  //取得所有商品类别的方法
  public String[][] getAllGoodsCategory() {
    String[][] detail = new String[0][4];
    try{
      //取得商品类别的所有记录
      detail = stockManagementData.getAllGoodsCategory();
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //创建商品的方法
  public int createGoods(String goodsBarCode, int categoryId, String goodsName,
                         String goodsNickName, String goodsAssistantName,
                         String goodsPYName, String unit, String specification,
                         String producer, int upperLimit, int lowerLimit,
                         double salePrice, double discount) {
     int result = 0;
     try {
       result = stockManagementData.createGoods(goodsBarCode, categoryId, goodsName,
                     goodsNickName, goodsAssistantName, goodsPYName, unit,
                     specification, producer, upperLimit, lowerLimit, salePrice, discount);
     }catch (Exception ex) {
       ex.printStackTrace();
     }
     return result;
  }
  //更新商品的方法
  public int updateGoods(String goodsBarCode, int categoryId, String goodsName,
                         String goodsNickName, String goodsAssistantName,
                         String goodsPYName, String unit, String specification,
                         String producer, int upperLimit, int lowerLimit,
                         double salePrice, double discount) {
    int result = 0;
    try {
      result = stockManagementData.updateGoods(goodsBarCode, categoryId, goodsName,
                    goodsNickName, goodsAssistantName, goodsPYName, unit,
                    specification, producer, upperLimit, lowerLimit, salePrice, discount);
    }catch (Exception ex) {
      ex.printStackTrace();
    }
    return result;
  }
  //删除商品的方法
  public int deleteGoods(String goodsBarCode) {
     int result = 0;
     try {
       result = stockManagementData.deleteGoods(goodsBarCode);
     }catch (Exception ex) {
       ex.printStackTrace();
     }
     return result;
  }
  //根据类别取得商品的方法
  public String[][] getGoodsByGoodsCategory(int goodsCategory){
    String[][] detail = new String[0][13];
    try{
      detail = stockManagementData.getGoodsByGoodsCategory(goodsCategory);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //根据条形码取得商品的方法
  public String[][] getGoodsByGoodsBarCode(String goodsBarCode){
    String[][] detail = new String[0][13];
    try{
      detail = stockManagementData.getGoodsByGoodsBarCode(goodsBarCode);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //根据商品名字取得商品的方法
  public String[][] getGoodsByGoodsName(String goodsName){
    String[][] detail = new String[0][13];
    try{
      detail = stockManagementData.getGoodsByGoodsName(goodsName);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //根据生产厂商取得商品的方法
  public String[][] getGoodsByProducer(String producer){
    String[][] detail = new String[0][13];
    try{
      detail = stockManagementData.getGoodsByProducer(producer);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //取得折扣商品的方法
  public String[][] getDiscountGoods(){
    String[][] detail = new String[0][13];
    try{
      detail = stockManagementData.getDiscountGoods();
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //设置商品折扣的方法
  public int setGoodsDiscount(String goodsBarCode, double discount){
    int result = 0;
    try {
      result = stockManagementData.setGoodsDiscount(goodsBarCode, discount);
    }catch (Exception ex) {
      ex.printStackTrace();
    }
    return result;
  }
  //创建供应商的方法
  public int createSupplier(String[] supplierArray) {
     int result = 0;
     if(supplierArray.length != 16){
       return result;
     }
     try {
       //创建供应商
       result = stockManagementData.createSupplier(supplierArray);
     }catch (Exception ex) {
       ex.printStackTrace();
     }
     return result;
  }
  //更新供应商的方法
  public int updateSupplier(String[] supplierArray) {
     int result = 0;
     if(supplierArray.length != 16){
       return result;
     }
     try {
       //更新供应商
       result = stockManagementData.updateSupplier(supplierArray);
     }catch (Exception ex) {
       ex.printStackTrace();
     }
     return result;
  }
  //删除供应商的方法
  public int deleteSupplier(String supplierName) {
     int result = 0;
     try {
       result = stockManagementData.deleteSupplier(supplierName);
     }catch (Exception ex) {
       ex.printStackTrace();
     }
     return result;
  }
  //根据供应商名字取得记录的方法
  public String[][] getSuppliersBySupplierName(String supplierName){
    String[][] detail = new String[0][16];
    try{
      //根据供应商名字取得记录
      detail = stockManagementData.getSuppliersBySupplierName(supplierName);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //根据地区取得供应商记录的方法
  public String[][] getSuppliersBySupplierZone(String supplierZone){
    String[][] detail = new String[0][16];
    try{