BeautifulSoup

http://www.crummy.com/software/BeautifulSoup/

http://susukang98.springnote.com/pages/333771

http://www.ibm.com/developerworks/kr/library/l-python-mechanize-beautiful-soup/index.html

pygtk + glade 사용

1. glade에 있는 gBox는 사용이 안될때 
1. 대체 방법 windowFrame에 gBox을 올리고 마우스 오른쪽 클릭해서 상위 콤포넌트로 설치하기 해서 VBox를 넣는다.
2. TextView에서 스크롤바 올리는 방법
1. scrollWidget 위에 TextView를 놓는다.
3. x 버튼 클릭시 닫기 .
1. windowframe에서 delete-event에 call back 함수 연결
2. call back 함수에서 gtk.main_quit()
4. gtk 관련 링크 
1. http://giv.sourceforge.net/

python sort

http://wiki.python.org/moin/HowTo/Sorting/

언어별 나머지

나머지 구하기
scheme : remainder

erlang : rem

clisp : rem

몫 구하기

erlang : / 실수형
           div 정수형

clisp  : 정수 / 정수 :  분수
           정수 / 실수 or 실수 / 정수 : 실수

spring mvc + jxls

jxls view

package resolver;

import java.io.FileInputStream;
import java.net.URLEncoder;
import java.util.HashMap;
import java.util.Locale;
import java.util.Map;
import java.util.Enumeration;

import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import net.sf.jxls.transformer.XLSTransformer;


import org.apache.commons.lang.StringUtils;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Workbook;
import org.springframework.core.io.Resource;
import org.springframework.core.io.support.LocalizedResourceHelper;
import org.springframework.web.servlet.support.RequestContextUtils;
import org.springframework.web.servlet.view.AbstractView;
import org.springframework.web.servlet.view.InternalResourceView;
import org.springframework.web.servlet.view.document.AbstractExcelView;

public class JxlsView extends InternalResourceView {
	
	private Log log = LogFactory.getLog(this.getClass());
	
	/** The content type for an Excel response */
	private static final String CONTENT_TYPE = "application/vnd.ms-excel";

	/** The extension to look for existing templates */
	private static final String EXTENSION = ".xls";


	private String url;

	private boolean existFile = false;
	
	private Resource resource;
	
	
	public Resource getResource() {
		return resource;
	}

	public void setResource(Resource resource) {
		this.resource = resource;
	}

	/**
	 * Default Constructor.
	 * Sets the content type of the view to "application/vnd.ms-excel".
	 */
	public JxlsView() {
		setContentType(CONTENT_TYPE);
	}

	@Override
	protected boolean generatesDownloadContent() {
		return true;
	}
	
	
	
	public void setExistFile(boolean existFile) {
		this.existFile = existFile;
	}

	public boolean isExistFile() {
		return existFile;
	}

	@Override
	protected void renderMergedOutputModel(Map model, HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		// Determine which request handle to expose to the RequestDispatcher.
				HttpServletRequest requestToExpose = getRequestToExpose(request);

		// Expose the model object as request attributes.
		exposeModelAsRequestAttributes(model, requestToExpose);
		
		Map map =  exposeRequestAttributesAsMap(request);
		String contentDisposition = "attachment; filename=";
		if(StringUtils.isNotEmpty((String)map.get("filename"))) {
			
			contentDisposition +=  URLEncoder.encode((String)map.get("filename"),"UTF-8");
		} else {
			contentDisposition +=  this.getResource().getFilename();
		}
		
		response.setHeader("Content-Disposition", contentDisposition);
		 
		if(log.isDebugEnabled()) {
			log.debug("URL ="+url);
		}
		Workbook workbook;
		if (resource != null) {
			workbook = new XLSTransformer().transformXLS(this.resource.getInputStream(),map);
		}
		else {
			workbook = new HSSFWorkbook();
			logger.debug("Created Excel Workbook from scratch");
		}

		buildExcelDocument(model, workbook, request, response);

		// Set the content type.
		response.setContentType(getContentType());

		// Should we set the content length here?
		// response.setContentLength(workbook.getBytes().length);

		// Flush byte array to servlet output stream.
		ServletOutputStream out = response.getOutputStream();
		workbook.write(out);
		
		out.flush();
	}
	
	protected Map exposeRequestAttributesAsMap(HttpServletRequest request) throws Exception {
		Map map = new HashMap();

		for (Enumeration e = request.getAttributeNames() ; e.hasMoreElements() ;) {
			String name = e.nextElement();
			map.put(name,request.getAttribute(name));
	     }
		return map;
	}

	/**
	 * Subclasses must implement this method to create an Excel HSSFWorkbook document,
	 * given the model.
	 * @param model the model Map
	 * @param workbook the Excel workbook to complete
	 * @param request in case we need locale etc. Shouldn't look at attributes.
	 * @param response in case we need to set cookies. Shouldn't write to it.
	 */
	protected void buildExcelDocument(
			Map model, Workbook workbook, HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		
	}


	/**
	 * Convenient method to obtain the cell in the given sheet, row and column.
	 * Creates the row and the cell if they still doesn't already exist.
	 * Thus, the column can be passed as an int, the method making the needed downcasts.
	 * @param sheet a sheet object. The first sheet is usually obtained by workbook.getSheetAt(0)
	 * @param row thr row number
	 * @param col the column number
	 * @return the HSSFCell
	 */
	protected HSSFCell getCell(HSSFSheet sheet, int row, int col) {
		HSSFRow sheetRow = sheet.getRow(row);
		if (sheetRow == null) {
			sheetRow = sheet.createRow(row);
		}
		HSSFCell cell = sheetRow.getCell((short) col);
		if (cell == null) {
			cell = sheetRow.createCell((short) col);
		}
		return cell;
	}

	/**
	 * Convenient method to set a String as text content in a cell.
	 * @param cell the cell in which the text must be put
	 * @param text the text to put in the cell
	 */
	protected void setText(HSSFCell cell, String text) {
		cell.setCellType(HSSFCell.CELL_TYPE_STRING);
		cell.setCellValue(text);
	}
	
}

resolver

package app.resolver;

import java.io.File;
import java.util.Locale;

import javax.servlet.http.HttpServletRequest;
import javax.swing.JSlider;

import org.apache.commons.io.FilenameUtils;
import org.apache.commons.lang.StringUtils;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.core.io.Resource;
import org.springframework.core.io.support.LocalizedResourceHelper;
import org.springframework.web.context.request.RequestContextHolder;
import org.springframework.web.context.request.ServletRequestAttributes;
import org.springframework.web.servlet.View;
import org.springframework.web.servlet.support.RequestContextUtils;
import org.springframework.web.servlet.view.AbstractUrlBasedView;
import org.springframework.web.servlet.view.InternalResourceView;
import org.springframework.web.servlet.view.InternalResourceViewResolver;
import org.springframework.web.servlet.view.UrlBasedViewResolver;

public class UrlBasedExcelViewResolver extends InternalResourceViewResolver {
	
	private Log log = LogFactory.getLog(this.getClass());
	
	@Override
	protected JxlsView buildView(String viewName) throws Exception {
		JxlsView view = (JxlsView) super.buildView(viewName);
		LocalizedResourceHelper helper = new LocalizedResourceHelper(getApplicationContext());
		HttpServletRequest request=((ServletRequestAttributes)RequestContextHolder.currentRequestAttributes()).getRequest();
		Locale userLocale = RequestContextUtils.getLocale(request);
		Resource resource =  helper.findLocalizedResource(super.getPrefix() + StringUtils.chomp(viewName, FilenameUtils.getExtension(viewName)), FilenameUtils.getExtension(viewName), userLocale);
		
		if( resource != null) {
			view.setResource(resource);
			view.setExistFile(resource.exists());
		} else {
			view.setExistFile(false);
		}
		
		return view;
	}
	
	protected View loadView(String viewName, Locale locale) throws Exception {
		JxlsView view = buildView(viewName);
		View result = (View) getApplicationContext().getAutowireCapableBeanFactory().initializeBean(view, viewName);
		return (view.isExistFile() ? result : null);
	}
}

excel 다운 controller 처리

@RequestMapping("/excel.do")
	public String excel(HttpServletRequest request) {

		/**
		 * http://jxls.sourceforge.net/samples/tagsample.html
		 * 참고 주소 
		 */
		request.setAttribute("filename","샘플.xlsx");
		request.setAttribute("title","타이틀");
		List> list = new ArrayList>();
		HashMap map = new HashMap();
		map.put("name", "재진");
		map.put("value", "값");
		list.add(map );
		list.add(map );
		list.add(map );
		request.setAttribute("list", list);
		return "sampleExcel.xlsx";
	}

spring-servlet.xml 설정

<bean class="app.resolver.UrlBasedExcelViewResolver" p:order="1"
       p:prefix="/WEB-INF/excel/"
       p:viewclass="app.resolver.JxlsView">
</bean>


필요 lib
스프링 3.0
스프링 MVC 3.0
POI-3.8
JXLS 1.0

gtk 로 이미지 합치기

http://faq.pygtk.org/index.py?req=show&file=faq08.018.htp

 pixbuf = gtk.gdk.pixbuf_new_from_file("foo.png") // 위에 올릴 이미지
 pixbuf2 = gtk.gdk.pixbuf_new_from_file("bar.png") // 백그라운드로 할 이미지 
 pixbuf.composite(pixbuf2, 0, 0, pixbuf.props.width, pixbuf.props.height, 0, 0, 1.0, 1.0, gtk.gdk.INTERP_HYPER, 127)

 ## now pixbuf2 contains the result of the compositing operation
 pixbuf2.save("zbr.png", 'png') // 최종합친 이미지

번표

비교할 수 :

내 번표에 FFFNNDDFF로 입력..
상대방 번표에서 FFNNDDFFD로 번표 길이을 동일하게 입력하고 번표확인을 클릭하면 같이 번표인 날을 표시함.