excel java ʵÀý
POIFSFileSystem fs=new POIFSFileSystem(new FileInputStream(cfname));
HSSFWorkbook wb = new HSSFWorkbook(fs);
// wb.removeSheetAt(2);
HSSFSheet sheet = wb.getSheetAt(0);
// sheet.setColumnWidth((short)200,(short)500);
sheet.setColumnWidth((short)1, (short)4000); //ÉèÖÃÎïÁϱàºÅÁеĿí¶È
sheet.setColumnWidth((short)2, (short)12000); //ÉèÖÃÎïÁÏÃèÊöÁеĿí¶È
sheet.setColumnWidth((short)4, (short)4000); // ÉèÖÃͼºÅÁеĿí¶È
HSSFFont hf=wb.createFont();
hf.setColor((short)4); //1:°×É«,2:ºìÉ«,3:ÂÌÉ«,4:À¶É«,5:»ÆÉ«,6:×ÏÉ«
HSSFCellStyle cs = wb.createCellStyle();
&
Ïà¹ØÎĵµ£º
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class LinkAccess {
/**
* @param args
*/
public stat ......
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet. ......
Jsp
·½Ãæ
jspµÄ³£ÓõÄÃüÁî´ð£ºpage, include, talib, forward,
Servlet
·½Ãæ
1
¡¢ËµÒ»Ëµ
Servlet
µÄÉúÃüÖÜÆÚ
?
´ð:servletÓÐÁ¼ºÃ
µÄÉú´æÆÚµÄ¶¨Ò壬°üÀ¨¼ÓÔØºÍʵÀý»¯¡¢³õʼ»¯¡¢´¦ÀíÇëÇóÒÔ¼°·þÎñ½áÊø¡£Õâ¸öÉú´æÆÚÓÉjavax.servlet.Servlet½Ó¿ÚµÄ
init,serviceºÍdestroy·½·¨±í´ï¡£
2
¡¢
Servlet
°æ±¾¼ä
(
ÍüÁ ......
package com.qiao.java;
import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.OutputStreamWriter;
import java.io.PrintWriter;
import java.util.HashMap;
import java.util.Iter ......