记录备忘</h1> <article> <h1>记录备忘</h1> <p>Wed, 09 Aug 2017 11:52:00 GMT</p> 1. java zip 多个文�g�Ӟ��如果先添加了一个excel文�g�Q�然后再��x��加其他的文�g时会出现 steam is closed的错误。这是因为work.write(outputSteam)后，��用outputSteam.close()�Q�关闭输出流�?br />解决�Ҏ��Q?br />��原来的�E�序�Q?br /><div> ZipEntry entry = new ZipEntry( "file3.txt" );<br /> zos.putNextEntry( entry );<br /> workbook.write( zos );<br /> zos.closeEntry();</div>改�ؓ�Q?div> ZipEntry entry = new ZipEntry( "file3.txt" );<br /> zos.putNextEntry( entry );<br /> workbook.write( new NonCloseableOutputStream( zos ) );<br /> zos.closeEntry();</div><br />其中 NonCloseableOutputStream 定义如下�Q?br /><div>public class NonCloseableOutputStream extends java.io.FilterOutputStream {<br /> public NonCloseableOutputStream(OutputStream out) {<br /> super(out);<br /> }<br /> @Override public void close() throws IOException {<br /> flush();<br /> }<br />}</div><br /><br /><br />2. 使用binary使得mysql区分大小�?br />select * from table1 where binary field1 = 'abc';<br><br><div align=right><a style="text-decoration:none;" href="http://www.dentisthealthcenter.com/usherlight/" target="_blank">云自无心水自�?/a> 2017-08-09 19:52 <a href="http://www.dentisthealthcenter.com/usherlight/archive/2017/08/09/432731.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div> </article> <article> <h1>plugin manage for 64 bit notepadd++</h1> <p>Mon, 26 Jun 2017 01:33:00 GMT</p> <div>https://notepad-plus-plus.org/community/topic/13661/plugin-manager-x64-available-submit-your-plugins</div><br><br><div align=right><a style="text-decoration:none;" href="http://www.dentisthealthcenter.com/usherlight/" target="_blank">云自无心水自�?/a> 2017-06-26 09:33 <a href="http://www.dentisthealthcenter.com/usherlight/archive/2017/06/26/432623.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div> </article> <article> <h1>Remote Git Server migration</h1> <p>Thu, 15 Jun 2017 00:40:00 GMT</p> <span style="color: #242729; font-family: Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 15px; background-color: #ffffff;">move Git Server to a new IP/URL:<br /><br />you can just edit </span><code style="margin: 0px; padding: 1px 5px; border: 0px; font-variant-numeric: inherit; font-stretch: inherit; font-size: 13px; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; background-color: #eff0f1; white-space: pre-wrap; color: #242729;">.git/config</code><span style="color: #242729; font-family: Arial, "Helvetica Neue", Helvetica, sans-serif; font-size: 15px; background-color: #ffffff;"> and change the URLs there<br /><br />也可以在git视图中，右键点击��目�Q�选择属性，然后修改url中的地址<br /></span><br><br><div align=right><a style="text-decoration:none;" href="http://www.dentisthealthcenter.com/usherlight/" target="_blank">云自无心水自�?/a> 2017-06-15 08:40 <a href="http://www.dentisthealthcenter.com/usherlight/archive/2017/06/15/432602.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div> </article> <article> <h1>一些小工具</h1> <p>Tue, 23 May 2017 23:13:00 GMT</p> autohotkey<br />listary<br />cmder可以split screen,在一个窗口中同时�q�行��C��cmd<br><br><div align=right><a style="text-decoration:none;" href="http://www.dentisthealthcenter.com/usherlight/" target="_blank">云自无心水自�?/a> 2017-05-24 07:13 <a href="http://www.dentisthealthcenter.com/usherlight/archive/2017/05/24/432545.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div> </article> <article> <h1>一个好用的��工具AutoHotKey</h1> <p>Wed, 08 Mar 2017 05:06:00 GMT</p> 官网地址�Q�autohotkey.com<br /><br /><div>; fill password</div><div>^Numpad2::</div><div><span style="white-space:pre"> </span>Send, root{tab}root{enter}</div><div>Return</div><div></div><div>^Numpad3::</div><div>IfWinExist, ahk_exe OUTLOOK.EXE</div><div>{</div><div> WinActivate ahk_exe OUTLOOK.EXE ; Automatically uses the window found above.</div><div> ; WinMaximize ; same</div><div> ;Send, Some text.{Enter}</div><div><span style="white-space:pre"> </span>msgbox Outlook is running.</div><div></div><div>}</div><div>Return</div><div></div><br><br><div align=right><a style="text-decoration:none;" href="http://www.dentisthealthcenter.com/usherlight/" target="_blank">云自无心水自�?/a> 2017-03-08 13:06 <a href="http://www.dentisthealthcenter.com/usherlight/archive/2017/03/08/432367.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div> </article> <article> <h1>First Vue.js html page</h1> <p>Wed, 08 Feb 2017 23:41:00 GMT</p> <div><html><br /><head><br /> <script src="https://unpkg.com/vue/dist/vue.js"></script><br /> <script><br /> window.onload = function () {<br /> var app = new Vue({<br /> el: '#app',<br /> data: {<br /> message: 'Hello Vue!'<br /> }<br /> });<br /> } <br /> </script><br /></head><br /><br /><body><br /> <div id="app"><br /> {{ message }}<br /> </div><br /></body><br /></html></div><br><br><div align=right><a style="text-decoration:none;" href="http://www.dentisthealthcenter.com/usherlight/" target="_blank">云自无心水自�?/a> 2017-02-09 07:41 <a href="http://www.dentisthealthcenter.com/usherlight/archive/2017/02/09/432293.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div> </article> <article> <h1>SLF4J 打印数组</h1> <p>Thu, 29 Dec 2016 03:51:00 GMT</p> <br /><div>String[] splits=someString.split("a,b,c,d", ",");</div>logger.debug( "array: {}", (Object) splits );<br /><br />�q�里要注意的��是要把数组的数据类型强制�{换�ؓObject <br><br><div align=right><a style="text-decoration:none;" href="http://www.dentisthealthcenter.com/usherlight/" target="_blank">云自无心水自�?/a> 2016-12-29 11:51 <a href="http://www.dentisthealthcenter.com/usherlight/archive/2016/12/29/432213.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div> </article> <article> <h1>mysql遗忘root密码</h1> <p>Tue, 20 Dec 2016 23:12:00 GMT</p> 在windows环境中，可以用如下方法重�|�root密码<br /><br />1、先停止mysql数据�?br /><br />2、保存密码重�|�sql文�g<br /> 5.7.6�Q�包括）以后的版本：ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';<br /> 5.7.5�Q�包括）以前的版本：SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');<br />假设保存到文�? c:\reset.txt<br /><br />3、以��理员��n份打开命��o行窗口，�q�行<br />C:\> cd "C:\Program Files\MySQL\MySQL Server 5.5\bin"<div>C:\> mysqld --init-file=C:\reset.txt<br /><br />4、启动后�Q�还不能马上用新密码�q�接数据库，需要重启mysql数据�?br /></div><br><br><div align=right><a style="text-decoration:none;" href="http://www.dentisthealthcenter.com/usherlight/" target="_blank">云自无心水自�?/a> 2016-12-21 07:12 <a href="http://www.dentisthealthcenter.com/usherlight/archive/2016/12/21/432160.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div> </article> <article> <h1>Eclipse启动时update indexes很慢</h1> <p>Tue, 29 Nov 2016 00:38:00 GMT</p> <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 15px; clear: both; color: #242729; font-family: Arial, "Helvetica Neue", Helvetica, sans-serif; background-color: #ffffff;">This is a general step that happens when m2e/m2eclipse (Maven integration for Eclipse) is installed, whether projects are actively using it or not.<br />�q�是因�ؓm2eclipse(maven插�g)要在启动旉��要进行的一个步骤�?/p><p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 15px; clear: both; color: #242729; font-family: Arial, "Helvetica Neue", Helvetica, sans-serif; background-color: #ffffff;">This step can be disabled through the Eclipse preferences: Window / Preferences / Maven / "Download repository index updates on startup". This option is on the main "Maven" preference page (not a child page). Just uncheck the box to prevent this from happening.<br />我们可以停止�q�个动作。方法：Windows -> Preferences -> Maven 取消��N�?Download repository index updates on startup</p><br><br><div align=right><a style="text-decoration:none;" href="http://www.dentisthealthcenter.com/usherlight/" target="_blank">云自无心水自�?/a> 2016-11-29 08:38 <a href="http://www.dentisthealthcenter.com/usherlight/archive/2016/11/29/432021.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div> </article> <article> <p>Mon, 28 Nov 2016 03:03:00 GMT</p> 有好几个java library都可以实现这个功能，但是从pdf提取文本的一个问题是�Q�提取出来的文本没有固定的顺序，不容易比较好的还原其格式�?br /><br />我的做法是��用pdfclown来进行这��工作。官方网站是�Q�https://pdfclown.org/ 先下载其最新版本�?br />参考其�C�Z��代码�Q�https://pdfclown.org/2010/01/02/upcoming-0-0-8-whats-going-to-be-new/#more-30<br /><br />使用�q�段代码�Q�我们不仅可以得到文本的字符�Ԍ��q�能得到文本的页数和相对坐标�?br />我的思�\是先把所有文本的字符串和坐标提取出来。然后排序，排序的顺序是�U�坐标，然后横坐标�?br />�q�样排序完毕后，��p��比较好的解决文本格式问题�?img src ="http://www.dentisthealthcenter.com/usherlight/aggbug/432019.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.dentisthealthcenter.com/usherlight/" target="_blank">云自无心水自�?/a> 2016-11-28 11:03 <a href="http://www.dentisthealthcenter.com/usherlight/archive/2016/11/28/432019.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div> </article> </main></body></html>