コード例 #1
0
  // 增加进货单
  public void add(purchaseList list) {

    try {
      Connection con = initDB();

      Statement stmt = con.createStatement();

      String query =
          "insert into purchaseList(purch_id,purch_date,purch_totalPrice,unitId,acc_id) values ('"
              + list.getPurch_id()
              + "','"
              + list.getPurch_date()
              + "','"
              + list.getPurch_totalPrice()
              + "','"
              + list.getUnit_id()
              + "','"
              + list.getAcc_id()
              + "')";
      stmt.execute(query);

      // 关闭命令对象连接
      stmt.close();
      // 关闭数据库连接
      con.close();
    } catch (SQLException e) {
      System.out.println("添加数据失败!");
      e.printStackTrace();
    }
  }
コード例 #2
0
  public void update(purchaseList list) {
    try {
      Connection con = initDB();
      // 创建SQL命令对象
      Statement stmt = con.createStatement();
      // 创建SQL命令字符串
      String query =
          "update purchaseList set purch_date='"
              + list.getPurch_date()
              + "',purch_totalPrice='"
              + list.getPurch_totalPrice()
              + "',unitId='"
              + list.getUnit_id()
              + "',acc_id='"
              + list.getAcc_id()
              + "' where purch_id ='"
              + list.getPurch_id()
              + "'";

      // 执行SQL语句
      stmt.execute(query);

      // 关闭命令对象连接
      stmt.close();

      // 关闭数据库连接
      con.close();
    } catch (Exception e) {
      System.out.println("更新数据失败!");
      e.printStackTrace();
    }
  }
コード例 #3
0
  /* 	SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");

  Date date1 = new Date(2014-1900,6-1,25);

  String day1=sdf.format(date1);
  就是这样获取*/
  public ArrayList<purchaseList> findByPurch_dates(String day1, String day2) {

    purchaseList list;
    ArrayList<purchaseList> showList = new ArrayList<purchaseList>();
    try {

      Connection con = initDB();
      // 创建SQL命令对象
      Statement stmt = con.createStatement();
      // 创建SQL命令字符串
      String query =
          "select * from purchaseList where purch_date between'" + day1 + "'and'" + day2 + "'";

      // 执行SQL语句
      ResultSet rs = stmt.executeQuery(query);
      while (rs.next()) {
        list = new purchaseList();
        list.setPurch_id(rs.getString("purch_id"));
        list.setPurch_date(rs.getString("purch_date"));
        list.setPurch_totalPrice(rs.getFloat("purch_totalPrice"));
        list.setUnit_id(rs.getString("unitId"));
        list.setAcc_id(rs.getString("acc_id"));
        showList.add(list);
        list = null;
      }
      // 关闭记录集
      rs.close();
      // 关闭命令对象连接
      stmt.close();

      // 关闭数据库连接
      con.close();

    } catch (SQLException e) {
      System.out.println("查找数据失败!");
      e.printStackTrace();
    }

    return showList;
  }
コード例 #4
0
  public purchaseList findByPurch_id(String purch_id) {
    purch_id.trim();
    purchaseList purh = new purchaseList();

    try {

      Connection con = initDB();
      // 创建SQL命令对象
      Statement stmt = con.createStatement();
      // 创建SQL命令字符串
      String query = "select * from purchaseList where purch_id ='" + purch_id + "'";

      // 执行SQL语句
      ResultSet rs = stmt.executeQuery(query);
      rs.next();
      purh.setPurch_id(rs.getString("purch_id"));
      purh.setPurch_date(rs.getString("purch_date"));
      purh.setPurch_totalPrice(rs.getFloat("purch_totalPrice"));
      purh.setUnit_id(rs.getString("unitId"));
      purh.setAcc_id(rs.getString("acc_id"));

      // 关闭记录集
      rs.close();
      // 关闭命令对象连接
      stmt.close();

      // 关闭数据库连接
      con.close();

    } catch (SQLException e) {
      System.out.println("查找数据失败!");
      e.printStackTrace();
    }

    return purh;
  }