Ejemplo n.º 1
0
 /** * 批量修改线路名称 */
 @Action(
     value = "changeLineName",
     results = {@Result(type = "json")})
 public String changeLineName() throws Exception {
   Connection conn = null;
   String sql = null;
   try {
     conn = MyDataSource.getConnect();
     conn.setAutoCommit(false);
     QueryRunner qr = new QueryRunner();
     sql = " SELECT newName AS a1,oldName AS a2 FROM sheet1 ";
     List<AppVo_2> list = qr.query(conn, sql, new BeanListHandler<AppVo_2>(AppVo_2.class));
     if (null != list && list.size() > 0) {
       AppVo_2 vo = new AppVo_2();
       Object[] args = null;
       for (int i = 0; i < list.size(); i++) {
         vo = list.get(i);
         sql = " UPDATE line_base_info SET lineName= ? WHERE lineName = ? ";
         args = new Object[2];
         args[0] = vo.getA1();
         args[1] = vo.getA2();
         qr.update(conn, sql, args);
       }
     }
     getResponse().getWriter().print("success");
     conn.commit();
   } catch (Exception e) {
     e.printStackTrace();
     try {
       if (null != conn && conn.isClosed() == false) {
         try {
           conn.rollback();
         } catch (SQLException e1) {
           e1.printStackTrace();
         }
       }
     } catch (SQLException e1) {
       getResponse().getWriter().print("error");
       e1.printStackTrace();
     }
   } finally {
     try {
       if (null != conn && conn.isClosed() == false) {
         conn.setAutoCommit(true);
         conn.close();
       }
     } catch (SQLException e) {
       e.printStackTrace();
     }
   }
   return null;
 }
Ejemplo n.º 2
0
  /** 更改线路价格(通用价格-指定日期(包括指定日期)以后的班次价格) */
  @Action(
      value = "updateLinePrice",
      results = {@Result(type = "json")})
  public String updateLinePrice() throws Exception {
    Connection conn = null;
    String sql = null;
    try {
      conn = MyDataSource.getConnect();
      conn.setAutoCommit(false);
      QueryRunner qr = new QueryRunner();
      sql = " SELECT A AS a1,B AS a2,C AS a3 FROM updateLinePrice ";
      List<AppVo_3> list = qr.query(conn, sql, new BeanListHandler<AppVo_3>(AppVo_3.class));
      int statu = 0;
      if (null != list && list.size() > 0) {
        AppVo_3 vo = new AppVo_3();
        Object[] args = null;
        for (int i = 0; i < list.size(); i++) {
          vo = list.get(i);
          // 改线路价格
          sql = " UPDATE line_base_info SET orderPrice= ? WHERE lineName = ? ";
          args = new Object[2];
          args[0] = vo.getA2().trim();
          args[1] = vo.getA1().trim();
          statu = qr.update(conn, sql, args);
          System.out.println("line_base_info:" + statu);

          // 改指定日期(包括指定日期)以后的班次价格
          sql =
              " UPDATE line_class_info SET price = ? WHERE lineBaseId = "
                  + "( SELECT lineBaseId FROM line_base_info WHERE lineName = ? AND lineType = 1 AND lineSubType = 0 AND lineStatus = 3 ) AND orderDate >= ? AND delFlag = 0 ";
          args = new Object[3];
          args[0] = vo.getA2().trim();
          args[1] = vo.getA1().trim();
          args[2] = vo.getA3().trim();
          statu = qr.update(conn, sql, args);
          System.out.println("line_class_info:" + statu);
        }
      }
      getResponse().getWriter().print("success");
      conn.commit();
    } catch (Exception e) {
      e.printStackTrace();
      try {
        if (null != conn && conn.isClosed() == false) {
          try {
            conn.rollback();
          } catch (SQLException e1) {
            e1.printStackTrace();
          }
        }
      } catch (SQLException e1) {
        getResponse().getWriter().print("error");
        e1.printStackTrace();
      }
    } finally {
      try {
        if (null != conn && conn.isClosed() == false) {
          conn.setAutoCommit(true);
          conn.close();
        }
      } catch (SQLException e) {
        e.printStackTrace();
      }
    }
    return null;
  }