ʹÓÃJava Web¶ÔAccessÊý¾Ý¿âµÄ±¸×¢×ֶβÙ×÷ÎÊÌâ
½üÆÚÓиöСCMSÏîÄ¿£¬ÓÉÓÚ·þÎñÆ÷¡¢ÈËÔ±ÒÔ¼°¹ÜÀíÖÆ¶ÈµÈһϵÁÐÎÊÌ⣬²»µÃ²»²ÉÓÃJava Web+AccessÕâÖÖ²»Âײ»ÀàµÄ×éºÏ½øÐпª·¢£¬ÆÚ¼äÓöµ½ÁËÒ»¸öСÎÊÌ⣬ÄǾÍÊÇÎÄÕÂÄÚÈݲÉÓÃAccessµÄ“±¸×¢”ÀàÐÍ´æÈ¡Ê±£¬·¢Éú×Ô¶¯½Ø¶ÏµÄÎÊÌâ¡£Ò²¾ÍÊÇ˵£¬´æ½øÈ¥10000×ÖµÄÎÄÕ£¬Ö»ÄÜÏÔʾ³ö3000×Ö¡£¾¹ý²éÕÒ×ÊÁϺÍʵÑ飬·¢ÏÖÕâ¸öÎÊÌâÊÇPreparedStatementµÄsetter()ºÍgetter()·½·¨Ê¹Óò»µ±Ôì³ÉµÄ¡£
¹Ù·½×ÊÁÏÏÔʾ£¬AccessµÄ“±¸×¢”×ֶεÄ×Ö·û¸öÊý£¬Èôͨ¹ýÓû§½çÃæÊäÈëÔò×î´óΪ65,535£»ÈôÒÔ±à³Ì·½Ê½ÊäÈëʱÔò¿ÉÖ§³Ö1G×Ö½ÚµÄ×Ö·û´æ´¢¡£ËùÒÔ²»´æÔÚÊý¾Ý¿â×Ö¶ÎÀàÐÍÑ¡Ôñ´íÎóµÄÎÊÌâ¡£ÄÇôֻÓÐÔÚ´æÈ¡µÄ¹ý³ÌÖÐÕÒÎÊÌâÁË¡£
JavaµÄStringÀàÐÍÍüÁ˾¿¾¹ÄÜ´æ·Å¶àÉÙ¸ö×Ö·ûÁË£¨10µÄ16´Î·½£¿£©£¬×ÜÖ®Ò²²»ÊÇStringÀàÐ͵ĴíÎó¡£Òò´Ë£¬¾Í½«ÎÊÌⶨλÔÚÁË´¦ÀíÊý¾Ý¿â´æ·ÅµÄsetter()ºÍgetter()·½·¨ÉÏÁË¡£¾²é£¬setString()·½·¨ÄÜ´æµÄֵȡ¾öÓڸòÎÊýÏà¶ÔÓÚÇý¶¯³ÌÐòÔÚ VARCHAR
ÖµÉϵÄÏÞÖÆµÄ´óС¡£GoogleÁËһϣ¬ÍøÉÏÌṩÁ˸÷ÖÖ·½·¨£¬ÊÔÁËÊÔclobµÄ·½Ê½£¬·¢ÏÖAccessËÆºõ²»Ö§³Öclob£¬Òò´ËÎÒ¾ö¶¨ÊÔÒ»ÊÔ×Ö·ûÁ÷µÄ·½Ê½½øÐдæÈ¡¡£¾¹ýÊÔÑ飬ÖÕÓڳɹ¦£¬ÏÖ½«´úÂëÌṩÈçÏ£º
Ò»¡¢Ê¹ÓÃsetCharacterStream()ÏòAccessÊý¾Ý¿âÖдæ·ÅÊý¾Ý
//contentΪStringÐ͵ÄÎÄÕÂÄÚÈÝ
java.io.Reader clobReader = new java.io.StringReader(content);
pStatement.setCharacterStream(4, clobReader, content.length());
¶þ¡¢½«×Ö½ÚÁ÷·½·¨·â×°ÆðÀ´
public class UtilTools {
/*
* ÔÚaccessÊý¾Ý¿âÖУ¬½«Memo±¸×¢ÐÍ×Ö¶ÎÀïµÄÊý¾ÝÍêÕûÈ¡³ö
* @param InputStream
* @return StringBuilder
*/
public StringBuilder accessdbMemoToString(InputStream in)
{
BufferedReader reader=new BufferedReader(new InputStreamReader(in));
StringBuilder sb=new StringBuilder();
String line=null;
try {
while((line=reader.readLine())!=null){
sb.append(line);
}
} catch (IOException e) {
e.printStackTrace();
}
return sb;
}
Èý¡¢µ÷ÓöþÖеķ½·¨£¬ÊµÏÖ´ÓAccessÊý¾Ý¿âÖÐÍêÕûÈ¡Êý¾Ý
//dbΪÏàÓ¦µÄPOJO¶ÔÏó£¬"content"Ϊ×Ö¶ÎÃû³Æ£¬rsΪResultSet¶ÔÏó
UtilTools ut = new UtilTools();
db.setContent(
Ïà¹ØÎĵµ£º
´ò¿ªÖÕ¶Ë£¬Ö´ÐÐÒÔÏÂÃüÁ»òʹÓÃAdept/ÐÂÁ¢µÃÈí¼þ¹ÜÀíÆ÷£¬ÔÚÆäÖÐËÑË÷"sun-java6-jdk"²¢±ê¼Ç°²×°¡£
sudo apt-get install sun-java6-jdk
Ìáʾ£º°²×°¹ý³ÌÖÐÐèÒªÄã»Ø´ðÊÇ·ñͬÒâʹÓÃÐÒ飨ÖÕ¶ËÖкìÀ¶É«µÄÌáʾ½çÃæ£©£¬´Ëʱ°´tab¼üÖÁOK£¬ÔÙ°´»Ø³µ¼´¿ÉÕý³£°²×°¡£
* ÉèÖõ±Ç°Ä¬ÈϵÄjava½âÊÍÆ÷ºÍ±àÒ ......
ת×Ô£ºhttp://hi.baidu.com/wqj403/blog/item/149957345cd6a11891ef3976.html
ÓÃjavaÔõôÌáÈ¡»òÊǽâѹrarѹËõÎĵµ£¿ÒÔǰ²éÁ˺ܶàµÄ×ÊÁÏ£¬Ã»ÓÐÕÒµ½Ïà¹ØµÄµÚÈý·½¿â£¬ÍøÉϲéÕÒµÄ×ÊÁÏ˵ÊǽâÎörarÖ»Äܸü¼ÓrarµÄÃüÁîÐвÎÊýÀ´½âÎö¡£ÒòΪrarѹËõÎĵµµÄÄÚ²¿½á¹¹ÊÇûÓй²¿ªµÄ¡£ËùÒÔûÓÐרÃŵĽâÎö¿â³ÌÐò¡£×Ô¼ºÒ²¾ÍÖ»ºÃÓÃÃüÁîÐÐÁË£¬µ« ......
from:http://topic.csdn.net/u/20080123/10/28c8cf34-5eb1-40e6-a117-7abe9cd92291.html
1.ûÓа²×°matlab2007֮ǰ£¬³ÌÐò±¨´í£º
Exception in thread "main" java.lang.UnsatisfiedLinkError: C:\WINDOWS\system32\nativemcl77.dll
ÎÒ²éÕÒ×ÊÁÏ·¢ÏÖ£¬Èç¹û²»°²×°matlab£¬Ôò±ØÐëÒª°²×°MATLAB Component Run-time(MCR)£¬
2. ......
ÐòÁл¯µÄ¹ý³Ì¾ÍÊǶÔÏóдÈë×Ö½ÚÁ÷ºÍ´Ó×Ö½ÚÁ÷ÖжÁÈ¡¶ÔÏó¡£½«¶ÔÏó״̬ת»»³É×Ö½ÚÁ÷Ö®ºó£¬¿ÉÒÔÓÃjava.io°üÖеĸ÷ÖÖ×Ö½ÚÁ÷ÀཫÆä±£´æµ½ÎļþÖУ¬¹ÜµÀµ½ÁíÒ»Ïß³ÌÖлòͨ¹ýÍøÂçÁ¬½Ó½«¶ÔÏóÊý¾Ý·¢Ë͵½ÁíÒ»Ö÷»ú¡£¶ÔÏóÐòÁл¯¹¦Äܷdz£¼òµ¥¡¢Ç¿´ó£¬ÔÚRMI¡¢Socket¡¢JMS¡¢EJB¶¼ÓÐÓ¦Ó᣶ÔÏóÐòÁл¯ÎÊÌâÔÚÍøÂç±à³ÌÖв¢²»ÊÇ× ......