仓酷云

标题: 发布一篇java程序将汉字存进mysql数据库中时酿成乱码 [打印本页]
作者: 飘灵儿    时间: 2015-1-18 11:00
标题: 发布一篇java程序将汉字存进mysql数据库中时酿成乱码
有了这样一个呼声：让java代替C语言成为基本语言。这些足以说明java简单易学的这个优点。其次，java的功能强大，前面我也提到了，EJB3.0的推出使java成为了大型项目的首选。
明天忧郁了一天，java程序在向mysql拔出数据前不是乱码，数据库安装时也选了编码为utf8（和我程序的编码格局分歧）。但是拔出数据就酿成乱码，相称忧郁。
缘故原由：mysql的设置文件中的编码并没有改成utf8,；
办理举措：在mysql的安装目次下找到my.ini文件，将内里两处触及编码的中央改成utf8,以下：
  2. #MySQLServerInstanceConfigurationFile
  3. #----------------------------------------------------------------------
  4. #GeneratedbytheMySQLServerInstanceConfigurationWizard
  5. #
  6. #
  7. #InstallationInstructions
  8. #----------------------------------------------------------------------
  9. #
  10. #OnLinuxyoucancopythisfileto/etc/my.cnftosetglobaloptions,
  11. #mysql-data-dir/my.cnftosetserver-specificoptions
  12. #(forthisinstallation)orto
  13. #~/.my.cnftosetuser-specificoptions.
  14. #
  15. #OnWindowsyoushouldkeepthisfileintheinstallationdirectory
  16. #ofyourserver(e.g.C:ProgramFilesMySQLMySQLServerX.Y).To
  17. #makesuretheserverreadstheconfigfileusethestartupoption
  18. #"--defaults-file".
  19. #
  20. #Torunruntheserverfromthecommandline,executethisina
  21. #commandlineshell,e.g.
  22. #mysqld--defaults-file="C:ProgramFilesMySQLMySQLServerX.Ymy.ini"
  23. #
  24. #ToinstalltheserverasaWindowsservicemanually,executethisina
  25. #commandlineshell,e.g.
  26. #mysqld--installMySQLXY--defaults-file="C:ProgramFilesMySQLMySQLServerX.Ymy.ini"
  27. #
  28. #Andthenexecutethisinacommandlineshelltostarttheserver,e.g.
  29. #netstartMySQLXY
  30. #
  31. #
  32. #Guildlinesforeditingthisfile
  33. #----------------------------------------------------------------------
  34. #
  35. #Inthisfile,youcanusealllongoptionsthattheprogramsupports.
  36. #Ifyouwanttoknowtheoptionsaprogramsupports,starttheprogram
  37. #withthe"--help"option.
  38. #
  39. #Moredetailedinformationabouttheindividualoptionscanalsobe
  40. #foundinthemanual.
  41. #
  42. #
  43. #CLIENTSECTION
  44. #----------------------------------------------------------------------
  45. #
  46. #ThefollowingoptionswillbereadbyMySQLclientapplications.
  47. #NotethatonlyclientapplicationsshippedbyMySQLareguaranteed
  48. #toreadthissection.IfyouwantyourownMySQLclientprogramto
  49. #honorthesevalues,youneedtospecifyitasanoptionduringthe
  50. #MySQLclientlibraryinitialization.
  51. #
  52. [client]
  54. port=3306
  56. [mysql]
  58. <spanstyle="color:#ff0000;">default-character-set=utf8
  60. </span>
  61. #SERVERSECTION
  62. #----------------------------------------------------------------------
  63. #
  64. #ThefollowingoptionswillbereadbytheMySQLServer.Makesurethat
  65. #检察本栏目更多出色内容：http://www.bianceng.cn/Programming/Java/
  66. #youhaveinstalledtheservercorrectly(seeabove)soitreadsthis
  67. #file.
  68. #
  69. [mysqld]
  71. #TheTCP/IPPorttheMySQLServerwilllistenon
  72. port=3306
  75. #Pathtoinstallationdirectory.Allpathsareusuallyresolvedrelativetothis.
  76. basedir="C:/ProgramFiles/MySQL/MySQLServer5.5/"
  78. #Pathtothedatabaseroot
  79. datadir="C:/DocumentsandSettings/AllUsers/ApplicationData/MySQL/MySQLServer5.5/Data/"
  81. #Thedefaultcharactersetthatwillbeusedwhenanewschemaortableis
  82. #createdandnocharactersetisdefined
  83. <spanstyle="color:#ff0000;">character-set-server=utf8
  85. </span>#Thedefaultstorageenginethatwillbeusedwhencreatenewtableswhen
  86. default-storage-engine=INNODB
  88. #SettheSQLmodetostrict
  89. sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  91. #ThemaximumamountofconcurrentsessionstheMySQLserverwill
  92. #allow.Oneoftheseconnectionswillbereservedforauserwith
  93. #SUPERprivilegestoallowtheadministratortologinevenifthe
  94. #connectionlimithasbeenreached.
  95. max_connections=100
  97. #QuerycacheisusedtocacheSELECTresultsandlaterreturnthem
  98. #withoutactualexecutingthesamequeryonceagain.Havingthequery
  99. #cacheenabledmayresultinsignificantspeedimprovements,ifyour
  100. #havealotofidenticalqueriesandrarelychangingtables.Seethe
  101. #"Qcache_lowmem_prunes"statusvariabletocheckifthecurrentvalue
  102. #ishighenoughforyourload.
  103. #Note:Incaseyourtableschangeveryoftenorifyourqueriesare
  104. #textuallydifferenteverytime,thequerycachemayresultina
  105. #slowdowninsteadofaperformanceimprovement.
  106. query_cache_size=0
  108. #Thenumberofopentablesforallthreads.Increasingthisvalue
  109. #increasesthenumberoffiledescriptorsthatmysqldrequires.
  110. #Thereforeyouhavetomakesuretosettheamountofopenfiles
  111. #allowedtoatleast4096inthevariable"open-files-limit"in
  112. #section[mysqld_safe]
  113. table_cache=256
  115. #Maximumsizeforinternal(in-memory)temporarytables.Ifatable
  116. #growslargerthanthisvalue,itisautomaticallyconvertedtodisk
  117. #basedtableThislimitationisforasingletable.Therecanbemany
  118. #ofthem.
  119. tmp_table_size=17M
  122. #Howmanythreadsweshouldkeepinacacheforreuse.Whenaclient
  123. #disconnects,theclientsthreadsareputinthecacheiftherearent
  124. #morethanthread_cache_sizethreadsfrombefore.Thisgreatlyreduces
  125. #theamountofthreadcreationsneededifyouhavealotofnew
  126. #connections.(Normallythisdoesntgiveanotableperformance
  127. #improvementifyouhaveagoodthreadimplementation.)
  128. thread_cache_size=8
  130. #***MyISAMSpecificoptions
  132. #ThemaximumsizeofthetemporaryfileMySQLisallowedtousewhile
  133. #recreatingtheindex(duringREPAIR,ALTERTABLEorLOADDATAINFILE.
  134. #Ifthefile-sizewouldbebiggerthanthis,theindexwillbecreated
  135. #throughthekeycache(whichisslower).
  136. myisam_max_sort_file_size=100G
  138. #Ifthetemporaryfileusedforfastindexcreationwouldbebigger
  139. #thanusingthekeycachebytheamountspecifiedhere,thenpreferthe
  140. #keycachemethod.Thisismainlyusedtoforcelongcharacterkeysin
  141. #largetablestousetheslowerkeycachemethodtocreatetheindex.
  142. myisam_sort_buffer_size=34M
  144. #SizeoftheKeyBuffer,usedtocacheindexblocksforMyISAMtables.
  145. #Donotsetitlargerthan30%ofyouravailablememory,assomememory
  146. #isalsorequiredbytheOStocacherows.Evenifyourenotusing
  147. #MyISAMtables,youshouldstillsetitto8-64Masitwillalsobe
  148. #usedforinternaltemporarydisktables.
  149. key_buffer_size=25M
  151. #SizeofthebufferusedfordoingfulltablescansofMyISAMtables.
  152. #Allocatedperthread,ifafullscanisneeded.
  153. read_buffer_size=64K
  154. read_rnd_buffer_size=256K
  156. #ThisbufferisallocatedwhenMySQLneedstorebuildtheindexin
  157. #REPAIR,OPTIMZE,ALTERtablestatementsaswellasinLOADDATAINFILE
  158. #intoanemptytable.Itisallocatedperthreadsobecarefulwith
  159. #largesettings.
  160. sort_buffer_size=256K
  163. #***INNODBSpecificoptions***
  166. #UsethisoptionifyouhaveaMySQLserverwithInnoDBsupportenabled
  167. #butyoudonotplantouseit.Thiswillsavememoryanddiskspace
  168. #andspeedupsomethings.
  169. #skip-innodb
  171. #AdditionalmemorypoolthatisusedbyInnoDBtostoremetadata
  172. #information.IfInnoDBrequiresmorememoryforthispurposeitwill
  173. #starttoallocateitfromtheOS.Asthisisfastenoughonmost
  174. #recentoperatingsystems,younormallydonotneedtochangethis
  175. #value.SHOWINNODBSTATUSwilldisplaythecurrentamountused.
  176. innodb_additional_mem_pool_size=2M
  178. #Ifsetto1,InnoDBwillflush(fsync)thetransactionlogstothe
  179. #diskateachcommit,whichoffersfullACIDbehavior.Ifyouare
  180. #willingtocompromisethissafety,andyouarerunningsmall
  181. #transactions,youmaysetthisto0or2toreducediskI/Otothe
  182. #logs.Value0meansthatthelogisonlywrittentothelogfileand
  183. #thelogfileflushedtodiskapproximatelyoncepersecond.Value2
  184. #meansthelogiswrittentothelogfileateachcommit,butthelog
  185. #fileisonlyflushedtodiskapproximatelyoncepersecond.
  186. innodb_flush_log_at_trx_commit=1
  188. #ThesizeofthebufferInnoDBusesforbufferinglogdata.Assoonas
  189. #itisfull,InnoDBwillhavetoflushittodisk.Asitisflushed
  190. #oncepersecondanyway,itdoesnotmakesensetohaveitverylarge
  191. #(evenwithlongtransactions).
  192. innodb_log_buffer_size=1M
  194. #InnoDB,unlikeMyISAM,usesabufferpooltocachebothindexesand
  195. #rowdata.ThebiggeryousetthisthelessdiskI/Oisneededto
  196. #accessdataintables.Onadedicateddatabaseserveryoumaysetthis
  197. #parameterupto80%ofthemachinephysicalmemorysize.Donotsetit
  198. #toolarge,though,becausecompetitionofthephysicalmemorymay
  199. #causepagingintheoperatingsystem.Notethaton32bitsystemsyou
  200. #mightbelimitedto2-3.5Gofuserlevelmemoryperprocess,sodonot
  201. #setittoohigh.
  202. innodb_buffer_pool_size=47M
  204. #Sizeofeachlogfileinaloggroup.Youshouldsetthecombinedsize
  205. #oflogfilestoabout25%-100%ofyourbufferpoolsizetoavoid
  206. #unneededbufferpoolflushactivityonlogfileoverwrite.However,
  207. #notethatalargerlogfilesizewillincreasethetimeneededforthe
  208. #recoveryprocess.
  209. innodb_log_file_size=24M
  211. #NumberofthreadsallowedinsidetheInnoDBkernel.Theoptimalvalue
  212. #dependshighlyontheapplication,hardwareaswellastheOS
  213. #schedulerproperties.Atoohighvaluemayleadtothreadthrashing.
  214. innodb_thread_concurrency=8
复制代码
首先第一点：jsp，servlet,javabean这些最基本的，嘿嘿，就算你是高手的话，在大行的企业级应用的话还是需要框架的，一个好的框架确实能构解决许多问题。
作者: 老尸    时间: 2015-1-20 12:31
接着就是EJB了，EJB就是Enterprise JavaBean, 看名字好象它是Javabean，可是它和Javabean还是有区别的。它是一个体系结构，你可以搭建更安全、更稳定的企业应用。它的大量代码已由中间件（也就是我们常听到的 Weblogic,Websphere这些J2EE服务器）完成了，所以我们要做的程序代码量很少，大部分工作都在设计和配置中间件上。
作者: 仓酷云    时间: 2015-1-21 11:12
Sun公司看见Oak在互联网上应用的前景，于是改造了Oak，于1995年5月以Java的名称正式发布。Java伴随着互联网的迅猛发展而发展，逐渐成为重要的网络编程语言。
作者: 小魔女    时间: 2015-1-30 16:44
设计模式是高级程序员真正掌握面向对象核心思想的必修课。设计模式并不是一种具体"技术",它讲述的是思想，它不仅仅展示了接口或抽象类在实际案例中的灵活应用和智慧
作者: 再见西城    时间: 2015-1-31 08:10
[url]http://www.jdon.com/[/url]去下载，或到同济技术论坛的服务器[url]ftp://nro.shtdu.edu.cn[/url]去下，安装上有什么问题，可以到论坛上去提问。
作者: 只想知道    时间: 2015-1-31 12:34
如果要向java web方向发展也要吧看看《Java web从入门到精通》学完再到《Struts2.0入门到精通》这样你差不多就把代码给学完了。有兴趣可以看一些设计模块和框架的包等等。
作者: 兰色精灵    时间: 2015-2-1 08:25
Java自面世后就非常流行，发展迅速，对C++语言形成了有力冲击。Java 技术具有卓越的通用性、高效性、平台移植性和安全性，广泛应用于个人PC、数据中心、游戏控制台
作者: 简单生活    时间: 2015-2-7 01:49
是一种语言，用以产生「小应用程序(Applet(s))
作者: 莫相离    时间: 2015-2-19 13:53
一直感觉JAVA很大，很杂，找不到学习方向，前两天在网上找到了这篇文章，感觉不错，给没有方向的我指了一个方向，先不管对不对，做下来再说。
作者: 爱飞    时间: 2015-3-6 14:55
我大二，Java也只学了一年，觉得还是看thinking in java好，有能力的话看英文原版(中文版翻的不怎么好)，还能提高英文文档阅读能力。
作者: 柔情似水    时间: 2015-3-13 02:09
科学超级计算机、移动电话和互联网，同时拥有全球最大的开发者专业社群。
作者: 再现理想    时间: 2015-3-20 09:58
你可以去承接一些项目做了，一开始可能有些困难，可是你有技术积累，又考虑周全，接下项目来可以迅速作完，相信大家以后都会来找你的，所以Money就哗啦啦的。。。。。。



欢迎光临 仓酷云 (http://ckuyun.com/) Powered by Discuz! X3.2