ÕªÒª£º jspÒ³Ãæת³Éexcel¸ñʽµÄʵÏÖ˼·£º1.ʹÓÃpoi°ü£ºpoi-bin-3.9-20121203¡¡ÏÂÔØÁ¬½ÓµØÖ·£ºhttp://www.apache.org/dyn/closer.cgi/poi/release/bin/poi-bin-3.9-20121203.tar.gz import org.apache.poi.hssf.usermodel.*; Õâ¸ö°ü¿ÉÒÔ°ïÖúʵÏÖÏÂÔØexcelÄ£°æµÄÉè¼Æ£¬¼òµ¥Ò×Ó㬹¦ÄÜÒ²·Ç³£Ç¿´ó¡£1 HSSFWorkbook workBook = new HSSFWorkbook();//ÊDzÙ×÷Excel2003µÄ°æ±¾£¬À©Õ¹ÃûÊÇxls2 3 HSSFSheet... ÔĶÁÈ«ÎÄ
posted @ 2013-07-16 10:30 °®Ð¦µÄºüÀê ÔĶÁ(726) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º 1. URL´«²Î:jspÏòºǫ́servlet´«²Î /AccountServlet?action=code&nbbm=${sl.sl_nbm}&gsmc=${s1.sl_gsmc}">¶ÔÕ˵¥³¬Á´½Ó´«²Î¶¼ÊÇget·½·¨ ³öÏÖÂÒÂë½â¾ö·½·¨£º String gsmc = request.getParameter("gsmc"); gsmc = new String(gsmc.getBytes("ISO-8859-1"), "UTF-8"); //URL´«²ÎÖÐÎıØÐëתÂë 2. URL´«²Î£ºjspµ÷ÓÃjavasrip ÔĶÁÈ«ÎÄ
posted @ 2013-07-11 15:56 °®Ð¦µÄºüÀê ÔĶÁ(427) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º Êý¾ÝÁ¿ÓÐ40ÍòÌõ£¬´ÓÒ»¸ö¶ÔÏótable_01Ò»ÌõÒ»ÌõÈ¡Êýµ½¶ÔÏótable_02,Èç¹ûÓÃԭʼµÄStatement Statmt =comm.createStatement();String sql="insert into tb2....";Statmt.executeUpdate(sql);newCon.commit();//ÕâÀïÊÇÿִÐÐÒ»Ìõsql²åÈëÓï¾ä¾ÍcommitÒ»´ÎStatmt.close();µ±io²Ù×÷Ƶ·±µÄʱºò±ØÈ»»á½µµÍsqlÐÔÄÜ£¬ÕâÀï¿ÉÒÔ²ÉÈ¡·ÖÅúcommitµÄÐÎʽ¼õÉÙio²Ù×÷¡£Ê×Ïȶ¨ÒåÒ»¸ö¼ÆÊýÆ÷count£¬µ±count%1000µÄʱºòcommitÒ»´Î£¬¼Çס×îºó ÔĶÁÈ«ÎÄ
posted @ 2013-06-26 14:13 °®Ð¦µÄºüÀê ÔĶÁ(737) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º @ »ñȡϵͳÐÅÏ¢:ÉèÖÃÃüÁî²ÎÊý@ ±íÊäÈë: ÔĶÁÈ«ÎÄ
posted @ 2013-06-24 10:29 °®Ð¦µÄºüÀê ÔĶÁ(6519) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º ÔĶÁÈ«ÎÄ
posted @ 2013-06-24 10:13 °®Ð¦µÄºüÀê ÔĶÁ(2223) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º Ç°Á½ÌìÓÃkettleºÍ´æ´¢¹ý³ÌʵÏÖÁËÁ½¸ö»®Ð¡½Ó¿Ú£¬È»ºóÓÃbatµ÷ÓÃËüÃÇ£¬ÔÚ×Ô¼ºµÄxpϵͳÉϲâÊÔÍêȫͨ¹ý£¬Ã»ÓÐÈκÎÎÊÌ⡣ȻºóºÜ¿ªÐĵΰѳɹû´ò°ü¸ø±±¾©µÄͬÊÂËûÃÇʹÓᣵڶþÌìËûÃǸúa56爆大奖在线娱乐˵ÎÞ·¨È¡Êý£¬a56爆大奖在线娱乐ÂíÉϾÍÁ÷À亹ÁË£¬Ö±¾õ²»»áÕâô¼òµ¥¾ÍËãÁË¡£Íò°ãÎÞÄÎÏ£¬Ö»µÃÔ¶³Ì½â¾öÎÊÌâÄÄ~£¡kettle×îÁîÈË¿ªÐĵÄÊDz»ÐèÒª°²×°£¬Ö»ÐèÒªÌṩÏàÓ¦µÄjdk°æ±¾¾Í¿ÉÒÔ¡£´ò¿ªspoon.bat£¬¿ÉÒÔ²éѯµ½ÏàÓ¦µÄ°æ±¾£º==============================================REM java version "1.6.0_17"REM Java(TM) SE Runtime En ÔĶÁÈ«ÎÄ
posted @ 2013-06-21 14:40 °®Ð¦µÄºüÀê ÔĶÁ(245) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º @batset /p param=ÇëÊäÈëʱ¼ä:echo %param%F:cd D:/data-integrationecho ÕýÔÚÖ´ÐнӿÚcall Kitchen.bat/norep /file jobname.kjb %param%@kjbÎļþ±ØÐë·ÅÖÃÔÚĿ¼¡¾D:/data-integration¡¿Ï ÔĶÁÈ«ÎÄ
posted @ 2013-06-20 13:23 °®Ð¦µÄºüÀê ÔĶÁ(632) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º public static void info(String[] param){ StringBuffer sb=new StringBuffer(); for(int i=0;i<param.length;i++){ sb.append(param[i]).append(","); } System.out.println(sb); } ÔĶÁÈ«ÎÄ
posted @ 2013-06-19 13:33 °®Ð¦µÄºüÀê ÔĶÁ(440) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º @batµ÷ÓÃsqlÎļþ sqlplus user/pass@orcl @F:\factory.sql@½«ËùÓеĴ洢¹ý³Ì·â×°ÔÚsqlÖÐ factory.sql:exec pro_factory(&identifier,&param);@pro_factory.pro´æ´¢¹ý³Ì·â×°ËùÓеÄ×Ó´æ´¢¹ý³Ì£¬²¢ÉèÖòÎÊýidentifierÇø·Ö²»Í¬µÄ´æ´¢¹ý³Ìcreate or replace procedure pro_factory(identifier in number, param in varchar2) isbegin if identifier=0 then pro_1(param ÔĶÁÈ«ÎÄ
posted @ 2013-06-19 13:11 °®Ð¦µÄºüÀê ÔĶÁ(2466) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º @ ÔÚÏîĿ·¾¶Ï´´½¨Ò»¸ötext: jco.client.ashost=host jco.client.client=client ±£´æÁí´æΪuser.properties@public static void main(String[] args) throws SQLException, IOException { String currpath = new File("").getAbsolutePath() +"\\user.properties"; //»ñÈ¡ÊôÐÔÎļþµÄ¾ø¶Ô·¾¶ System.out.println(currpath); Prop ÔĶÁÈ«ÎÄ
posted @ 2013-06-17 10:53 °®Ð¦µÄºüÀê ÔĶÁ(203) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º import java.lang.reflect.Field; static String url; public static void main(String[] agrs) throws Exception{ Class clazz = DBPool.class; Field fieldUrl = clazz.getDeclaredField("url"); fieldUrl.setAccessible(true);//Ö»ÓÐÕâÀïÉèÖÃΪtrue²Å¿ÉÒÔÐÞ¸Ä fieldUrl.set(url, "192.168.10.155"); System.out. ÔĶÁÈ«ÎÄ
posted @ 2013-06-14 13:25 °®Ð¦µÄºüÀê ÔĶÁ(4107) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º /** * ¶ÁÈ¡a56爆大奖在线娱乐ÎļþµÄÅäÖÃÐÅÏ¢ * @throws IOException * */ public static String readTxtFile() throws IOException{ String read; BufferedReader bufread= new BufferedReader(new FileReader(filename)); while((read=bufread.readLine())!=null){ readStr=(readStr+read); } System.out.println("¶ÁÈ¡ÅäÖÃÎļþÐÅÏ¢£º"+readStr); ÔĶÁÈ«ÎÄ
posted @ 2013-06-14 11:46 °®Ð¦µÄºüÀê ÔĶÁ(156) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º javaÏà¶Ô·¾¶http://www.blogjava.net/flysky19/articles/93492.htmlͨ¹ýjava.io¶ÁÈ¡texta56爆大奖在线娱乐ÄÚÈÝhttp://www.cnblogs.com/manongxiaojiang/archive/2012/10/13/2722068.html ÔĶÁÈ«ÎÄ
posted @ 2013-06-14 09:24 °®Ð¦µÄºüÀê ÔĶÁ(164) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º import java.text.ParseException;import java.text.SimpleDateFormat;import java.util.Calendar; @ ËæÒâ¸øÒ»¸öʱ¼äµÄ×Ö·û´®:4201305¶ÔÓ¦¸ñʽ"4yyyyMM" String¡¡it_state="4201301";@ ת»»³Éʱ¼äpublic static String getPrevByState(String it_state) throws ParseException{ Calendar cal = Calendar.getInstance(); cal. ÔĶÁÈ«ÎÄ
posted @ 2013-06-09 17:19 °®Ð¦µÄºüÀê ÔĶÁ(544) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º ¾­ÀíÒªÇóËùÓеÄÈ¡ÊýÍÆÊý½Ó¿ÚÈ«²¿·â×°ÔÚÒ»¸ömainº¯ÊýÖУ¬È»ºó´ò°üд³ÉbatÅú´¦ÀíÎļþ£¬µ«ÊÇÀïÃæµÄ½Ó¿ÚÍÆÊýµÄÊý¾Ý¿âÁ¬½ÓÊDz»Í¬µÄ¡£Í¬ÊÂÃÇдµÄÊý¾Ý¿âÁ¬½Ó¶¼Êǹ«ÓÃͬһ¸öconn£¬Ã¿´ÎÖ´ÐÐÄĸö½Ó¿Ú¾ÍÐÞ¸ÄÊý¾Ý¿â³ØµÄurl,userºÍpassword¡£Èç¹ûÒª°ü×°³ÉÅú´¦ÀíÎļþ£¬ÄÇôÐèÒª´´½¨Ò»¸ö·½·¨ÓÃÓÚ¶¯Ì¬´´½¨Êý¾Ý¿âÁ¬½Ó¡£ Ê×ÏÈ£¬ÓÉÓÚÏîÄ¿»¹ÊDZȽÏÅÓ´óµÄ£¬²»¿ÉÄÜ´´½¨¶à¸öconn£¬È»ºóÐ޸ĴúÂëÉñÂíµÄ£¬Î¨Ò»µÄ°ì·¨¾ÍÊÇÒªÐÞ¸ÄÈý¸ö²ÎÊýurl,userºÍpassword¡£¿ÉÊÇÈç¹ûÔÚÊý¾Ý¿â³ØjavaÎļþÖн«ÕâÈý¸ö²ÎÊýÉèÖÃΪÊôÐÔ£¬È»ºóÿ´Îµ÷ÓõÄʱºòͨ¹ý·´ÉäÐÞ¸ÄÊôÐÔÖµ£¬ÕâÑùµÄ¿ÉÐÐÐÔÒ²ÊǺܲîµÄ¡£±¾À´java¾ÍÊÇÃæÏò¶ÔÏóµÄ£¬ÐÞ¸ÄÊô. ÔĶÁÈ«ÎÄ
posted @ 2013-06-09 16:17 °®Ð¦µÄºüÀê ÔĶÁ(945) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º http://www.ztree.me/v3/main.php#_zTreeInfo ÔĶÁÈ«ÎÄ
posted @ 2013-06-09 09:18 °®Ð¦µÄºüÀê ÔĶÁ(105) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º @eclipseµ¼ÈëjavaÏîÄ¿·½·¨£º File->Import->General->Existing Projects into Workspace@¿ÉÄܳöÏÖÎÊÌ⣺cannot be resolved to a type@Ô­Òò£ºjdk°æ±¾²»Ò»ÖÂ@½â¾ö·½°¸£º1.¡¾ÏîÄ¿¡¿-ÓÒ»÷¡¾ÊôÐÔ¡¿2.Ë¢ÐÂÏÂÏîÄ¿¾Í¿ÉÒÔÁË ÔĶÁÈ«ÎÄ
posted @ 2013-06-08 16:50 °®Ð¦µÄºüÀê ÔĶÁ(345) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º @¼òµ¥µÄmainº¯Êý£ºÊµÏÖ¹«Ë¾±àÂëȱʡʱ£¬ÕâÀォĬÈÏÈ¡ËùÓй«Ë¾±àÂëimport java.sql.SQLException;import com.evsoft.db.DataList;import com.evsoft.db.Db;public class teststr { /** * @param args * @throws SQLException */ public static void main(String[] args) throws SQLException { DataList gsbmList=null; // TODO Auto-generated... ÔĶÁÈ«ÎÄ
posted @ 2013-06-06 16:46 °®Ð¦µÄºüÀê ÔĶÁ(453) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º @Ô´´úÂ룺Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();@±¨´í£ºNEW DB CONNECTION ERROR: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriverException in thread "main" java.lang.NullPointerException at org.evsoft.batProject.db.DBPool.getConnection(DBPool.java ÔĶÁÈ«ÎÄ
posted @ 2013-06-06 14:10 °®Ð¦µÄºüÀê ÔĶÁ(347) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º 1.Mainº¯Êý:ÓÃÓÚµ÷ÓÃÊý¾Ý¿â³Ø´´½¨Êý¾Ý¿âÁ¬½Ópublic class MainPro { public static void main(String[] args) { //ÕâÀï¾ÍÊǽÓÊÕ¿ØÖÆ̨²ÎÊýµÄ·½·¨ String ip =args[0]; String user=args[1]; String password=args[2]; System.out.println(DBPool.getConnection(ip,user,password)); }}2.ÔÚ¿ØÖÆ̨ÊäÈë²ÎÊý@Run Congifurations@Ñ¡ÔñÒªÖ´ÐеÄmainº¯Êý@ÔÚ¿ØÖÆ̨ÊäÈë²ÎÊý¡¾Apply¡¿... ÔĶÁÈ«ÎÄ
posted @ 2013-06-06 13:41 °®Ð¦µÄºüÀê ÔĶÁ(1411) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º ÏÂÃæµÄÖ÷³ÌÐòÊÇͨ¹ýeclipseдµÄ£º1.ÔÚMainº¯Êý½ÓÊÕbatÎļþ´«µÝµÄ²ÎÊý£¨String[] args£©È磺 String ip =args[0]; String user=args[1]; String password=args[2];2.½«ÏîÄ¿´ò°ü@°²×°²å¼þfatjar ½âѹ²å¼þ½«"net.sf.fjep.fatjar_0.0.31.zip"·ÅÔÚeclipse\pluginsĿ¼ÏÂ@ÖØÆôEclipseÔÚÓÒ»÷ÏîÄ¿'"Bulid Fat Jar" ¡¾Jar-Name¡¿ÊäÈëÉú³ÉµÄjarÃû£»¡¾Main_Class¡¿Ñ¡ÔñÖ÷Àࣻ3.ÔÚµ¼³öµÄjar ÔĶÁÈ«ÎÄ
posted @ 2013-06-06 13:28 °®Ð¦µÄºüÀê ÔĶÁ(5921) ÆÀÂÛ(0) ÍƼö(1) ±à¼­
ÕªÒª£º OracleÊÇʲô£¬×÷ÓÃÊÇʲô£¿oracleÊǹØϵÐ͵ÄÊý¾Ý¿â£¬ÓÃÓÚ´æÈ¡Ïà¹ØÐÅÏ¢£¨store and retrieve related information£©£¬Êǽâ¾öÐÅÏ¢¹ÜÀíµÄ¹Ø¼ü£¬²¢ÇÒ¿É¿¿µØ¹ÜÀí¶àÓû§»·¾³ÖеĴóÁ¿Êý¾Ý£¬Ê¹¶àÓû§¿ÉÒÔͬʱ·ÃÎÊͬһ¸öÊý¾Ý¡£ ÔĶÁÈ«ÎÄ
posted @ 2013-04-02 15:27 °®Ð¦µÄºüÀê ÔĶÁ(132) ÆÀÂÛ(0) ÍƼö(0) ±à¼­
ÕªÒª£º ×òÌìÃæÊÔµÄʱºò£¬¾­ÀíÎÊa56爆大奖在线娱乐orcle»ù´¡»¹ÊÇÏ൱²»´íµÄ£¬ÄÇÇëÎÊÄãµÄorcleÓÃʲô¹¤¾ß¿ª·¢£¿µ±Ê±a56爆大奖在线娱乐¾Í¾õµÃÃÉÁË£¬oracle²»ÊǾÍÓÃÄǸöoracle¹¤¾ßÂ𣬲»ÊÇÉñÂídeveloperÂð£¿È»ºóËû˵ÊÇPL/SQLdev¡£Êǵģ¬Ã»´í¡£Õâ¸öÁìÓòa56爆大奖在线娱乐Á¬Æ¤Ã«¶¼Ã»ÓÐÃþµ½£¬»ØÀ´ºóa56爆大奖在线娱乐¾Í¶Ô×Ô¼ºËµÒªÅ¬Á¦³äµç¡£ ½ñÌìÔÚÖªºõÉÏÃæËÑË÷µ½Ñ§Ï°orcleµÄһЩ·½·¨£¬a56爆大奖在线娱乐¾õµÃ×ۺϸ÷λ´óʦËùÑԵĸ÷ÖÖ·½·¨£¬¿ÉÄܶÔÓÚa56爆大奖在线娱乐À´ËµÓÐÓõÄÊÇ£º1.ÄÚ¹¦£º±ØÐ붮µÃorcleµÄ¹¤×÷Ô­Àí£»2.Í⹦£ºÕâ¸ö¸úÏîÄ¿¾­ÑéÏà¹Ø¡£orcleѧµÄÀ÷º¦µÄÈ˾ø·ÇÓÐõ辶¿É×ߣ¬¶¼ÊÇ»ýõͲ½ÂýÂý³ÁµíÏÂÀ´µÄ£¬µ±È»Ò²ÐèÒªa56爆大奖在线娱乐¾õÎò¡£ÕâÖÖ¾õÎòÊÇÐèÒª³ÁµíºÍ˼¿¼µÄ¡£½ñÌìËÑË÷µ½¼¸¸ö²»´íµÄѧϰÍøÕ¾. ÔĶÁÈ«ÎÄ
posted @ 2013-04-02 14:04 °®Ð¦µÄºüÀê ÔĶÁ(217) ÆÀÂÛ(0) ÍƼö(0) ±à¼­