ʹÓÃ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(
Ïà¹ØÎĵµ£º
ת×Ô£ºhttp://hi.baidu.com/wqj403/blog/item/149957345cd6a11891ef3976.html
ÓÃjavaÔõôÌáÈ¡»òÊǽâѹrarѹËõÎĵµ£¿ÒÔÇ°²éÁ˺ܶàµÄ×ÊÁÏ£¬Ã»ÓÐÕÒµ½Ïà¹ØµÄµÚÈý·½¿â£¬ÍøÉϲéÕÒµÄ×ÊÁÏ˵ÊǽâÎörarÖ»Äܸü¼ÓrarµÄÃüÁîÐвÎÊýÀ´½âÎö¡£ÒòΪrarѹËõÎĵµµÄÄÚ²¿½á¹¹ÊÇûÓй²¿ªµÄ¡£ËùÒÔûÓÐרÃŵĽâÎö¿â³ÌÐò¡£×Ô¼ºÒ²¾ÍÖ»ºÃÓÃÃüÁîÐÐÁË£¬µ« ......
Ò»£® Incident
import java.util.ArrayList;
import java.util.List;
public class Test {
public static void main(String[] args) {
......
C# accessÈÕÆÚ²éѯ¼Ó#
if (((string)((ComboBoxItem)cmbField.SelectedItem).Value).Equals("System.DateTime"))
{
//ÅжÏÈÕÆÚµÄ;
& ......
µÚ1ÕÂ
Java»ù´¡
1.1 JavaµÄÀúÊ·ºÍ»ù±¾ÔÀí
1.2 Java×Ö½ÚÂë
1.3 JavaÊõÓï
1.4 &nbs ......
ÐòÁл¯µÄ¹ý³Ì¾ÍÊǶÔÏóдÈë×Ö½ÚÁ÷ºÍ´Ó×Ö½ÚÁ÷ÖжÁÈ¡¶ÔÏó¡£½«¶ÔÏó״̬ת»»³É×Ö½ÚÁ÷Ö®ºó£¬¿ÉÒÔÓÃjava.io°üÖеĸ÷ÖÖ×Ö½ÚÁ÷ÀཫÆä±£´æµ½ÎļþÖУ¬¹ÜµÀµ½ÁíÒ»Ïß³ÌÖлòͨ¹ýÍøÂçÁ¬½Ó½«¶ÔÏóÊý¾Ý·¢Ë͵½ÁíÒ»Ö÷»ú¡£¶ÔÏóÐòÁл¯¹¦Äܷdz£¼òµ¥¡¢Ç¿´ó£¬ÔÚRMI¡¢Socket¡¢JMS¡¢EJB¶¼ÓÐÓ¦Ó᣶ÔÏóÐòÁл¯ÎÊÌâÔÚÍøÂç±à³ÌÖв¢²»ÊÇ× ......