JavaÖн«Êý×é¸÷ÔªËØ×÷ΪÊý¾ÝÏî²åÈëµ½Êý¾Ý¿âÖÐ
private PreparedStatement pstmt;
String sql="INSERT INTO TABLE(id,Ãû³Æ,Óû§id,Stbid,MAC,Óû§×´Ì¬,×Ü´ÎÊý,IpµØÖ·,×ÊÁϸüÐÂʱ¼ä) " +
"VALUES(?,?,?,?,?,?,?,?,?)";
pstmt=connection.prepareStatement(sql);
pstmt.setString(1,array[0]);
pstmt.setString(2, array[1]);
pstmt.setString(3, array[2]);
pstmt.setString(4, array[3]);
pstmt.setString(5, array[4]);
pstmt.setString(6, array[5]);
pstmt.setString(7, array[6]);
pstmt.setString(8, array[7]);
pstmt.setString(9, array[8]);
pstmt.executeUpdate();
pstmt.close();
connection.commit();
ÆäÖÐTABLEÖеĸ÷×ֶεÄÀàÐ;ùΪCharÀàÐÍ¡£
Ïà¹ØÎĵµ£º
ÔںܶàÊý¾Ý¿âÖУ¬“ÐÔ±ð”ÕâÒ»×Ö¶ÎÊÇÓÃÓÚintÀàÐÍ´æ´¢µÄ£¬ÈçÓÃ0±íʾ“Å®”£¬1±íʾ“ÄД¡£Ê¹ÓÃResultSet¶ÔÏórs½ÓÊÕ²éѯÊý¾Ý£¬ÔÚ»ñÈ¡Êý¾Ýʱʱ£¬rs.getString()·½·¨ºÍrs.getInt()·½·¨»ñÈ¡µÄÈÔÈ»ÊÇ0(Çø±ðÔÚÓÚStringÀàÐÍ»òÊÇintÀàÐÍ)¡£¶øÔÚʵ¼ÊÓ¦ÓÃʱ£¬ÎÒÃǸüÏ£Íû»ñµÃµÄÊý¾ÝÊÇÖ±¹ÛµØÏÔʾ“ÄÐ ......
JAVA EXCEL API¼ò½é
Java ExcelÊÇÒ»¿ª·ÅÔ´ÂëÏîÄ¿£¬Í¨¹ýËüJava¿ª·¢ÈËÔ±¿ÉÒÔ¶ÁÈ¡ExcelÎļþµÄÄÚÈÝ¡¢´´½¨ÐµÄExcelÎļþ¡¢¸üÐÂÒѾ´æÔÚµÄExcelÎļþ¡£Ê¹ÓøÃAPI·ÇWindows²Ù×÷ϵͳҲ¿ÉÒÔͨ¹ý´¿JavaÓ¦ÓÃÀ´´¦ÀíExcelÊý¾Ý±í¡£ÒòΪÊÇʹÓÃJava±àдµÄ£¬ËùÒÔÎÒÃÇÔÚWebÓ¦ÓÃÖпÉÒÔͨ¹ýJSP¡¢ServletÀ´µ÷ÓÃAPIʵÏÖ¶ÔExcelÊý¾Ý±íµÄ·ÃÎÊ¡£
ÏÖÔ ......
ÔÚJavaÓïÑÔÖУ¬equals()ºÍhashCode()Á½¸öº¯ÊýµÄʹÓÃÊǽôÃÜÅäºÏµÄ£¬ÄãÒªÊÇ×Ô¼ºÉè¼ÆÆäÖÐÒ»¸ö£¬¾ÍÒªÉè¼ÆÁíÍâÒ»¸ö¡£ÔÚ¶àÊýÇé¿ö
Ï£¬ÕâÁ½¸öº¯ÊýÊDz»Óÿ¼Âǵģ¬Ö±½ÓʹÓÃËüÃǵÄĬÈÏÉè¼Æ¾Í¿ÉÒÔÁË¡£µ«ÊÇÔÚһЩÇé¿öÏ£¬ÕâÁ½¸öº¯Êý×îºÃÊÇ×Ô¼ºÉè¼Æ£¬²ÅÄÜÈ·±£Õû¸ö³ÌÐòµÄÕý³£ÔËÐС£×î³£¼ûµÄÊǵ±
Ò»¸ö¶ÔÏó±»¼ÓÈëÊÕ¼¯¶ÔÏó£¨collection
ob ......
java¿ª·¢ÈËÔ±¾Ñé×ܽá-Î人±±´óÇàÄñ
¡¡¡¡·Á¢Ïî
¡¡¡¡Ò»¡¢ÐèÇóµÄÊÕ¼¯£¬UCµÄ±àдËäÈ»²»ÊÇ¿ª·¢ÈËÔ±µÄ¹¤×÷£¬µ«×îÖÕÐèÒª¿ª·¢ÈËÔ±ÔÚ²úÆ·ÖÐʵÏÖ¡£ËùÒÔ¿ª·¢²»ºÏÀíµÄÉè¼ÆÖÁÉÙÀË·ÑÁËÄãµÄʱ¼ä£¬¿ª·¢¼¼ÊõÎÞ·¨ÊµÏÖµÄÉè¼Æ´øÀ´×î´óµÄÍ´¿à£ºÊ§°Ü¡£ËùÒÔ£¬¿ª·¢ÈËÔ±ÒªÖØÊÓÐèÇóÒÔ¼°UCµÄÆÀÉó£¬Ìá³ö×Ô¼ºÄܹ»Ïëµ½µÄËùÓÐÒìÒé¡£
¡¡¡¡¶þ¡¢Ò»¶ ......
Ò»¡¢Àà×°ÔØÆ÷£ºÍ¨¹ý·Ö±ðʹÓò»Í¬µÄÀà×°ÔØÆ÷×°ÔØ¿É¿¿µÄ°üºÍ²»¿É¿¿µÄ°üÀ´ÊµÏÖ°² È«ÐÔ¡£
ÔÚ1.2°æ±¾µÄJavaÐéÄâ»ú¿ªÊ¼ÔËÐÐʱ£¬ÔÚÓ¦ÓóÌÐòÆô¶¯ÒÔǰ£¬ËüÖÁÉÙ´´½¨Ò»¸öÓû§×Ô¶¨ÒåÀà×°ÔØÆ÷£¬Ò²¿ÉÄÜÊǶà¸ö¡£ËùÓÐÕâЩÀà×°ÔØÆ÷±»Á¬½ÓÔÚÒ»¸öË«Ç×--º¢×ӵĹØÏµÁ´ÖУ¬ÔÚÕâÌõÁ´µÄ¶¥¶ËÊÇÆô¶¯Àà×°ÔØÆ÷£¬Ä©¶ËÊÇÒ»¸ö±»³ÆÎª“ϵͳÀà× ......