/**
  * @name : registerOk
  * @date : 2015. 6. 25.
  * @author : 이명진
  * @description : 회원가입시 입력된 데이터를 member 테이블에 저장하기 위한 메소드
  */
 @Override
 public int registerOk(MemberDto memberDto) {
   // TODO Auto-generated method stub
   if (memberDto.getMemberFileName() != null) {
     return sqlSession.insert("member.dao.mapper.registerOkFile", memberDto);
   } else {
     return sqlSession.insert("member.dao.mapper.registerOk", memberDto);
   }
 }
Example #2
0
  /**
   * @name : blogWrite
   * @date : 2015. 7. 02.
   * @author : 황준
   * @description : 블로그 작성
   */
  @Override
  public HashMap<String, Object> blogWrite(HashMap<String, Object> hashMap) {
    logger.info("BoardDao blogWrite  DAO-------------------------");
    int check = sqlSession.insert("dao.BoardMapper.blogWrite", hashMap);

    if (check > 0) {
      check = sqlSession.insert("dao.BoardMapper.blogWrite_addr", hashMap);
      if (check > 0) {
        check = sqlSession.insert("dao.BoardMapper.blogWrite_point", hashMap);
      }
    }
    hashMap.put("check", check);
    return hashMap;
  }
Example #3
0
  public static void main(String[] args) throws Exception {

    ClassPathXmlApplicationContext applicationContext =
        new ClassPathXmlApplicationContext("classpath:ApplicationContext.xml");

    SqlSessionTemplate template =
        applicationContext.getBean("sqlSessionTemplate", SqlSessionTemplate.class);
    FileInputStream stream = new FileInputStream(new File("/Users/yanzhao/Desktop/gg.html"));
    InputStreamReader reader = new InputStreamReader(stream, "utf-8");
    BufferedReader bufferedReader = new BufferedReader(reader);

    String line = null;
    Map<String, Content> map = new HashMap<String, Content>();
    List<String>[] tcodes = new List[10];
    while ((line = bufferedReader.readLine()) != null) {
      String[] params = line.split(" ");
      Basedata basedata = new Basedata();
      basedata.setCode(params[2]);
      basedata.setLink(params[0]);
      basedata.setName(params[1]);
      basedata.setZs(Long.parseLong(params[4]));
      basedata.setZsabbre(params[3]);
      System.out.println(JSON.toJSON(basedata));

      template.insert("mybatis/mapper.BasedataMapper.insert", basedata);
    }
  }
Example #4
0
  /**
   * @함수이름 : infoInsert @작성일 : 2015. 12. 7. @개발자 : 전현준 @함수설명 : xml 파일에 넘겨서 관리자 페이지 회사정보 등록 - (footer
   * 부분)
   */
  @Override
  public int infoInsert(AdminInfoDto adminInfoDto) {
    int value = 0;

    value = sessionTemplate.insert("dao.adminInfoMapper.infoInsert", adminInfoDto);
    return value;
  }
Example #5
0
 /**
  * @name : getCoupon
  * @date : 2015. 7. 15.
  * @author : 황준
  * @description :쿠폰 조회
  */
 @Override
 public int getCoupon(String member_id, String coupon_no) {
   HashMap<String, Object> hMap = new HashMap<String, Object>();
   hMap.put("member_id", member_id);
   hMap.put("coupon_no", coupon_no);
   return sqlSession.insert("dao.BoardMapper.insertCouponIssue", hMap);
 }
Example #6
0
  public void reply_insert(BoardDTO dto) {
    logger.info("\nBoardDAO class reply_insert(BoardDTO)");
    logger.info("BoardDAO replyname = " + dto.getReply_name());
    logger.info("BoardDAO replycontent =" + dto.getReply_content());
    logger.info("BoardDAO hobby_no =" + dto.getHobby_no());

    sqlSession.insert("reply_add", dto);
  } // end reply_insert
Example #7
0
 public void dbInsert(BoardDTO dto) {
   logger.info("\nBoardDAO class dbInsert(BoardDTO)");
   logger.info("BoardDAO name = " + dto.getName());
   logger.info("BoardDAO title =" + dto.getTitle());
   logger.info("BoardDAO content =" + dto.getContent());
   logger.info("BoardDAO gender =" + dto.getGender());
   logger.info("BoardDAO hobby =" + dto.getHobby());
   logger.info("BoardDAO filename=" + dto.getImg_file_name());
   sqlSession.insert("add", dto);
 } // end dbInsert
Example #8
0
  /**
   * @name : blogWrite_attach
   * @date : 2015. 7. 02.
   * @author : 황준
   * @description : 블로그 작성(첨부이미지)
   */
  @Override
  public int blogWrite_attach(HashMap<String, Object> hashMap) {
    logger.info("BoardDao blogWrite_attach  DAO-------------------------");

    ArrayList<Attach_fileDto> attachList = (ArrayList<Attach_fileDto>) hashMap.get("attachList");
    logger.info("attachList:" + attachList.size());
    for (int i = 0; i < attachList.size(); i++) {
      logger.info(attachList.get(i).getFile_path());
    }

    int check = sqlSession.insert("dao.BoardMapper.blogWrite_attach", hashMap);
    return check;
  }
Example #9
0
 @Override
 public void insert(App app) {
   sqlSession.insert("insertApp", app);
 }
  public void writeLog(CoreModel model, String operateType) {
    String name = model.getClass().getName();
    Map<String, Object> param = new HashMap<String, Object>();
    param.put("className", name);
    param.put("outLog", "Y");
    List<Table> tableList =
        sqlSessionTemplate.selectList(
            "com.delmar.core.mybatis.sql.TableMapper.selectByExample", param);

    Table table = null;
    if (tableList != null && tableList.size() > 0) {
      table = tableList.get(0);
    }
    try {
      if (table != null) {
        param = new HashMap<String, Object>();
        param.put("tableId", table.getId());
        List<TableColumn> tableColumnList =
            sqlSessionTemplate.selectList(
                "com.delmar.core.mybatis.sql.TableColumnMapper.selectByExample", param);
        Map<String, Object> obj = new HashMap<String, Object>();
        if (tableColumnList != null) {
          for (TableColumn column : tableColumnList) {
            obj.put(
                column.getAttributeName(),
                PropertyUtils.getProperty(model, column.getAttributeName()));
          }
        }
        Changelog log = new Changelog();
        log.setOperateType(operateType);
        log.setCreated(new Date());
        log.setContext(gson.toJson(obj));

        if (request != null) {
          UserInterface user = (UserInterface) request.getSession().getAttribute("loginUser");
          if (user != null) {
            log.setUserId(user.getId());
            log.setUsername(user.getUsername());
          } else {
            String userName = SessionContent.getUserId(Thread.currentThread().getId());
            log.setUsername(userName);
          }
        } else {
          String userName = SessionContent.getUserId(Thread.currentThread().getId());
          log.setUsername(userName);
        }

        Object pk = PropertyUtils.getProperty(model, "id");
        if (pk != null) log.setPk((Integer) pk);
        if (StringUtil.isNotEmpty(table.getBuPk())) {
          Object buPk = PropertyUtils.getProperty(model, table.getBuPk());
          if (buPk != null) log.setBuPk(buPk.toString());
        }

        log.setTableId(table.getId());
        sqlSessionTemplate.insert("com.delmar.core.mybatis.sql.ChangelogMapper.insert", log);
      }

    } catch (Exception e) {
      logger.error("插入操作日志异常", e);
    }
  }
Example #11
0
 @Override
 public void addService(ServicePara servicePara) {
   sqlSession.insert("addService", servicePara);
 }
 /**
  * 插入操作
  *
  * @param statement SQL语句的Id号(命名空间+name)
  * @param parameter 参数
  */
 public int insert(String statement, Object parameter) {
   return sqlSession.insert(statement, parameter);
 }
Example #13
0
 @Override
 public int join(String queryId, MemberDTO dto) throws DataAccessException {
   printQueryId(queryId);
   return sqlMap.insert("insertMember", dto);
 }
Example #14
0
 public void addAppclient(RawAppClientDto app) {
   sqlSession.insert("appclient.addAppclient", app);
 }
Example #15
0
 public Object insert(String queryId, Object params) {
   printQueryId(queryId);
   return sqlSession.insert(queryId, params);
 }
 /**
  * 插入操作
  *
  * @param statement SQL语句的Id号(命名空间+name)
  */
 public int insert(String statement) {
   return sqlSession.insert(statement);
 }
 /* (non-Javadoc)
  * @see com.delmar.core.dao.SqlSessionForLog#insert(java.lang.String, java.lang.Object)
  */
 public int insert(String statement, CoreModel model) {
   int returnvalue = sqlSessionTemplate.insert(statement, model);
   this.writeLog(model, SessionContent.OPERATE_INSERT);
   return returnvalue;
 }
Example #18
0
 public void insert(Children children) {
   sqlSession.insert("children.insert");
 }
Example #19
0
 public boolean addImage(Image image) {
   return sqlSessionTemplate.insert("addImage", image) > 0;
 }