Mysql ´æ´¢ javabean
ÒµÎñÐèÒª£¬½«javabean ÐòÁл¯ºó´æ´¢µ½mysqlÖУ¬×Ö¶ÎÉèÖÃΪblob
ÐòÁл°£º
Java code:
PipedInputStream is = new PipedInputStream();
try {
ObjectOutputStream oos = new ObjectOutputStream(new PipedOutputStream(is));
oos.writeObject(object);
oos.flush();
oos.close();
} catch (Exception e) {
e.printStackTrace();
}
²åÈëÊý¾Ý¿â:
Java code:
pstmt.setBinaryStream(10, is, is.available());
ÕâÒ»²½Êdzɹ¦µÄ
È¡Êý¾Ý:
Java code:
InputStream is = rs.getBinaryStream("bean");
·´ÐòÁл¯£º
Object object = null;
try {
if(is.available() >0){
ObjectInputStream ois = new ObjectInputStream(is);
object = ois.readObject();
ois.close();
is.close();
}
} catch (Exception e) {
e.printStackTrace();
}
objectһֱΪ¿Õ£¬²é¿´ÁËÏÂisÀïÃæÊÇÓÐÖµµÄ
ÍøÉÏÕâ·½ÃæµÄ×ÊÁÏÌ«ÉÙÁË£¬Íü¸ßÈËÖ¸µã£¬·Ö²»¹»¿ÉÒÔÔÙ¼Ó¡£
лл¹þ
²»ÖªµÀ.ÓÑÇé°ô¶¥.
Ïà¹ØÎÊ´ð£º
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ ......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......
ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë
Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ
Ö§³Ö£¬¼ì² ......
echo %~dp0
CD %~dp0
mysqld.exe --defaults-file=..\my.ini --console
pause
´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£
ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£
echo %~dp0
ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû
CD %~dp0
......